odc
odc copied to clipboard
[Bug]: CREATE TYPE does not work with no ';' before '/'
ODC version
4.2.4-1712049785000
OB version
OceanBase 3.2.4.8
What happened?
This SQL can not run (no ';' before '/')
CREATE OR REPLACE TYPE "TYPE_TEST" as object
(
total varchar2(4000)
)
/
This SQL can run (with ';' before '/')
CREATE OR REPLACE TYPE "TYPE_TEST" as object
(
total varchar2(4000)
);
/
What did you expect to happen?
Both should work
CREATE OR REPLACE TYPE "TYPE_TEST" as object
(
total varchar2(4000)
)
/
CREATE OR REPLACE TYPE "TYPE_TEST" as object
(
total varchar2(4000)
);
/
How can we reproduce it (as minimally and precisely as possible)?
run following sqls in ODC
CREATE OR REPLACE TYPE "TYPE_TEST" as object
(
total varchar2(4000)
)
/
CREATE OR REPLACE TYPE "TYPE_TEST" as object
(
total varchar2(4000)
);
/
Anything else we need to know?
No response
Need to modify the parser, the repair cost is high, later versions to fix.