Restrictions - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
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.