I like the idea of a new operator, but I side with Sanne that "~" would be useful for similarity/full-text searches.
What about "?=", somewhat inspired by Groovy's Elvis operator? It seems nicer to me for expressing null-awareness. The pattern could even be generalized by using the operator prefix for making some more comparison operators null-aware: "?<", "?>" etc. --Gunnar 2015-08-28 16:36 GMT+02:00 Brett Meyer <br...@hibernate.org>: > +1 to ~. Sanne has a good point, but I think I'd rather see a function > name there (CONTAINS, etc.). > > On 08/28/2015 10:09 AM, Sanne Grinovero wrote: >> On 28 August 2015 at 15:02, Steve Ebersole <st...@hibernate.org> wrote: >>> What do y'all think of using a symbol like ~ for this? The idea would be >>> similar to the "wavy equals" from logic used to denote "approximately >>> equals". >> I was hoping that one day we would be able to use the '~' symbol for >> full-text queries, i.e. a fuzzy match for text fields to extend HQL. >> But we have no concrete plans about that, and we currently don't do a >> great job in allowing people to combine full-text restrictions with >> relational restrictions, so that might be an unrealistic dream. >> >> >>> On Thu, Aug 27, 2015 at 7:05 AM andrea boriero <and...@hibernate.org> wrote: >>> >>>> i like the idea of "matches" operator for dealing with "is null". >>>> +1 >>>> >>>> On 26 August 2015 at 19:32, Steve Ebersole <st...@hibernate.org> wrote: >>>> >>>>> https://hibernate.atlassian.net/browse/SQM-11 >>>>> _______________________________________________ >>>>> hibernate-dev mailing list >>>>> hibernate-dev@lists.jboss.org >>>>> https://lists.jboss.org/mailman/listinfo/hibernate-dev >>>>> >>>> >>> _______________________________________________ >>> hibernate-dev mailing list >>> hibernate-dev@lists.jboss.org >>> https://lists.jboss.org/mailman/listinfo/hibernate-dev >> _______________________________________________ >> hibernate-dev mailing list >> hibernate-dev@lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/hibernate-dev > > > _______________________________________________ > hibernate-dev mailing list > hibernate-dev@lists.jboss.org > https://lists.jboss.org/mailman/listinfo/hibernate-dev _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
