[
https://issues.apache.org/jira/browse/CALCITE-2843?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-2843:
---------------------------------
Fix Version/s: (was: next)
> 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
>
> *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)
