17.05 - Restrictions - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
vnq1596660420420.ditamap
dita:ditavalPath
hoy1596145193032.ditaval

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.