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

["Stamatis Zampetakis (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-2843?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16766166#comment-16766166 ] 

Stamatis Zampetakis commented on CALCITE-2843:
----------------------------------------------

Hi [~mgelbana], can you reduce the query in the description of this ticket to contain only the part related with the casting operator? Can you also add the code that you tried to use to parse the query and the error message obtained? These additional information can help people understand easier the problem (I understand because I participated in the discussion in the dev list but it may not be as straighforward for others). Thanks! 

> 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
>            Priority: Major
>             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)