view protocol: sys_vars.log_disabled_statements_func

sys_vars.log_disabled_statements_func    w3 [ fail ]

        Test ended at 2025-05-02 06:10:20

CURRENT_TEST: sys_vars.log_disabled_statements_func

--- /source/mysql-test/suite/sys_vars/r/log_disabled_statements_func.result	2022-04-27 00:36:33.711543655 +0000

+++ /build/mysql-test/var/3/log/log_disabled_statements_func.reject	2025-05-02 06:10:20.319869822 +0000

@@ -29,7 +29,10 @@

 argument

 check table t1

 CALL slow()

-SELECT count(if(sleep(1) >= 0,0,NULL)) from t1 where j>'b and part2'

+CREATE OR REPLACE VIEW mysqltest_tmp_v AS SELECT count(if(sleep(1) >= 0,0,NULL)) from t1 where j>'b and part2'

+SELECT * FROM mysqltest_tmp_v

+DROP VIEW mysqltest_tmp_v

+SELECT * FROM mysqltest_tmp_v

 <--

 TRUNCATE TABLE mysql.general_log;

 SET SESSION log_disabled_statements="";

@@ -52,7 +55,10 @@

 CALL slow()

 SELECT count(if(sleep(1) >= 0,0,NULL)) from t1 where j>'b'

 SELECT count(*) from t1 where j>'a'

-SELECT count(if(sleep(1) >= 0,0,NULL)) from t1 where j>'b and part3'

+CREATE OR REPLACE VIEW mysqltest_tmp_v AS SELECT count(if(sleep(1) >= 0,0,NULL)) from t1 where j>'b and part3'

+SELECT * FROM mysqltest_tmp_v

+DROP VIEW mysqltest_tmp_v

+SELECT * FROM mysqltest_tmp_v

 <--

 TRUNCATE TABLE mysql.general_log;

 SET SESSION log_disabled_statements="sp,slave";

@@ -73,7 +79,10 @@

 SET SESSION log_disabled_statements="sp,slave"

 check table t1

 CALL slow()

-SELECT count(if(sleep(1) >= 0,0,NULL)) from t1 where j>'b and part4'

+CREATE OR REPLACE VIEW mysqltest_tmp_v AS SELECT count(if(sleep(1) >= 0,0,NULL)) from t1 where j>'b and part4'

+SELECT * FROM mysqltest_tmp_v

+DROP VIEW mysqltest_tmp_v

+SELECT * FROM mysqltest_tmp_v

 <--

 DROP TABLE t1;

 DROP PROCEDURE slow;

Result length mismatch