I have tried CREATE INDEX title_idx ON books (lower(title)); but getting SQLException. Basically I want to configure the index in my Ignite XML Configuration. <property name="indexes"> <list> <bean class="org.apache.ignite.cache.QueryIndex"> <constructor-arg> <list> <value>referenceId</value> <value>customerId</value> </list> </constructor-arg> <constructor-arg value="SORTED" /> </bean> </list> </property> In above in have define one index and now need to create one more index on name field which should be case-insensitive
On Thu, Jan 12, 2023 at 9:46 PM Ilya Korol <[email protected]> wrote: > Hi, usually this can be achieved by using lower() function in index > definition. I guess it should be something like: > > CREATE INDEX title_idx ON books (lower(title)); > > I'm not sure whether Ignite supports such feature, but you can give it a > try. > Btw, to exploit this index you also would have to use lower() function > in you queries as well. > > Useful link: > > https://use-the-index-luke.com/sql/where-clause/functions/case-insensitive-search > > 12.01.2023 17:56, Biraj Deb пишет: > > Hello, > > I am writing to inquire about creating a case-insensitive index in > > Ignite's XML Configuration. I have been trying to implement this > > feature in my current project, but I am having some difficulty. > > I understand that ignite supports case-sensitive indexing by default, > > but I would like to know if there is a way to configure it for > > case-insensitive indexing. If anyone has experience with this or can > > point me in the right direction, it would be greatly appreciated. > > Thank you for your time and expertise. > > Best regards > > Biraj Deb >
