[SQLEngine] mysql兼容模式问题

你好，mysql兼容模式。这个问题可以帮忙看看吗？

CREATE DATABASE dolphindb2 DBCOMPATIBILITY 'B' encoding 'UTF-8' LC_COLLATE 'zh_CN.utf8' LC_CTYPE 'zh_CN.utf8'; \c dolphindb2 set dolphin.b_compatibility_mode = on; -- ALTER schema information_schema CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE DATABASE mydatabase1 CHARACTER SET utf8 COLLATE utf8_general_ci; set search_path to mydatabase1; create table T1(a int,B varchar(100)); insert into t1 values(1,'aaaa'); -- 值是可以大小写忽略匹配 select * from t1 where b = 'AAAA'; select * from information_schema.columns where table_name='t1'; -- 这个视图的，还是没办法去匹配（mysql支持） select * from information_schema.columns where table_name='T1'; -- 这个视图的，还是没办法去匹配（mysql支持）

SELECT table_name, column_name, character_set_name FROM information_schema.columns WHERE table_name = 't1';

SELECT table_name, column_name, character_set_name FROM information_schema.columns WHERE table_name = 'T1';

| | keep | | keep__go@163.com |