diff options
| author | Alexander Barkov <bar@mariadb.org> | 2015-09-25 21:33:50 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2015-09-25 21:33:50 +0400 |
| commit | 30711c6650fc7e2f166f29d0bc59eeab64dadb3e (patch) | |
| tree | bd9a209f1e339c73a2d23c22c9c078ea992ebd08 /mysql-test/r/func_str.result | |
| parent | 26e4403f649839e82dd26f7a6b31165063eb2871 (diff) | |
| download | mariadb-git-30711c6650fc7e2f166f29d0bc59eeab64dadb3e.tar.gz | |
MDEV-8806 Numeric CAST produce different warnings for strings literals vs functions
Diffstat (limited to 'mysql-test/r/func_str.result')
| -rw-r--r-- | mysql-test/r/func_str.result | 13 |
1 files changed, 11 insertions, 2 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index d392da84ea7..9bc80613710 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -1160,6 +1160,8 @@ Warning 1292 Truncated incorrect DOUBLE value: 'notnumber' SELECT * FROM t1, t2 WHERE num=substring(str from 1 for 6); str num notnumber 0 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'notnum' DROP TABLE t1,t2; CREATE TABLE t1( id int(11) NOT NULL auto_increment, @@ -1352,6 +1354,8 @@ cast(rtrim(' 20.06 ') as decimal(19,2)) select cast(ltrim(' 20.06 ') as decimal(19,2)); cast(ltrim(' 20.06 ') as decimal(19,2)) 20.06 +Warnings: +Note 1292 Truncated incorrect DECIMAL value: '20.06 ' select cast(rtrim(ltrim(' 20.06 ')) as decimal(19,2)); cast(rtrim(ltrim(' 20.06 ')) as decimal(19,2)) 20.06 @@ -2915,7 +2919,7 @@ format(rpad('111111111.1', 1111111, '999999999999999999999999999999999999999999'),0,'be_BY') ; -DO +SELECT round( concat( ( coalesce( ( @@ -2930,9 +2934,14 @@ sha1('P'), ) ) ) -); +) AS r; +r +0 Warnings: +Warning 1292 Truncated incorrect INTEGER value: '511993d3c99719e38a6779073019dacd7178ddb9' Warning 1292 Truncated incorrect DECIMAL value: '[.DC2.]' +Warning 1292 Truncated incorrect INTEGER value: '511993d3c99719e38a6779073019dacd7178ddb9' +Warning 1292 Truncated incorrect DOUBLE value: '0.000000000000000000000000000000111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111' SET @@global.max_allowed_packet:= @tmp_max; SELECT @tmp_max:= @@global.max_allowed_packet; @tmp_max:= @@global.max_allowed_packet |