Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 10.0.20, 10.1.7, 10.1.8, 10.0.21-galera
-
Component/s: Dynamic Columns
-
Labels:None
-
Environment:Server version: 10.0.20-MariaDB-1~wheezy-wsrep-log
Description
COLUMN_CHECK fails on valid data
SELECT COLUMN_CHECK(COLUMN_CREATE('a',0,'b','1'))
|
Result: 0 (failed)
|
|
SELECT COLUMN_CHECK(COLUMN_CREATE('a',1,'b','1'))
|
Result: 1 (correct)
|
|
SELECT COLUMN_JSON(COLUMN_CREATE('a',0,'b','1'))
|
Result: {"a":0,"b":"1"} (correct)
|
|
SELECT COLUMN_JSON(COLUMN_CREATE('a',1,'b','1'))
|
Result: {"a":1,"b":"1"} (correct)
|
It appears that COLUMN_CHECK fails when one of the dynamic column values is set to INTEGER 0, and only when there is more than 1 dynamic column present. COLUMN_JSON is able to parse the results properly, so the returned values from COLUMN_CREATE appears to be correct.
Attachments
Issue Links
- relates to
-
MDEV-9167 [PATCH] COLUMN_CHECK fails on valid decimal data
-
- Closed
-
- links to