LightDB24.1新特性Oracle模式支持in后面单个元素不带括号

默认PostgreSQL不支持in后面接单个元素不带括号，Oracle支持该行为，LightDB24.1开始支持该行为

lightdb@test=# create table test (
lightdb@test(# a int,
lightdb@test(# b varchar(100),
lightdb@test(# c varchar2(10), 
lightdb@test(# d date, 
lightdb@test(# m timestamp(6),
lightdb@test(# n ROWID
lightdb@test(# );
CREATE TABLE
lightdb@test=# select * from test where a in 2;
 a | b | c | d | m | n 
---+---+---+---+---+---
(0 rows)

lightdb@test=# select * from test where b in 'abc';
 a | b | c | d | m | n 
---+---+---+---+---+---
(0 rows)

lightdb@test=# select * from test where c in 'abc';
 a | b | c | d | m | n 
---+---+---+---+---+---
(0 rows)

lightdb@test=# select * from test where d in to_date('2022-01-01','yyyy-mm-dd');
 a | b | c | d | m | n 
---+---+---+---+---+---
(0 rows)

lightdb@test=# select * from test where m in to_timestamp('2022-01-01','yyyy-mm-dd');
 a | b | c | d | m | n 
---+---+---+---+---+---
(0 rows)

lightdb@test=# select * from test where n in 'dadsadqeqeqeqeq';
ERROR:  invalid input syntax for type tid: "dadsadqeqeqeqeq"
LINE 1: select * from test where n in 'dadsadqeqeqeqeq';
复制