Overview

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

Version

All the versions of Altibase

Cause

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.