[
https://issues.apache.org/jira/browse/CALCITE-5905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17762275#comment-17762275
]
Benchao Li commented on CALCITE-5905:
-------------------------------------
It sounds good, thanks for providing the reference of Oracle.
> 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
> 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)
