TaowzzZ opened a new issue, #32715: URL: https://github.com/apache/shardingsphere/issues/32715
In my project(springboot) with Shardingsphere , there a SQL as follow: `select table_name ,create_time , engine, table_collation, table_comment from information_schema.tables where table_schema = (select database()) and table_name like :table order by create_time desc` This SQL aims to qurey some tables' infomation. After excuting this SQL, the following error occured: `digger- 2024-08-28 23:49:55 [main] INFO ShardingSphere-SQL - Logic SQL: select quartzjob0_.job_id as job_id1_15_, quartzjob0_.create_by as create_b2_15_, quartzjob0_.create_time as create_t3_15_, quartzjob0_.update_by as update_b4_15_, quartzjob0_.update_time as update_t5_15_, quartzjob0_.bean_name as bean_nam6_15_, quartzjob0_.cron_expression as cron_exp7_15_, quartzjob0_.description as descript8_15_, quartzjob0_.email as email9_15_, quartzjob0_.is_pause as is_paus10_15_, quartzjob0_.job_name as job_nam11_15_, quartzjob0_.method_name as method_12_15_, quartzjob0_.params as params13_15_, quartzjob0_.pause_after_failure as pause_a14_15_, quartzjob0_.person_in_charge as person_15_15_, quartzjob0_.sub_task as sub_tas16_15_ from sys_quartz_job quartzjob0_ where quartzjob0_.is_pause=0 digger- 2024-08-28 23:49:55 [main] INFO ShardingSphere-SQL - SQLStatement: MySQLSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=0, parameterMarkerSegments=[], commentSegments=[]), projections=ProjectionsSegment(startIndex=7, stopIndex=656, projections=[ColumnProjectionSegment(column=ColumnSegment(startIndex=7, stopIndex=24, identifier=IdentifierValue(value=job_id, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=7, stopIndex=17, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[job_id1_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=42, stopIndex=62, identifier=IdentifierValue(value=create_by, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=42, stopIndex=52, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[create_b2_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=82, stopIndex=10 4, identifier=IdentifierValue(value=create_time, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=82, stopIndex=92, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[create_t3_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=124, stopIndex=144, identifier=IdentifierValue(value=update_by, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=124, stopIndex=134, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[update_b4_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=164, stopIndex=186, identifier=IdentifierValue(value=update_time, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=164, stopIndex=174, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[update_t5_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=206, stopIndex=226, identifier=Ide ntifierValue(value=bean_name, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=206, stopIndex=216, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[bean_nam6_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=246, stopIndex=272, identifier=IdentifierValue(value=cron_expression, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=246, stopIndex=256, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[cron_exp7_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=292, stopIndex=314, identifier=IdentifierValue(value=description, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=292, stopIndex=302, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[descript8_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=334, stopIndex=350, identifier=IdentifierValu e(value=email, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=334, stopIndex=344, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[email9_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=367, stopIndex=386, identifier=IdentifierValue(value=is_pause, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=367, stopIndex=377, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[is_paus10_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=406, stopIndex=425, identifier=IdentifierValue(value=job_name, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=406, stopIndex=416, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[job_nam11_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=445, stopIndex=467, identifier=IdentifierValue(value=method_name, quoteCh aracter=NONE), owner=Optional[OwnerSegment(startIndex=445, stopIndex=455, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[method_12_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=487, stopIndex=504, identifier=IdentifierValue(value=params, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=487, stopIndex=497, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[params13_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=523, stopIndex=553, identifier=IdentifierValue(value=pause_after_failure, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=523, stopIndex=533, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[pause_a14_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=573, stopIndex=600, identifier=IdentifierValue(value=person_in_charge, quoteCharacte r=NONE), owner=Optional[OwnerSegment(startIndex=573, stopIndex=583, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[person_15_15_]), ColumnProjectionSegment(column=ColumnSegment(startIndex=620, stopIndex=639, identifier=IdentifierValue(value=sub_task, quoteCharacter=NONE), owner=Optional[OwnerSegment(startIndex=620, stopIndex=630, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), alias=Optional[sub_tas16_15_])], distinctRow=false), from=SimpleTableSegment(tableName=TableNameSegment(startIndex=663, stopIndex=676, identifier=IdentifierValue(value=sys_quartz_job, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional[quartzjob0_]), where=Optional[WhereSegment(startIndex=690, stopIndex=717, expr=BinaryOperationExpression(startIndex=696, stopIndex=717, left=ColumnSegment(startIndex=696, stopIndex=715, identifier=IdentifierValue(value=is_pause, quoteCharacter=NONE), owner=Optional[O wnerSegment(startIndex=696, stopIndex=706, identifier=IdentifierValue(value=quartzjob0_, quoteCharacter=NONE), owner=Optional.empty)]), right=LiteralExpressionSegment(startIndex=717, stopIndex=717, literals=0), operator==, text=quartzjob0_.is_pause=0))], groupBy=Optional.empty, having=Optional.empty, orderBy=Optional.empty, combines=[]), table=Optional.empty, limit=Optional.empty, lock=Optional.empty, window=Optional.empty) digger- 2024-08-28 23:49:55 [main] INFO ShardingSphere-SQL - Actual SQL: digger ::: select quartzjob0_.job_id as job_id1_15_, quartzjob0_.create_by as create_b2_15_, quartzjob0_.create_time as create_t3_15_, quartzjob0_.update_by as update_b4_15_, quartzjob0_.update_time as update_t5_15_, quartzjob0_.bean_name as bean_nam6_15_, quartzjob0_.cron_expression as cron_exp7_15_, quartzjob0_.description as descript8_15_, quartzjob0_.email as email9_15_, quartzjob0_.is_pause as is_paus10_15_, quartzjob0_.job_name as job_nam11_15_, quartzjob0_.method_name as method_12_15_, quartzjob0_.params as params13_15_, quartzjob0_.pause_after_failure as pause_a14_15_, quartzjob0_.person_in_charge as person_15_15_, quartzjob0_.sub_task as sub_tas16_15_ from sys_quartz_job quartzjob0_ where quartzjob0_.is_pause=0` It looks like that the Shardingsphere rewrited my SQL, and delete 'information_schema.', which make the error?Is there anyone encountered this situation? How can it be solved? The version number of Shardingsphere that I use is shardingsphere-jdbc-core-spring-boot-starter v5.2.0. -- 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: notifications-unsubscr...@shardingsphere.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
