Bug #19009 INSERT DELAYED into a <view> refuses to insert

Submitted: 11 Apr 2006 13:51 Modified: 14 Nov 2006 19:29
Reporter: Alexander Ivanov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0, 5.1 OS:
Assigned to: Paul DuBois CPU Architecture:Any

[11 Apr 2006 13:51] Alexander Ivanov
Description:
INSERT DELAYED into a <view> reports an error
(in both 5.0 and 5.1):

mysql> DROP TABLE IF EXISTS t1;
Query OK, 0 rows affected (0.01 sec)

mysql> DROP VIEW IF EXISTS v1;
Query OK, 0 rows affected (0.02 sec)

mysql> CREATE TABLE t1 (n INT);
Query OK, 0 rows affected (0.08 sec)

mysql> CREATE VIEW  v1 AS SELECT * FROM t1;
Query OK, 0 rows affected (0.05 sec)

mysql> INSERT DELAYED INTO v1 VALUES (1);
ERROR 1347 (HY000): 'test.v1' is not BASE TABLE

mysql> SELECT * FROM t1;
Empty set (0.00 sec)

As discussed with Psergey and Sanja (see also BUG#13683), either
INSERT DELAYED into a <view> should be executed as normal (i.e.
not delayed) INSERT (and really why not?) or there should be an
explicit remark in the Reference Manual.

How to repeat:
See above
[11 Apr 2006 15:08] MySQL Verification Team
Thank you for the bug report.
[2 Nov 2006 14:28] Georgi Kodinov
This is a design limitation that is not trivial to lift. So please have it mentioned in the appropriate place in the documentation.
[14 Nov 2006 19:29] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

I've updated the manual to indicate that INSERT DELAYED
is not supported for views.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.054 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.