[GitHub] [shardingsphere] yl-yue edited a comment on issue #8296: shardingsphere-proxy select * from XXX error

[GitBox <gi...@apache.org>]

yl-yue edited a comment on issue #8296:
URL: https://github.com/apache/shardingsphere/issues/8296#issuecomment-732642987


   sharding-proxy: 5.0.0-RC1-SNAPSHOT
   ```java
   [INFO ] 12:15:41.580 [ShardingSphere-Command-10] ShardingSphere-SQL - Actual SQL: common ::: SELECT id, create_time, update_time, is_deleted, sort_idx, delete_time, key, id_card, card_start_time, card_end_time, name, sex, sex_key, sex_name, nation, nation_key, native_place, native_place_key, is_certified, photo, person_photos, birthday, address, name_pinyin, age, work_phone, unit_code, unit_name, unit_key, work_time, residential_address, lng, lat, residence_community_name, residence_community_code, email, cellphone AS cellphone, contact, marriage, marriage_key, school, speciality, education, education_key, is_act_user, act_user_time, person_status, extend_field, is_permission_control_data, is_check_data, data_source_description, data_quality_integrity, data_quality_validity, data_quality_validity_alarm, card_type_name, card_type_key, card_code, before_name, zongjiao_name, zongjiao_key, work_name, work_key, huji_name, huji_key, blood_name, blood_key, height, is_farmer, is_laowu, is
 _fuyi FROM `ssc_demo`.`base_person` LIMIT 0,1000
   [ERROR] 12:15:41.690 [ShardingSphere-Command-10] o.a.s.p.f.c.CommandExecutorTask - Exception occur: 
   java.sql.SQLSyntaxErrorException: 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 'key, id_card, card_start_time, card_end_time, name, sex, sex_key, sex_name, nati' at line 1
   	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
   	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
   	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
   	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
   	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:781)
   	at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:103)
   	at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
   	at org.apache.shardingsphere.proxy.backend.communication.jdbc.statement.accessor.impl.StatementAccessor.execute(StatementAccessor.java:43)
   	at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.ProxyJDBCExecutorCallback.executeSQL(ProxyJDBCExecutorCallback.java:84)
   	at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.ProxyJDBCExecutorCallback.executeSQL(ProxyJDBCExecutorCallback.java:77)
   	at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.ProxyJDBCExecutorCallback.executeSQL(ProxyJDBCExecutorCallback.java:48)
   	at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutorCallback.execute(JDBCExecutorCallback.java:76)
   	at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutorCallback.execute(JDBCExecutorCallback.java:56)
   	at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.syncExecute(ExecutorEngine.java:99)
   	at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.parallelExecute(ExecutorEngine.java:95)
   	at org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.execute(ExecutorEngine.java:80)
   	at org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutor.execute(JDBCExecutor.java:66)
   	at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.executeWithDriver(JDBCExecuteEngine.java:131)
   	at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.execute(JDBCExecuteEngine.java:124)
   	at org.apache.shardingsphere.proxy.backend.communication.jdbc.execute.engine.jdbc.JDBCExecuteEngine.execute(JDBCExecuteEngine.java:104)
   	at org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.doExecute(JDBCDatabaseCommunicationEngine.java:92)
   	at org.apache.shardingsphere.proxy.backend.communication.jdbc.JDBCDatabaseCommunicationEngine.execute(JDBCDatabaseCommunicationEngine.java:78)
   	at org.apache.shardingsphere.proxy.backend.text.query.QueryBackendHandler.execute(QueryBackendHandler.java:55)
   	at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:57)
   	at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:100)
   	at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:76)
   	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
   	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
   	at java.base/java.lang.Thread.run(Thread.java:834)
   ```


----------------------------------------------------------------
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:
users@infra.apache.org