Bug #50677 ctype_big5 and ctype* tests give SQL warnings when run with --debug
Submitted: 27 Jan 2010 22:07 Modified: 28 Sep 2010 11:53
Reporter: Guilhem Bichot Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Charsets Severity:S3 (Non-critical)
Version:5.5.99-m3 OS:Linux (64)
Assigned to: Assigned Account CPU Architecture:Any

[27 Jan 2010 22:07] Guilhem Bichot
Description:
This is specific of running with --debug.
I have next-mr-bugfixing, revision-id:guilhem@mysql.com-20100125221934-ei1bo7a69bmwg30j .
./mtr --mem ctype_big5 --debug
CURRENT_TEST: main.ctype_big5
--- /home/mysql_src/bzrrepos/mysql-next-mr-bugfixing/mysql-test/r/ctype_big5.result	2010-01-21 12:10:10.000000000 +0300
+++ /home/mysql_src/bzrrepos/mysql-next-mr-bugfixing/mysql-test/r/ctype_big5.reject	2010-01-28 01:02:47.000000000 +0300
@@ -30,6 +30,8 @@
 location
 loberge
 lotre
+Warnings:
+Warning	1366	Incorrect string value: '\xFF\xFF\xFF' for column 'c1' at row 1
(cut other similar diffs).
This warning is due at least to print_key() which is used to print some optimizer's debug output to the debug log. I see this by running with --gdb and breaking in push_warning(). The debug printing manipulates keys, and there seems to be a charset conversion error at this moment, which ends up to the client, which shouldn't be.

How to repeat:
./mtr --mem ctype_big5 --debug
[27 Jan 2010 23:29] MySQL Verification Team
Thank you for the bug report. Verified as described:

[miguel@tikal mr-bf]$ cd mysql-test/
[miguel@tikal mysql-test]$ ./mtr --mem ctype_big5 --debug
Logging: ./mtr  --mem ctype_big5 --debug
100127 21:25:43 [Note] Buffered information: Performance schema disabled (reason: start parameters).

100127 21:25:43 [Note] Plugin 'FEDERATED' is disabled.
100127 21:25:43 [Note] Plugin 'ndbcluster' is disabled.
MySQL Version 5.5.99
Checking supported features...
 - using ndbcluster when necessary, mysqld supports it
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
vardir: /home/miguel/bzr/mr-bf/mysql-test/var
Removing old var directory...
Creating var directory '/home/miguel/bzr/mr-bf/mysql-test/var'...
 - symlinking 'var' to '/dev/shm/var_auto_c549'
Installing system database...
Using server port 50678

==============================================================================

TEST                                      RESULT   TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.ctype_big5                          [ fail ]
        Test ended at 2010-01-27 21:25:58

CURRENT_TEST: main.ctype_big5
--- /home/miguel/bzr/mr-bf/mysql-test/r/ctype_big5.result	2010-01-28 02:16:36.808243382 +0300
+++ /home/miguel/bzr/mr-bf/mysql-test/r/ctype_big5.reject	2010-01-28 02:25:58.194992450 +0300
@@ -30,6 +30,8 @@
 location
 loberge
 lotre
+Warnings:
+Warning	1366	Incorrect string value: '\xFF\xFF\xFF' for column 'c1' at row 1
 SELECT c1 as want3results from t1 where c1 like 'lo%';
 want3results
 location
[28 Sep 2010 11:53] Alexander Barkov
A fix for Bug#45012 fixed this problem as well.