Ivan Artukhov created IGNITE-19615:
--------------------------------------
Summary: Index is not used while performing SELECT over an indexed
column
Key: IGNITE-19615
URL: https://issues.apache.org/jira/browse/IGNITE-19615
Project: Ignite
Issue Type: Bug
Components: sql
Reporter: Ivan Artukhov
Performing SELECT on an indexed column does not utilize the index. This is
shown on EXPLAIN query.
```
11:35:27.760 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: create table index_test_table_1(id INTEGER not null, field_1 TINYINT,
field_2 SMALLINT, field_3 INTEGER, field_4 FLOAT, field_5 VARCHAR(50), primary
key (id))
11:35:28.924 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: CREATE INDEX index_test_index_1_1 ON index_test_table_1 (field_2)
Jun 01, 2023 11:35:28 AM org.apache.ignite.internal.logger.IgniteLogger
logInternal
INFO: Partition assignment change notification received
[remoteAddress=localhost:10801]
11:35:29.003 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (0, 0, 0, 0, 0.0, 'string_value_0')
11:35:30.529 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (1, 1, 1, 1, 1.1, 'string_value_1')
11:35:30.571 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (2, 2, 2, 2, 2.2, 'string_value_2')
11:35:30.602 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (3, 3, 3, 3, 3.3000000000000003, 'string_value_3')
11:35:30.636 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (4, 4, 4, 4, 4.4, 'string_value_4')
11:35:30.669 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (5, 5, 5, 5, 5.5, 'string_value_5')
11:35:30.700 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (6, 6, 6, 6, 6.6000000000000005, 'string_value_6')
11:35:30.727 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (7, 7, 7, 7, 7.700000000000001, 'string_value_7')
11:35:30.755 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (8, 8, 8, 8, 8.8, 'string_value_8')
11:35:30.785 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (9, 9, 9, 9, 9.9, 'string_value_9')
11:35:30.819 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (10, 10, 10, 10, 11.0, 'string_value_10')
11:35:30.850 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (11, 11, 11, 11, 12.100000000000001, 'string_value_11')
11:35:30.881 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (12, 12, 12, 12, 13.200000000000001, 'string_value_12')
11:35:30.907 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (13, 13, 13, 13, 14.3, 'string_value_13')
11:35:30.932 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (14, 14, 14, 14, 15.400000000000002, 'string_value_14')
11:35:30.964 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (15, 15, 15, 15, 16.5, 'string_value_15')
11:35:30.998 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (16, 16, 16, 16, 17.6, 'string_value_16')
11:35:31.030 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (17, 17, 17, 17, 18.700000000000003, 'string_value_17')
11:35:31.053 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (18, 18, 18, 18, 19.8, 'string_value_18')
11:35:31.078 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (19, 19, 19, 19, 20.900000000000002, 'string_value_19')
11:35:31.106 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (20, 20, 20, 20, 22.0, 'string_value_20')
11:35:31.133 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (21, 21, 21, 21, 23.1, 'string_value_21')
11:35:31.164 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (22, 22, 22, 22, 24.200000000000003, 'string_value_22')
11:35:31.190 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (23, 23, 23, 23, 25.3, 'string_value_23')
11:35:31.222 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (24, 24, 24, 24, 26.400000000000002, 'string_value_24')
11:35:31.252 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (25, 25, 25, 25, 27.500000000000004, 'string_value_25')
11:35:31.287 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (26, 26, 26, 26, 28.6, 'string_value_26')
11:35:31.323 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (27, 27, 27, 27, 29.700000000000003, 'string_value_27')
11:35:31.360 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (28, 28, 28, 28, 30.800000000000004, 'string_value_28')
11:35:31.390 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (29, 29, 29, 29, 31.900000000000002, 'string_value_29')
11:35:31.421 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (30, 30, 30, 30, 33.0, 'string_value_30')
11:35:31.452 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (31, 31, 31, 31, 34.1, 'string_value_31')
11:35:31.484 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (32, 32, 32, 32, 35.2, 'string_value_32')
11:35:31.517 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (33, 33, 33, 33, 36.300000000000004, 'string_value_33')
11:35:31.546 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (34, 34, 34, 34, 37.400000000000006, 'string_value_34')
11:35:31.579 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (35, 35, 35, 35, 38.5, 'string_value_35')
11:35:31.631 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (36, 36, 36, 36, 39.6, 'string_value_36')
11:35:31.676 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (37, 37, 37, 37, 40.7, 'string_value_37')
11:35:31.713 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (38, 38, 38, 38, 41.800000000000004, 'string_value_38')
11:35:31.746 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (39, 39, 39, 39, 42.900000000000006, 'string_value_39')
11:35:31.768 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (40, 40, 40, 40, 44.0, 'string_value_40')
11:35:31.790 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (41, 41, 41, 41, 45.1, 'string_value_41')
11:35:31.830 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (42, 42, 42, 42, 46.2, 'string_value_42')
11:35:31.857 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (43, 43, 43, 43, 47.300000000000004, 'string_value_43')
11:35:31.881 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (44, 44, 44, 44, 48.400000000000006, 'string_value_44')
11:35:31.907 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (45, 45, 45, 45, 49.50000000000001, 'string_value_45')
11:35:31.936 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (46, 46, 46, 46, 50.6, 'string_value_46')
11:35:31.962 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (47, 47, 47, 47, 51.7, 'string_value_47')
11:35:31.988 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (48, 48, 48, 48, 52.800000000000004, 'string_value_48')
11:35:32.011 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (49, 49, 49, 49, 53.900000000000006, 'string_value_49')
11:35:32.033 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (50, 50, 50, 50, 55.00000000000001, 'string_value_50')
11:35:32.052 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (51, 51, 51, 51, 56.1, 'string_value_51')
11:35:32.075 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (52, 52, 52, 52, 57.2, 'string_value_52')
11:35:32.097 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (53, 53, 53, 53, 58.300000000000004, 'string_value_53')
11:35:32.118 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (54, 54, 54, 54, 59.400000000000006, 'string_value_54')
11:35:32.136 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (55, 55, 55, 55, 60.50000000000001, 'string_value_55')
11:35:32.154 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (56, 56, 56, 56, 61.60000000000001, 'string_value_56')
11:35:32.173 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (57, 57, 57, 57, 62.7, 'string_value_57')
11:35:32.190 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (58, 58, 58, 58, 63.800000000000004, 'string_value_58')
11:35:32.212 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (59, 59, 59, 59, 64.9, 'string_value_59')
11:35:32.244 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (60, 60, 60, 60, 66.0, 'string_value_60')
11:35:32.266 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (61, 61, 61, 61, 67.10000000000001, 'string_value_61')
11:35:32.288 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (62, 62, 62, 62, 68.2, 'string_value_62')
11:35:32.313 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (63, 63, 63, 63, 69.30000000000001, 'string_value_63')
11:35:32.333 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (64, 64, 64, 64, 70.4, 'string_value_64')
11:35:32.356 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (65, 65, 65, 65, 71.5, 'string_value_65')
11:35:32.380 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (66, 66, 66, 66, 72.60000000000001, 'string_value_66')
11:35:32.406 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (67, 67, 67, 67, 73.7, 'string_value_67')
11:35:32.431 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (68, 68, 68, 68, 74.80000000000001, 'string_value_68')
11:35:32.464 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (69, 69, 69, 69, 75.9, 'string_value_69')
11:35:32.488 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (70, 70, 70, 70, 77.0, 'string_value_70')
11:35:32.512 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (71, 71, 71, 71, 78.10000000000001, 'string_value_71')
11:35:32.531 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (72, 72, 72, 72, 79.2, 'string_value_72')
11:35:32.554 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (73, 73, 73, 73, 80.30000000000001, 'string_value_73')
11:35:32.579 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (74, 74, 74, 74, 81.4, 'string_value_74')
11:35:32.605 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (75, 75, 75, 75, 82.5, 'string_value_75')
11:35:32.633 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (76, 76, 76, 76, 83.60000000000001, 'string_value_76')
11:35:32.658 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (77, 77, 77, 77, 84.7, 'string_value_77')
11:35:32.683 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (78, 78, 78, 78, 85.80000000000001, 'string_value_78')
11:35:32.726 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (79, 79, 79, 79, 86.9, 'string_value_79')
11:35:32.764 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (80, 80, 80, 80, 88.0, 'string_value_80')
11:35:32.792 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (81, 81, 81, 81, 89.10000000000001, 'string_value_81')
11:35:32.817 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (82, 82, 82, 82, 90.2, 'string_value_82')
11:35:32.846 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (83, 83, 83, 83, 91.30000000000001, 'string_value_83')
11:35:32.868 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (84, 84, 84, 84, 92.4, 'string_value_84')
11:35:32.886 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (85, 85, 85, 85, 93.50000000000001, 'string_value_85')
11:35:32.910 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (86, 86, 86, 86, 94.60000000000001, 'string_value_86')
11:35:32.937 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (87, 87, 87, 87, 95.7, 'string_value_87')
11:35:32.958 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (88, 88, 88, 88, 96.80000000000001, 'string_value_88')
11:35:32.982 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (89, 89, 89, 89, 97.9, 'string_value_89')
11:35:33.002 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (90, 90, 90, 90, 99.00000000000001, 'string_value_90')
11:35:33.032 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (91, 91, 91, 91, 100.10000000000001, 'string_value_91')
11:35:33.067 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (92, 92, 92, 92, 101.2, 'string_value_92')
11:35:33.093 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (93, 93, 93, 93, 102.30000000000001, 'string_value_93')
11:35:33.119 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (94, 94, 94, 94, 103.4, 'string_value_94')
11:35:33.141 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (95, 95, 95, 95, 104.50000000000001, 'string_value_95')
11:35:33.167 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (96, 96, 96, 96, 105.60000000000001, 'string_value_96')
11:35:33.189 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (97, 97, 97, 97, 106.7, 'string_value_97')
11:35:33.212 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (98, 98, 98, 98, 107.80000000000001, 'string_value_98')
11:35:33.236 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Update: INSERT INTO index_test_table_1 (id, field_1, field_2, field_3, field_4,
field_5) VALUES (99, 99, 99, 99, 108.9, 'string_value_99')
11:35:33.258 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Query: SELECT * FROM index_test_table_1 WHERE field_2 = 50
11:35:33.513 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Query: explain plan for SELECT * FROM index_test_table_1 WHERE field_2 = 50
11:35:33.565 [Test worker] INFO org.gridgain.ai3tests.tests.IndexTests --
Result: IgniteExchange(distribution=[single]): rowcount = 1500.0, cumulative
cost = IgniteCost [rowCount=11500.0, cpu=41500.0, memory=0.0, io=240000.0,
network=36000.0], id = 10103
IgniteTableScan(table=[[PUBLIC, INDEX_TEST_TABLE_1]],
tableId=[8239005d-346b-40d9-afe7-c15923ef3020], filters=[=(CAST($t2):INTEGER,
50)], requiredColumns=[{0, 1, 2, 3, 4, 5}]): rowcount = 1500.0, cumulative cost
= IgniteCost [rowCount=10000.0, cpu=40000.0, memory=0.0, io=240000.0,
network=0.0], id = 10102
```
It is expected that `explain plan for SELECT * FROM index_test_table_1 WHERE
field_2 = 50` query will contain `IgniteIndexScan` with `index_test_index_1_1`.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
