Hello, I want to understand the correlation between ci property and ci index.
According to documentation ci property will lead to case insensitive comparation in sql: alter property Test.foo collate ci select from Test where foo = 'test' will select all 'test', 'Test' etc. Case insensitive index: create index Test.foo on Test (foo collate ci) notunique But are these collate settings are independent? For example, if I want case sensitive property (default) and ci index, can I have it? I did a very simple test (2.0.10) and it showed that after I create ci index on property, property become ci too (queries on the property become case insensitive). What is the expected behaviour? Should it work in the opposite way: if a property is case insensitive, will index on that property be case insensitive? Thanks -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
