But
x NEAR (y, 0.03)
might be another matter.
Also, is there a hybrid of IN and NEAR?
x NEAR_IN ((1.7, 3.2, 5.5), 0.1)
> -----Original Message-----
> From: Jacek Becla [mailto:becla@stripped]
> Sent: Monday, November 20, 2006 3:12 PM
> To: Rick James
> Cc: internals@stripped
> Subject: Re: near operator
>
> It was suggested that it should internally use a range,
> for example x NEAR (5, 0.03) would be internally
> translated to 4.97 < x < 5.03
> So no, it will not invalidate indexes, at least that is my
> understanding.
>
> Jacek
>
>
>
> Rick James wrote:
> > Will the near operator invalidate use of indexes, as do functions?
> >
> >> -----Original Message-----
> >> From: Jacek Becla [mailto:becla@stripped]
> >> Sent: Monday, November 20, 2006 12:51 PM
> >> To: internals@stripped
> >> Subject: near operator
> >>
> >> Hi,
> >>
> >> I talked to Monty at the mysqlcamp about problems with
> >> precision, and he
> >> mentioned that mysql can implement "near" operator which
> >> would take an
> >> argument: required precision. He mentioned this could be
> >> implemented in
> >> release 5.1, and asked to send a note to document this
> >> feature request
> >> (which I am doing right now).
> >>
> >> Let me know if you have any questions.
> >>
> >> Thanks,
> >> Jacek
> >>
> >> --
> >> MySQL Internals Mailing List
> >> For list archives: http://lists.mysql.com/internals
> >> To unsubscribe:
> >> http://lists.mysql.com/internals?unsub=1
> >>
> >>
> >
>
>
