Re: SELECT id, myFunc(id) FROM aTable ORDER BY id; returns bad data

[Jay Pipes]

Roland Bouman wrote:
> because I was (and
> still am) under the same impression as you, namely
> that EXISTS is a unary logical operator that
> accepts a subquery operand and returns true only
> if that subquery yields at least one row.

Roland, are you sure that English is your second language? You always seem so eloquent in your explanations! ;)

> Shall I report this DUAL business as a
> bug or what?

I would, unless you can find something in the Docs specific to DUAL that explains this behavour (I could not).

Cheers,

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com



Edited 1 time(s). Last edit at 09/26/2005 05:25AM by Jay Pipes.