Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8526

Unsupported datatypes in COLUMN_CREATE()

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.3.12, 10.0.18, 5.5
    • Fix Version/s: N/A
    • Labels:
      None
    • Environment:
      Darwin yossy.local 14.3.0 Darwin Kernel Version 14.3.0: Mon Mar 23 11:59:05 PDT 2015; root:xnu-2782.20.48~5/RELEASE_X86_64 x86_64

      Description

      My reading of the documentation for Dynamic Columns is that all of the following COLUMN_CREATE() calls are not syntax errors. Maria says that they are.

      SELECT     COLUMN_GET(COLUMN_CREATE('x', 12.99E+30         as DOUBLE(6)     ), 'x' as DOUBLE  );
      SELECT     COLUMN_GET(COLUMN_CREATE('x', 12.99E+30         as DOUBLE(6,3)   ), 'x' as DOUBLE  );
      SELECT     COLUMN_GET(COLUMN_CREATE('x', -432              as SIGNED        ), 'x' as INTEGER );
      SELECT     COLUMN_GET(COLUMN_CREATE('x', -432              as SIGNED INTEGER), 'x' as INTEGER );
      SELECT     COLUMN_GET(COLUMN_CREATE('x', 321               as UNSIGNED      ), 'x' as UNSIGNED);
      SELECT hex(COLUMN_GET(COLUMN_CREATE('x', unhex('5ca1ab1e') as BINARY        ), 'x' as BINARY  ));
      SELECT hex(COLUMN_GET(COLUMN_CREATE('x', unhex('ca55e77e') as BINARY(10)    ), 'x' as BINARY  ));

      I don't know why I would need these but the unit tests I wrote for my ORM follow the Maria documentation. For my purposes, removing these from the docs would suffice.

        Attachments

          Activity

            People

            Assignee:
            greenman Ian Gilfillan
            Reporter:
            thefsb Tom
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration