You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/04/01 03:43:05 UTC

[GitHub] [shardingsphere] jingshanglu opened a new issue #9899: PostgreSQL parser error

jingshanglu opened a new issue #9899:
URL: https://github.com/apache/shardingsphere/issues/9899


   ## Bug Report
   
   
   Please answer these questions before submitting your issue. Thanks!
   
   ### Which version of ShardingSphere did you use?
   
   commit :59970c77e435c702a174a1d98e932cc9fa125a85
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   
   ### Expected behavior
   ```
   SELECT n.nspname as "Schema",c.relname as "Name",CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN 'partitioned table' WHEN 'I' THEN 'partitioned index' END as "Type",pg_catalog.pg_get_userbyid(c.relowner) as "Owner" FROM pg_catalog.pg_classcLEFTJOINpg_catalog.pg_namespacen ON n.oid=c.relnamespace WHERE c.relkind IN('r','p','v','m','S','f','') AND n.nspname<>'pg_catalog' AND n.nspname<>'information_schema' AND n.nspname!~'^pg_toast'
   ```
   The SQL can be parsed correctly
   ### Actual behavior
   
   ```
   line 10:23 no viable alternative at input 'SELECTn.nspnameas"Schema",c.relnameas"Name",CASEc.relkindWHEN'r'THEN'table'WHEN'v'THEN'view'WHEN'm'THEN'materialized view'WHEN'i'THEN'index'WHEN'S'THEN'sequence'WHEN's'THEN'special'WHEN'f'THEN'foreign table'WHEN'p'THEN'partitioned table'WHEN'I'THEN'partitioned index'ENDas"Type",pg_catalog.pg_get_userbyid(c.relowner)as"Owner"FROMpg_catalog.pg_classcLEFTJOINpg_catalog.pg_namespacenONn.oid=c.relnamespaceWHEREc.relkindIN('r','p','v','m','S','f','')ANDn.nspname<>'pg_catalog'ANDn.nspname<>'information_schema'ANDn.nspname!~'^pg_toast''
   line 10:23 no viable alternative at input 'SELECTn.nspnameas"Schema",c.relnameas"Name",CASEc.relkindWHEN'r'THEN'table'WHEN'v'THEN'view'WHEN'm'THEN'materialized view'WHEN'i'THEN'index'WHEN'S'THEN'sequence'WHEN's'THEN'special'WHEN'f'THEN'foreign table'WHEN'p'THEN'partitioned table'WHEN'I'THEN'partitioned index'ENDas"Type",pg_catalog.pg_get_userbyid(c.relowner)as"Owner"FROMpg_catalog.pg_classcLEFTJOINpg_catalog.pg_namespacenONn.oid=c.relnamespaceWHEREc.relkindIN('r','p','v','m','S','f','')ANDn.nspname<>'pg_catalog'ANDn.nspname<>'information_schema'ANDn.nspname!~'^pg_toast''
   line 1:0 no viable alternative at input 'SELECT'
   line 1:0 no viable alternative at input 'SELECT'
   
   SELECT n.nspname as "Schema",c.relname as "Name",CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN 'partitioned table' WHEN 'I' THEN 'partitioned index' END as "Type",pg_catalog.pg_get_userbyid(c.relowner) as "Owner" FROM pg_catalog.pg_classcLEFTJOINpg_catalog.pg_namespacen ON n.oid=c.relnamespace WHERE c.relkind IN('r','p','v','m','S','f','') AND n.nspname<>'pg_catalog' AND n.nspname<>'information_schema' AND n.nspname!~'^pg_toast'
   ```
   
   ### Reason analyze (If you can)
   Operator '! ~' cannot be parsed correctly
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero closed issue #9899: PostgreSQL parser error

Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #9899:
URL: https://github.com/apache/shardingsphere/issues/9899


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org