Opened 8 years ago

Closed 6 years ago

Last modified 6 years ago

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

  1. X = Y is True if and only if X_i = Y_i is True for all i.
  2. 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.
  3. X = Y is False if and only if NOT (X_i = Y_i) is True for some i.
  4. 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 Dimitar Misev, 6 years ago

Resolution: fixed
Status: newclosed

comment:2 by Dimitar Misev, 6 years ago

Milestone: 10.09.7
Note: See TracTickets for help on using tickets.