[DERBY-6049] Allow tuples in IN lists

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.10.1.1
• Component/s: SQL
• Labels: derby_triage10_11
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Richard N. Hillegas
• Created: 23/Jan/13 14:22
• Updated: 25/Jun/13 04:41

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 ) )