Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28562

main.secure_file_priv_win fails with ps-protocol due to missing warnings

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            wlad Vladislav Vaintroub
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.