Debian Codegraph @

mysql-test/suite/funcs_1/r/is_coll_char_set_appl.result

raw
1 SHOW TABLES FROM information_schema LIKE 'COLLATION_CHARACTER_SET_APPLICABILITY';
2 Tables_in_information_schema (COLLATION_CHARACTER_SET_APPLICABILITY)
3 COLLATION_CHARACTER_SET_APPLICABILITY
4 #######################################################################
5 # Testcase 3.2.1.1: INFORMATION_SCHEMA tables can be queried via SELECT
6 #######################################################################
7 DROP VIEW IF EXISTS test.v1;
8 DROP PROCEDURE IF EXISTS test.p1;
9 DROP FUNCTION IF EXISTS test.f1;
10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.COLLATION_CHARACTER_SET_APPLICABILITY;
11 CREATE PROCEDURE test.p1() SELECT * FROM information_schema.COLLATION_CHARACTER_SET_APPLICABILITY;
12 CREATE FUNCTION test.f1() returns BIGINT
13 BEGIN
14 DECLARE counter BIGINT DEFAULT NULL;
15 SELECT COUNT(*) INTO counter FROM information_schema.COLLATION_CHARACTER_SET_APPLICABILITY;
16 RETURN counter;
17 END//
18 # Attention: The printing of the next result sets is disabled.
19 SELECT * FROM information_schema.COLLATION_CHARACTER_SET_APPLICABILITY;
20 SELECT * FROM test.v1;
21 CALL test.p1;
22 SELECT test.f1();
23 DROP VIEW test.v1;
24 DROP PROCEDURE test.p1;
25 DROP FUNCTION test.f1;
26 #########################################################################
27 # Testcase 3.2.4.1: INFORMATION_SCHEMA.CHARACTER_SET_APPLICABILITY layout
28 #########################################################################
29 DESCRIBE information_schema.COLLATION_CHARACTER_SET_APPLICABILITY;
30 Field Type Null Key Default Extra
31 COLLATION_NAME varchar(64) NO NULL
32 CHARACTER_SET_NAME varchar(32) NO NULL
33 FULL_COLLATION_NAME varchar(64) NO NULL
34 ID bigint(11) NO NULL
35 IS_DEFAULT varchar(3) NO NULL
36 SHOW CREATE TABLE information_schema.COLLATION_CHARACTER_SET_APPLICABILITY;
37 Table Create Table
38 COLLATION_CHARACTER_SET_APPLICABILITY CREATE TEMPORARY TABLE `COLLATION_CHARACTER_SET_APPLICABILITY` (
39 `COLLATION_NAME` varchar(64) NOT NULL,
40 `CHARACTER_SET_NAME` varchar(32) NOT NULL,
41 `FULL_COLLATION_NAME` varchar(64) NOT NULL,
42 `ID` bigint(11) NOT NULL,
43 `IS_DEFAULT` varchar(3) NOT NULL
44 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
45 SHOW COLUMNS FROM information_schema.COLLATION_CHARACTER_SET_APPLICABILITY;
46 Field Type Null Key Default Extra
47 COLLATION_NAME varchar(64) NO NULL
48 CHARACTER_SET_NAME varchar(32) NO NULL
49 FULL_COLLATION_NAME varchar(64) NO NULL
50 ID bigint(11) NO NULL
51 IS_DEFAULT varchar(3) NO NULL
52 # Testcases 3.2.4.2 and 3.2.4.3 are checked in suite/funcs_1/t/charset_collation*.test
53 ########################################################################
54 # Testcases 3.2.1.3-3.2.1.5 + 3.2.1.8-3.2.1.12: INSERT/UPDATE/DELETE and
55 # DDL on INFORMATION_SCHEMA tables are not supported
56 ########################################################################
57 DROP DATABASE IF EXISTS db_datadict;
58 CREATE DATABASE db_datadict;
59 INSERT INTO information_schema.collation_character_set_applicability
60 SELECT * FROM information_schema.collation_character_set_applicability;
61 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
62 UPDATE information_schema.collation_character_set_applicability
63 SET collation_name = 'big6_chinese_ci' WHERE character_set_name = 'big6';
64 Got one of the listed errors
65 UPDATE information_schema.collation_character_set_applicability
66 SET character_set_name = 't_4711';
67 Got one of the listed errors
68 DELETE FROM information_schema.collation_character_set_applicability;
69 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
70 TRUNCATE information_schema.collation_character_set_applicability;
71 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
72 CREATE INDEX my_idx
73 ON information_schema.collation_character_set_applicability(collation_name);
74 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
75 ALTER TABLE information_schema.collation_character_set_applicability ADD f1 INT;
76 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
77 DROP TABLE information_schema.collation_character_set_applicability;
78 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
79 ALTER TABLE information_schema.collation_character_set_applicability
80 RENAME db_datadict.collation_character_set_applicability;
81 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
82 ALTER TABLE information_schema.collation_character_set_applicability
83 RENAME information_schema.xcollation_character_set_applicability;
84 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
85 DROP DATABASE db_datadict;