This is an automated email from the ASF dual-hosted git repository.
chengzhang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new b79117d92b8 Support OpenGauss int4range function parse (#28349)
b79117d92b8 is described below
commit b79117d92b87bba5911aa1fb649cda05695b7655
Author: Zichao <[email protected]>
AuthorDate: Mon Sep 4 21:38:50 2023 +1200
Support OpenGauss int4range function parse (#28349)
---
.../src/main/antlr4/imports/opengauss/BaseRule.g4 | 1 +
.../main/resources/case/dml/select-expression.xml | 16 ++++++++
.../sql/supported/dml/select-expression.xml | 1 +
.../main/resources/sql/unsupported/unsupported.xml | 48 ----------------------
4 files changed, 18 insertions(+), 48 deletions(-)
diff --git
a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4
b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4
index 114ab6e7cde..70871c8aba9 100644
--- a/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4
+++ b/parser/sql/dialect/opengauss/src/main/antlr4/imports/opengauss/BaseRule.g4
@@ -447,6 +447,7 @@ unreservedWord
| FLOAT4
| ELEM_CONTAINED_BY_RANGE
| INT8RANGE
+ | INT4RANGE
| NUMRANGE
;
diff --git a/test/it/parser/src/main/resources/case/dml/select-expression.xml
b/test/it/parser/src/main/resources/case/dml/select-expression.xml
index be382e57b8d..4adac49aae0 100644
--- a/test/it/parser/src/main/resources/case/dml/select-expression.xml
+++ b/test/it/parser/src/main/resources/case/dml/select-expression.xml
@@ -3053,4 +3053,20 @@
</expression-projection>
</projections>
</select>
+
+ <select sql-case-id="select_int4range">
+ <projections start-index="7" stop-index="48">
+ <expression-projection start-index="7" stop-index="48"
text="int4range(2,4) <@ int4range(1,7)" alias="RESULT">
+ <binary-operation-expression start-index="7" stop-index="38">
+ <left>
+ <function start-index="7" stop-index="21"
function-name="int4range" text="int4range(2,4)" />
+ </left>
+ <operator><@</operator>
+ <right>
+ <function start-index="23" stop-index="37"
function-name="int4range" text="int4range(1,7)" />
+ </right>
+ </binary-operation-expression>
+ </expression-projection>
+ </projections>
+ </select>
</sql-parser-test-cases>
diff --git
a/test/it/parser/src/main/resources/sql/supported/dml/select-expression.xml
b/test/it/parser/src/main/resources/sql/supported/dml/select-expression.xml
index b68344fbc9c..b95a9a0aa6d 100644
--- a/test/it/parser/src/main/resources/sql/supported/dml/select-expression.xml
+++ b/test/it/parser/src/main/resources/sql/supported/dml/select-expression.xml
@@ -129,4 +129,5 @@
<sql-case id="select_int_2_function" value="select int2(25.3);"
db-types="openGauss" />
<sql-case id="select_elem_contained_by_range_function" value="SELECT
elem_contained_by_range('2', numrange(1.1,2.2));" db-types="openGauss" />
<sql-case id="select_int8range" value="SELECT int8range(5,15) *
int8range(10,20) AS RESULT;" db-types="openGauss" />
+ <sql-case id="select_int4range" value="SELECT int4range(2,4) <@
int4range(1,7) AS RESULT;" db-types="openGauss" />
</sql-cases>
diff --git a/test/it/parser/src/main/resources/sql/unsupported/unsupported.xml
b/test/it/parser/src/main/resources/sql/unsupported/unsupported.xml
index 04764d04320..6e9cf9d0c99 100644
--- a/test/it/parser/src/main/resources/sql/unsupported/unsupported.xml
+++ b/test/it/parser/src/main/resources/sql/unsupported/unsupported.xml
@@ -186,124 +186,76 @@
<sql-case id="unsupported_select_case_for_opengauss_191" value="select
asin(2 2) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_192" value="select
asin(2)(2) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_193" value="select
asin 1 as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_194" value="select
int4range(1,3) + int8range(25,35) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_195" value="select
tsrange('[2021-01-01,2021-03-01)') + '[3,4]'::int4range as result;"
db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_197" value="select
tsrange('[2013-12-11 pst,2025-03-01 pst)') > ('[2013-12-11 pst,2021-05-01
pst)') as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_198" value="select
tsrange('[2021-01-01,2028-03-01)') > ('[2021-01-01,2021-05-01)') as result;"
db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_199" value="select
int4range(1,5) > '[1,4]'::int4range as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_200" value="select
int4range(10,10) > '(10,15)'::int4range as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_202" value="select
int4range(1,5) <= '[1,4]'::int4range as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_203" value="select
int4range(10,18) <= '(10,15)'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_206" value="select
tsrange('[2013-12-11 pst,2025-03-01 pst)') <= ('[2013-12-11 pst,2021-05-01
pst)') as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_207" value="select
tsrange('[2021-01-01,2028-03-01)') <= ('[2021-01-01,2021-05-01)') as
result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_208" value="select
int4range(1,5) * '[3,4]'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_210" value="select
tsrange('[2021-01-01,2021-03-01)') *('[2021-03-01,2021-10-01)') as result;"
db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_211" value="select
tsrange('[2013-12-11 pst,2021-03-01 pst)') *('[2021-3-01 pst,2021-05-01 pst)')
as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_212" value="select
tsrange('[2021-01-01,2021-03-01)') * ('[2021-3-01 pst,2021-05-01 pst)') as
result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_214" value="select
int4range(10,16) * '(10,11)'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_217" value="select
tsrange('[2013-12-11 pst,2021-03-01 pst)') < ('[2013-12-11 pst,2021-05-01
pst)') as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_218" value="select
tsrange('[2021-01-01,2021-03-01)') < ('[2021-01-01,2021-05-01)') as result;"
db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_219" value="select
int4range(1,5) < '[1,4]'::int4range as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_220" value="select
int4range(10,10) < '(10,11)'::int4range as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_222" value="select
int4range(1,3) + '[3,4]'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_224" value="select
tsrange('[2021-01-01,2021-03-01)') +('[2021-03-01,2021-10-01)') as result;"
db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_225" value="select
tsrange('[2013-12-11 pst,2021-03-01 pst)') +('[2021-3-01 pst,2021-05-01 pst)')
as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_226" value="select
tsrange('[2021-01-01,2021-03-01)') + ('[2021-3-01 pst,2021-05-01 pst)') as
result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_228" value="select
int4range(10,16) + '(10,11)'::int4range as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_230" value="select
lower_inc(int4range(10,10)) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_233" value="select
lower_inc(tsrange('[2021-01-01,2021-03-01)')) as result;" db-types="openGauss"
/>
<sql-case id="unsupported_select_case_for_opengauss_234" value="select
lower_inc(tsrange('[2013-12-11 pst,2021-03-01 pst)')) as result;"
db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_235" value="select
isempty(macaddr('08:00:2b:01:02:03'::macaddr ,'08:00:2b:01:02:03'::macaddr)) as
result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_236" value="select
isempty(bugstatus (create, closed)) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_237" value="select
int4range(1,3) -|- '[3,4]'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_239" value="select
tsrange('[2021-01-01,2021-03-01)') -|-('[2021-03-01,2021-10-01)') as result;"
db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_240" value="select
tsrange('[2013-12-11 pst,2021-03-01 pst)') -|-('[2021-3-01 pst,2021-05-01
pst)') as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_242" value="select
int4range(10,16) -|- '(10,11)'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_245" value="select
tsrange('[2013-12-11 pst,2021-03-01 pst)') <> ('[2013-12-11
pst,2021-05-01 pst)') as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_246" value="select
int4range(1,5) <> '[1,4]'::int4range as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_247" value="select
int4range(10,10) <> '(10,11)'::int4range as result;" db-types="openGauss"
/>
<sql-case id="unsupported_select_case_for_opengauss_249" value="select
tsrange('[2021-01-01,2021-03-01)') <> ('[2021-01-01,2021-03-01)') as
result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_252" value="select
int4range(1,5) >= '[1,4]'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_255" value="select
tsrange('[2013-12-11 pst,2025-03-01 pst)') >= ('[2013-12-11 pst,2021-05-01
pst)') as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_256" value="select
tsrange('[2021-01-01,2028-03-01)') >= ('[2021-01-01,2021-05-01)') as
result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_257" value="select
int4range(10,18) >= '(10,15)'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_259" value="select
tsrange('[2010-5-11 pst,2011-03-01 pst)') << ('[2013-12-11 pst,2021-05-01
pst)') as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_260" value="select
tsrange('[1999-01-01,2000-05-01)') << ('[2021-01-01,2021-05-01)') as
result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_261" value="select
int4range(1,5) << '[1,4]'::int4range as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_262" value="select
int4range(10,10) << '(10,11)'::int4range as result;" db-types="openGauss"
/>
- <sql-case id="unsupported_select_case_for_opengauss_264" value="select
int4range(5,10) >> '[1,4]'::int4range as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_265" value="select
int4range(20,25) >> '(10,20)'::int4range as result;" db-types="openGauss"
/>
<sql-case id="unsupported_select_case_for_opengauss_268" value="select
tsrange('[2010-5-11 pst,2011-03-01 pst)') >> ('[2013-12-11 pst,2021-05-01
pst)') as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_269" value="select
tsrange('[1999-01-01,2000-05-01)') >> ('[2021-01-01,2021-05-01)') as
result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_270" value="select
int4range(1,5) @> '[1,4]'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_272" value="select
tsrange('[2013-12-11 pst,2025-03-01 pst)') @> ('[2013-12-11 pst,2021-05-01
pst)') as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_273" value="select
tsrange('[2021-01-01,2028-03-01)') @> ('[2021-01-01,2021-05-01)') as
result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_274" value="select
int4range(10,12) @> '(10,15)'::int4range as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_276" value="select
int4range(1,5) = '[1,4]'::int4range as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_277" value="select
int4range(10,10) = '(10,11)'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_279" value="select
tsrange('[2021-01-01,2021-03-01)') = ('[2021-01-01,2021-03-01)') as result;"
db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_281" value="select
tsrange('[2013-12-11 pst,2021-03-01 pst)') = ('[2013-12-11 pst,2021-05-01
pst)') as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_282" value="select
int4range(1,5) &> '[1,4]'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_284" value="select
tsrange('[2021-01-01,2021-03-01)') &> ('[2021-01-01,2021-03-01)') as
result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_285" value="select
tsrange('[2013-12-11 pst,2021-03-01 pst)') &> ('[2013-12-11
pst,2021-05-01 pst)') as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_287" value="select
int4range(10,16) &> '(10,11)'::int4range as result;"
db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_288" value="select
int4range(1,5) <@ '[1,4]'::int4range as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_290" value="select
int4range(10,12) <@ '(10,15)'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_292" value="select
tsrange('[2013-12-11 pst,2025-03-01 pst)') <@ ('[2013-12-11 pst,2021-05-01
pst)') as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_293" value="select
tsrange('[2021-01-01,2028-03-01)') <@ ('[2021-01-01,2021-05-01)') as
result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_294" value="select
int4range(1,5) @> 4 as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_295" value="select
tsrange('[2013-12-11 pst,2025-03-01 pst)') @> '2014-12-11 pst'::timestamp
as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_296" value="select
tsrange('[2021-01-01,2028-03-01)') @> '2026-09-09'::timestamp as result;"
db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_297" value="select
int4range(10,12) @> 9 as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_299" value="select
int4range(1,5) &< '[1,4]'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_301" value="select
tsrange('[2021-01-01,2021-03-01)') &< ('[2021-01-01,2021-03-01)') as
result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_302" value="select
tsrange('[2013-12-11 pst,2021-03-01 pst)') &< ('[2013-12-11
pst,2021-05-01 pst)') as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_304" value="select
int4range(10,16) &< '(10,11)'::int4range as result;"
db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_305" value="select
int4range(1,3) - int8range(25,35) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_306" value="select
tsrange('[2021-01-01,2021-03-01)') - '[3,4]'::int4range as result;"
db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_312" value="select
lower(int4range(10,80)) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_315" value="select
lower(tsrange('[2021-01-01,2021-03-01)')) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_316" value="select
lower(tsrange('[2013-12-11 pst,2021-03-01 pst)')) as result;"
db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_320" value="select
lower_inf(macaddr('08:00:2b:01:02:03'::macaddr ,'08:00:2b:01:02:03'::macaddr))
as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_321" value="select
lower_inf(bugstatus (create, closed)) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_322" value="select 4
<@ int4range(1,5) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_324" value="select
'2014-12-11 pst'::timestamp <@ tsrange('[2013-12-11 pst,2025-03-01 pst)') as
result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_325" value="select
'2026-09-09'::timestamp <@ tsrange('[2021-01-01,2028-03-01)') as result;"
db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_326" value="select 9
<@ int4range(10,12) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_328" value="select
int4range(1,5) && '[1,4]'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_330" value="select
tsrange('[2021-01-01,2021-03-01)') && ('[2021-01-01,2021-03-01)') as
result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_331" value="select
tsrange('[2013-12-11 pst,2021-03-01 pst)') && ('[2013-12-11
pst,2021-05-01 pst)') as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_333" value="select
int4range(10,10) && '(10,11)'::int4range as result;"
db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_334" value="select
upper_inf('(,)'::daterange) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_335" value="select
upper_inf(int4range'(,10)') as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_338" value="select
upper_inf(tsrange('(2021-01-01,]')) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_339" value="select
upper_inf(tsrange('[,2021-03-01 pst]')) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_345" value="select
int4range(1,5) - '[3,4]'::int4range as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_347" value="select
tsrange('[2021-01-01,2021-03-01)') -('[2021-03-01,2021-10-01)') as result;"
db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_348" value="select
tsrange('[2013-12-11 pst,2021-03-01 pst)') -('[2021-3-01 pst,2021-05-01 pst)')
as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_349" value="select
tsrange('[2021-01-01,2021-03-01)') - ('[2021-3-01 pst,2021-05-01 pst)') as
result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_350" value="select
int4range(10,16) - '(10,11)'::int4range as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_352" value="select
upper(int4range(10,80)) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_355" value="select
upper(tsrange('[2021-01-01,2021-03-01)')) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_356" value="select
upper(tsrange('[2013-12-11 pst,2021-03-01 pst)')) as result;"
db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_357" value="select
upper_inc(int4range(10,10)) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_360" value="select
upper_inc(tsrange('(2021-01-01,2021-03-01]')) as result;" db-types="openGauss"
/>
<sql-case id="unsupported_select_case_for_opengauss_361" value="select
upper_inc(tsrange('[2013-12-11 pst,2021-03-01 pst]')) as result;"
db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_362" value="select
lower_inc(macaddr('08:00:2b:01:02:03'::macaddr ,'08:00:2b:01:02:03'::macaddr))
as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_363" value="select
lower_inc(bugstatus (create, closed)) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_364" value="select
lower(macaddr('08:00:2b:01:02:03'::macaddr ,'08:00:2b:01:02:03'::macaddr)) as
result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_365" value="select
lower(bugstatus (create, closed)) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_366" value="select
int4range(1,3) * int8range(25,35) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_367" value="select
tsrange('[2021-01-01,2021-03-01)') * '[3,4]'::int4range as result;"
db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_368" value="select
upper_inc(macaddr('08:00:2b:01:02:03'::macaddr ,'08:00:2b:01:02:03'::macaddr))
as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_369" value="select
upper_inc(bugstatus (create, closed)) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_370" value="select
upper(macaddr('08:00:2b:01:02:03'::macaddr ,'08:00:2b:01:02:03'::macaddr)) as
result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_371" value="select
upper(bugstatus (create, closed)) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_372" value="select
isempty(int4range(10,10)) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_375" value="select
isempty(tsrange('[2021-01-01,2021-03-01)')) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_376" value="select
isempty(tsrange('[2013-12-11 pst,2021-03-01 pst)')) as result;"
db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_377" value="select
lower_inf('(,)'::daterange) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_378" value="select
lower_inf(int4range'(,10)') as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_381" value="select
lower_inf(tsrange('(2021-01-01,2021-03-01]')) as result;" db-types="openGauss"
/>
<sql-case id="unsupported_select_case_for_opengauss_382" value="select
lower_inf(tsrange('[,2021-03-01 pst]')) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_383" value="select
hll_hash_boolean(@,10);" db-types="openGauss" />
