Archives of the TeradataForum
Message Posted: Fri, 03 Feb 2012 @ 10:21:22 GMT
David Wellman wrote:
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 :-)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|