CREATE OR REPLACE TABLE (MDEV-5491)

[MDEV-5588] Strange error on CREATE OR REPLACE table over an existing view Created: 2014-01-29  Updated: 2014-01-31  Resolved: 2014-01-30

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

Type: Technical task Priority: Minor
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates

 Description    

MariaDB [test]> create or replace view v1 as select 1;
 
Query OK, 0 rows affected (0.08 sec)
 
 
 
MariaDB [test]> create or replace table v1 as select 1;
 
ERROR 1051 (42S02): Unknown table 'test.v1'

There should probably be some error, but not "Unknown table", because it's confusing.



 Comments   
Comment by Michael Widenius [ 2014-01-30 ]

Fixed by creating a new error message:
"xxxx" is a view

This will be given both in "drop table this_is_a_view' and 'create or replace this_is_a_view...'

Comment by Michael Widenius [ 2014-01-30 ]

Fixed in my tree, soon to be pushed

Generated at Thu Feb 08 07:05:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.