Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 03 Feb 2012 @ 10:21:22 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020