Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6, 10.7(EOL), 10.8(EOL)
-
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.