oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
#owner       : nijia.nj
5
#owner group : sql2
6
#description : test information_schema.collations
7

8
use information_schema;
9

10
#basic
11
select * from collations;
12
select collation_name, character_set_name, id, is_default, is_compiled, sortlen from collations;
13
select * from collations where collation_name like '%utf8%';
14

15
#show
16
--source mysql_test/include/show_create_table_old_version_replica2.inc
17
show create table collations;
18
desc collations;
19