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

create temporary table ... select ... from ... fails on read-only slave

    Details

      Description

      On a read only slave, given a table "existing_table"

      CREATE TEMPORARY TABLE foobar AS SELECT 1 FROM existing_table;

      Error in query (1290): The MariaDB server is running with the --read-only option so it cannot execute this statement

      same as in mysql #73119 apparently fixed in mysql 5.6

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                mathroc Mathieu Rochette
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: