Ok i now realize this leads to the question on which value to present for "name" when its aggregated case insensitively. I guess i will have to go for an outer query for this.
On Thursday, October 15, 2015 at 12:57:49 PM UTC+5:30, Chandima Jayawickrema wrote: > > Hi, > > Recently i found out that Class Property Setting "Collate" > "Case > Insensitive" will make filter conditions case insensitive, which is great. > However, I observed that it is not effective on GROUP BY clause. > > e.g. SELECT name, COUNT(*) as count FROM Person GROUP BY name > This gives me the result > > name | count > ------------------ > John | 1 > john | 1 > > note that "name" property has been marked as case insenstitive > > I am on orientdb-community-2.1.0. > > Appreciate your help.. > -- --- 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.
