ilyasahsan123 commented on issue #29289:
URL:
https://github.com/apache/shardingsphere/issues/29289#issuecomment-1870391693
Hi @zihaoAK47,
I'm not sure if there's an issue with the provided query. I tested it with
the following test case, and it passed. Could you please re-validate it?
**Case:**
```
<create-table sql-case-id="create_table_with_issue_29289">
<table name="TEST_BASIC2" start-delimiter="""
end-delimiter=""" start-index="13" stop-index="36">
<owner name="C##TPCC2" start-delimiter="""
end-delimiter=""" start-index="13" stop-index="22" />
</table>
<column-definition type="NUMBER" start-index="43" stop-index="59">
<column name="BS_COL01"/>
</column-definition>
<column-definition type="NUMBER" start-index="66" stop-index="82">
<column name="BS_COL02"/>
</column-definition>
<constraint-definition start-index="89" stop-index="111">
<primary-key-column name="BS_COL01" start-delimiter="""
end-delimiter=""" start-index="102" stop-index="111" />
</constraint-definition>
</create-table>
```
**SQL**
```
<sql-case id="create_table_with_issue_29289" value="CREATE TABLE
"C##TPCC2"."TEST_BASIC2"
("BS_COL01" NUMBER,
"BS_COL02" NUMBER,
PRIMARY KEY ("BS_COL01")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TPCCTAB" ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TPCCTAB"" db-types="Oracle" />
```
--
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]
