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

main.multi_update fails with --ps-protocol

    Details

      Description

      CURRENT_TEST: main.multi_update
      mysqltest: At line 1048: query 'UPDATE t1 t1  left join v3 t2 on t1.f4 = t2.fe2    SET t1.f20 = t2.ft6_1,    t1.f32 = t2.f32,    t1.f33 = t2.f33,    t1.f37 = t2.f37    WHERE f5 >= '2015-02-01'' failed: 1030: Got error 1 from storage engine

      See also buildbot, e.g. http://buildbot.askmonty.org/buildbot/builders/bld-dan-debug/builds/2062/steps/test_1/logs/stdio

      The test started failing from the following commit on 5.5 tree:

      commit b9a75862eaa05708921b8fe9773ffe233048bebc
      Author: Oleksandr Byelkin <sanja@mariadb.com>
      Date:   Thu Mar 5 16:34:13 2015 +0100
       
          MDEV-7613: MariaDB 5.5.40 server crash on update table left join with a view
          
          Multi-update do not need full list of leaf tables. It also do not use it on prepare (mysql_multi_update_prepare()).

      Although the failing portion of the test is new, the same updated test passes on the code before the change, so it looks like a code problem.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sanja Oleksandr Byelkin
                Reporter:
                elenst Elena Stepanova
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: