Restrictions - Advanced SQL Engine - Teradata Database

SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
vjt1596846980081.ditamap
dita:ditavalPath
vjt1596846980081.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata Vantage™

The following limitations apply to view definitions that specify set operators:

  • UPDATE, DELETE, and INSERT are not applicable The following example does not work:
       REPLACE VIEW V AS
       SELECT X 
       FROM TABLE_1
       UNION 
       SELECT Y FROM 
       TABLE_1;
    
       UPDATE V
       SET X=0;

    An attempt to perform this sequence of statements produces the following error message:

          ***Failure 3823 VIEW 'v' may not be used for Help Index/
      Constraint/Statistics, Update, Delete or Insert.
  • WITH CHECK OPTION is not applicable The following example does not work:
       REPLACE VIEW ERRV( c ) AS
       SELECT * 
       FROM TABLE_1
       UNION
       SELECT * 
       FROM TABLE_2
       WHERE TABLE_2.X=2 WITH CHECK OPTION;

    An attempt to perform this statement causes the following error message:

       ***Failure 3847 Illegal use of a WITH clause.
  • Column level privileges cannot be granted The following example does not work:
       GRANT UPDATE ( c ) ON TABLE_VIEW TO USER_NAME;

    An attempt to perform this statement causes the following error message:

       ***Failure 3499: GRANT cannot be used on views with set operators.
  • A view definition that uses set operators cannot specify an ORDER BY clause, but a SELECT statement applied on the view can use ORDER BY.