YuJue Li created IGNITE-17453: --------------------------------- Summary: Calcite Engine: ORDER BY Optimization Key: IGNITE-17453 URL: https://issues.apache.org/jira/browse/IGNITE-17453 Project: Ignite Issue Type: Bug Components: sql Affects Versions: 2.13 Reporter: YuJue Li Fix For: 2.14
1.start a node; 2.create table: CREATE TABLE PI_COM_DAY (COM_ID VARCHAR(30) NOT NULL , ITEM_ID VARCHAR(30) NOT NULL , DATE1 VARCHAR(8) NOT NULL , KIND VARCHAR(1), QTY_IOD DECIMAL(18, 6) , AMT_IOD DECIMAL(18, 6) , PRIMARYKEY (COM_ID,ITEM_ID,DATE1)) WITH"template=partitioned,CACHE_NAME=PI_COM_DAY"; CREATE INDEX IDX_PI_COM_DAY_ITEM_DATE ON PI_COM_DAY(ITEM_ID); 3.insert some data, for example, 1m; 4.execute sql: select * from pi_com_day order by item_id desc limit 10; normal. select /*+ QUERY_ENGINE('calcite') */ * from pi_com_day order by item_id desc limit 10; then OOM. -- This message was sent by Atlassian Jira (v8.20.10#820010)