[
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)
