[hibernate-dev] SQM-11 : Consider a new matches operator - thoughts?

Steve Ebersole steve at hibernate.org
Sat Aug 29 13:21:01 EDT 2015


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 <gunnar at 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 <brett at 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 <steve at 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 <andrea at 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 <steve at hibernate.org>
> wrote:
> >>>>
> >>>>> https://hibernate.atlassian.net/browse/SQM-11
> >>>>> _______________________________________________
> >>>>> hibernate-dev mailing list
> >>>>> hibernate-dev at lists.jboss.org
> >>>>> https://lists.jboss.org/mailman/listinfo/hibernate-dev
> >>>>>
> >>>>
> >>> _______________________________________________
> >>> hibernate-dev mailing list
> >>> hibernate-dev at lists.jboss.org
> >>> https://lists.jboss.org/mailman/listinfo/hibernate-dev
> >> _______________________________________________
> >> hibernate-dev mailing list
> >> hibernate-dev at lists.jboss.org
> >> https://lists.jboss.org/mailman/listinfo/hibernate-dev
> >
> >
> > _______________________________________________
> > hibernate-dev mailing list
> > hibernate-dev at lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/hibernate-dev
> _______________________________________________
> hibernate-dev mailing list
> hibernate-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/hibernate-dev
>


More information about the hibernate-dev mailing list