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

Support INSERT DELAYED INTO (just revert to simple INSERT INTO)

    Details

      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!

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            elenst Elena Stepanova added a comment -

            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/).
            If you are using MyISAM tables, it is still supported.

            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.

            Show
            elenst Elena Stepanova added a comment - 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/ ). If you are using MyISAM tables, it is still supported. 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.
            Hide
            Profforg Alexander Loginov added a comment -

            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.

            Show
            Profforg Alexander Loginov added a comment - 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.

              People

              • Assignee:
                Unassigned
                Reporter:
                Profforg Alexander Loginov
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1 hour
                  1h
                  Remaining:
                  Remaining Estimate - 1 hour
                  1h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified