mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
50 lines
1.4 KiB
Text
50 lines
1.4 KiB
Text
** Setup **
|
|
|
|
SET @default_sql_warnings = @@sql_warnings;
|
|
CREATE TEMPORARY TABLE t1(a varchar(5), b varchar(20));
|
|
'#-----------------------------FN_DYNVARS_167_01------------#'
|
|
SET @@sql_warnings = DEFAULT;
|
|
affected rows: 0
|
|
INSERT IGNORE INTO t1 VALUES('abcdef', 'val1');
|
|
affected rows: 1
|
|
'#-----------------------------FN_DYNVARS_167_02------------------#'
|
|
SET @@sql_warnings = 0;
|
|
affected rows: 0
|
|
INSERT IGNORE INTO t1 VALUES('abcdef', 'val1');
|
|
affected rows: 1
|
|
'#-----------------------------FN_DYNVARS_167_03---------------#'
|
|
SET @@sql_warnings = 1;
|
|
affected rows: 0
|
|
INSERT IGNORE INTO t1 VALUES('abcdef', 'val1');
|
|
affected rows: 1
|
|
info: Records: 1 Duplicates: 0 Warnings: 1
|
|
'#----------------------------FN_DYNVARS_167_04---------------#'
|
|
connect con_int1,localhost,root,,;
|
|
connection con_int1;
|
|
SELECT @@SESSION.sql_warnings;
|
|
@@SESSION.sql_warnings
|
|
0
|
|
0 / FALSE Expected
|
|
SET SESSION sql_warnings = FALSE;
|
|
connect con_int2,localhost,root,,;
|
|
connection con_int2;
|
|
SELECT @@SESSION.sql_warnings;
|
|
@@SESSION.sql_warnings
|
|
0
|
|
0 / FALSE Expected
|
|
SET SESSION sql_warnings = TRUE;
|
|
connection con_int2;
|
|
SELECT @@SESSION.sql_warnings;
|
|
@@SESSION.sql_warnings
|
|
1
|
|
1 / TRUE Expected
|
|
connection con_int1;
|
|
SELECT @@SESSION.sql_warnings;
|
|
@@SESSION.sql_warnings
|
|
0
|
|
0 / FALSE Expected
|
|
connection default;
|
|
disconnect con_int1;
|
|
disconnect con_int2;
|
|
DROP TABLE t1;
|
|
SET @@sql_warnings = @default_sql_warnings;
|