Leo-zd commented on issue #33481:
URL:
https://github.com/apache/shardingsphere/issues/33481#issuecomment-2456084061
> Because you have made customizations, it is difficult to analyze your
issue through logs. Can you provide reproducible code? Please keep the code
simple and only related to reproducing this issue, and remove other third-party
ORM frameworks, etc.
```
<select id="queryPage2"
resultType="com.telecom.im.entity.view.MessageRecordViewEntity">
SELECT
*
FROM
(
SELECT
`a`.`id` AS `msg_id`,
`a`.`msg_from` AS `id`,
`b`.`username` AS `username`,
`b`.`avatar` AS `avatar`,
`a`.`content` AS `content`,
`a`.`create_time` AS `timestamp`,
`a`.`msg_to` AS `msg_to`,
`c`.`username` AS `to_user_name`,
`a`.`msg_type` AS `type`,
`a`.`group_id` AS `group_id`,
`a`.`is_read` AS `is_read`,
`a`.`req_state` AS `req_state`,
`a`.`system_id` AS `system_id`,
`a`.`stars` AS `stars`,
`a`.`tag` AS `tag`
FROM
`im_user_message` `a`
LEFT JOIN `im_user_account` `b` ON `a`.`msg_from` = `b`.`id`
LEFT JOIN `im_user_account` `c` ON `a`.`msg_to` = `c`.`id`
) t1
WHERE
(system_id IN ("xxx","xxx") AND id =
"fe14f88tdhs89ieda6fd8a61b1dfb")
ORDER BY TIMESTAMP DESC
LIMIT 11
</select>
```
##### error msg
```
Error attempting to get column 'username' from result set. Cause:
java.sql.SQLFeatureNotSupportedException: Can not get index from column label
`username`.\n; Can not get index from column label `username`.; nested
exception is java.sql.SQLFeatureNotSupportedException: Can not get index from
column label `username`.
```
--
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]
