[MDEV-8252] Support INSERT DELAYED INTO (just revert to simple INSERT INTO) Created: 2015-06-01 Updated: 2015-10-23 Resolved: 2015-06-01 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Manipulation - Insert |
| Affects Version/s: | 10.0.20, 10.1.5 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Critical |
| Reporter: | Alexander Loginov | Assignee: | Unassigned |
| Resolution: | Won't Fix | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Hello. I found it crazy to not support such a simple feature like INSERT DELAYED INTO. Why don't simply INSERT row without delay if INSERT DELAYED INTO was used? Now "#1616 - DELAYED option not supported for table 'tablename'" returned and nothing done. It breaks applications! |
| Comments |
| Comment by Elena Stepanova [ 2015-06-01 ] |
|
Hi, What do you mean by Now? If you are using InnoDB tables, it has never been supported, neither in MySQL (it's explicitly documented, see http://dev.mysql.com/doc/refman/5.6/en/insert-delayed.html), nor in MariaDB (https://mariadb.com/kb/en/mariadb/insert-delayed/). However, I understand your point, and if you insist, this issue can be converted into a feature request, although I think chances that it will ever be implemented are very little, because this option has already been deprecated in MySQL 5.6 and will be removed in a future release. Eventually it will happen in MariaDB as well. |
| Comment by Alexander Loginov [ 2015-06-01 ] |
|
Right, you may close that. Just some application use it in code. To not break them, insert delayed into can be converted to insert into internally. |