#1285 closed defect (fixed)
struct comparison should not be induced
Reported by: | Dimitar Misev | Owned by: | |
---|---|---|---|
Priority: | major | Milestone: | 9.7 |
Component: | qlparser | Version: | development |
Keywords: | Cc: | Peter Baumann, Alex Toader | |
Complexity: | Medium |
Description
The result of struct comparison should be a single boolean.
The comparison is defined like this in SQL (X and Y are rows with n attributes):
- X = Y is True if and only if X_i = Y_i is True for all i.
- X < Y is True if and only if X_i = Y_i is True for all i < n and X_n < Y_n for some n.
- X = Y is False if and only if NOT (X_i = Y_i) is True for some i.
- X < Y is False if and only if X = Y is True or Y < X is True.
If X or Y is null, then the result is Unknown (null in our case).
min/max should similarly not be induced, see #1283
Change History (2)
comment:1 by , 6 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
comment:2 by , 6 years ago
Milestone: | 10.0 → 9.7 |
---|
Note:
See TracTickets
for help on using tickets.