Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.3.12, 10.0.18, 5.5
-
Fix Version/s: N/A
-
Component/s: Documentation, Dynamic Columns
-
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.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Ian Gilfillan, Oleksandr Byelkin,
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?
Probably yes, it is documentation issue, I'll check as far as this bug priority is higher.
In that case, note that the types COLUMN_GET() allows are different from those COLUMN_CREATE() allows.
I have updated the documentation to make note of MDEV-597
one more:
SELECT COLUMN_GET(COLUMN_CREATE('x', 'charN' as CHAR(10)), 'x' as CHAR);