EVOLUTION-MANAGER

Edit File: not_embedded_server.result

call mtr.add_suppression("Can't open and lock privilege tables: Table 'user' was not locked with LOCK TABLES"); SHOW VARIABLES like 'slave_skip_errors'; Variable_name Value slave_skip_errors OFF # # Bug#58026: massive recursion and crash in regular expression handling # SELECT '1' RLIKE RPAD('1', 10000, '('); Got one of the listed errors # # WL#4284: Transactional DDL locking # # FLUSH PRIVILEGES should not implicitly unlock locked tables. # DROP TABLE IF EXISTS t1; CREATE TABLE t1 (c1 INT); LOCK TABLES t1 READ; FLUSH PRIVILEGES; ERROR HY000: Table 'user' was not locked with LOCK TABLES UNLOCK TABLES; DROP TABLE t1; # # Bug#54812: assert in Diagnostics_area::set_ok_status during EXPLAIN # CREATE USER nopriv_user@localhost; connection default; DROP TABLE IF EXISTS t1,t2,t3; DROP FUNCTION IF EXISTS f; CREATE TABLE t1 (key1 INT PRIMARY KEY); CREATE TABLE t2 (key2 INT); INSERT INTO t1 VALUES (1),(2); CREATE FUNCTION f() RETURNS INT RETURN 1; GRANT FILE ON *.* TO 'nopriv_user'@'localhost'; FLUSH PRIVILEGES; connect con1,localhost,nopriv_user,,; connection con1; SELECT MAX(key1) FROM t1 WHERE f() < 1 INTO OUTFILE '<outfile>'; ERROR 42000: execute command denied to user 'nopriv_user'@'localhost' for routine 'test.f' INSERT INTO t2 SELECT MAX(key1) FROM t1 WHERE f() < 1; ERROR 42000: execute command denied to user 'nopriv_user'@'localhost' for routine 'test.f' SELECT MAX(key1) INTO @dummy FROM t1 WHERE f() < 1; ERROR 42000: execute command denied to user 'nopriv_user'@'localhost' for routine 'test.f' CREATE TABLE t3 (i INT) AS SELECT MAX(key1) FROM t1 WHERE f() < 1; ERROR 42000: execute command denied to user 'nopriv_user'@'localhost' for routine 'test.f' disconnect con1; connection default; DROP TABLE t1,t2; DROP FUNCTION f; DROP USER nopriv_user@localhost; # # End Bug#54812 # # # Test for Bug#12601974 - STORED PROCEDURE SQL_MODE=NO_BACKSLASH_ESCAPES # IGNORED AND BREAKS REPLICATION # SET @org_mode=@@sql_mode; SET @@sql_mode=''; # USER NAME CONTAINING BACKSLASH IN CREATE USER OPERATION CREATE USER 'user\'s_12601974'@'localhost'; CREATE USER 'user\'s_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\'s_12601974'@'localhost' DROP USER 'user\'s_12601974'@'localhost'; CREATE USER 'user\"s_12601974'@'localhost'; CREATE USER 'user\"s_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\"s_12601974'@'localhost' DROP USER 'user\"s_12601974'@'localhost'; CREATE USER 'user\bs_12601974'@'localhost'; CREATE USER 'user\bs_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'users_12601974'@'localhost' DROP USER 'user\bs_12601974'@'localhost'; CREATE USER 'user\ns_12601974'@'localhost'; CREATE USER 'user\ns_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\ns_12601974'@'localhost' DROP USER 'user\ns_12601974'@'localhost'; CREATE USER 'user\rs_12601974'@'localhost'; CREATE USER 'user\rs_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\rs_12601974'@'localhost' DROP USER 'user\rs_12601974'@'localhost'; CREATE USER 'user\ts_12601974'@'localhost'; CREATE USER 'user\ts_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user s_12601974'@'localhost' DROP USER 'user\ts_12601974'@'localhost'; CREATE USER 'user\\s_12601974'@'localhost'; CREATE USER 'user\\s_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\\s_12601974'@'localhost' DROP USER 'user\\s_12601974'@'localhost'; CREATE USER 'user\%s_12601974'@'localhost'; CREATE USER 'user\%s_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\\%s_12601974'@'localhost' DROP USER 'user\%s_12601974'@'localhost'; CREATE USER 'user\_s_12601974'@'localhost'; CREATE USER 'user\_s_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\\_s_12601974'@'localhost' DROP USER 'user\_s_12601974'@'localhost'; # END OF CASE - USER NAME CONTAINING BACKSLASH IN CREATE USER OPERATION SET @@sql_mode='NO_BACKSLASH_ESCAPES'; # USER NAME CONTAINING BACKSLASH IN DROP USER OPERATION CREATE USER 'user\"s_12601974'@'localhost'; CREATE USER 'user\"s_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\"s_12601974'@'localhost' DROP USER 'user\"s_12601974'@'localhost'; CREATE USER 'user\bs_12601974'@'localhost'; CREATE USER 'user\bs_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\bs_12601974'@'localhost' DROP USER 'user\bs_12601974'@'localhost'; CREATE USER 'user\ns_12601974'@'localhost'; CREATE USER 'user\ns_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\ns_12601974'@'localhost' DROP USER 'user\ns_12601974'@'localhost'; CREATE USER 'user\rs_12601974'@'localhost'; CREATE USER 'user\rs_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\rs_12601974'@'localhost' DROP USER 'user\rs_12601974'@'localhost'; CREATE USER 'user\ts_12601974'@'localhost'; CREATE USER 'user\ts_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\ts_12601974'@'localhost' DROP USER 'user\ts_12601974'@'localhost'; CREATE USER 'user\\s_12601974'@'localhost'; CREATE USER 'user\\s_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\\s_12601974'@'localhost' DROP USER 'user\\s_12601974'@'localhost'; CREATE USER 'user\%s_12601974'@'localhost'; CREATE USER 'user\%s_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\%s_12601974'@'localhost' DROP USER 'user\%s_12601974'@'localhost'; CREATE USER 'user\_s_12601974'@'localhost'; CREATE USER 'user\_s_12601974'@'localhost'; ERROR HY000: Operation CREATE USER failed for 'user\_s_12601974'@'localhost' DROP USER 'user\_s_12601974'@'localhost'; # END OF CASE - USER NAME CONTAINING BACKSLASH IN CREATE USER OPERATION SET @@sql_mode= @org_mode; #End of Test for Bug#12601974