List:Commits« Previous MessageNext Message »
From:Sergey Glukhov Date:December 14 2010 4:29pm
Subject:bzr commit into mysql-trunk-bugfixing branch (sergey.glukhov:3431)
View as plain text  
#At file:///home/gluh/MySQL/mysql-trunk-bugfixing/ based on revid:georgi.kodinov@stripped

 3431 Sergey Glukhov	2010-12-14 [merge]
      5.5-bugteam->trunk-bugfixing merge(test case only)
     @ mysql-test/r/func_str.result
        5.5-bugteam->trunk-bugfixing merge(test case only)
     @ mysql-test/t/func_str.test
        5.5-bugteam->trunk-bugfixing merge(test case only)

    modified:
      mysql-test/r/func_str.result
      mysql-test/t/func_str.test
=== modified file 'mysql-test/r/func_str.result'
--- a/mysql-test/r/func_str.result	2010-12-02 13:44:21 +0000
+++ b/mysql-test/r/func_str.result	2010-12-14 16:29:15 +0000
@@ -2603,6 +2603,18 @@ ORDER BY QUOTE(t1.a);
 1
 1
 DROP TABLE t1;
+#
+# Bug#57913 large negative number to string conversion functions crash
+# Bug#57810 case/when/then : Assertion failed: length || !scale
+#
+SELECT '1' IN ('1', SUBSTRING(-9223372036854775809, 1));
+'1' IN ('1', SUBSTRING(-9223372036854775809, 1))
+1
+SELECT CONVERT(('' IN (REVERSE(CAST(('') AS DECIMAL)), '')), CHAR(3));
+CONVERT(('' IN (REVERSE(CAST(('') AS DECIMAL)), '')), CHAR(3))
+1
+Warnings:
+Warning	1292	Truncated incorrect DECIMAL value: ''
 End of 5.1 tests
 Start of 5.4 tests
 SELECT format(12345678901234567890.123, 3);

=== modified file 'mysql-test/t/func_str.test'
--- a/mysql-test/t/func_str.test	2010-12-02 13:44:21 +0000
+++ b/mysql-test/t/func_str.test	2010-12-14 16:29:15 +0000
@@ -1363,6 +1363,13 @@ SELECT 1 FROM t1, t1 t2
 ORDER BY QUOTE(t1.a);
 DROP TABLE t1;
 
+--echo #
+--echo # Bug#57913 large negative number to string conversion functions crash
+--echo # Bug#57810 case/when/then : Assertion failed: length || !scale
+--echo #
+SELECT '1' IN ('1', SUBSTRING(-9223372036854775809, 1));
+SELECT CONVERT(('' IN (REVERSE(CAST(('') AS DECIMAL)), '')), CHAR(3));
+
 --echo End of 5.1 tests
 
 --echo Start of 5.4 tests

No bundle (reason: revision is a merge).
Thread
bzr commit into mysql-trunk-bugfixing branch (sergey.glukhov:3431) Sergey Glukhov14 Dec