shardingsphere There is LOCATION,PARENT etc in Oracle SQL, then prompt You have an error in your SQL syntax.

There is LOCATION,PARENT etc in Oracle SQL, then prompt You have an error in your SQL syntax.

Open XuHaijwill opened this issue 2 years ago • 4 comments

My contains the fields LOCATION,PARENT, and the program reported an error.

My Eventment is shardingsphere 5.1.0(spring-boot-start) mybaits Oracle 19c Java 1.8

sql is:select location,parent from organization

Mar 03 '22 14:03 XuHaijwill

Hi team,Why can't location and pareant be queried as field names in Oracle?

Mar 03 '22 14:03 XuHaijwill

It seems like oracle parse problem, does anyone want to fix it?

Jun 24 '22 15:06 terrymanu

I would like to take this.

Aug 11 '22 04:08 tianhao960

@tianhao960 Welcome.

Aug 11 '22 04:08 strongduanmu