448700174 opened a new issue, #29421:
URL: https://github.com/apache/shardingsphere/issues/29421
select a.*, b.elder_name,b.insurance_no,b.gender,b.birth_day
from medical_medicine_kit_order a, elder_info b
where a.tenant_id = #{paramMap.tenantId} and a.elder_id = b.elder_id and
a.status > 0
Logic SQL: select a.*, b.elder_name,b.insurance_no,b.gender,b.birth_day
from medical_medicine_kit_order_12 a, elder_info b
where a.elder_id = b.elder_id and a.status > 0 limit 10
Actual SQL: ds ::: select a.*,
b.elder_name,b.insurance_no,b.gender,b.birth_day
from medical_medicine_kit_order_12 a, elder_info b
where a.elder_id = b.elder_id and a.status > 0 limit 10
Error attempting to get column 'id' from result set. Cause:
java.sql.SQLFeatureNotSupportedException: Can not get index from column label
`id`.
; Can not get index from column label `id`.; nested exception is
java.sql.SQLFeatureNotSupportedException: Can not get index from column label
`id`.
I can only get elder_name、insurance_no、gender、birth_day。
CREATE TABLE `medical_medicine_kit_order` (
`id` bigint unsigned NOT NULL COMMENT 'ID',
`elder_id` int unsigned NOT NULL COMMENT ' ',
`tenant_id` int unsigned NOT NULL COMMENT ' ',
`medicine_count` tinyint NOT NULL COMMENT ' ',
`source` tinyint NOT NULL COMMENT ''；）',
`type` tinyint NOT NULL DEFAULT '1' COMMENT ' ',
...
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
COMMENT='';
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
