Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Recursion is not allowed without the RECURSIVE keyword Next Page

Recursive column %1: conversion from '%2' to '%3' loses precision


Item

Value

Constant

SQLE_BAD_RECURSIVE_COLUMN_CONVERSION

ODBC 2 State

37000

ODBC 3 State

42000

Parameter 1

Column number of the recursive subquery.

Parameter 2

Type converted from.

Parameter 3

Type converted to.

Severity

16

SQLCODE

-945

SQLSTATE

42WA2

Sybase error code

13543

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.