[
https://issues.apache.org/jira/browse/CALCITE-5905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benchao Li resolved CALCITE-5905.
---------------------------------
Assignee: Mihai Budiu
Resolution: Fixed
Merged via
[https://github.com/apache/calcite/commit/b57f2d2cb0fa1227ce17e4be872982c05f260249]
[~mbudiu] Thanks for the PR!
> Documentation for CREATE TYPE is incorrect
> ------------------------------------------
>
> Key: CALCITE-5905
> URL: https://issues.apache.org/jira/browse/CALCITE-5905
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.35.0
> Reporter: Mihai Budiu
> Assignee: Mihai Budiu
> Priority: Minor
> Labels: pull-request-available
> Fix For: 1.36.0
>
>
> I have tried to run the example CREATE TYPE statements from this page
> https://calcite.apache.org/docs/reference.html#declaring-objects-for-user-defined-types
> through the compiler:
> {code:sql}
> CREATE TYPE address_typ AS OBJECT (
> street VARCHAR2(30),
> city VARCHAR2(20),
> state CHAR(2),
> postal_code VARCHAR2(6));
> {code}
> Calcite complains in two places: OBJECT and VARCHAR2.
> The following compiles fine:
> {code:sql}
> CREATE TYPE address_typ AS (
> street VARCHAR(30),
> city VARCHAR(20),
> state CHAR(2),
> postal_code VARCHAR(6));
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
