[MDEV-649] LP:992947 - Wrong error message when attempting to create a view for a database that does not exists Created: 2012-05-01  Updated: 2014-04-14  Resolved: 2014-04-14

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Igor Babaev Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug992947.xml    

 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).

 Comments   
Comment by Rasmus Johansson (Inactive) [ 2012-05-02 ]

Launchpad bug id: 992947

Comment by Elena Stepanova [ 2014-04-14 ]

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
 
...

Generated at Thu Feb 08 06:30:19 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.