Bug #7164 Test failure: 'ctype_uca' when using '--embedded-server'
Submitted: 10 Dec 2004 11:28 Modified: 21 Dec 2004 9:39
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.8-pre OS:Unix/Linux (various)
Assigned to: Alexander Barkov CPU Architecture:Any

[10 Dec 2004 11:28] Joerg Bruehe
Description:
With a fresh pull of 4.1.8 this morning (latest changeset: 
 1.2158 04/12/10 02:36:45 heikki@hundin.mysql.fi +1 -0
  dict0dict.c:     Fix the bug that the character 0xA0 that EMS MySQL Manager
...)
I ran the test suite on my PC (Linux, x86, gcc 3.3).

It passed for the default options and with '--ps-protocol', but had failures
with '--embedded-server' which I now report individually.

For 'ctype_uca', the report is:
-------------------------------------------------------
*** r/ctype_uca.result.es       2004-12-02 20:57:00.000000000 +0300
--- r/ctype_uca.reject  2004-12-10 14:21:44.000000000 +0300
***************
*** 2375,2377 ****
--- 2375,2388 ----
  USE test;
  SET character_set_server= @safe_character_set_server;
  SET collation_server= @safe_collation_server;
+ create table t1 (a varchar(1)) character set utf8 collate utf8_estonian_ci;
+ insert into t1 values ('A'),('B'),('C'),('a'),('b'),('c');
+ select a, a regexp '[a]' from t1 order by binary a;
+ a     a regexp '[a]'
+ A     1
+ B     0
+ C     0
+ a     1
+ b     0
+ c     0
+ drop table t1;
-------------------------------------------------------

The 'result' file was changed yesterday:
mysql-test/r/ctype_uca.result@1.10, 2004-12-09 15:56:15+04:00, bar@mysql.com
  Bugs: #7111: server crashes when regexp is used

How to repeat:
Run the test suite with '--embedded-server'.
[10 Dec 2004 11:36] Joerg Bruehe
Sorry, I looked at the wrong 'result' file - with '--embedded-server', 'result.es' is used, and that was not changed as recently:
mysql-test/r/ctype_uca.result.es@1.0, 2004-12-02 16:08:08+04:00, hf@deer.(none)
  BitKeeper file /home/hf/work/mysql-4.1.clean/mysql-test/r/ctype_uca.result.es

But the test was changed:
mysql-test/t/ctype_uca.test@1.9, 2004-12-09 15:56:15+04:00, bar@mysql.com
  Bugs: #7111: server crashes when regexp is used

So it seems that expected result file update is missing.
[10 Dec 2004 11:59] Joerg Bruehe
Typing error in synopsis ...
[10 Dec 2004 18:28] Alexander Barkov
I've fixed the bug with ctype_uca, but the same
problem remains with ps_xxx tests. I need to
discuss the remaining problems with HF before
fixing them.