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

[Jay Pipes]

Don't know if this is the source of your issues, but the following:

EXISTS (SELECT count(*) FROM users WHERE userID = usrID)

will always return true, as the SELECT will always return a single row. Since the EXISTS tests for the return of one or more rows, it will always return true. I believe you need:

EXISTS (SELECT NULL FROM users WHERE userID = usrID)

This will return no rows if there is none found.

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

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