Sorry, but I agree with Brett. CONTAINS is a much more natural way to perform a full-text search, especially for those coming from SQL.
On Sat, Aug 29, 2015 at 1:47 AM Gunnar Morling <gun...@hibernate.org> wrote: > 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 > _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
