[jira] [Updated] (CALCITE-2843) Babel parser should parse PostgreSQL-style '::' cast operator

[Muhammad Gelbana (JIRA)]

     [ 
https://issues.apache.org/jira/browse/CALCITE-2843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Muhammad Gelbana updated CALCITE-2843:
--------------------------------------
    Description: 
How to reproduce the bug
{code:java}
public static void main(String[] args) throws Exception {
    Config parserConfig = 
configBuilder().setConformance(SqlConformanceEnum.BABEL).setParserFactory(SqlBabelParserImpl.FACTORY).build();
    FrameworkConfig frameworkConfig = 
Frameworks.newConfigBuilder().parserConfig(parserConfig).build();

    Planner planner = Frameworks.getPlanner(frameworkConfig);
    String pg = "SELECT 'array_in'::regproc, typtype FROM pg_catalog.pg_type";
    planner.parse(pg);
}{code}

  was:
*Query*
{code:sql}
SELECT typinput='array_in'::regproc, typtype FROM pg_catalog.pg_type LEFT JOIN 
(select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select 
s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, 
array_upper(current_schemas(false), 1)) as s(r) ) as r using ( nspname )) as sp 
ON sp.nspoid = typnamespace WHERE typname = $1 ORDER BY sp.r, pg_type.oid DESC 
LIMIT 1{code}


> Babel parser should parse PostgreSQL-style '::' cast operator
> -------------------------------------------------------------
>
>                 Key: CALCITE-2843
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2843
>             Project: Calcite
>          Issue Type: Bug
>          Components: babel
>    Affects Versions: 1.18.0
>            Reporter: Muhammad Gelbana
>            Assignee: Julian Hyde
>            Priority: Major
>
> How to reproduce the bug
> {code:java}
> public static void main(String[] args) throws Exception {
>     Config parserConfig = 
> configBuilder().setConformance(SqlConformanceEnum.BABEL).setParserFactory(SqlBabelParserImpl.FACTORY).build();
>     FrameworkConfig frameworkConfig = 
> Frameworks.newConfigBuilder().parserConfig(parserConfig).build();
>     Planner planner = Frameworks.getPlanner(frameworkConfig);
>     String pg = "SELECT 'array_in'::regproc, typtype FROM pg_catalog.pg_type";
>     planner.parse(pg);
> }{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)