[ 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)