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

Missing update when updating a CONNECT table

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.4
    • Fix Version/s: 10.0.4
    • Component/s: None
    • Labels:
      None

      Description

      After doing:

      create table debit (ete int, hiver int, saison char(12)) engine=connect;
      insert into debit(ete,hiver) values(33,44);
      insert into debit values(11,23,'ete'),(17,24,'hiver'),(14,18,'printemps');
      update `débit` set hiver=68 where ete in (11,17);

      The update replies "affected rows 1" and indeed the row for ete = 17 is not updated.

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            bertrandop Olivier Bertrand
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: