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

Syntax error due to FOR..LOOP usage in triggers (sql_mode=oracle)

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Triggers
    • None

    Description

      On table row update, I got error:
      /* SQL Error (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 '' at line 1 */
      Win64, version 11.4.10-MariaDB.
      That is related with triggers, sql_mode=oracle and for..loop usage within triggers.
      Checked that the latest of 11.4 (11.4.11-MariaDB) is affected as well. Also checked that on
      11.8.6-MariaDB or on 11.1.2-MariaDB there is no such error in the same operation.

      Attachments

        Activity

          People

            Unassigned Unassigned
            balta Tadas Balaišis
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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