Error Messages Associated with SQLSTATE 0A005

This topic lists the errors associated with the SQLSTATE 0A005.

SQLSTATE 0A005 Description

ERRCODE_PLAN_TO_SQL_NOT_SUPPORTED

Error messages associated with this SQLState

ERROR 6679: Cannot generate annotated query when query contains table that does not have a projection
ERROR 6700: Constant NULLs in NOT-IN clause / Nullaware Anti Join not supported for optimizer-generated annotated queries
ERROR 6739: DML not supported for optimizer-generated annotated queries
ERROR 6770: EXPORT not supported for optimizer-generated annotated queries
ERROR 6866: Meta-function not supported for optimizer-generated annotated queries
ERROR 6889: Optimizer can only generate annotated query for SELECT queries
ERROR 6973: System tables not supported for optimizer-generated annotated queries
ERROR 7114: Query with syntactic hints not supported for optimizer-generated annotated queries
ERROR 7132: Under non-default locale, Multi-level aggregates in set operator sub-queries (except UNION ALL) not supported for optimizer-generated annotated queries
ERROR 7187: Multi-level aggregate queries with more than value grouping sets not supported for optimizer-generated annotated queries
ERROR 7449: Match clause not supported for optimizer-generated annotated queries
ERROR 7666: Query with geometry type not supported for optimizer-generated annotated queries
ERROR 7696: Queries with UDX functions with user defined parameter type of string is not supported

Note: For information about troubleshooting Vertica error messages, see the Vertica Knowledge Base and the Vertica Forum.