Igniters, i found that ignite allow to create multiple case sensitive
indexes with equal fields collection, i.e. no exception and warn here:
CREATE INDEX \"title_idx\" ON books (title);
CREATE INDEX \"tiTLE_IDX\" ON books (title);
1. in this case will be created two different index structures.
2. documentation [1] not clarify that quotation usage will create
different ones and quotation absence will create index name in upper
registry.
3. what index, query planner would be use?
4. and main question: why do we need this functional?
i found that other vendors not allow such indexes [2]
if we can`t change this in 2.x version due to some backward compatibility
reasons, plz show them, i have no clue why we can`t change it in near
release versions.
[1] https://apacheignite-sql.readme.io/docs/create-index
[2]
https://oracle-base.com/articles/12c/multiple-indexes-on-same-set-of-columns-12cr1
thanks!
