strongduanmu opened a new issue, #34029: URL: https://github.com/apache/shardingsphere/issues/34029
## Feature Request ### Is your feature request related to a problem? No ### Describe the feature you would like. Currently, TablesContext is used to process tables in SQL statements, as well as the database and schema information to which the tables belong. It also provides the `findTableNames` method, which is responsible for finding the table information based on columns and metadata. This method can handle simple SQL scenarios, but for complex multi-table associations and nested subqueries, findTableNames has difficulty analyzing the correct table, which can cause some functional abnormalities. In order to completely solve this problem, we need to use SQLBindEngine to process these statements. Currently, statements that implement the TableAvailable interface need to be bound in SQL BindEngine. The binding goal is to find the library and schema to which the TableNameSegment in SimpleTableSegement belongs, and then set the TableSegmentBoundInfo object. The following are the statements that need to implement SQLBind. - [x] AlterIndexStatementContext @YaoFly - [x] AlterTableStatementContext @strongduanmu - [x] AlterViewStatementContext - [x] AnalyzeTableStatementContext - [x] CloseStatementContext - [x] CommentStatementContext - [x] CopyStatementContext @lubochen - [x] CreateIndexStatementContext - [x] CreateTableStatementContext @strongduanmu - [x] CreateViewStatementContext - [x] CursorStatementContext - [x] DeleteStatementContext @strongduanmu - [x] DenyUserStatementContext - [x] DropIndexStatementContext @YaoFly - [x] DropTableStatementContext - [x] DropViewStatementContext @chakkk309 - [ ] ExplainStatementContext - [x] FetchStatementContext - [ ] FlushStatementContext - [ ] GrantStatementContext - [x] InsertStatementContext @strongduanmu - [x] LoadDataStatementContext @YaoFly - [x] LoadXMLStatementContext @YaoFly - [x] MoveStatementContext - [x] OptimizeTableStatementContext - [x] PrepareStatementContext - [x] RenameTableStatementContext - [x] RevokeStatementContext - [x] SelectStatementContext @strongduanmu - [x] ShowColumnsStatementContext - [x] ShowCreateTableStatementContext - [x] ShowIndexStatementContext - [x] TruncateStatementContext - [x] UpdateStatementContext @strongduanmu -- 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]
