Bug #34730 create.test fails on Windows x64
Submitted: 21 Feb 2008 15:20 Modified: 12 Dec 2008 11:24
Reporter: Guilhem Bichot Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1-maria, 6.0 OS:Windows (64bit)
Assigned to: Sergei Glukhov CPU Architecture:Any

[21 Feb 2008 15:20] Guilhem Bichot
Description:
create.test fails on Windows64 like this:
main.create                    [ fail ]

mysqltest: At line 1230: query 'create table имя_таблицы_в_кодировке_утф8_длиной
_больше_чем_48
(
имя_поля_в_кодировке_утф8_длиной_больше_чем_45 int,
index имя_индекса_в_кодировке_утф8_длиной_больше_чем_48 (имя_поля_в_кодировке_ут
ф8_длиной_больше_чем_45)
)' failed: 1049: Unknown database 'test'

It does not fail in 6.0 or 5.1.

How to repeat:
A simpler testcase is in the "files" section.
[21 Feb 2008 15:20] Guilhem Bichot
run this with mysql-test-run.pl on the Win4 machine

Attachment: create.test (application/octet-stream, text), 541 bytes.

[21 Feb 2008 21:34] Guilhem Bichot
It is not specific to the Maria tree; it shows up there because the tree has a long version name (5.1.23a-maria-alpha). I can repeat the same bug by using a 6.0 tree (same machine) if I add to the test of the "Files" section (to lengthen the database' name):
create database testtesttesttesttesttesttesttesttesttesttesttesttesttest;
set names utf8;
use testtesttesttesttesttesttesttesttesttesttesttesttesttest;
Maybe some too long file name.
[2 Oct 2008 13:31] Konstantin Osipov
Guilhem, is it still relevant?
[2 Oct 2008 13:43] Guilhem Bichot
Hi Konstantin.
I believe it is relevant if the testcase still breaks (see testcase after "I can repeat the same bug").
I suggest to ask the bug-verification team to re-verify (I don't want to spend my time on that, it has nothing to do with Maria, was just noticed by Maria team because 5.1.23a-maria-alpha is a long name, but can happen with any release if testcase is modified a bit as explained).
[3 Nov 2008 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[6 Nov 2008 10:02] Guilhem Bichot
As said in my previous post "I suggest to ask the bug-verification team to re-verify"
[14 Nov 2008 16:35] MySQL Verification Team
Back to verified failed on XP 32-bit too.
[12 Dec 2008 11:24] MySQL Verification Team
I couldn't repeat anymore:

miguel@skybr /cygdrive/c/dbs/mysql-5.1/mysql-test
$ ./mysql-test-run.pl create
Logging: ./mysql-test-run.pl create
081212  9:22:39 [Warning] Can't create test file \tmp\xYgCieOjP4\skybr.lower-test
081212  9:22:39 [Warning] Can't create test file \tmp\xYgCieOjP4\skybr.lower-test
c:\dbs\mysql-5.1\sql\debug\mysqld.exe: Can't change dir to '\tmp\xYgCieOjP4\' (Errcode: 2)
MySQL Version 5.1.31
Using dynamic switching of binlog format
Disable Instance manager - testing not supported on Windows
Skipping ndbcluster, mysqld not compiled with ndbcluster
Setting mysqld to support SSL connections
Binaries are debug compiled
Using MTR_BUILD_THREAD      = 0
Using MASTER_MYPORT         = 9306
Using MASTER_MYPORT1        = 9307
Using SLAVE_MYPORT          = 9308
Using SLAVE_MYPORT1         = 9309
Using SLAVE_MYPORT2         = 9310
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Installing Master Database
mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped
=======================================================

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

main.create                    [ pass ]          10532
-------------------------------------------------------
Stopping All Servers
All 1 tests were successful.
The servers were restarted 1 times
Spent 10.532 of 48 seconds executing testcases

miguel@skybr /cygdrive/c/dbs/mysql-5.1/mysql-test