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

different behaviour with "INTO @var1" for MySQL and MariaDB

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None

    Description

      MySQL 5.7
       
      mysql> (SELECT 1 INTO @var1);
      Query OK, 1 row affected (0.00 sec)
      

      MariaDB (tested with 10.4 and 10.8)
       
      MariaDB [d1]> (SELECT 1 INTO @var1);
      ERROR 1064 (42000): 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 'into @var1)' at line 1
      

      Attachments

        Issue Links

          Activity

            People

              ralf.gebhardt Ralf Gebhardt
              Richard Richard Stracke
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.