(ok 2.9.1) bug in Table.class.php

Logged In: YES
user_id=1383652

if cihar demo
http://pma.cihar.com/HEAD-config/index.php?db=test
is down, you can see the effect on
http://rabus.phpmyadmin.net/demos/CVS_LATEST/index.php?db=test_abc
(user demo,pw='')

no problen on pma2822:
http://rabus.phpmyadmin.net/demos/RELEASE_FINAL/index.php?db=test_abc
(user demo,pw='')

Logged In: YES
user_id=210714

I can see the effects on my server :) debugging now...

Logged In: YES
user_id=210714

The problem happens because selecting from
information_schema for some value in TABLE_SCHEMA finds test
and also Test.
Working on a patch.

Logged In: YES
user_id=1383652

the only workaround is using "show databases" here!

use `information_schema`;
SELECT * FROM `TABLES`;

gives only

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME
....
NULL Test tt

whereas "show databases" displays both `Test` and `test` as
well.
....
but not
....
NULL test
....

but there is no equivalent for show databases in
information_scheme!

using information_scheme mysql scans databases
caseinsensitive and grabs the first non empty table even if
it belongs to a different database.

Logged In: YES
user_id=1383652

rephrase:
use `information_schema`;
SELECT * FROM `TABLES`;

gives only

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME
....
NULL Test tt
....

but not
....
NULL test
....

whereas "show databases" displays both `Test` and
`test` as
well.
-----

using information_scheme mysql scans databases
caseinsensitive and grabs the first non empty table even if
it belongs to a different database.

this can be reproduced by creating a db `Test2` with no
tables and `test2` with any table

no fatal error, but wrong table list in db `Test2`

Logged In: YES
user_id=210714

Please have a look at what I just merged in QA_2_9.

Logged In: YES
user_id=1383652

i only have access to HEAD :(
is there a Tortoise setting?

Logged In: YES
user_id=210714

http://phpmyadmin.cvs.sourceforge.net/phpmyadmin/phpMyAdmin/libraries/database_interface.lib.php?r1=2.52.2.1&r2=2.52.2.2&pathrev=QA_2_9

Logged In: YES
user_id=1383652

yes,
BINARY is the "magic solution",
but i can't test it locally on my win box (for obvious reason ;)
could you merge it in HEAD too?

Logged In: YES
user_id=1383652

fixed in
http://pma.cihar.com/QA_2_9/index.php?db=test

Logged In: YES
user_id=210714

Merged to HEAD.

Logged In: YES
user_id=1383652

well,
the bug is fixed for tux, but reinduces a win/mysql bug:
if you have a db `Dummy` with some "alpha" named tables in
it, the tables don't appear any longer neither in Navi frame
or in structure. (one can only work with "digit only" tables
like '127')

information_schema.tables says:
TABLE_SCHEMA TABLE_NAME
Dummy 127
Dummy db1__a
Dummy db1__b
Dummy db~2
Dummy db~a
Dummy default_userdb
....

(win2k,pmaHEAD,mysql5024a)
[the old mysql 5.0.18 bug was fixed as of 5.0.23]

Logged In: YES
user_id=210714

Juergen,
I tried PMA 2.9.0.2 with a version of XAMPP containing MySQL
5.0.20. With lower_case_table_names set to 1, 0 or 2, I had
no problem with a db "Dummy" with a table "alpha" in it:
listed in left panel and in db structure.

Please help me reproduce your problem.

Logged In: YES
user_id=1383652

>containing MySQL 5.0.20.
it's only in mysql 5.0.24a, (mysql 5.0.22 working well here
on w2k)
as mysql fixed the above mentioned bug as of 5.0.23
(reported by Sebastian som month ago)

Logged In: YES
user_id=1383652

pma290 (2006-09-20) is working with mysql5022 and 5024a as well.

Logged In: YES
user_id=210714

Juergen,
I made an error by testing 2.9.0.2. Of course, my latest
patch about case sensitivity is not part of it. I retested,
this time with QA_2_9 and the latest XAMPP (MySQL 5.0.24a)
and with all possibilities of lower_case_table_names (0, 1,
2), and I have no problem with a db Dummy and a table alpha
in it.

Logged In: YES
user_id=1383652

ok, maybe someone else can reproduce this.
I only happend to have this db from debugging some month ago.
As it is of minimal relevance i will set this tracker to
pending for now. No need to waste your precious time on this.