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

LP:992947 - Wrong error message when attempting to create a view for a database that does not exists

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          Description

          If we try to create a view in a database that does not exists MariaDB 5.2 returns a wrong message:

          MariaDB [test]> DROP DATABASE IF EXISTS nodb;
          Query OK, 0 rows affected, 1 warning (0.00 sec)

          MariaDB [test]> CREATE VIEW nodb.a AS SELECT 1;
          ERROR 1 (HY000): Can't create/write to file './nodb/a.frm~' (Errcode: 2)

          (see also bug #12626844 in mysql).

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 992947

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 992947
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                The bug was fixed in MySQL 5.5.23 (and, consequently, in MariaDB) by the following revision:

                revno: 3749
revision-id: chaithra.gopalareddy@oracle.com-20120314005703-lm2sm22183lc7msd
parent: luis.soares@oracle.com-20120312232600-v7oj3e9mluw79i4t
committer: Chaithra Gopalareddy <chaithra.gopalareddy@oracle.com>
branch nick: mysql-5.5
timestamp: Wed 2012-03-14 06:27:03 +0530
message:
  Bug#12626844 : WE ARE NOT CHECKING VIEW TABLE NAMES
                 ENOUGH - CONCAT() HACKS. ALSO WRONG
                 ERROR MESSAGE WHILE TRYING TO CREATE
                 A VIEW ON A NON EXISTING DATABASE
...
                Show
                elenst Elena Stepanova added a comment - The bug was fixed in MySQL 5.5.23 (and, consequently, in MariaDB) by the following revision: revno: 3749 revision-id: chaithra.gopalareddy@oracle.com-20120314005703-lm2sm22183lc7msd parent: luis.soares@oracle.com-20120312232600-v7oj3e9mluw79i4t committer: Chaithra Gopalareddy <chaithra.gopalareddy@oracle.com> branch nick: mysql-5.5 timestamp: Wed 2012-03-14 06:27:03 +0530 message: Bug#12626844 : WE ARE NOT CHECKING VIEW TABLE NAMES ENOUGH - CONCAT() HACKS. ALSO WRONG ERROR MESSAGE WHILE TRYING TO CREATE A VIEW ON A NON EXISTING DATABASE ...

                  People

                  • Assignee:
                    sanja Oleksandr Byelkin
                    Reporter:
                    igor Igor Babaev
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: