Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.0.20, 10.1.7, 10.1.8, 10.0.21-galera
-
None
-
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