[MDEV-8526] Unsupported datatypes in COLUMN_CREATE() Created: 2015-07-22  Updated: 2015-08-18  Resolved: 2015-08-18

Status: Closed
Project: MariaDB Server
Component/s: Documentation, Dynamic Columns
Affects Version/s: 5.3.12, 10.0.18, 5.5
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Tom Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
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.

 Comments   
Comment by Tom [ 2015-07-22 ]

one more:

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

Comment by Elena Stepanova [ 2015-07-27 ]

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?

Comment by Oleksandr Byelkin [ 2015-07-28 ]

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

Comment by Tom [ 2015-07-28 ]

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

Comment by Ian Gilfillan [ 2015-08-18 ]

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

Generated at Thu Feb 08 07:27:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.