Titansonia opened a new issue, #48126: URL: https://github.com/apache/doris/issues/48126
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.1.8 ### What's Wrong? 1. I'm using lower_case_table_names = 2 started the FE <img width="1494" alt="Image" src="https://github.com/user-attachments/assets/4dae4827-92aa-4563-a480-d3e2c6f959dd"; /> 2. created table using: CREATE TABLE `mysql2doris`.`test_all_String` ( `id` INT NOT NULL COMMENT "int", `_char` CHAR(1) DEFAULT "b" COMMENT "你好", `_varchar` VARCHAR(255) DEFAULT "default" COMMENT "你好", `_binary` STRING COMMENT "original: binary", `_varbinary` STRING COMMENT "original: varbinary", `_tinytext` STRING COMMENT "original: tinytext", `_text` STRING COMMENT "original: TEXT", `_mediumtext` STRING COMMENT "original: MEDIUMTEXT", `_longtext` STRING COMMENT "original: longtext", `_tinyblob` STRING COMMENT "original: tinyblob", `_blob` STRING COMMENT "original: BLOB", `_mediumblob` STRING COMMENT "original: MEDIUMBLOB", `_longblob` STRING COMMENT "original: longblob", `_enum` STRING COMMENT "original: ENUM", `_set` STRING COMMENT "original: SET", `_json` STRING COMMENT "original: json", ) UNIQUE KEY(id) DISTRIBUTED BY HASH(`id`) BUCKETS 8 PROPERTIES( "replication_allocation" = "tag.location.default:1" ); 3. select the table using lower case table name worked:  4. try to select from INFORMATION_SCHEMA.COLUMNS using TABLE_NAME = 'test_all_string'(in lower case), not worked: <img width="1205" alt="Image" src="https://github.com/user-attachments/assets/2ba39897-4dbf-4849-ae24-3837f63ce3be"; /> 5. using TABLE_NAME = 'test_all_String', worked:  I think there may be some Compatibility problem in INFORMATION_SCHEMA.COLUMNS table and the lower_case_table_names attribute. In mysql, no such problem. please help check. thx. ### What You Expected? when lower_case_table_names = 2 is set, I can use lower case table names to select INFORMATION_SCHEMA.COLUMNS table where the table names is created by upper case. ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
