← Back to branch summary

~mdcallag/+junk/5.1-map

« back to all changes in this revision

Viewing changes to mysql-test/t/information_schema.test

  • Committer: msvensson at pilot
  • Date: 2007-04-24 09:11:45 UTC
  • mfrom: (2469.1.106)
  • Revision ID: sp1r-msvensson@pilot.blaudden-20070424091145-10463
Merge pilot.blaudden:/home/msvensson/mysql/my51-m-mysql_upgrade
into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/information_schema.test
1042
1042
connection default;
1043
1043
drop user user3148@localhost;
1044
1044
 
 
1045
#
 
1046
# Bug #26174 Server Crash: INSERT ... SELECT ... FROM I_S.GLOBAL_STATUS
 
1047
# in Event (see also openssl_1.test)
 
1048
#
 
1049
--disable_warnings
 
1050
DROP TABLE IF EXISTS server_status;
 
1051
DROP EVENT IF EXISTS event_status;
 
1052
--enable_warnings
 
1053
 
 
1054
SET GLOBAL event_scheduler=1;
 
1055
 
 
1056
DELIMITER $$;
 
1057
 
 
1058
CREATE EVENT event_status
 
1059
 ON SCHEDULE AT NOW()
 
1060
 ON COMPLETION NOT PRESERVE
 
1061
 DO
 
1062
BEGIN
 
1063
  CREATE TABLE server_status
 
1064
  SELECT variable_name
 
1065
  FROM information_schema.global_status
 
1066
  WHERE variable_name LIKE 'ABORTED_CONNECTS' OR
 
1067
  variable_name LIKE 'BINLOG_CACHE_DISK_USE';
 
1068
END$$
 
1069
 
 
1070
DELIMITER ;$$
 
1071
 
 
1072
let $wait_condition=select count(*) = 0 from information_schema.events where event_name='event_status';
 
1073
--source include/wait_condition.inc
 
1074
 
 
1075
SELECT variable_name FROM server_status;
 
1076
 
 
1077
DROP TABLE server_status;
 
1078
SET GLOBAL event_scheduler=0;
 
1079
 
1045
1080
--echo End of 5.1 tests.
1046