You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ignite.apache.org by zs...@apache.org on 2022/10/20 14:24:08 UTC

[ignite-3] branch main updated: IGNITE-15609 Sql. Remove erroneous test with WHERE clause - Fixes #1227.

This is an automated email from the ASF dual-hosted git repository.

zstan pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/ignite-3.git


The following commit(s) were added to refs/heads/main by this push:
     new 852111f8e7 IGNITE-15609 Sql. Remove erroneous test with WHERE clause - Fixes #1227.
852111f8e7 is described below

commit 852111f8e79a22ef7ac35310492da1a186d54f62
Author: zstan <st...@gmail.com>
AuthorDate: Thu Oct 20 17:23:38 2022 +0300

    IGNITE-15609 Sql. Remove erroneous test with WHERE clause - Fixes #1227.
    
    Signed-off-by: zstan <st...@gmail.com>
---
 .../scalar/test_tpcds_correlated_subquery.test_ignore    | 16 ----------------
 1 file changed, 16 deletions(-)

diff --git a/modules/runner/src/integrationTest/sql/subquery/scalar/test_tpcds_correlated_subquery.test_ignore b/modules/runner/src/integrationTest/sql/subquery/scalar/test_tpcds_correlated_subquery.test_ignore
deleted file mode 100644
index 0e96ef37cc..0000000000
--- a/modules/runner/src/integrationTest/sql/subquery/scalar/test_tpcds_correlated_subquery.test_ignore
+++ /dev/null
@@ -1,16 +0,0 @@
-# name: test/sql/subquery/scalar/test_tpcds_correlated_subquery.test
-# description: Test correlated subqueries based on TPC-DS
-# group: [scalar]
-# Ignore https://issues.apache.org/jira/browse/IGNITE-15609
-
-statement ok
-CREATE TABLE item(i_manufact INTEGER)
-
-query I
-SELECT * FROM item i1 WHERE (SELECT count(*) AS item_cnt FROM item WHERE (i_manufact = i1.i_manufact AND i_manufact=3) OR (i_manufact = i1.i_manufact AND i_manufact=3)) > 0 ORDER BY 1 LIMIT 100;
-----
-
-query I
-SELECT * FROM item i1 WHERE (SELECT count(*) AS item_cnt FROM item WHERE (i_manufact = i1.i_manufact AND i_manufact=3) OR (i_manufact = i1.i_manufact AND i_manufact=3)) ORDER BY 1 LIMIT 100;
-----
-