zstan commented on code in PR #5311:
URL: https://github.com/apache/ignite-3/pull/5311#discussion_r1981495668
##########
modules/sql-engine/src/integrationTest/java/org/apache/ignite/internal/sql/engine/ItSecondaryIndexTest.java:
##########
@@ -421,6 +421,27 @@ public void testComplexIndexCondition3() {
.check();
}
+ // Check plan immediately after table creation.
+ @Test
+ public void testComplexIndexConditionInitialTableCreate() {
+ try {
+ sql("CREATE TABLE TBL1 (id INT, name VARCHAR, depid INT, city
VARCHAR, age INT, PRIMARY KEY USING SORTED (id))");
+ sql("CREATE INDEX NAME_IDX1 ON TBL1 (name DESC)");
+ sql("CREATE INDEX NAME_CITY_IDX1 ON TBL1 (name DESC, city DESC)");
+ sql("CREATE INDEX NAME_DEP_CITY_IDX1 ON TBL1 (name DESC, depid
DESC, city DESC)");
+
+ insertData("TBL1", List.of("ID", "NAME", "DEPID", "CITY", "AGE"),
new Object[][]{
+ {1, "Mozart", 3, "Vienna", 33}
+ });
+
+ assertQuery("SELECT * FROM TBL1 WHERE name='Mozart' AND depId=3
AND city='Vienna'")
+ .matches(containsIndexScan("PUBLIC", "TBL1",
"NAME_DEP_CITY_IDX1"))
Review Comment:
changed to table scan
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscr...@ignite.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
