1** Setup ** 2 3SET @default_sql_notes = @@sql_notes; 4'#--------------------FN_DYNVARS_162_01-------------------------#' 5SET SESSION sql_notes = ON; 6creating a temporary table 7CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20)); 8conditionally dropping the table twice so that a note generates 9DROP TABLE IF EXISTS t1; 10SELECT @@warning_count; 11@@warning_count 120 130 Expected 14DROP TABLE IF EXISTS t1; 15Warnings: 16Note 1051 Unknown table 'test.t1' 17SELECT @@warning_count; 18@@warning_count 191 201 Expected 21'#--------------------FN_DYNVARS_162_02-------------------------#' 22SET SESSION sql_notes = OFF; 23creating a temporary table 24CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20)); 25conditionally dropping the table twice so that a note generates 26DROP TABLE IF EXISTS t1; 27SELECT @@warning_count; 28@@warning_count 290 300 Expected 31DROP TABLE IF EXISTS t1; 32SELECT @@warning_count; 33@@warning_count 340 350 Expected 36'#------------------FN_DYNVARS_162_03---------------------------#' 37connect con_int1,localhost,root,,; 38connection con_int1; 39SELECT @@SESSION.sql_notes; 40@@SESSION.sql_notes 411 421 / TRUE Expected 43SET SESSION sql_notes = FALSE; 44connect con_int2,localhost,root,,; 45connection con_int2; 46SELECT @@SESSION.sql_notes; 47@@SESSION.sql_notes 481 491 / TRUE Expected 50SET SESSION sql_notes = TRUE; 51connection con_int2; 52SELECT @@SESSION.sql_notes; 53@@SESSION.sql_notes 541 551 / TRUE Expected 56connection con_int1; 57SELECT @@SESSION.sql_notes; 58@@SESSION.sql_notes 590 600 / FALSE Expected 61connection default; 62disconnect con_int1; 63disconnect con_int2; 64SET SESSION sql_notes = @default_sql_notes; 65DROP TABLE IF EXISTS t1; 66