Skip to end of metadata
Go to start of metadata



This document describes the causes and examples of invalid literal error.



All the versions of Altibase



It occurs when the data types between comparison targets do not match when using conversion functions such as TO_NUMBER and CAST or comparison operators.

It can also occur when you have a value that cannot be converted to the data type you want to convert during automatic casting.

Case 1. When using UNION and UNION ALL, the data type of the column to be mapped is different.

Case 2. When the value given to the TO_NUMBER function is a character type that cannot be converted to a numeric type.

Case 3. When there is a data value that cannot be converted automatically in a column used in a comparison operation.

  • No labels