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 4625: Row comparison operator must not return a set

ERROR 4626: Row comparison operator must yield type boolean, not 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 7708: Column must be a string type

ERROR 7929: Column to be added/refreshed is of type string but default/set-using expression is of type string