-344 THE RECURSIVE COMMON TABLE EXPRESSION `name` HAS MISMATCHED DATA TYPES OR LENGTHS OR CODE PAGE FOR COLUMN `column-name`

Explanation
 The recursive common table expression name name has
a column column-name that is referred to in the
iterative fullselect of the common table expression. The data type
and length are set based on the initialization fullselect for this
column. The result of the expression for the column column-name in
the iterative fullselect has a different data type or length that
may result in failure to assign the value for the column.

System action
 The statement cannot be processed.

Programmer response
 Correct the column used in the fullselects
of the recursive common table expression so that the initialization
column matches the iterative columns.

SQLSTATE
 42825

-344 THE RECURSIVE COMMON TABLE EXPRESSION name HAS MISMATCHED DATA TYPES OR LENGTHS OR CODE PAGE FOR COLUMN column-name

Explanation

System action

Programmer response

SQLSTATE

-344 THE RECURSIVE COMMON TABLE EXPRESSION `name` HAS MISMATCHED DATA TYPES OR LENGTHS OR CODE PAGE FOR COLUMN `column-name`