[CALCITE-2002] DISTINCT applied to VALUES returns wrong result

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.0
• Fix Version/s: 1.16.0
• Assignee: Julian Hyde
• Reporter: Marc Prud'hommeaux
• Created: 05/Oct/17 18:55
• Updated: 27/Feb/24 22:23
• Resolved: 23/Feb/18 21:56

Description

The following output is clearly wrong:

baddistinct.sql

0: jdbc:calcite:model=inline:{"version":1.0,"> SELECT DISTINCT T.B FROM (VALUES (1, 'X'),(2, 'Y'),(3, 'X'),(4, 'X')) AS T(A, B);
+---+
| B |
+---+
| X |
| Y |
| X |
| X |
+---+
4 rows selected (0.014 seconds)

I'm guessing it is distinct-ing against the complete value tuple rather than the selected column, since the following is correct:

gooddistinct.sql

0: jdbc:calcite:model=inline:{"version":1.0,"> SELECT DISTINCT T.B FROM (VALUES (1, 'X'),(2, 'Y'),(3, 'X'),(3, 'X')) AS T(A, B);
+---+
| B |
+---+
| X |
| Y |
+---+
2 rows selected (0.013 seconds)