This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang 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 b86dfa516ea Support OpenGauss int8range function parse (#28348)
b86dfa516ea is described below
commit b86dfa516ea577d500f786abb7fa614814767813
Author: Zichao <[email protected]>
AuthorDate: Mon Sep 4 15:56:46 2023 +1200
Support OpenGauss int8range function parse (#28348)
---
.../src/main/antlr4/imports/opengauss/BaseRule.g4 | 3 +-
.../main/resources/case/dml/select-expression.xml | 16 ++++++
.../sql/supported/dml/select-expression.xml | 1 +
.../main/resources/sql/unsupported/unsupported.xml | 62 ----------------------
4 files changed, 19 insertions(+), 63 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 c87f174e4d9..114ab6e7cde 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
@@ -446,7 +446,8 @@ unreservedWord
| INT16
| FLOAT4
| ELEM_CONTAINED_BY_RANGE
-
+ | INT8RANGE
+ | NUMRANGE
;
typeFuncNameKeyword
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 5f258c8ed2f..d955db4258d 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
@@ -2994,4 +2994,20 @@
</expression-projection>
</projections>
</select>
+
+ <select sql-case-id="select_int8range">
+ <projections start-index="7" stop-index="50">
+ <expression-projection start-index="7" stop-index="50"
text="int8range(5,15) * int8range(10,20)" alias="RESULT">
+ <binary-operation-expression start-index="7" stop-index="40">
+ <left>
+ <function start-index="7" stop-index="22"
function-name="int8range" text="int8range(5,15)" />
+ </left>
+ <operator>*</operator>
+ <right>
+ <function start-index="23" stop-index="40"
function-name="int8range" text="int8range(10,20)" />
+ </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 29f68db6a71..b68344fbc9c 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
@@ -128,4 +128,5 @@
<sql-case id="select_ts_rewrite_function" value="SELECT ts_rewrite('a
& b'::tsquery, 'a'::tsquery, 'c'::tsquery);" db-types="openGauss" />
<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-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 3d0b4bdab19..04764d04320 100644
--- a/test/it/parser/src/main/resources/sql/unsupported/unsupported.xml
+++ b/test/it/parser/src/main/resources/sql/unsupported/unsupported.xml
@@ -188,163 +188,105 @@
<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_196" value="select
numrange(8.1,10.2,'[]') > numrange(5.1,6.7,'()') 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_201" value="select
int8range(15,25) > int8range(15,26) 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_204" value="select
int8range(15,26) <= int8range(15,26) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_205" value="select
numrange(8.1,10.2,'[]') <= numrange(5.1,6.7,'()') 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_209" value="select
int8range(16,30) *int8range(25,35) 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_213" value="select
numrange(1.1,9.9,'[]') * numrange(5.1,6.7,'()') 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_215" value="select
int8range(16,25) *int8range(15,35) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_216" value="select
numrange(1.1,2.2,'[]') < numrange(5.1,6.7,'()') 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_221" value="select
int8range(15,25) < int8range(15,25) 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_223" value="select
int8range(16,25) +int8range(25,35) 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_227" value="select
numrange(1.1,9.9,'[]') + numrange(5.1,6.7,'()') 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_229" value="select
int8range(16,25) +int8range(15,35) 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_231" value="select
lower_inc(int8range(15,25)) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_232" value="select
lower_inc(numrange(1.1,2.2)) 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_238" value="select
int8range(16,25) -|-int8range(25,35) 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_241" value="select
numrange(1.1,9.9,'[]') -|- numrange(5.1,6.7,'()') 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_243" value="select
int8range(16,25) -|-int8range(15,35) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_244" value="select
numrange(1.1,2.2,'[]') <> numrange(5.1,6.7,'()') 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_248" value="select
int8range(15,25) <> int8range(15,25) 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_253" value="select
int8range(15,26) >= int8range(15,26) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_254" value="select
numrange(8.1,10.2,'[]') >= numrange(5.1,6.7,'()') 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_258" value="select
numrange(1.1,2.2,'[]') << numrange(5.1,6.7,'()') 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_263" value="select
int8range(15,25) << int8range(15,25) 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_266" value="select
int8range(25,50) >> int8range(15,25) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_267" value="select
numrange(1.1,2.2,'[]') >> numrange(5.1,6.7,'()') 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_271" value="select
int8range(15,26) @> int8range(15,26) 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_275" value="select
numrange(8.1,10.2,'[]') @> numrange(5.1,6.7,'()') 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_278" value="select
int8range(15,25) = int8range(15,25) 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_280" value="select
numrange(1.1,2.2,'[]') = numrange(5.1,6.7,'()') 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_283" value="select
int8range(16,25) &> int8range(15,25) 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_286" value="select
numrange(1.1,9.9,'[]') &> numrange(5.1,6.7,'()') 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_289" value="select
int8range(15,26) <@ int8range(15,26) 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_291" value="select
numrange(8.1,10.2,'[]') <@ numrange(5.1,6.7,'()') 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_298" value="select
numrange(8.1,10.2,'[]') @> 6.1::numeric 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_300" value="select
int8range(15,25) &< int8range(15,25) 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_303" value="select
numrange(1.1,9.9,'[]') &< numrange(5.1,6.7,'()') 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_313" value="select
lower(int8range(15,25)) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_314" value="select
lower(numrange(1.1,2.2)) 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_317" value="select
numrange(1.1,'a','[]') as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_318" value="select
numrange('abc','111','[]') as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_319" value="select
numrange(2.3,111.5,'1') 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_323" value="select
17::int8 <@ int8range(15,26) 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_327" value="select
6.1::numeric <@ numrange(8.1,10.2,'[]') 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_329" value="select
int8range(15,25) && int8range(15,25) 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_332" value="select
numrange(1.1,2.2,'[]') && numrange(5.1,6.7,'()') 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_336" value="select
upper_inf('(15,)'::int8range) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_337" value="select
upper_inf(numrange(1.1,2.2)) 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_340" value="select
numrange(1.1,2.2,'[]') as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_341" value="select
numrange(5.1,6.7,'()') as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_342" value="select
numrange(5.1,6.7,'(]') as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_343" value="select
numrange(7.7,8.7,'[)') as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_344" value="select
numrange(1.1,'123','[]') 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_346" value="select
int8range(16,30) -int8range(25,35) 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_351" value="select
int8range(16,25) -int8range(15,35) 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_353" value="select
upper(int8range(15,25)) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_354" value="select
upper(numrange(1.1,2.2)) 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_358" value="select
upper_inc(int8range(15,25)) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_359" value="select
upper_inc(numrange(1.1,2.2)) 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" />
@@ -358,14 +300,10 @@
<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_373" value="select
isempty(int8range(15,25)) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_374" value="select
isempty(numrange(1.1,2.2)) 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_379" value="select
lower_inf(int8range(15,25)) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_380" value="select
lower_inf(numrange(1.1,2.2)) 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" />
