"Kate Porter" <[EMAIL PROTECTED]> wrote:
> I am using 4.0.15 on RedHat 7.3 and ran it to a strangest problem today.
>
> SELECT col FROM table WHERE site_id=123;
> returns a list of data.
>
> SELECT col FROM table WHERE site_id IN(123);
> returns an empty set.
>
> Upon further investigation, I f
I am using 4.0.15 on RedHat 7.3 and ran it to a strangest problem today.
SELECT col FROM table WHERE site_id=123;
returns a list of data.
SELECT col FROM table WHERE site_id IN(123);
returns an empty set.
Upon further investigation, I found cases when the IN() syntax gets a
smaller subset of th
