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(64) NO NULL
33 SHOW CREATE TABLE information_schema.COLLATION_CHARACTER_SET_APPLICABILITY;
34 View Create View character_set_client collation_connection
35 COLLATION_CHARACTER_SET_APPLICABILITY CREATE ALGORITHM=UNDEFINED DEFINER=`mysql.infoschema`@`localhost` SQL SECURITY DEFINER VIEW `information_schema`.`COLLATION_CHARACTER_SET_APPLICABILITY` AS select `col`.`name` AS `COLLATION_NAME`,`cs`.`name` AS `CHARACTER_SET_NAME` from (`mysql`.`character_sets` `cs` join `mysql`.`collations` `col` on((`cs`.`id` = `col`.`character_set_id`))) utf8mb3 utf8mb3_general_ci
36 SHOW COLUMNS FROM information_schema.COLLATION_CHARACTER_SET_APPLICABILITY;
37 Field Type Null Key Default Extra
38 COLLATION_NAME varchar(64) NO NULL
39 CHARACTER_SET_NAME varchar(64) NO NULL
40 # Testcases 3.2.4.2 and 3.2.4.3 are checked in suite/funcs_1/t/charset_collation*.test
41 ########################################################################
42 # Testcases 3.2.1.3-3.2.1.5 + 3.2.1.8-3.2.1.12: INSERT/UPDATE/DELETE and
43 # DDL on INFORMATION_SCHEMA tables are not supported
44 ########################################################################
45 DROP DATABASE IF EXISTS db_datadict;
46 CREATE DATABASE db_datadict;
47 INSERT INTO information_schema.collation_character_set_applicability
48 SELECT * FROM information_schema.collation_character_set_applicability;
49 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
50 UPDATE information_schema.collation_character_set_applicability
51 SET collation_name = 'big6_chinese_ci' WHERE character_set_name = 'big6';
52 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
53 UPDATE information_schema.collation_character_set_applicability
54 SET character_set_name = 't_4711';
55 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
56 DELETE FROM information_schema.collation_character_set_applicability;
57 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
58 TRUNCATE information_schema.collation_character_set_applicability;
59 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
60 CREATE INDEX my_idx
61 ON information_schema.collation_character_set_applicability(collation_name);
62 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
63 ALTER TABLE information_schema.collation_character_set_applicability ADD f1 INT;
64 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
65 DROP TABLE information_schema.collation_character_set_applicability;
66 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
67 ALTER TABLE information_schema.collation_character_set_applicability
68 RENAME db_datadict.collation_character_set_applicability;
69 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
70 ALTER TABLE information_schema.collation_character_set_applicability
71 RENAME information_schema.xcollation_character_set_applicability;
72 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
73 DROP DATABASE db_datadict;