Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-5905

Documentation for CREATE TYPE is incorrect

    XMLWordPrintableJSON

Details

    Description

      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:

      CREATE TYPE address_typ AS OBJECT (
         street          VARCHAR2(30),
         city            VARCHAR2(20),
         state           CHAR(2),
         postal_code     VARCHAR2(6));
      

      Calcite complains in two places: OBJECT and VARCHAR2.

      The following compiles fine:

      CREATE TYPE address_typ AS (
         street          VARCHAR(30),
         city            VARCHAR(20),
         state           CHAR(2),
         postal_code     VARCHAR(6));
      

      Attachments

        Issue Links

          Activity

            People

              mbudiu Mihai Budiu
              mbudiu Mihai Budiu
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: