[Bug]: sql-check report a syntax error when a sql is executed successfully

[yhilmare]

ODC version

4.2.2

OB version

not replated

What happened?

1. switch on the 'syntax error' rule

   

2. type and execute the sql as follow:

   drop table if exists t1;
   create table t1 (c1 text) ;
   insert into t1 select  (randstr(1+zipf(1, 43250, random()), random())) from table(generator(1000));

3. as you can see, the database execute these sqls successfully but the sql-check gives a syntax error:

What did you expect to happen?

if a sql is executed by observer without any syntax error, the sql-check should not report syntax error.

How can we reproduce it (as minimally and precisely as possible)?

follow 'what happened'

Anything else we need to know?

No response

Cloud

No response

[tonghan-gsh]

pass