[jira] [Commented] (IGNITE-15391) IndexName parameter of IndexQuery should be optional

["Ignite TC Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-15391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17419763#comment-17419763 ] 

Ignite TC Bot commented on IGNITE-15391:
----------------------------------------

{panel:title=Branch: [pull/9407/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/9407/head] Base: [master] : New Tests (126)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Index Query API{color} [[tests 126|https://ci.ignite.apache.org/viewLog.html?buildId=6193658]]
* {color:#013220}IndexQueryTestSuite: IndexQueryAllTypesTest.testRangeStringField[useIdxName=false] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryAllTypesTest.testRangeDoubleField[useIdxName=false] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryAllTypesTest.testRangePojoField[useIdxName=false] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryAllTypesTest.testRangeByteField[useIdxName=false] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryAllTypesTest.testBoolField[useIdxName=true] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryAllTypesTest.testRangeDecimalField[useIdxName=true] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryAllTypesTest.testRangeIntField[useIdxName=false] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryAllTypesTest.testRangeUuidField[useIdxName=false] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryAllTypesTest.testRangeLongField[useIdxName=false] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryAllTypesTest.testRangeTimeField[useIdxName=false] - PASSED{color}
* {color:#013220}IndexQueryTestSuite: IndexQueryAllTypesTest.testRangeShortField[useIdxName=false] - PASSED{color}
... and 115 new tests

{panel}
[TeamCity *--> Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=6183695&buildTypeId=IgniteTests24Java8_RunAll]

> IndexName parameter of IndexQuery should be optional
> ----------------------------------------------------
>
>                 Key: IGNITE-15391
>                 URL: https://issues.apache.org/jira/browse/IGNITE-15391
>             Project: Ignite
>          Issue Type: New Feature
>            Reporter: Maksim Timonin
>            Assignee: Maksim Timonin
>            Priority: Major
>              Labels: IEP-71
>          Time Spent: 40m
>  Remaining Estimate: 0h
>
> IndexQuery should be created by list of fields specified in criteria. Order of fields doesn't matter. Ignite should find best index by criteria fields, and fields has to match index prefix.
>  
> I believe that it's a useful feature. My main argument is still the same:
>  1. Ignite provides to users the possibility to create an index without name setting. Then Ignite should provide the possibility to query them. 
> 2. Naming of index isn't transparent, and hidden in internal packages. For example QuerySqlField provides opportunity to create an index, and set name to field (but not for index). But QuerySqlField.Group name set index name. This misleading.
> 3. There is an example of using such API in other databases: as Ivan mentioned, MongoDB doesn't require to specify an index name [1], it searches it by fields only. Note, MongoDB doesn't require strict fields order for querying indexes, but requires it for sorting [2]. 
>   
>  I don't see reasons not to provide a similar API for our users.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)