[jira] [Commented] (IGNITE-16138) Calcite. AssertionError: Input not sorted for some ORDER BY containing requests.

["Evgeny Stanilovsky (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-16138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17463341#comment-17463341 ] 

Evgeny Stanilovsky commented on IGNITE-16138:
---------------------------------------------

[~alex_pl] [~tledkov-gridgain] [~korlov] guys make a review plz

> Calcite. AssertionError: Input not sorted for some ORDER BY containing requests.
> --------------------------------------------------------------------------------
>
>                 Key: IGNITE-16138
>                 URL: https://issues.apache.org/jira/browse/IGNITE-16138
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>            Reporter: Evgeny Stanilovsky
>            Assignee: Evgeny Stanilovsky
>            Priority: Major
>              Labels: calcite, calcite2-required, calcite3-required, ignite-3
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> {noformat}
> statement ok
> CREATE TABLE tab0(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 VARCHAR, col3 INTEGER, col4 FLOAT, col5 VARCHAR)
> statement ok
> INSERT INTO tab0 VALUES(0,544,473.59,'lupfg',846,31.38,'crmer')
> statement ok
> INSERT INTO tab0 VALUES(1,551,716.92,'sxtsd',562,145.36,'xxacr')
> statement ok
> INSERT INTO tab0 VALUES(2,481,975.35,'uxrjj',652,750.52,'rdgic')
> statement ok
> INSERT INTO tab0 VALUES(3,345,371.4,'nxyqi',51,199.34,'lekdd')
> statement ok
> INSERT INTO tab0 VALUES(4,908,772.92,'owifa',256,154.36,'xophl')
> statement ok
> INSERT INTO tab0 VALUES(5,309,912.32,'iganw',957,707.84,'tewpl')
> statement ok
> INSERT INTO tab0 VALUES(6,691,521.59,'fstmf',656,504.37,'ptkph')
> statement ok
> INSERT INTO tab0 VALUES(7,823,447.70,'rrwze',294,877.49,'fvoic')
> statement ok
> INSERT INTO tab0 VALUES(8,725,784.91,'iaoqu',878,963.31,'razqy')
> statement ok
> INSERT INTO tab0 VALUES(9,297,993.36,'eoujh',105,829.18,'kvyce')
> statement ok
> CREATE TABLE tab1(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 VARCHAR, col3 INTEGER, col4 FLOAT, col5 VARCHAR)
> statement ok
> CREATE INDEX idx_tab1_0 on tab1 (col0)
> statement ok
> CREATE INDEX idx_tab1_1 on tab1 (col1)
> statement ok
> CREATE INDEX idx_tab1_3 on tab1 (col3)
> statement ok
> CREATE INDEX idx_tab1_4 on tab1 (col4)
> statement ok
> INSERT INTO tab1 SELECT * FROM tab0
> statement ok
> CREATE TABLE tab2(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 VARCHAR, col3 INTEGER, col4 FLOAT, col5 VARCHAR)
> statement ok
> CREATE INDEX idx_tab2_0 ON tab2 (col0 DESC,col4 DESC)
> statement ok
> CREATE INDEX idx_tab2_1 ON tab2 (col3,col1)
> statement ok
> CREATE INDEX idx_tab2_3 ON tab2 (col0,col1 DESC)
> statement ok
> CREATE INDEX idx_tab2_5 ON tab2 (col4 DESC)
> statement ok
> INSERT INTO tab2 SELECT * FROM tab0
> statement ok
> CREATE TABLE tab3(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 VARCHAR, col3 INTEGER, col4 FLOAT, col5 VARCHAR)
> statement ok
> CREATE INDEX idx_tab3_0 ON tab3 (col4)
> statement ok
> CREATE INDEX idx_tab3_2 ON tab3 (col0 DESC,col3)
> statement ok
> CREATE INDEX idx_tab3_3 ON tab3 (col1 DESC)
> statement ok
> INSERT INTO tab3 SELECT * FROM tab0
> statement ok
> CREATE TABLE tab4(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 VARCHAR, col3 INTEGER, col4 FLOAT, col5 VARCHAR)
> statement ok
> CREATE INDEX idx_tab4_1 ON tab4 (col3)
> statement ok
> CREATE INDEX idx_tab4_2 ON tab4 (col4)
> statement ok
> CREATE INDEX idx_tab4_3 ON tab4 (col1,col0 DESC)
> SELECT pk FROM tab3 WHERE (col3 < 204) AND col3 IN (SELECT col0 FROM tab3 WHERE col3 >= 218) AND col4 IN (SELECT col1 FROM tab3 WHERE (((((col3 IN (427) OR col3 <= 404)))) OR ((col0 IS NULL AND (col4 > 802.10 AND col0 = 651))) OR col3 BETWEEN 851 AND 573)) ORDER BY 1 DESC
> {noformat}



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