Re: I can't understand

2001-03-13 Thread Gerald L. Clark
"P.Peti" wrote: > > Hello, > > Thanx for the answers, I think I've got the point now. I > have one more doubt though. You described me that this > whole thing with the comparison not working with NULL > values is obvious. Why did it work in 3.22.25 then? > > Thank you for the answers so far. >

Re: I can't understand

2001-03-12 Thread Gerald L. Clark
"P.Peti" wrote: > > Hello, > > >And > >SELECT COUNT(*) FROM FILM WHERE COMMENT IS NULL: > > > >returns what? > > Sure, I forgot to mention that I know it's all about the > NULL values, i can correct the "problem" (maybe not a > problem but I think it's a weird behavior) i just don't > understan

Re: I can't understand

2001-03-12 Thread P.Peti
Hello, >And >SELECT COUNT(*) FROM FILM WHERE COMMENT IS NULL: > >returns what? Sure, I forgot to mention that I know it's all about the NULL values, i can correct the "problem" (maybe not a problem but I think it's a weird behavior) i just don't understand why? The query you mentioned retu

Re: I can't understand

2001-03-12 Thread Gerald L. Clark
And SELECT COUNT(*) FROM FILM WHERE COMMENT IS NULL: returns what? "P.Peti" wrote: > > Hello, > > I have updated my mysql server from version 3.22.25 to > 3.23.33. I've noticed that the same query's output I've run > in the old version differs from the new version's. > > Eg. > > I've got a