diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-09-24 15:48:02 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-09-24 15:48:02 +0400 |
| commit | 428f03c0b5cb9b0d85a7d70772dbf2b430672e83 (patch) | |
| tree | e8cdf68d31281010712670e8789e25f69faf90b8 /mysql-test/suite/vcol | |
| parent | e5418942609833edb681d16c4e2705f8c338bfee (diff) | |
| download | mariadb-git-428f03c0b5cb9b0d85a7d70772dbf2b430672e83.tar.gz | |
MDEV-8839 COLUMN_GET() produces warnings with no data
Diffstat (limited to 'mysql-test/suite/vcol')
| -rw-r--r-- | mysql-test/suite/vcol/r/vcol_misc.result | 19 | ||||
| -rw-r--r-- | mysql-test/suite/vcol/t/vcol_misc.test | 9 |
2 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/suite/vcol/r/vcol_misc.result b/mysql-test/suite/vcol/r/vcol_misc.result index 5cd55af831b..279777b8b36 100644 --- a/mysql-test/suite/vcol/r/vcol_misc.result +++ b/mysql-test/suite/vcol/r/vcol_misc.result @@ -346,5 +346,24 @@ t1 CREATE TABLE `t1` ( ) ENGINE=MyISAM DEFAULT CHARSET=latin1 DROP TABLE t1; # +# MDEV-8839 COLUMN_GET() produces warnings with no data +# +SET @aaa= COLUMN_CREATE('price', _binary 0xF0F1F2F3F4F5F6F7); +SELECT COLUMN_GET(@aaa, 'price' AS DECIMAL) aaa; +aaa +0 +Warnings: +Warning 1918 Encountered illegal value '\xF0\xF1\xF2\xF3\xF4\xF5\xF6\xF7' when converting to DECIMAL +SELECT COLUMN_GET(@aaa, 'price' AS INT) aaa; +aaa +0 +Warnings: +Warning 1918 Encountered illegal value '\xF0\xF1\xF2\xF3\xF4\xF5\xF6\xF7' when converting to INT +SELECT COLUMN_GET(@aaa, 'price' AS DOUBLE) aaa; +aaa +0 +Warnings: +Warning 1918 Encountered illegal value '\xF0\xF1\xF2\xF3\xF4\xF5\xF6\xF7' when converting to DOUBLE +# # End of 10.1 tests # diff --git a/mysql-test/suite/vcol/t/vcol_misc.test b/mysql-test/suite/vcol/t/vcol_misc.test index 717dd7775fa..c5b534fe200 100644 --- a/mysql-test/suite/vcol/t/vcol_misc.test +++ b/mysql-test/suite/vcol/t/vcol_misc.test @@ -303,5 +303,14 @@ SHOW CREATE TABLE t1; DROP TABLE t1; --echo # +--echo # MDEV-8839 COLUMN_GET() produces warnings with no data +--echo # +SET @aaa= COLUMN_CREATE('price', _binary 0xF0F1F2F3F4F5F6F7); +SELECT COLUMN_GET(@aaa, 'price' AS DECIMAL) aaa; +SELECT COLUMN_GET(@aaa, 'price' AS INT) aaa; +SELECT COLUMN_GET(@aaa, 'price' AS DOUBLE) aaa; + + +--echo # --echo # End of 10.1 tests --echo # |