sandynz commented on issue #37579:
URL:
https://github.com/apache/shardingsphere/issues/37579#issuecomment-3782422389
Test on openGauss, run PostgreSQLMigrationGeneralE2EIT .
Proxy log:
```
[INFO ] 2026-01-22 11:46:27.980
[j0102p000033170cdbde8047c808003a086ae4ca0a_Worker-1]
o.a.s.d.p.c.p.d.PipelineJobDataSourcePreparer - Execute target table SQL:
CREATE INDEX idx_user_id ON test.test.t_order USING btree (user_id) TABLESPACE
pg_default
[ERROR] 2026-01-22 11:46:28.225
[j0102p000033170cdbde8047c808003a086ae4ca0a_Worker-1]
o.a.s.d.p.c.j.e.DistributedPipelineJobExecutor - Job
j0102p000033170cdbde8047c808003a086ae4ca0a-0 execution failed.
org.apache.shardingsphere.database.exception.core.exception.syntax.sql.DialectSQLParsingException:
You have an error in your SQL syntax: CREATE INDEX idx_user_id ON
test.test.t_order USING btree (user_id) TABLESPACE pg_default, null
at
org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.getException(ShardingSphereSQLParserEngine.java:66)
at
org.apache.shardingsphere.infra.parser.ShardingSphereSQLParserEngine.parse(ShardingSphereSQLParserEngine.java:59)
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.createQueryContext(ShardingSphereStatement.java:259)
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.execute(ShardingSphereStatement.java:247)
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSphereStatement.execute(ShardingSphereStatement.java:195)
at
org.apache.shardingsphere.data.pipeline.core.preparer.datasource.PipelineJobDataSourcePreparer.executeTargetTableSQL(PipelineJobDataSourcePreparer.java:152)
at
org.apache.shardingsphere.data.pipeline.core.preparer.datasource.PipelineJobDataSourcePreparer.prepareTargetTables(PipelineJobDataSourcePreparer.java:124)
at
org.apache.shardingsphere.data.pipeline.scenario.migration.preparer.MigrationJobPreparer.prepareTarget(MigrationJobPreparer.java:148)
```
Original SQL:
```
CREATE INDEX idx_user_id ON test.t_order USING btree (user_id) TABLESPACE
pg_default
```
Related debug screenshots:
<img width="3178" height="1362" alt="Image"
src="https://github.com/user-attachments/assets/f2befa3c-698f-4872-8a91-c277d300c1ca";
/>
--
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]
