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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.