DB2-style on composite-key query using IN expression
Registered by
Chun Ko
Default DB2 SQL implementation does not support composite-key within in statement. For example: select * from atable where (key1, key2) in ( (valueA, valueB), (valueC, valueD), (valueE, valueF)). Such SQL must be transform into: select * from atable where (key1, key2) = (valueA, valueB) or (key1, key2) = (valueC, valueD) or (key1, key2) = (valueE, valueF).
Blueprint information
- Status:
- Not started
- Approver:
- None
- Priority:
- Undefined
- Drafter:
- None
- Direction:
- Needs approval
- Assignee:
- None
- Definition:
- Approved
- Series goal:
- None
- Implementation:
-
Unknown
- Milestone target:
- None
- Started by
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
(?)
