生产环境下,出现以下报错。但是数据明明是MySQL 这里感觉识别成Oracle了?(没法给出其他日志信息了)
!Nutz SQL Error: 'SELECT * FROM (SELECT ROW_NUMBER() OVER() AS ROWNUM, T.* FROM ( SELECT * FROM account WHERE name=?) T) AS A WHERE ROWNUM BETWEEN 1 AND 1
| 1 |
|-------------|
| 3kft_214633 |
For example:> "SELECT * FROM (SELECT ROW_NUMBER() OVER() AS ROWNUM, T.* FROM ( SELECT * FROM account WHERE name='3kft_214633') T) AS A WHERE ROWNUM BETWEEN 1 AND 1 "'
PreparedStatement:
'SELECT * FROM (SELECT ROW_NUMBER() OVER() AS ROWNUM, T.* FROM ( SELECT * FROM account WHERE name=?) T) AS A WHERE ROWNUM BETWEEN 1 AND 1 '
CaseMessage=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '() AS ROWNUM, T.* FROM ( SELECT * FROM account WHERE name='3kft_214633') T) AS ' at line 1