328931589 commented on issue #29499: URL: https://github.com/apache/shardingsphere/issues/29499#issuecomment-2051380038
> @niaucz I saw your project. It seems that `create table` is not executed through ShardingSphere? In this case, there are no tables required for sharding in your DB. > > I submitted a PR, you can execute `testCreateTable` first and then `testInsert` [niaucz/ss-test#1](https://github.com/niaucz/ss-test/pull/1) > > ```sql > Logic SQL: INSERT INTO nx_data ( id, point_guid, tag, `value`, `timestamp` ) VALUES ( ?, ? , ? , ? , ? ) > Actual SQL: write_ds ::: INSERT INTO nx_data_2 ( id, point_guid, tag, `value`, `timestamp` ) VALUES (?, ?, ?, ?, ?) ::: [1735191437835788289, 21F272A4-6D8A-4638-9C9F-07D2B12E4B14, 205021001003, 8158.21, 2023-12-26 14:31:56.0] > ``` I don't think it's a good idea。 In the case of use sharding table，SimpleTableSegmentBinder checkTableExists is earlier than SQLRouter，we use logic table name in the sql, when checkTableExists，must require a logical table name in the database。 -- 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]
