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

Incorrect error message, when with VALUES table construction used empty value

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.3, 10.4
    • 10.4
    • None
    • None

    Description

      MariaDB [test]> values (1), (2), () ;
      ERROR 4099 (HY000): The used table value constructor has a different number of values
       
      MariaDB [test]> values (1), (((2))), (1) ;
      +---+
      | 1 |
      +---+
      | 1 |
      | 2 |
      | 1 |
      +---+
      3 rows in set (0.000 sec)
       
      MariaDB [test]> values (1), (((2))), (()) ;
      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 '))' at line 1
      

      Attachments

        Activity

          People

            igor Igor Babaev
            alice Alice Sherepa
            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.