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

[feature request] for SELECT ... INTO OUTFILE [LOCAL] '...'

        Details

        • Type: Task
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          Description

          MySQL and MariaDB have very useful feature for loading big data arrays
          LOAD DATA [LOCAL] which allow application server easily update big dictionaries.

          But I don't understand why this feature absent in SELECT ... INTO OUTFILE statement.
          It would be very useful for uploading big dictionaries into file.

          Can you add [LOCAL] to SELECT ... INTO OUTFILE statement, please?

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                mikhail Mikhail Gavrilov added a comment -

                This also needed for resolving security issues. Because application works under one user, and SQL server run under another user. All data which exported with 'SELECT ... INTO OUTFILE' statement is inaccessible for application user and necessary invent a terrible perversion to get around this.

                Show
                mikhail Mikhail Gavrilov added a comment - This also needed for resolving security issues. Because application works under one user, and SQL server run under another user. All data which exported with 'SELECT ... INTO OUTFILE' statement is inaccessible for application user and necessary invent a terrible perversion to get around this.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    mikhail Mikhail Gavrilov
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated: