Mihai Budiu created CALCITE-5905:
------------------------------------
Summary: 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
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)
