Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.3.12, 10.0.18, 5.5(EOL)
-
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.