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

Spuštění nežádoucího triggeru, Zmatení engine, generování null

    XMLWordPrintable

Details

    Description

      Máme dvě tabulky, prázdnou hlavní, s (prázdným before upfdate triggerem) a dvouřádkovou nepráznou (not null) dočasnou.

      Database contains two tables,
      main is empty, with (empty, but same trouble comes with any content) before update trigger.
      temp has two non-empty rows.

      Fail:
      INSERT into MIxQIbind_bck (M_ID,Q_ID) select M_ID,Q_ID from `MIxQItemp`;
      pokud odejmeme trigger, vše funguje, a zadání jednoho řádku také.
      if limit 1 used., all is OK, if no trigger, all OK too.

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              ttsoftt Tomas Tregl
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.