diff options
Diffstat (limited to 'mysql-test/suite/funcs_1/r/is_collations.result')
| -rw-r--r-- | mysql-test/suite/funcs_1/r/is_collations.result | 90 |
1 files changed, 90 insertions, 0 deletions
diff --git a/mysql-test/suite/funcs_1/r/is_collations.result b/mysql-test/suite/funcs_1/r/is_collations.result new file mode 100644 index 00000000..c74976f9 --- /dev/null +++ b/mysql-test/suite/funcs_1/r/is_collations.result @@ -0,0 +1,90 @@ +SHOW TABLES FROM information_schema LIKE 'COLLATIONS'; +Tables_in_information_schema (COLLATIONS) +COLLATIONS +####################################################################### +# Testcase 3.2.1.1: INFORMATION_SCHEMA tables can be queried via SELECT +####################################################################### +DROP VIEW IF EXISTS test.v1; +DROP PROCEDURE IF EXISTS test.p1; +DROP FUNCTION IF EXISTS test.f1; +CREATE VIEW test.v1 AS SELECT * FROM information_schema.COLLATIONS; +CREATE PROCEDURE test.p1() SELECT * FROM information_schema.COLLATIONS; +CREATE FUNCTION test.f1() returns BIGINT +BEGIN +DECLARE counter BIGINT DEFAULT NULL; +SELECT COUNT(*) INTO counter FROM information_schema.COLLATIONS; +RETURN counter; +END// +# Attention: The printing of the next result sets is disabled. +SELECT * FROM information_schema.COLLATIONS; +SELECT * FROM test.v1; +CALL test.p1; +SELECT test.f1(); +DROP VIEW test.v1; +DROP PROCEDURE test.p1; +DROP FUNCTION test.f1; +######################################################################### +# Testcase 3.2.3.1: INFORMATION_SCHEMA.COLLATIONS layout +######################################################################### +DESCRIBE information_schema.COLLATIONS; +Field Type Null Key Default Extra +COLLATION_NAME varchar(32) NO +CHARACTER_SET_NAME varchar(32) NO +ID bigint(11) NO 0 +IS_DEFAULT varchar(3) NO +IS_COMPILED varchar(3) NO +SORTLEN bigint(3) NO 0 +SHOW CREATE TABLE information_schema.COLLATIONS; +Table Create Table +COLLATIONS CREATE TEMPORARY TABLE `COLLATIONS` ( + `COLLATION_NAME` varchar(32) NOT NULL DEFAULT '', + `CHARACTER_SET_NAME` varchar(32) NOT NULL DEFAULT '', + `ID` bigint(11) NOT NULL DEFAULT 0, + `IS_DEFAULT` varchar(3) NOT NULL DEFAULT '', + `IS_COMPILED` varchar(3) NOT NULL DEFAULT '', + `SORTLEN` bigint(3) NOT NULL DEFAULT 0 +) ENGINE=MEMORY DEFAULT CHARSET=utf8 +SHOW COLUMNS FROM information_schema.COLLATIONS; +Field Type Null Key Default Extra +COLLATION_NAME varchar(32) NO +CHARACTER_SET_NAME varchar(32) NO +ID bigint(11) NO 0 +IS_DEFAULT varchar(3) NO +IS_COMPILED varchar(3) NO +SORTLEN bigint(3) NO 0 +# Testcases 3.2.3.2 and 3.2.3.3 are checked in suite/funcs_1/t/charset_collation*.test +######################################################################## +# Testcases 3.2.1.3-3.2.1.5 + 3.2.1.8-3.2.1.12: INSERT/UPDATE/DELETE and +# DDL on INFORMATION_SCHEMA tables are not supported +######################################################################## +DROP DATABASE IF EXISTS db_datadict; +CREATE DATABASE db_datadict; +INSERT INTO information_schema.collations +SELECT * FROM information_schema.collations; +ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' +INSERT INTO information_schema.collations +(collation_name,character_set_name,id,is_default,is_compiled,sortlen) +VALUES ( 'cp1251_bin', 'cp1251',50, '', '',0); +ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' +UPDATE information_schema.collations SET description = 'just updated'; +Got one of the listed errors +DELETE FROM information_schema.collations WHERE table_name = 't1'; +ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' +TRUNCATE information_schema.collations; +ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' +CREATE INDEX my_idx ON information_schema.collations(character_set_name); +ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' +ALTER TABLE information_schema.collations DROP PRIMARY KEY; +ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' +ALTER TABLE information_schema.collations ADD f1 INT; +ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' +ALTER TABLE information_schema.collations ENABLE KEYS; +ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' +DROP TABLE information_schema.collations; +ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' +ALTER TABLE information_schema.collations RENAME db_datadict.collations; +ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' +ALTER TABLE information_schema.collations +RENAME information_schema.xcollations; +ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema' +DROP DATABASE db_datadict; |