zhang-zhipeng commented on issue #21799: URL: https://github.com/apache/shardingsphere/issues/21799#issuecomment-1294456383
Logic SQL: SELECT * FROM (SELECT TMP.*, ROWNUM ROW_ID FROM (SELECT ID, NAME, PWD, MOBILE, CUSTOMER_ID, CREATE_TIME, UPDATe_TIME, FROM T_CIPHER_OLD WHERE (ID = ?) ) TMP WHERE ROWNUM <= ?) WHERE ROW_ID > ? ACTUAL SQL： SELECT "ID", "NAME", "PWD_CIPHER" AS "PWD", "MOBILE", "CUSTOMER_ID", "CREATE_TIME", "UPDATE_TIME", "ROWNUM" AS "ROW_ID" FROM ( SELECT "ID", "NAME", "PWD_CIPHER", "MOBILE", "CUSTOMER_ID", "CREATE_TIME", "UPDATE_TIME", ROWNUM AS ROW_ID FROM (SELECT SELECT ID, NAME, PWD, MOBILE, CUSTOMER_ID, CREATE_TIME, UPDATe_TIME, FROM T_CIPHER_OLD WHERE (ID = ?) ) TMP WHERE ROWNUM <= ?) WHERE ROW_ID > ? The "ROWNUM" AS "ROW_ID" in ACTUAL SQL regards the ROWNUM as a real field, but it is not -- 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]
