Lalant commented on code in PR #7270: URL: https://github.com/apache/ignite-3/pull/7270#discussion_r2635113919
########## modules/runner/src/integrationTest/java/org/apache/ignite/internal/runner/app/ItIndexNodeTest.java: ########## @@ -0,0 +1,322 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed with + * this work for additional information regarding copyright ownership. + * The ASF licenses this file to You under the Apache License, Version 2.0 + * (the "License"); you may not use this file except in compliance with + * the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.ignite.internal.runner.app; + +import static org.apache.ignite.internal.TestWrappers.unwrapIgniteImpl; +import static org.apache.ignite.internal.TestWrappers.unwrapTableViewInternal; +import static org.apache.ignite.internal.network.configuration.NetworkConfigurationSchema.DEFAULT_PORT; +import static org.apache.ignite.internal.storage.index.SortedIndexStorage.GREATER_OR_EQUAL; +import static org.apache.ignite.internal.storage.index.SortedIndexStorage.LESS_OR_EQUAL; +import static org.apache.ignite.internal.testframework.IgniteTestUtils.testNodeName; +import static org.apache.ignite.internal.testframework.matchers.CompletableFutureMatcher.willCompleteSuccessfully; +import static org.hamcrest.MatcherAssert.assertThat; +import static org.hamcrest.Matchers.hasSize; +import static org.junit.jupiter.api.Assertions.assertEquals; +import static org.junit.jupiter.api.Assertions.assertNotNull; +import static org.junit.jupiter.api.Assertions.assertThrows; + +import java.util.ArrayList; +import java.util.List; +import java.util.concurrent.CompletableFuture; +import java.util.concurrent.ExecutionException; +import java.util.concurrent.Flow.Publisher; +import java.util.concurrent.Flow.Subscriber; +import java.util.concurrent.Flow.Subscription; +import java.util.concurrent.TimeUnit; +import org.apache.ignite.Ignite; +import org.apache.ignite.IgniteServer; +import org.apache.ignite.InitParameters; +import org.apache.ignite.InitParametersBuilder; +import org.apache.ignite.internal.app.IgniteImpl; +import org.apache.ignite.internal.binarytuple.BinaryTupleBuilder; +import org.apache.ignite.internal.binarytuple.BinaryTupleReader; +import org.apache.ignite.internal.catalog.Catalog; +import org.apache.ignite.internal.catalog.CatalogManager; +import org.apache.ignite.internal.catalog.descriptors.CatalogIndexDescriptor; +import org.apache.ignite.internal.schema.BinaryRow; +import org.apache.ignite.internal.schema.BinaryTuple; +import org.apache.ignite.internal.schema.BinaryTuplePrefix; +import org.apache.ignite.internal.schema.Column; +import org.apache.ignite.internal.schema.SchemaDescriptor; +import org.apache.ignite.internal.sql.SqlCommon; +import org.apache.ignite.internal.table.IndexScanCriteria; +import org.apache.ignite.internal.table.InternalTable; +import org.apache.ignite.internal.table.TableViewInternal; +import org.apache.ignite.internal.testframework.IgniteAbstractTest; +import org.apache.ignite.internal.testframework.TestIgnitionManager; +import org.apache.ignite.table.Table; +import org.junit.jupiter.api.AfterEach; +import org.junit.jupiter.api.BeforeEach; +import org.junit.jupiter.api.Test; +import org.junit.jupiter.api.TestInfo; + +/** + * Integration tests running against a single Ignite node. + */ +public class ItIndexNodeTest extends IgniteAbstractTest { + private static final String NODE_CONFIG = "ignite.network.nodeFinder.netClusterNodes: [ \"localhost:" + DEFAULT_PORT + "\"]"; + + private static final String TABLE_NAME = "TEST_TABLE"; + private static final String HASH_IDX = "TEST_HASH_IDX"; + private static final String SORT_IDX = "TEST_SORT_IDX"; + private static final int LOWER_BOUND = 10; + private static final int UPPER_BOUND = 20; + private static final int VALUE = 15; + private static final int PART_ID = 0; + + private String nodeName; + + private IgniteServer node; + + private Ignite ignite; + private InternalTable internalTable; + private int hashIdx; + private int sortIdx; + + TableViewInternal tableViewInternal; + + @BeforeEach + void setUp(TestInfo testInfo) { + nodeName = testNodeName(testInfo, 0); + + node = TestIgnitionManager.start(nodeName, NODE_CONFIG, workDir.resolve(nodeName)); + + InitParameters parameters = new InitParametersBuilder() + .clusterName("cluster") + .metaStorageNodes(node) + .build(); + + node.initCluster(parameters); + + assertThat(node.waitForInitAsync(), willCompleteSuccessfully()); + + ignite = node.api(); + + // Create zone with 1 partition + String createZoneSql = "CREATE ZONE IF NOT EXISTS test_zone (PARTITIONS 1, REPLICAS 1) STORAGE PROFILES ['default']"; + + String createTableSql = "CREATE TABLE " + TABLE_NAME + "(\n" + + " key int PRIMARY KEY,\n" + + " field1 int,\n" + + " field2 int\n" + + ") ZONE test_zone"; + String createHashIndexSql = "CREATE INDEX IF NOT EXISTS " + HASH_IDX + " ON " + TABLE_NAME + " USING HASH (field1)"; + String createSortIndexSql = "CREATE INDEX IF NOT EXISTS " + SORT_IDX + " ON " + TABLE_NAME + " USING SORTED (field2)"; + String insertWithParams = "INSERT INTO " + TABLE_NAME + " (key, field1, field2) VALUES (?, ?, ?)"; + + ignite.sql().execute(null, createZoneSql); + ignite.sql().execute(null, createTableSql); + ignite.sql().execute(null, createHashIndexSql); + ignite.sql().execute(null, createSortIndexSql); + ignite.sql().execute(null, insertWithParams, 1, VALUE, VALUE); + + IgniteImpl igniteImpl = unwrapIgniteImpl(ignite); + + CatalogManager catalogManager = igniteImpl.catalogManager(); + + Catalog catalog = catalogManager.activeCatalog(igniteImpl.clock().nowLong()); + + hashIdx = getIndexIdBy(HASH_IDX, catalog); + sortIdx = getIndexIdBy(SORT_IDX, catalog); + + // Get the public Table API + Table table = ignite.tables().table(TABLE_NAME); + + assertNotNull(table); + + // Unwrap to get TableViewInternal + tableViewInternal = unwrapTableViewInternal(table); + + // Get the InternalTable + internalTable = tableViewInternal.internalTable(); + + assertNotNull(internalTable); + } + + @AfterEach + void tearDown() { + node.shutdown(); + } + + @Test + void testHashIndexThrowsWithRangeScan() { + Publisher<BinaryRow> publisher = internalTable.scan(PART_ID, null, hashIdx, + createMatchingRange()); + CollectingSubscriber subscriber = new CollectingSubscriber(); + publisher.subscribe(subscriber); + assertThrows(ExecutionException.class, () -> { + subscriber.result().get(10, TimeUnit.SECONDS); + }); + } + + @Test + void testHashIndexThrowsWithUnboundRangeScan() { + Publisher<BinaryRow> publisher = internalTable.scan(PART_ID, null, hashIdx, + IndexScanCriteria.unbounded()); + CollectingSubscriber subscriber = new CollectingSubscriber(); + publisher.subscribe(subscriber); + assertThrows(ExecutionException.class, () -> { + subscriber.result().get(10, TimeUnit.SECONDS); + }); + } + + @Test + void testSortWorksWithRangeScan() { + Publisher<BinaryRow> publisher = internalTable.scan(PART_ID, null, sortIdx, + createMatchingRange()); + CollectingSubscriber subscriber = new CollectingSubscriber(); + publisher.subscribe(subscriber); + assertThat(subscriber.result(), willCompleteSuccessfully()); + } + + @Test + void testSortFindsResultWithUnboundRangeScan() throws Exception { + Publisher<BinaryRow> publisher = internalTable.scan(PART_ID, null, sortIdx, + IndexScanCriteria.unbounded()); + CollectingSubscriber subscriber = new CollectingSubscriber(); + publisher.subscribe(subscriber); + assertThat(subscriber.result(), willCompleteSuccessfully()); + List<BinaryRow> result = subscriber.result().get(10, TimeUnit.SECONDS); + assertToBeCorrect(result); + } + + @Test + void testSortFindsResultWithBoundRangeScan() throws Exception { + Publisher<BinaryRow> publisher = internalTable.scan(PART_ID, null, sortIdx, + createMatchingRange()); + CollectingSubscriber subscriber = new CollectingSubscriber(); + publisher.subscribe(subscriber); + assertThat(subscriber.result(), willCompleteSuccessfully()); + List<BinaryRow> result = subscriber.result().get(10, TimeUnit.SECONDS); + assertToBeCorrect(result); + } + + @Test + void testSortFindsNothingWithUnmatchingRangeScan() throws Exception { + Publisher<BinaryRow> publisher = internalTable.scan(PART_ID, null, sortIdx, + createUnmatchingRange()); + CollectingSubscriber subscriber = new CollectingSubscriber(); + publisher.subscribe(subscriber); + assertThat(subscriber.result(), willCompleteSuccessfully()); + List<BinaryRow> result = subscriber.result().get(10, TimeUnit.SECONDS); + assertThat(result, hasSize(0)); + } + + @Test + void testScanFailsWithNonExistentIndex() { + // Use a non-existent index ID + int nonExistentIndexId = -1; + + Publisher<BinaryRow> publisher = internalTable.scan(PART_ID, null, nonExistentIndexId, + IndexScanCriteria.unbounded()); + CollectingSubscriber subscriber = new CollectingSubscriber(); + publisher.subscribe(subscriber); + + assertThrows(ExecutionException.class, () -> { + subscriber.result().get(10, TimeUnit.SECONDS); + }); + } + + private int getIndexIdBy(String name, Catalog catalog) { + String schemaName = SqlCommon.DEFAULT_SCHEMA_NAME; + CatalogIndexDescriptor indexDesc = catalog.aliveIndex(schemaName, name); + int res; + if (indexDesc != null) { + res = indexDesc.id(); + } else { + throw new IllegalStateException(); + } + return res; + } + + private void assertToBeCorrect(List<BinaryRow> result) { + assertThat(result, hasSize(1)); + + // Extract values from BinaryRow + BinaryRow row = result.get(0); + SchemaDescriptor schema = tableViewInternal.schemaView().lastKnownSchema(); + BinaryTupleReader reader = new BinaryTupleReader(schema.length(), row.tupleSlice()); + + Column keyColumn = findColumnByName(schema, "key"); + Column field1Column = findColumnByName(schema, "field1"); + Column field2Column = findColumnByName(schema, "field2"); + + int key = reader.intValue(keyColumn.positionInRow()); + int field1 = reader.intValue(field1Column.positionInRow()); + int field2 = reader.intValue(field2Column.positionInRow()); + + assertEquals(1, key); + assertEquals(VALUE, field1); + assertEquals(VALUE, field2); + } + + private Column findColumnByName(SchemaDescriptor schema, String columnName) { + return schema.columns().stream() + .filter(column -> columnName.equalsIgnoreCase(column.name())) + .findFirst() + .orElseThrow(() -> new AssertionError( + String.format("Can't find column by name: [columnName=%s]", columnName) + )); + } + + private IndexScanCriteria.Range createMatchingRange() { + return IndexScanCriteria.range(createBinaryTuplePrefix(LOWER_BOUND), + createBinaryTuplePrefix(UPPER_BOUND), GREATER_OR_EQUAL | LESS_OR_EQUAL); + } + + private IndexScanCriteria.Range createUnmatchingRange() { Review Comment: Done. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
