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

LP:1011543 - JOIN statement inside the DELETE query are broken

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Not a Bug
    • None
    • None
    • None

    Description

      After upgrading MariaDB from 5.3.7 to 5.5.24 version, JOIN statement inside the DELETE query are broken.

      All triggers containing:

        DELETE sales_tree_p t1 FROM sales_tree_p t1

         JOIN (SELECT * FROM sales_tree_p WHERE id_sale_in = 1999) t2 ON t2.id_sale = t1.id_sale

         JOIN (SELECT * FROM sales_tree_p WHERE id_sale = 2000) t3 ON (t3.id_sale_in = t1.id_sale_in);

      are lost!!!!!

      And when I manually try exec this query I receive error message

      Error Code: 1064

      You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 't1 FROM sales_tree_p t1

         JOIN (SELECT * FROM sales_tree_p WHERE id_sale_in = 1' at line 1

      After downgrade to version 5.3.7 all my triggers appear again and begins work.

      Thus, I see two problems:

      1) the main, broken JOIN statement inside the DELETE query.

      2) when update must be reported that the break triggers and stored procedures.

      Attachments

        Activity

          People

            Unassigned Unassigned
            ntman NT Man (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.