diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2015-12-16 11:09:54 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2015-12-16 11:09:54 +0100 |
| commit | 71eee693b2ffadaf3d3ae9f68d5a723d9e4b503a (patch) | |
| tree | 084d1f77d3912a4e14b1635fbe533d4affb78241 /mysql-test/t/dyncol.test | |
| parent | bd69d7b3f30267011675747e4a74959b71a7ebc6 (diff) | |
| download | mariadb-git-71eee693b2ffadaf3d3ae9f68d5a723d9e4b503a.tar.gz | |
MDEV-9167: COLUMN_CHECK fails on valid decimal data
Check now allows zero length decimals too.
(backporting Adam Chainz patch to 10.0)
Diffstat (limited to 'mysql-test/t/dyncol.test')
| -rw-r--r-- | mysql-test/t/dyncol.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/dyncol.test b/mysql-test/t/dyncol.test index f0b8e0444f1..03e2345ba1c 100644 --- a/mysql-test/t/dyncol.test +++ b/mysql-test/t/dyncol.test @@ -909,5 +909,17 @@ SELECT COLUMN_GET(COLUMN_CREATE(1, 0xC2A2 AS CHAR CHARACTER SET latin1), 1 AS CH SELECT COLUMN_GET(COLUMN_CREATE(1, 0xC2A2 AS CHAR CHARACTER SET utf8), 1 AS CHAR CHARACTER SET utf8) AS a; --echo # +--echo # MDEV-9167: COLUMN_CHECK fails on valid decimal data +--echo # + +SELECT COLUMN_CHECK(COLUMN_CREATE('a',0 AS DECIMAL,'b',1 AS DECIMAL)); + +SELECT COLUMN_CHECK(COLUMN_CREATE('a',1 AS DECIMAL,'b',1 AS DECIMAL)); + +SELECT COLUMN_JSON(COLUMN_CREATE('a',0 AS DECIMAL,'b',1 AS DECIMAL)); + +SELECT COLUMN_JSON(COLUMN_CREATE('a',1 AS DECIMAL,'b',1 AS DECIMAL)); + +--echo # --echo # end of 10.0 tests --echo # |