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

Unsupported datatypes in COLUMN_CREATE()

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.3.12, 10.0.18, 5.5(EOL)
    • N/A
    • Documentation, Dynamic Columns
    • None
    • 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

          Ascending order - Click to sort in descending order
          thefsb Tom added a comment -

          one more:

          SELECT COLUMN_GET(COLUMN_CREATE('x', 'charN' as CHAR(10)), 'x' as CHAR);

          thefsb Tom added a comment - one more: SELECT COLUMN_GET(COLUMN_CREATE( 'x' , 'charN' as CHAR (10)), 'x' as CHAR );
          elenst Elena Stepanova added a comment - - edited

          greenman, sanja,

          We have a very old bug MDEV-597 about it, but since it's not getting fixed, maybe we should treat this report MDEV-8526 as a documentation issue to adjust the KB to the existing state of the server?

          elenst Elena Stepanova added a comment - - edited greenman , sanja , We have a very old bug MDEV-597 about it, but since it's not getting fixed, maybe we should treat this report MDEV-8526 as a documentation issue to adjust the KB to the existing state of the server?
          sanja Oleksandr Byelkin added a comment -

          Probably yes, it is documentation issue, I'll check as far as this bug priority is higher.

          sanja Oleksandr Byelkin added a comment - Probably yes, it is documentation issue, I'll check as far as this bug priority is higher.
          thefsb Tom added a comment -

          In that case, note that the types COLUMN_GET() allows are different from those COLUMN_CREATE() allows.

          thefsb Tom added a comment - In that case, note that the types COLUMN_GET() allows are different from those COLUMN_CREATE() allows.
          greenman Ian Gilfillan added a comment -

          I have updated the documentation to make note of MDEV-597

          greenman Ian Gilfillan added a comment - I have updated the documentation to make note of MDEV-597

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.