 |
 |
Archives of the TeradataForum
Message Posted: Fri, 03 Feb 2012 @ 10:21:22 GMT
| Subj: | | Re: Use of Union with literals |
| |
| From: | | Dieter Noeth |
David Wellman wrote:
| | When using a UNION (I think any of the set operators - UNION, UNION ALL, MINUS etc) the SELECT statement ** must ** reference a table. I
think this is just an ANSI syntax requirement (but not sure). | |
It's Standard SQL, but not only for set operators, so Teradata doesn't follow ANSI for "SELECT 1;".
I think the old TEQUEL syntax didn't need FROM: "RETRIEVE 1;", so they couldn't change it anymore.
But when they switched to Standard SQL they added set operators and wanted to do it "correct".
So it's SQL compliant but stupid. And the workaround has a stupid plan, too :-)
Dieter
| |
