Bug #32469 Result is false
Submitted: 17 Nov 2007 14:43 Modified: 19 Nov 2007 8:28
Reporter: d b Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: General Severity:S1 (Critical)
Version:V5.1.22 rc community OS:Windows
Assigned to: CPU Architecture:Any

[17 Nov 2007 14:43] d b 
Description:
Dear Misses and Misters,
I worked 3 days with Mysql V5.1.22 rc community on Windows XP Sp2 and I 
found an great error, this is not good for mysql:

create database MYSQLISTDOOF
create table MYSQLISTDOOF.VI01WCH (_ID INT, _DEL INT)
drop table MYSQLISTDOOF.VI01WCH
select count(*) from information_schemas.TABLES TABLE_TYPE = 'BASE_TABLE' 
and TABLE_NAME='VI01WCH' and TABLE_SCHEMA='MYSQLISTDOOF'

!!!!!! =====> the result is 1  <==== !!!!!!!

select * from information_schemas.TABLES TABLE_TYPE = 'BASE_TABLE' 
and TABLE_NAME='VI01WCH' and TABLE_SCHEMA='MYSQLISTDOOF'

!!!!!! =====> the result is 0 rows <==== !!!!!

This is a great shit!

With best regards
Dietmar Bombor

How to repeat:
create database MYSQLISTDOOF
create table MYSQLISTDOOF.VI01WCH (_ID INT, _DEL INT)
drop table MYSQLISTDOOF.VI01WCH
select count(*) from information_schemas.TABLES TABLE_TYPE = 'BASE_TABLE' 
and TABLE_NAME='VI01WCH' and TABLE_SCHEMA='MYSQLISTDOOF'

!!!!!! =====> the result is 1  <==== !!!!!!!

select * from information_schemas.TABLES TABLE_TYPE = 'BASE_TABLE' 
and TABLE_NAME='VI01WCH' and TABLE_SCHEMA='MYSQLISTDOOF'

!!!!!! =====> the result is 0 rows <==== !!!!!

This is a great shit!
[18 Nov 2007 10:01] d b 
Please insert "where" between "information_schemas.TABLES" and "TABLE_TYPE = 'BASE_TABLE'", its was forgotten
[19 Nov 2007 8:28] Sveta Smirnova 
Thank you for the report.

There is no predefined information_schemas schema. I tested this report with information_schema and can not repeat described behaviour. So I assumed you have information_schemas schema which shadowed information_schema schema and closed the report as "Not a Bug"

If you still think this is bug of MySQL, please check your application and if you can create test case repeatable on our side feel free to reopen the report.