Bug #21139 Handling of databases differs in "embedded", test "lowercase_fs_off" fails
Submitted: 19 Jul 2006 9:04 Modified: 3 Oct 2006 20:24
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Embedded Library ( libmysqld ) Severity:S3 (Non-critical)
Version:4.1.21 OS:all Unix
Assigned to: Kristofer Pettersson CPU Architecture:Any

[19 Jul 2006 9:04] Joerg Bruehe
Description:
Release build of 4.1.21

Test failure in all "embedded" builds (unless the test is skipped):

=====
lowercase_fs_off               [ fail ]

Errors are (from /PATH/mysqltest-time) :
mysqltest: At line NNN: query 'create database d2' succeeded - should have failed with errno 1044...
mysqltest: At line NNN: query 'create database D1' succeeded - should have failed with errno 1044...
(the last lines may be the most important ones)
=====

As a consequence, "ps_1general" then fails because it lists these two databases:
-------------------------------------------------------
*** r/ps_1general.result
--- r/ps_1general.reject
***************
*** 255,260
--- 255,262
  prepare stmt4 from ' show databases ';
  execute stmt4;
  Database
+ D1
+ d2
  mysql
  test
  prepare stmt4 from ' show tables from test like ''t2%'' ';
-------------------------------------------------------

How to repeat:
Build "embedded", run the tests.
[12 Sep 2006 15:37] Ingo Strüwing
This makes the 5.1-engines tree "red". Please assign.
[18 Sep 2006 11:33] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/12127

ChangeSet@1.2534, 2006-09-18 13:24:07+02:00, thek@kpdesk.mysql.com +1 -0
  Bug#21139 Handling of database differs in "embedded" , test lowercase_fs_off fails
  - Access checks are omitted when compiled without 
     --with-embedded-privilege-control
  - Patch: skip this test.
[19 Sep 2006 10:40] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/12196

ChangeSet@1.2540, 2006-09-19 12:40:31+02:00, thek@kpdesk.mysql.com +1 -0
  Bug#21139 Handling of database differs in "embedded" , test lowercase_fs_off fails
  - Access checks are omitted when compliled without --with-embedded-privilege-control
  - Patch: skip this test
[21 Sep 2006 11:36] Kristofer Pettersson
pushed to 4.1-maint, 5.0-maint and 5.1-maint
[3 Oct 2006 20:02] Chad MILLER
Available in 5.0.26.
[3 Oct 2006 20:16] Chad MILLER
Available in 5.1.12-beta.
[3 Oct 2006 20:24] Paul Dubois
Test case change only. No changelog entry needed.
[4 Oct 2006 13:57] Chad MILLER
Available in 4.1.22.