Peter Brawley wrote:
Giuseppe,
>mysql> select 2 not in (1,null,3);
>+-+
>| 2 not in (1,null,3) |
>+-+
>|NULL |
>+-+
>1 row in set (0.00 sec)
># NOT OK
Isn't that standard SQL behaviour?
Yes, it is. As I said before
Giuseppe,
>mysql> select 2 not in (1,null,3);
>+-+
>| 2 not in (1,null,3) |
>+-+
>|NULL |
>+-+
>1 row in set (0.00 sec)
># NOT OK
Isn't that standard SQL behaviour? NULL is not a value. NOT IN compares
the values using '='
In article <[EMAIL PROTECTED]>,
Giuseppe Maxia <[EMAIL PROTECTED]> writes:
> The whole point is actually in subqueries, not when using IN or NOT IN in a
> normal query.
> The bug occurs when a NOT IN is used in a subquery as a LEFT JOIN replacement.
> SELECT something from t1 where column1 NOT I
Dan Nelson wrote:
In the last episode (Mar 16), Giuseppe Maxia said:
Here is a description of what looks like a serious bug. This is
related to bugs #7294 and #6247
Tested against mysql 4.1.9 and 4.1.10.
Description:
operator NOT IN fails when a subquery returns one or more NULL
values.
How-To
In the last episode (Mar 16), Giuseppe Maxia said:
> Here is a description of what looks like a serious bug. This is
> related to bugs #7294 and #6247
>
> Tested against mysql 4.1.9 and 4.1.10.
>
> >Description:
> operator NOT IN fails when a subquery returns one or more NULL
> value
Hi.
Here is a description of what looks like a serious bug.
This is related to bugs #7294 and #6247
Tested against mysql 4.1.9 and 4.1.10.
Cheers
Giuseppe Maxia
>Description:
operator NOT IN fails when a subquery returns one or more NULL values.
>How-To-Repeat:
simple proof of conce
dd and
> might explain some weird experiences.
>
>
> DVP
>
> Dathan Vance Pattishall
> http://www.friendster.com
>
>
> > -Original Message-
> > From: Monet [mailto:[EMAIL PROTECTED]
> > Sent: Monday, September 13, 2004 10:22 AM
> &g
Monet [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 13, 2004 10:22 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: IN operator
>
> Hi there,
> I used very likely statement last week to update one
> table. My IN value is around 20. I checked the manual
&
client) with the values I used in an
> IN-operator for an
> update onto a mySQL database.
>
> The statement looks like this:
> UPDATE layer SET State=1
> WHERE fpObjectID IN (1,3,4,5,20,34,56,24,56,11,45)
>
> Now, the question came up if there is a maximum of
> values o
h the values I used in an IN-operator for an
> update onto a mySQL database.
>
> The statement looks like this:
> UPDATE layer SET State=1
> WHERE fpObjectID IN (1,3,4,5,20,34,56,24,56,11,45)
>
> Now, the question came up if there is a maximum of values or length in
> an IN
* Oliver Hirschi <[EMAIL PROTECTED]> [09/13/04]:
> Hi people
>
> Due to MySQL does not support "inner-selects", I generate a string (I
> programm java-client) with the values I used in an IN-operator for an
> update onto a mySQL database.
>
> The statemen
Hi people
Due to MySQL does not support "inner-selects", I generate a string (I
programm java-client) with the values I used in an IN-operator for an
update onto a mySQL database.
The statement looks like this:
UPDATE layer SET State=1
WHERE fpObjectID IN (1,3,4,5,20,34,56,24,56,11,45)
At 11:25 -0400 9/6/03, Roger Davis wrote:
I am having a bit of trouble with the "IN" operator. I am thinking that it
just may be my misunderstanding.
Situation.
I have a table (ZipCounty) that I want to pull vendors from based on
zipcode. So I have a Vendor like field declar
You are misunderstanding the 'IN' operator
Try and think of it this way
SELECT value from table where field in (1,2,3)
is the same as
SELECT value from table where field = 1 or field = 2 or field = 3
So in you case
SELECT Count(ID) FROM ZipCounty WHERE '528' IN (VendorLink)
I am having a bit of trouble with the "IN" operator. I am thinking that it
just may be my misunderstanding.
Situation.
I have a table (ZipCounty) that I want to pull vendors from based on
zipcode. So I have a Vendor like field declared as TEXT. To keep the table
up to date
At 12:41 -0600 2/15/03, Don! Briggs wrote:
I have a field (cdfeature) that contains a list of comma seperated values.
Example follows:
select item_id, cdfeature from cars where (101 in (cdfeature));
+-+-+
| item_id | cdfeature |
+-+---
I have a field (cdfeature) that contains a list of comma seperated values.
Example follows:
select item_id, cdfeature from cars where (101 in (cdfeature));
+-+-+
| item_id | cdfeature |
+-+-+
| 320 | 101,104,106 |
|
17 matches
Mail list logo
