[jira] [Created] (CALCITE-682) Tuple comparison

[Julian Hyde (JIRA)]

Julian Hyde created CALCITE-682:
-----------------------------------

             Summary: Tuple comparison
                 Key: CALCITE-682
                 URL: https://issues.apache.org/jira/browse/CALCITE-682
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


Comparing tuples using = and other comparison operators. Examples from 
http://www.sql-workbench.net/comparison/tuple_comparison.html: {code}SELECT *
FROM person
WHERE (firstname, lastname) = ( ('Arthur', 'Dent') );

SELECT *
FROM person
WHERE (firstname, lastname) > ('Arthur', 'Dent');

SELECT *
FROM person
WHERE (firstname, lastname) IN ( ('Arthur', 'Dent'), ('Ford','Prefect') )

SELECT *
FROM some_table
WHERE (col_one, col_two) IN (SELECT x,y FROM other_table);{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)