Debian Codegraph @

mysql-test/suite/sys_vars/r/sql_notes_func.result

raw
1 ** Setup **
2
3 SET @default_sql_notes = @@sql_notes;
4 '#--------------------FN_DYNVARS_162_01-------------------------#'
5 SET SESSION sql_notes = ON;
6 creating a temporary table
7 CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
8 conditionally dropping the table twice so that a note generates
9 DROP TABLE IF EXISTS t1;
10 SELECT @@warning_count;
11 @@warning_count
12 0
13 0 Expected
14 DROP TABLE IF EXISTS t1;
15 Warnings:
16 Note 1051 Unknown table 'test.t1'
17 SELECT @@warning_count;
18 @@warning_count
19 1
20 1 Expected
21 '#--------------------FN_DYNVARS_162_02-------------------------#'
22 SET SESSION sql_notes = OFF;
23 creating a temporary table
24 CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
25 conditionally dropping the table twice so that a note generates
26 DROP TABLE IF EXISTS t1;
27 SELECT @@warning_count;
28 @@warning_count
29 0
30 0 Expected
31 DROP TABLE IF EXISTS t1;
32 SELECT @@warning_count;
33 @@warning_count
34 0
35 0 Expected
36 '#------------------FN_DYNVARS_162_03---------------------------#'
37 ** Connecting con_int1 using root **
38 ** Connection con_int1 **
39 SELECT @@SESSION.sql_notes;
40 @@SESSION.sql_notes
41 1
42 1 / TRUE Expected
43 SET SESSION sql_notes = FALSE;
44 ** Connecting con_int2 using root **
45 ** Connection con_int2 **
46 SELECT @@SESSION.sql_notes;
47 @@SESSION.sql_notes
48 1
49 1 / TRUE Expected
50 SET SESSION sql_notes = TRUE;
51 ** Connection con_int2 **
52 SELECT @@SESSION.sql_notes;
53 @@SESSION.sql_notes
54 1
55 1 / TRUE Expected
56 ** Connection con_int1 **
57 SELECT @@SESSION.sql_notes;
58 @@SESSION.sql_notes
59 0
60 0 / FALSE Expected
61 ** Connection default **
62 Disconnecting Connections con_int1, con_int2
63 SET SESSION sql_notes = @default_sql_notes;
64 DROP TABLE IF EXISTS t1;