[MDEV-28562] main.secure_file_priv_win fails with ps-protocol due to missing warnings Created: 2022-05-13  Updated: 2022-07-18  Resolved: 2022-07-18

Status: Closed
Project: MariaDB Server
Component/s: Platform Windows, Prepared Statements, Tests
Affects Version/s: 10.6, 10.7, 10.8
Fix Version/s: 10.6.9, 10.7.5, 10.8.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Vladislav Vaintroub
Resolution: Fixed Votes: 0
Labels: None


 Description   

main.secure_file_priv_win fails when it's run with ps-protocol:

10.6 f027c1217b5

main.secure_file_priv_win                w1 [ fail ]
        Test ended at 2022-05-13 17:26:53
 
CURRENT_TEST: main.secure_file_priv_win
C:/Users/jenkins/workspace/Source-Build-Test/src/client//Debug/mysqltest.exe: Error on delete of 'C:/Users/jenkins/workspace/Source-Build-Test/src/mysql-test/var/tmp/1/B11764517.tmp;' (Errcode: 2 "No such file or directory")
C:/Users/jenkins/workspace/Source-Build-Test/src/client//Debug/mysqltest.exe: Error on delete of 'C:/Users/jenkins/workspace/Source-Build-Test/src/mysql-test/var/tmp/1/B11764517-2.tmp;' (Errcode: 2 "No such file or directory")
C:/Users/jenkins/workspace/Source-Build-Test/src/client//Debug/mysqltest.exe: Error on delete of 'C:/Users/jenkins/workspace/Source-Build-Test/src/mysql-test/var/tmp/1/B11764517-3.tmp;' (Errcode: 2 "No such file or directory")
C:/Users/jenkins/workspace/Source-Build-Test/src/client//Debug/mysqltest.exe: Error on delete of 'C:/Users/jenkins/workspace/Source-Build-Test/src/mysql-test/var/tmp/1/B11764517-4.tmp;' (Errcode: 2 "No such file or directory")
C:/Users/jenkins/workspace/Source-Build-Test/src/client//Debug/mysqltest.exe: Error on delete of 'C:/Users/jenkins/workspace/Source-Build-Test/src/mysql-test/var/tmp/1/B11764517-5.tmp;' (Errcode: 2 "No such file or directory")
--- C:/Users/jenkins/workspace/Source-Build-Test/src/mysql-test/main/secure_file_priv_win.result	2022-05-13 17:13:20.000000000 +0000
+++ C:\Users\jenkins\workspace\Source-Build-Test\src\mysql-test\main\secure_file_priv_win.reject	2022-05-13 17:26:52.011802400 +0000
@@ -1,8 +1,6 @@
 CREATE TABLE t1 (c1 longtext);
 INSERT INTO t1 values ('a');
 SELECT * FROM t1 INTO OUTFILE 'MYSQL_TMP_DIR/B11764517.tmp';
-Warnings:
-Warning	1287	'<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead
 show global variables like 'secure_file_priv';
 Variable_name	Value
 secure_file_priv	MYSQL_TMP_DIR/
@@ -34,15 +32,7 @@
 SELECT * FROM t1 INTO OUTFILE 'MYSQL_TMP_DIR\\..a..\\..\\..\\B11764517-2.tmp';
 ERROR HY000: The MariaDB server is running with the --secure-file-priv option so it cannot execute this statement
 SELECT * FROM t1 INTO OUTFILE 'MYSQL_TMP_DIR\\B11764517-2.tmp';
-Warnings:
-Warning	1287	'<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead
 SELECT * FROM t1 INTO OUTFILE 'MYSQL_TMP_DIR/B11764517-3.tmp';
-Warnings:
-Warning	1287	'<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead
 SELECT * FROM t1 INTO OUTFILE 'MYSQL_TMP_DIR_UCASE/B11764517-4.tmp';
-Warnings:
-Warning	1287	'<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead
 SELECT * FROM t1 INTO OUTFILE 'MYSQL_TMP_DIR_LCASE/B11764517-5.tmp';
-Warnings:
-Warning	1287	'<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead
 DROP TABLE t1;
 
mysqltest: Result length mismatch

Reproducible on 10.6+ on different machines.
On 10.3-10.5 the test passes.


Generated at Thu Feb 08 10:01:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.