You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "Hvision (via GitHub)" <gi...@apache.org> on 2023/12/05 08:16:12 UTC
[I] Unable to parse this statement that create a database [shardingsphere]
Hvision opened a new issue, #29289:
URL: https://github.com/apache/shardingsphere/issues/29289
CREATE TABLE "C##TPCC2"."TEST_BASIC2"
( "BS_COL01" NUMBER,
"BS_COL02" NUMBER(38,6),
"BS_COL03" VARCHAR2(6),
"BS_COL04" VARCHAR2(6),
"BS_COL05" NUMBER,
"BS_COL06" NUMBER,
"BS_COL07" NUMBER,
"BS_COL08" NUMBER(10,4),
"BS_COL09" NUMBER(10,4),
"BS_COL10" BINARY_DOUBLE,
"BS_COL11" VARCHAR2(6),
"BS_COL12" CHAR(6),
"BS_COL13" CHAR(6),
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"
--
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-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "zihaoAK47 (via GitHub)" <gi...@apache.org>.
zihaoAK47 commented on issue #29289:
URL: https://github.com/apache/shardingsphere/issues/29289#issuecomment-1840265632
Hi, please provide more detailed information, such as version and error information, based on the problem template.
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "zihaoAK47 (via GitHub)" <gi...@apache.org>.
zihaoAK47 commented on issue #29289:
URL: https://github.com/apache/shardingsphere/issues/29289#issuecomment-1870758864
@ilyasahsan123 Thank you.
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "zihaoAK47 (via GitHub)" <gi...@apache.org>.
zihaoAK47 commented on issue #29289:
URL: https://github.com/apache/shardingsphere/issues/29289#issuecomment-1870736788
@ilyasahsan123 Hi, thank you for your attention to this issue. Can you display a preview of antlr?
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "zihaoAK47 (via GitHub)" <gi...@apache.org>.
zihaoAK47 commented on issue #29289:
URL: https://github.com/apache/shardingsphere/issues/29289#issuecomment-1870745402
The second half of SQL seems to have not been parsed.
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "Hvision (via GitHub)" <gi...@apache.org>.
Hvision commented on issue #29289:
URL: https://github.com/apache/shardingsphere/issues/29289#issuecomment-1840230866
this is oracle 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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "ilyasahsan123 (via GitHub)" <gi...@apache.org>.
ilyasahsan123 commented on issue #29289:
URL: https://github.com/apache/shardingsphere/issues/29289#issuecomment-1870740288
Sure, here is the ANTLR preview.
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "ilyasahsan123 (via GitHub)" <gi...@apache.org>.
ilyasahsan123 commented on issue #29289:
URL: https://github.com/apache/shardingsphere/issues/29289#issuecomment-1870750646
Got it, you are correct. Sorry for my mistake.
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "ilyasahsan123 (via GitHub)" <gi...@apache.org>.
ilyasahsan123 commented on issue #29289:
URL: https://github.com/apache/shardingsphere/issues/29289#issuecomment-1870966188
Hi @zihaoAK47 @strongduanmu, i have sent the PR, could you please take a look?
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "zihaoAK47 (via GitHub)" <gi...@apache.org>.
zihaoAK47 closed issue #29289: Unable to parse this statement that create a database
URL: https://github.com/apache/shardingsphere/issues/29289
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "zihaoAK47 (via GitHub)" <gi...@apache.org>.
zihaoAK47 commented on issue #29289:
URL: https://github.com/apache/shardingsphere/issues/29289#issuecomment-1842167003
Thank you for your feedback. The above issue is caused by SQL not being parsed correctly. Would you be willing to improve this issue?
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "Hvision (via GitHub)" <gi...@apache.org>.
Hvision commented on issue #29289:
URL: https://github.com/apache/shardingsphere/issues/29289#issuecomment-1844799340
@zihaoAK47 sorry, I don't understand grammar of Antlr .
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "ilyasahsan123 (via GitHub)" <gi...@apache.org>.
ilyasahsan123 commented on issue #29289:
URL: https://github.com/apache/shardingsphere/issues/29289#issuecomment-1870757911
Sure, please assign this to me.
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "ilyasahsan123 (via GitHub)" <gi...@apache.org>.
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "zihaoAK47 (via GitHub)" <gi...@apache.org>.
zihaoAK47 commented on issue #29289:
URL: https://github.com/apache/shardingsphere/issues/29289#issuecomment-1870752829
Would you be willing to investigate this issue? I will assign it to you
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "Hvision (via GitHub)" <gi...@apache.org>.
Hvision commented on issue #29289:
URL: https://github.com/apache/shardingsphere/issues/29289#issuecomment-1842128312
@zihaoAK47 version is master and err infoļ¼
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Unable to parse this statement that create a database [shardingsphere]
Posted by "Hvision (via GitHub)" <gi...@apache.org>.
Hvision commented on issue #29289:
URL: https://github.com/apache/shardingsphere/issues/29289#issuecomment-1842129517
my code
--
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-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org