Debian Codegraph @

mysql-test/suite/sys_vars/r/character_set_database_func_myisam.result

raw
1 '#--------------------FN_DYNVARS_008_01-------------------------#'
2 SET @global_character_set_database = @@global.character_set_database;
3 SET @session_character_set_database = @@session.character_set_database;
4 SET @session_character_set_server = @@session.character_set_server;
5 SET @global_character_set_server = @@global.character_set_server;
6 SET @@global.character_set_database = utf8;
7 Warnings:
8 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
9 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
10 'connect (con1,localhost,root,,,,)'
11 'connection con1'
12 SELECT @@global.character_set_database;
13 @@global.character_set_database
14 utf8mb3
15 SELECT @@session.character_set_database;
16 @@session.character_set_database
17 utf8mb4
18 '#--------------------FN_DYNVARS_008_02-------------------------#'
19 'connection default'
20 DROP TABLE IF EXISTS t1;
21 '------Check if load data uses character_set_database----------'
22 USE test;
23 CREATE TABLE t1 (a CHAR(4) CHARACTER SET utf8) ENGINE=MyISAM CHARACTER SET utf8;
24 Warnings:
25 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
26 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
27 'Verify with latin';
28 SET @@session.character_set_database = latin1;
29 Warnings:
30 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
31 LOAD DATA INFILE 'MYSQLTEST_VARDIR/std_data/charset_utf8.txt' INTO TABLE t1;
32 SELECT count(*) FROM t1 WHERE CHAR_LENGTH(a)>1;
33 count(*)
34 2433
35 TRUNCATE TABLE t1;
36 'Verify with utf8';
37 SET @@session.character_set_database = utf8;
38 Warnings:
39 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
40 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
41 LOAD DATA INFILE 'MYSQLTEST_VARDIR/std_data/charset_utf8.txt' INTO TABLE t1;
42 SELECT count(*) FROM t1 WHERE CHAR_LENGTH(a)>1;
43 count(*)
44 1
45 DROP TABLE IF EXISTS t1;
46 SET @@global.character_set_database = @global_character_set_database;
47 Warnings:
48 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
49 SET @@session.character_set_database = @session_character_set_database;
50 Warnings:
51 Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
52 SET @@session.character_set_server = @session_character_set_server;
53 SET @@global.character_set_server = @global_character_set_server;