Error Messages Associated with SQLSTATE 42804
This topic lists the errors associated with the SQLSTATE 42804.
SQLSTATE 42804 Description
ERRCODE_DATATYPE_MISMATCH
Error messages associated with this SQLState
ERROR 2217: Argument string must be type float, not type string
ERROR 2218: Argument string must be type integer, not type string
ERROR 2222: Argument string must not return a set
ERROR 2224: Argument of string must be type boolean, not type string
ERROR 2225: Argument of string must not return a set
ERROR 2231: Array assignment requires type string but expression is of type string
ERROR 2232: Array assignment to "string" requires type string but expression is of type string
ERROR 2234: Array subscript must have type integer
ERROR 2358: Cannot assign to field "string" of column "string" because its type string is not a composite type
ERROR 2527: Cannot subscript type string because it is not an array
ERROR 2630: Column "string" is of type string but default expression is of type string
ERROR 2631: Column "string" is of type string but expression is of type string
ERROR 2846: Could not determine actual result type for function "string" declared to return type string
ERROR 2850: Could not determine row description for function returning record
ERROR 3429: For 'string', types string and string are inconsistent
ERROR 3447: Function "string" in FROM has unsupported return type string
ERROR 3545: Index expression may not return a set
ERROR 3801: IS DISTINCT FROM requires = operator to yield boolean
ERROR 3943: Mismatched types in VALUES LESS THAN expressions
ERROR 4069: No column alias was provided
ERROR 4199: Number of aliases does not match number of columns
ERROR 4284: Operator string must not return a set
ERROR 4285: Operator string must return type boolean, not type string
ERROR 4317: Parameter $value of type string cannot be coerced to the expected type string
ERROR 4803: Subfield "string" is of type string but expression is of type string
ERROR 6480: Column "string" is of type string but expression in Access Policy is of type string. It will be coerced at execution time
ERROR 7221: Argument of type string must be type boolean, not string
ERROR 7222: Argument of type string must be type boolean, not type string
ERROR 7309: Column "string" is of type string but set using expression is of type string
ERROR 7929: Column to be added/refreshed is of type string but default/set-using expression is of type string
The Vertica User Community contains knowledge base articles, blogs, and forum posts that may help you resolve these errors.