AS b, 1 AS c;
+---+---+---+
| a | b | c |
+---+---+---+
| 1 | 2 | 2 |
| 2 | 1 | 2 |
| 2 | 2 | 1 |
+---+---+---+
which is what I expected.
Fix:
look for result sets being set instead of set to a truth value.
Submitter-Id: submitter ID
Originator:Eric Prud'hommeaux
Organization
On Mon, Nov 15, 2004 at 10:26:29PM -0600, Paul DuBois wrote:
At 13:10 +0900 11/16/04, Eric Prud'hommeaux wrote:
Description:
A UNION B reports the A results faithfully, but 0s and NULLs
in B's results aren't making it to the result set intact.
How-To-Repeat:
SELECT 1