"Recursive column %1: conversion from '%2' to '%3' loses precision"
Item |
Description |
SQLCode
|
-945L
|
Constant
|
BAD_RECURSIVE_COLUMN_CONVERSION
|
SQLState
|
42WA2
|
ODBC 2 State
|
37000
|
ODBC 3 State
|
42000
|
Sybase Error Code
|
2609
|
Severity Code
|
16
|
Parameter 1
|
Column number of the recursive subquery.
|
Parameter 2
|
Type converted from.
|
Parameter 3
|
Type converted to.
|
Probable cause
Every column in the recursive subquery must be convertible to the type of the corresponding column in the initial subquery without loss of precision. Try casting the column in the initial subquery to an appropriate type.