问题描述:
DROP INDEX index_name on table_name时,如果table_name是大写,则会导致后续information_schema.statistics 表的访问问题。
环境:MYSQL 5.1.46 win32版本。
问题示例:
use test;
CREATE TABLE IF NOT EXISTS TCI_INST
(
FCIID INT UNSIGNED,
FCIDVER INT UNSIGNED,
FCINAME VARCHAR(256)
);
CREATE INDEX IND_TCI_FCIID ON TCI_INST(FCIID,FCIDVER);
SELECT * FROM information_schema.statistics where table_name='TCI_INST' and index_name='IND_TCI_FCIID';
应该输出两条记录。实际输出两条记录,正确!
SELECT count(*) FROM information_schema.statistics where table_name='TCI_INST' and index_name=&#