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

Innovation: CREATE [TEMPORARY] DATABASE

    XMLWordPrintable

    Details

      Description

      As an innovation to introduce in MariaDB 10.3, I would like to suggest that MariaDB supports temporary (session) databases:

      • In such databases, all created tables will be temporary, independently if we specify the TEMPORARY clause or not when creating tables on such database.
      • It would be a "shortcut" in order to assure that ALL tables created at top a specific database remain always temporary.
      • As temporary tables are always per user session and connection, that would avoid problems such as tables which have not been declared temporary could interfere between users.

      NEW SYNTAX:

      CREATE [OR REPLACE] [TEMPORARY] {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
          [create_specification] ...
       
      create_specification:
          [DEFAULT] CHARACTER SET [=] charset_name
        | [DEFAULT] COLLATE [=] collation_name
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            Juan Juan Telleria
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: