You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2023/09/07 04:40:09 UTC
[shardingsphere] branch master updated: Support OpenGauss tsquery type parse (#28370)
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 845533434fe Support OpenGauss tsquery type parse (#28370)
845533434fe is described below
commit 845533434fea924726936e00f89173247737c2bf
Author: Zichao <57...@users.noreply.github.com>
AuthorDate: Thu Sep 7 16:40:02 2023 +1200
Support OpenGauss tsquery type parse (#28370)
---
.../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 | 35 ----------------------
4 files changed, 18 insertions(+), 35 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 2858ced53ec..aa7744bb630 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
@@ -450,6 +450,7 @@ unreservedWord
| INT4RANGE
| NUMRANGE
| DATERANGE
+ | TSQUERY
;
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 b70cd7983d8..22842474aa4 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
@@ -3077,4 +3077,20 @@
</expression-projection>
</projections>
</select>
+
+ <select sql-case-id="select_tsquery">
+ <projections start-index="7" stop-index="24">
+ <expression-projection start-index="7" stop-index="24" text="'super:*'::tsquery">
+ <binary-operation-expression start-index="7" stop-index="24">
+ <left>
+ <literal-expression start-index="7" stop-index="15" value="super:*" />
+ </left>
+ <operator>::</operator>
+ <right>
+ <column start-index="17" stop-index="24" name="tsquery" />
+ </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 07fb4b61557..46c8cbb7acb 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
@@ -131,4 +131,5 @@
<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-case id="select_lower_inf_function" value="SELECT lower_inf('(,)'::daterange) AS RESULT;" db-types="openGauss" />
+ <sql-case id="select_tsquery" value="SELECT 'super:*'::tsquery;" 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 9b1cf441e28..a46faf20ed0 100644
--- a/test/it/parser/src/main/resources/sql/unsupported/unsupported.xml
+++ b/test/it/parser/src/main/resources/sql/unsupported/unsupported.xml
@@ -106,11 +106,6 @@
<sql-case id="unsupported_select_case_for_opengauss_96" value="select '[138,0.58,-369,1.25e+6]'::jsonb ->> 192.168.100.128/25;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_97" value="select '{&quot;a&quot;: 1, &quot;b&quot;: {&quot;a&quot;: 2, &quot;b&quot;: null}}'::json ->> 2021-05-31 12:59:08;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_98" value="select '{&quot;foo&quot;: [true, &quot;bar&quot;], &quot;tags&quot;: {&quot;a&quot;: 1, &quot;b&quot;: null}}'::json ->> 192.168.100.128/25;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_100" value="select 'fat:ab & cat'::tsquery;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_101" value="select 'super:*'::tsquery;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_102" value="select 'fat & rat'::tsquery;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_103" value="select 'fat & (rat | cat)'::tsquery;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_104" value="select 'fat & rat & ! cat'::tsquery;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_105" value="select 'a fat cat sat on a mat and ate a fat rat'::tsvector;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_106" value="select $$the lexeme ' ' contains spaces$$::tsvector;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_107" value="select 'a:1 fat:2 cat:3 sat:4 on:5 a:6 mat:7 and:8 ate:9 a:10 fat:11 rat:12'::tsvector;" db-types="openGauss" />
@@ -271,59 +266,29 @@
<sql-case id="unsupported_select_case_for_opengauss_444" value="select extract(week from timestamp '2001-02-16 20:38:40') from sys_dummy;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_447" value="select atan(11 11) from sys_dummy;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_448" value="select atan(,) from sys_dummy;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_449" value="select to_tsvector('fat cats ate fat rats') @@ 'fa:*'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_450" value="select to_tsvector('fat cats ate rats') @@(!!'rat'::tsquery) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_451" value="select $$the lexeme ' ' , contains spaces$$::tsvector@@ ','::tsquery as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_452" value="select setweight(body :: tsvector, 'a') from ts_zhparser;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_453" value="select to_tsvector('english', 'the fat rats')@@ 'the'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_454" value="select to_tsvector('fat cats ate rats') @@(!!'ratt'::tsquery) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_455" value="select 'fat cats ate'::tsvector || 'a b c'::tsvector;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_456" value="select 'fat | rat'::tsquery && 'cat'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_457" value="select to_tsvector('fat cats ate rats') @@('rat'::tsquery && 'cat'::tsquery) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_458" value="select 'a:1 b:2'::tsvector || 'c:1 d:2 b:3'::tsvector as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_459" value="select 'a b'::tsvector || 'c:1 d:2 b:3'::tsvector as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_460" value="select setweight('fat:2,4 cat:3 rat:5b'::tsvector, 1);" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_461" value="select setweight('fat:2,4 cat:3 rat:5b'::tsvector, '');" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_462" value="select $$the lexeme ' ' , contains spaces$$::tsvector || 'c:1 d:2 b:3'::tsvector as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_463" value="select numnode('(fat & rat) | cat'::tsquery);" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_464" value="select length(1::tsvector);" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_465" value="select strip(body :: tsvector) from ts_zhparser;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_466" value="select length('a b c'::tsvector || 'd e f'::tsvector);" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_467" value="select length('fat:2,4 cat:3 rat:5a'::tsvector);" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_468" value="select length($$the lexeme ' ' contains spaces$$::tsvector);" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_469" value="select length('fat:2,4 cat:3'::tsvector);" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_470" value="select numnode(body :: tsquery) from ts_zhparser;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_471" value="select 'fat'::tsquery = 'fat'::tsquery as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_472" value="select length('fat rat'::tsvector);" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_473" value="select numnode(bodyy :: tsquery) from ts_zhparser;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_474" value="select 'cat & rat'::tsquery <@ 'cat'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_475" value="select 'fat'::tsquery = 'fatt'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_476" value="select 'cat'::tsquery <@ 'cat & rat'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_477" value="select 'cat & rat'::tsquery <@ 'cat& rat'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_478" value="select 'cat'::tsquery @> 'cat'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_479" value="select 'cat&fat'::tsquery @> 'cat'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_480" value="select 'fat'::tsquery > 'fat'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_481" value="select 'fat'::tsquery > 'fat & rat'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_482" value="select 'fat & rat'::tsquery > 'fat'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_483" value="select 'cat'::tsquery @> 'cat & rat'::tsquery as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_484" value="select 'fat cats ate fat rats'::tsvector @@ ('fat'::tsquery && 'ate'::tsquery) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_485" value="select 'fat & rat'::tsquery || 'cat'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_486" value="select to_tsvector('fat cats ate rats') @@('rat'::tsquery || 'cat'::tsquery) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_487" value="select 'fat cats ate fat rats'::tsvector @@ ('fat'::tsquery && 'ateee'::tsquery) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_488" value="select 'fat | rat'::tsquery || 'cat'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_489" value="select 'fat:ab'::tsquery && 'fa:ab'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_490" value="select 'fat & rat'::tsquery && 'cat'::tsquery as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_491" value="select to_tsvector('fat cats ate ate' )|| 'a b c'::tsvector || 'd e f'::tsvector as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_492" value="select 'fat cats ate fat rats'::tsvector @@ ('fat'::tsquery || 'ateee'::tsquery) as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_493" value="select 'a:1a '::tsvector|| 'b:1a '::tsvector as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_494" value="select 'fat cats ate fat rats'::tsvector @@ to_tsquery('fat & rat')as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_495" value="select 'a:1 fat:2 cat:3 sat:4 on:5'::tsvector @@ 'fat'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_496" value="select 'rat'::tsquery && 'cat'::tsquery as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_497" value="select 'fat cats ate fat rats'::tsvector @@ ('fat11'::tsquery || 'ateee'::tsquery) as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_498" value="select 'rat'::tsquery && 'cat'::tsquery && '' ::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_499" value="select !! 'cat'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_500" value="select 'fat:ab'::tsquery || 'fa:ab'::tsquery as result;" db-types="openGauss" />
- <sql-case id="unsupported_select_case_for_opengauss_501" value="select 'rat'::tsquery && 'cat'::tsquery && ',' ::tsquery as result;" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_503" value="select to_char(interval '2' year ,'yyyy','yyyy');" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_504" value="select to_char(interval 2 year);" db-types="openGauss" />
<sql-case id="unsupported_select_case_for_opengauss_505" value="select to_char(current_timestamp, 0x5d);" db-types="openGauss" />