shenyao2333 opened a new issue #10955:
URL: https://github.com/apache/shardingsphere/issues/10955
When I want from an old project integrated Sharding, found that there are
some SQL query is not supported, and errors in some strange, such as:
- Java. Lang. ClassCastException:java.lang.String cannot be cast to
java.lang.Integer
- Error querying database. Cause: java.lang.ClassCastException:
java.lang.String cannot be cast to java.lang.Integer
- Error querying database. Cause: java.lang.IndexOutOfBoundsException:
Index: 0
and so on.....
Some of the SQL error is a temporary table, anyway, a lot of complex SQL
problems, this aspect can now have other ways to solve it?For example, forcing
the data source to be specified so as to skip the parsing of the SQL, since
this is an old project, this SQL is a bit errorless, so it is difficult to
modify the SQL.Is there any good solution to this BUG?
I put an incorrect SQL
```
SELECT
game.strength,
game.game_id,
game.member_id,
game.crated_time,
m.nickname,
m.headimg
FROM
( SELECT strength, game_id, member_id, crated_time FROM club_sugar_game
GROUP BY member_id, game_id ORDER BY strength DESC ) game
LEFT JOIN member m ON game.member_id = m.id
GROUP BY
game.member_id
ORDER BY
strength DESC,
game_id ASC
```
--
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.
For queries about this service, please contact Infrastructure at:
[email protected]
