Bug #7167 Test failure: 'insert_select' when using '--embedded-server'

• Submitted: 10 Dec 2004 12:14
• Modified: 13 Dec 2004 23:27
• Reporter: Joerg Bruehe
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 4.1.8-pre
• OS: Unix/Linux (various)
• Assigned to: Jim Winstead
• CPU Architecture: Any

[10 Dec 2004 12:14] Joerg Bruehe

Description:
With a fresh pull of 4.1.8 this morning (latest changeset: 
 1.2158 04/12/10 02:36:45 [e-mail] +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 'insert_select', the report is:
 -------------------------------------------------------
*** r/insert_select.result.es   2004-10-04 11:58:34.000000000 +0300
--- r/insert_select.reject      2004-12-10 14:27:41.000000000 +0300
***************
*** 78,83 ****
--- 78,90 ----
  1
  2
  drop table t1, t2;
+ create table t1(a int);
+ insert into t1 values(1),(1);
+ reset master;
+ create table t2(unique(a)) select a from t1;
+ ERROR 23000: Duplicate entry '1' for key 1
+ show binlog events;
+ drop table t1;
  create table t1 (a int not null);
  create table t2 (a int not null);
  insert into t1 values (1);
-------------------------------------------------------

The last changes for the test case are:
mysql-test/t/insert_select.test@1.14, 2004-12-03 00:32:44+01:00, [e-mail]
  Auto merged

mysql-test/t/insert_select.test@1.5.1.8, 2004-12-02 22:35:17+01:00, [e-mail]
  Add test case for Bug #6682

mysql-test/t/insert_select.test@1.13, 2004-10-26 19:29:53+03:00, [e-mail]
  Fixes for --ps-protocol

The "normal" result file was updated:
mysql-test/r/insert_select.result@1.21, 2004-12-03 02:28:00+01:00, [e-mail]
  Handle results that differ from 4.0 to 4.1

mysql-test/r/insert_select.result@1.20, 2004-12-03 00:36:01+01:00, [e-mail]
  SCCS merged

mysql-test/r/insert_select.result@1.7.1.9, 2004-12-02 22:35:28+01:00, [e-mail]
  Add results for test case for Bug #6682

But the "es" file remained unchanged:
mysql-test/r/insert_select.result.es@1.1, 2004-09-27 14:40:25+02:00, [e-mail]

mysql-test/r/insert_select.result.es@1.0, 2004-09-27 14:40:25+02:00, [e-mail]
  BitKeeper file /users/kboortz/daily/work/mysql-4.1-es/mysql-test/r/insert_select.result.es

How to repeat:
Run the test suite with '--embedded-server'

Suggested fix:
Update the 'es' result file.

[10 Dec 2004 22:52] Jim Winstead

Just missing results in the .es version of the results file.