[jira] [Updated] (IGNITE-14808) Calcite. RIGHT|FULL Join operations are lost nulls sort ordering.

2021-11-16 Thread Taras Ledkov (Jira) 


 [ 
https://issues.apache.org/jira/browse/IGNITE-14808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Taras Ledkov updated IGNITE-14808:
--
Labels: calcite  (was: calcite calcite3-required)

> Calcite. RIGHT|FULL Join operations are lost nulls sort ordering.
> -
>
> Key: IGNITE-14808
> URL: https://issues.apache.org/jira/browse/IGNITE-14808
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Reporter: Evgeny Stanilovsky
>Assignee: Konstantin Orlov
>Priority: Major
>  Labels: calcite
>  Time Spent: 4h 20m
>  Remaining Estimate: 0h
>
> queries like 
> {noformat}
> FROM integers FULL OUTER JOIN integers2 ON integers.i=integers2.k ORDER BY i 
> NULLS FIRST
> {noformat} will bring to erroneous results. Also some tests from /sql/join* 
> have no ordering thus results are not equal to pattern.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

[jira] [Updated] (IGNITE-14808) Calcite. RIGHT|FULL Join operations are lost nulls sort ordering.

2021-09-06 Thread Evgeny Stanilovsky (Jira) 


 [ 
https://issues.apache.org/jira/browse/IGNITE-14808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Evgeny Stanilovsky updated IGNITE-14808:

Labels: calcite calcite3-required  (was: calcite calcite2-required 
calcite3-required)

> Calcite. RIGHT|FULL Join operations are lost nulls sort ordering.
> -
>
> Key: IGNITE-14808
> URL: https://issues.apache.org/jira/browse/IGNITE-14808
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Reporter: Evgeny Stanilovsky
>Assignee: Konstantin Orlov
>Priority: Major
>  Labels: calcite, calcite3-required
>  Time Spent: 4h 20m
>  Remaining Estimate: 0h
>
> queries like 
> {noformat}
> FROM integers FULL OUTER JOIN integers2 ON integers.i=integers2.k ORDER BY i 
> NULLS FIRST
> {noformat} will bring to erroneous results. Also some tests from /sql/join* 
> have no ordering thus results are not equal to pattern.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Updated] (IGNITE-14808) Calcite. RIGHT|FULL Join operations are lost nulls sort ordering.

2021-06-18 Thread Yury Gerzhedovich (Jira) 


 [ 
https://issues.apache.org/jira/browse/IGNITE-14808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yury Gerzhedovich updated IGNITE-14808:
---
Labels: calcite calcite2-required calcite3-required  (was: calcite)

> Calcite. RIGHT|FULL Join operations are lost nulls sort ordering.
> -
>
> Key: IGNITE-14808
> URL: https://issues.apache.org/jira/browse/IGNITE-14808
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Reporter: Stanilovsky Evgeny
>Assignee: Stanilovsky Evgeny
>Priority: Major
>  Labels: calcite, calcite2-required, calcite3-required
>  Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> queries like 
> {noformat}
> FROM integers FULL OUTER JOIN integers2 ON integers.i=integers2.k ORDER BY i 
> NULLS FIRST
> {noformat} will bring to erroneous results. Also some tests from /sql/join* 
> have no ordering thus results are not equal to pattern.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Updated] (IGNITE-14808) Calcite. RIGHT|FULL Join operations are lost nulls sort ordering.

2021-06-01 Thread Stanilovsky Evgeny (Jira) 


 [ 
https://issues.apache.org/jira/browse/IGNITE-14808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Stanilovsky Evgeny updated IGNITE-14808:

Description: 
queries like 
{noformat}
FROM integers FULL OUTER JOIN integers2 ON integers.i=integers2.k ORDER BY i 
NULLS FIRST
{noformat} will bring to erroneous results. Also some tests from /sql/join* 
have no ordering thus results are not equal to pattern.


> Calcite. RIGHT|FULL Join operations are lost nulls sort ordering.
> -
>
> Key: IGNITE-14808
> URL: https://issues.apache.org/jira/browse/IGNITE-14808
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Reporter: Stanilovsky Evgeny
>Assignee: Stanilovsky Evgeny
>Priority: Major
>  Labels: calcite
>
> queries like 
> {noformat}
> FROM integers FULL OUTER JOIN integers2 ON integers.i=integers2.k ORDER BY i 
> NULLS FIRST
> {noformat} will bring to erroneous results. Also some tests from /sql/join* 
> have no ordering thus results are not equal to pattern.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Updated] (IGNITE-14808) Calcite. RIGHT|FULL Join operations are lost nulls sort ordering.

2021-06-01 Thread Stanilovsky Evgeny (Jira) 


 [ 
https://issues.apache.org/jira/browse/IGNITE-14808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Stanilovsky Evgeny updated IGNITE-14808:

Environment: (was: queries like 
{noformat}
FROM integers FULL OUTER JOIN integers2 ON integers.i=integers2.k ORDER BY i 
NULLS FIRST
{noformat} will bring to erroneous results. Also some tests from /sql/join* 
have no ordering thus results are not equal to pattern.
)

> Calcite. RIGHT|FULL Join operations are lost nulls sort ordering.
> -
>
> Key: IGNITE-14808
> URL: https://issues.apache.org/jira/browse/IGNITE-14808
> Project: Ignite
>  Issue Type: Bug
>  Components: sql
>Reporter: Stanilovsky Evgeny
>Assignee: Stanilovsky Evgeny
>Priority: Major
>  Labels: calcite
>




--
This message was sent by Atlassian Jira
(v8.3.4#803005)