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

IN() without parameter

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • N/A
    • OTHER
    • None

    Description

      It would be nice, if IN() without any parameter doesn't throw syntax error and return false instead. This would make easier writing scripts like DELETE / UPDATE ... WHERE (NOT) IN(?).

      example:
      SELECT 2 IN (0,3,5,7);
      returns false

      SELECT 2 IN ();
      returns syntax error
      false would be better

      Also NOT IN() without parameter should return true. Optimizer also could replace this functions with true / false.

      Attachments

        Activity

          People

            Unassigned Unassigned
            PavelCibulka Pavel Cibulka
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.