test: add test to verify use of range operations with composite indexes, issue #10456

tglman · tglman · commit b20e34a269bc · 2025-05-28T16:16:01.000+01:00
diff --git a/core/src/test/java/com/orientechnologies/orient/core/sql/executor/OSelectStatementExecutionTest.java b/core/src/test/java/com/orientechnologies/orient/core/sql/executor/OSelectStatementExecutionTest.java
@@ -1635,6 +1635,31 @@ public void testFetchFromClassWithIndexes15() {
     result.close();
   }
 
+  @Test
+  public void testFetchFromCompsiteIndex() {
+    String className = "testFetchFromClassCompositeIndex";
+    OClass clazz = db.getMetadata().getSchema().createClass(className);
+    clazz.createProperty("first", OType.LONG);
+    clazz.createProperty("second", OType.LONG);
+    clazz.createIndex(className + ".first_second", OClass.INDEX_TYPE.NOTUNIQUE, "second", "first");
+
+    for (int i = 0; i < 10; i++) {
+      ODocument doc = db.newInstance(className);
+      doc.setProperty("first", 99);
+      doc.setProperty("second", 5 + i);
+      db.save(doc);
+    }
+
+    OResultSet result =
+        db.query("select from " + className + " where second <=10  and first = 99  ");
+    printExecutionPlan(result);
+    Assert.assertEquals(result.stream().count(), 6);
+    OSelectExecutionPlan plan = (OSelectExecutionPlan) result.getExecutionPlan().get();
+    Assert.assertEquals(
+        1, plan.getSteps().stream().filter(step -> step instanceof FetchFromIndexStep).count());
+    result.close();
+  }
+
   @Test
   public void testFetchFromClassWithHashIndexes1() {
     String className = "testFetchFromClassWithHashIndexes1";
