odc icon indicating copy to clipboard operation
odc copied to clipboard

[Bug]: CREATE TYPE does not work with no ';' before '/'

Open alvinloong opened this issue 9 months ago • 1 comments

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

alvinloong avatar May 15 '24 10:05 alvinloong

Need to modify the parser, the repair cost is high, later versions to fix.

tonghan-gsh avatar Jun 04 '24 11:06 tonghan-gsh