Debian Codegraph @

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

raw
1 SHOW TABLES FROM information_schema LIKE 'CHARACTER_SETS';
2 Tables_in_information_schema (CHARACTER_SETS)
3 CHARACTER_SETS
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.CHARACTER_SETS;
11 CREATE PROCEDURE test.p1() SELECT * FROM information_schema.CHARACTER_SETS;
12 CREATE FUNCTION test.f1() returns BIGINT
13 BEGIN
14 DECLARE counter BIGINT DEFAULT NULL;
15 SELECT COUNT(*) INTO counter FROM information_schema.CHARACTER_SETS;
16 RETURN counter;
17 END//
18 # Attention: The printing of the next result sets is disabled.
19 SELECT * FROM information_schema.CHARACTER_SETS;
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.2.1: INFORMATION_SCHEMA.CHARACTER_SETS layout
28 #########################################################################
29 DESCRIBE information_schema.CHARACTER_SETS;
30 Field Type Null Key Default Extra
31 CHARACTER_SET_NAME varchar(32) NO NULL
32 DEFAULT_COLLATE_NAME varchar(64) NO NULL
33 DESCRIPTION varchar(60) NO NULL
34 MAXLEN bigint(3) NO NULL
35 SHOW CREATE TABLE information_schema.CHARACTER_SETS;
36 Table Create Table
37 CHARACTER_SETS CREATE TEMPORARY TABLE `CHARACTER_SETS` (
38 `CHARACTER_SET_NAME` varchar(32) NOT NULL,
39 `DEFAULT_COLLATE_NAME` varchar(64) NOT NULL,
40 `DESCRIPTION` varchar(60) NOT NULL,
41 `MAXLEN` bigint(3) NOT NULL
42 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
43 SHOW COLUMNS FROM information_schema.CHARACTER_SETS;
44 Field Type Null Key Default Extra
45 CHARACTER_SET_NAME varchar(32) NO NULL
46 DEFAULT_COLLATE_NAME varchar(64) NO NULL
47 DESCRIPTION varchar(60) NO NULL
48 MAXLEN bigint(3) NO NULL
49 # Testcases 3.2.2.2 and 3.2.2.3 are checked in suite/funcs_1/t/charset_collation*.test
50 ########################################################################
51 # Testcases 3.2.1.3-3.2.1.5 + 3.2.1.8-3.2.1.12: INSERT/UPDATE/DELETE and
52 # DDL on INFORMATION_SCHEMA tables are not supported
53 ########################################################################
54 DROP DATABASE IF EXISTS db_datadict;
55 CREATE DATABASE db_datadict;
56 INSERT INTO information_schema.character_sets
57 SELECT * FROM information_schema.character_sets;
58 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
59 UPDATE information_schema.character_sets SET description = 'just updated';
60 Got one of the listed errors
61 DELETE FROM information_schema.character_sets WHERE table_name = 't1';
62 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
63 TRUNCATE information_schema.character_sets;
64 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
65 CREATE INDEX my_idx ON information_schema.character_sets(character_set_name);
66 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
67 ALTER TABLE information_schema.character_sets DROP PRIMARY KEY;
68 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
69 ALTER TABLE information_schema.character_sets ADD f1 INT;
70 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
71 DROP TABLE information_schema.character_sets;
72 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
73 ALTER TABLE information_schema.character_sets RENAME db_datadict.character_sets;
74 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
75 ALTER TABLE information_schema.character_sets
76 RENAME information_schema.xcharacter_sets;
77 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
78 DROP DATABASE db_datadict;