| Bug #15428 | "embedded" tests not ready for case-insignificant file system | ||
|---|---|---|---|
| Submitted: | 2 Dec 2005 10:00 | Modified: | 23 Nov 2006 15:27 |
| Reporter: | Joerg Bruehe | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: Embedded Library ( libmysqld ) | Severity: | S3 (Non-critical) |
| Version: | 4.1.16 | OS: | MacOS (OS X (+ Windows expected)) |
| Assigned to: | Chad MILLER | CPU Architecture: | Any |
[2 Dec 2005 12:23]
Joerg Bruehe
Similar failures of further tests: heap [ fail ] Errors are (from PATH/mysqltest-time) : YYMMDD HH:MM:SS [Warning] Setting lower_case_table_names=2 because file system for PATH/mysql-test/var/master-data/ is case insensitive mysqltest: At line NNN: query 'insert into t1 values(1,1),(2,2),(3,3),(4,4)' failed: 1062: Duplicate entry '2' for key 1 heap_auto_increment [ fail ] Errors are (from PATH/mysqltest-time) : YYMMDD HH:MM:SS [Warning] Setting lower_case_table_names=2 because file system for PATH/mysql-test/var/master-data/ is case insensitive mysqltest: Result length mismatch (the last lines may be the most important ones) Below are the diffs between actual and expected results: ------------------------------------------------------- Binary files r/heap_auto_increment.result and r/heap_auto_increment.reject differ ------------------------------------------------------- ((surprised to see them classified as "binary")) heap_btree [ fail ] Errors are (from PATH/mysqltest-time) : YYMMDD HH:MM:SS [Warning] Setting lower_case_table_names=2 because file system for PATH/mysql-test/var/master-data/ is case insensitive mysqltest: At line NNN: query 'insert into t1 values(-2,-2),(-1,-1),(0,0),(1,1),(2,2),(3,3),(4,4)' failed: 1062: Duplicate entry '2' for key 1 heap_hash [ fail ] Errors are (from PATH/mysqltest-time) : YYMMDD HH:MM:SS [Warning] Setting lower_case_table_names=2 because file system for PATH/mysql-test/var/master-data/ is case insensitive mysqltest: At line NNN: query 'insert into t1 values(1,1),(2,2),(3,3),(4,4)' failed: 1062: Duplicate entry '2' for key 1 ps_4heap [ fail ] Errors are (from PATH/mysqltest-time) : YYMMDD HH:MM:SS [Warning] Setting lower_case_table_names=2 because file system for PATH/mysql-test/var/master-data/ is case insensitive mysqltest: In included file "./include/ps_modify.inc": At line 291: query 'insert into t2 values (NULL) ' failed: 1062: Duplicate entry '1' for key 1
[7 Nov 2006 14:06]
Chad MILLER
I can't recreate this.
Description: Build of 4.1.16, based on ChangeSet 1.2476 05/11/29 11:52:58 jimw@mysql.com +1 -0 Merge mysql.com:/home/jimw/my/mysql-4.1-14216 into mysql.com:/home/jimw/my/mysql-4.1-clean "Embedded" tests fail: === cut === ctype_utf8 [ fail ] Errors are (from PATH/mysqltest-time) : YYMMDD HH:MM:SS [Warning] Setting lower_case_table_names=2 because file system for PATH/mysql-test/var/master-data/ is case insensitive mysqltest: At line 340: query 'insert into t1 values ('a'),('b'),('c'),('d'),('e'),('f')' failed: 1062: Duplicate entry 'a' for key 1 (the last lines may be the most important ones) === cut === Occurred: powermacg5-4.1-standard.log embedded-server xserve-64bit-4.1-standard.log embedded-server osx-tiger-x86-4.1-standard.log embedded-server Line 340 is in this sequence: 328 select c as c_a from t1 where c='б'; 329 drop table t1; 330 331 # 332 # Bug 4531: unique key prefix interacts poorly with utf8 333 # Check HEAP+BTREE, case insensitive collation 334 # 335 create table t1 ( 336 c char(10) character set utf8, 337 unique key a using btree (c(1)) 338 ) engine=heap; 339 show create table t1; 340 insert into t1 values ('a'),('b'),('c'),('d'),('e'),('f'); 341 --error 1062 342 insert into t1 values ('aa'); I fail to see how "case insignificant file system" could affect that, but who knows. As a separated test, "ctype_utf8" passed (both in "default" and "PS protocol") on these platforms. How to repeat: Test suite failure