[jira] [Created] (CALCITE-2843) Babel parser doesn't parse PostgreSQL casting operator

[Muhammad Gelbana (JIRA)]

Muhammad Gelbana created CALCITE-2843:
-----------------------------------------

             Summary: Babel parser doesn't parse PostgreSQL casting 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
             Fix For: next


*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}



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