Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6049

Allow tuples in IN lists

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.10.1.1
    • Fix Version/s: None
    • Component/s: SQL
    • Urgency:
      Normal

      Description

      A user would like to be able to use tuples in IN lists. See http://apache-database.10148.n7.nabble.com/tuple-IN-clause-td126642.html. The following syntax (not currently supported by Derby) is legal according to my reading of the SQL Standard, part 2, sections 8.4 <in predicate> and 7.2 <row value expression>:

      select * from t where ( a, b ) in ( ( 1, 2 ), ( 3, 4 ) )

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              rhillegas Richard N. Hillegas
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: