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 Warnings:
7 Warning 1287 '@@sql_notes' is deprecated and will be removed in a future release. Please use '@@note_verbosity' instead
8 creating a temporary table
9 CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
10 conditionally dropping the table twice so that a note generates
11 DROP TABLE IF EXISTS t1;
12 SELECT @@warning_count;
13 @@warning_count
14 0
15 0 Expected
16 DROP TABLE IF EXISTS t1;
17 Warnings:
18 Note 1051 Unknown table 'test.t1'
19 SELECT @@warning_count;
20 @@warning_count
21 1
22 1 Expected
23 '#--------------------FN_DYNVARS_162_02-------------------------#'
24 SET SESSION sql_notes = OFF;
25 Warnings:
26 Warning 1287 '@@sql_notes' is deprecated and will be removed in a future release. Please use '@@note_verbosity' instead
27 creating a temporary table
28 CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
29 conditionally dropping the table twice so that a note generates
30 DROP TABLE IF EXISTS t1;
31 SELECT @@warning_count;
32 @@warning_count
33 0
34 0 Expected
35 DROP TABLE IF EXISTS t1;
36 SELECT @@warning_count;
37 @@warning_count
38 0
39 0 Expected
40 '#------------------FN_DYNVARS_162_03---------------------------#'
41 connect con_int1,localhost,root,,;
42 connection con_int1;
43 SELECT @@SESSION.sql_notes;
44 @@SESSION.sql_notes
45 1
46 1 / TRUE Expected
47 SET SESSION sql_notes = FALSE;
48 Warnings:
49 Warning 1287 '@@sql_notes' is deprecated and will be removed in a future release. Please use '@@note_verbosity' instead
50 connect con_int2,localhost,root,,;
51 connection con_int2;
52 SELECT @@SESSION.sql_notes;
53 @@SESSION.sql_notes
54 1
55 1 / TRUE Expected
56 SET SESSION sql_notes = TRUE;
57 Warnings:
58 Warning 1287 '@@sql_notes' is deprecated and will be removed in a future release. Please use '@@note_verbosity' instead
59 connection con_int2;
60 SELECT @@SESSION.sql_notes;
61 @@SESSION.sql_notes
62 1
63 1 / TRUE Expected
64 connection con_int1;
65 SELECT @@SESSION.sql_notes;
66 @@SESSION.sql_notes
67 0
68 0 / FALSE Expected
69 connection default;
70 disconnect con_int1;
71 disconnect con_int2;
72 SET SESSION sql_notes = @default_sql_notes;
73 Warnings:
74 Warning 1287 '@@sql_notes' is deprecated and will be removed in a future release. Please use '@@note_verbosity' instead
75 DROP TABLE IF EXISTS t1;