Data type inconsistency

This topic describes errors related to data type inconsistency and the troubleshooting procedure.

Error: ORA-00932

Error code

• Error code in OceanBase Database: 5083

• SQLSTATE: 22000

Error message

ORA-00932: inconsistent datatypes: left_type=%s right_type=%s

Examples

When you insert data into the ty2 table, this error is returned.

obclient> INSERT INTO ty2 VALUES(1970);
ORA-00932: inconsistent datatypes

Troubleshooting procedure

1. View the schema of the ty2 table.

   obclient> DESC ty2;
   +-------+------+------+-----+---------+-------+
   | FIELD | TYPE | NULL | KEY | DEFAULT | EXTRA |
   +-------+------+------+-----+---------+-------+
   | C1    | DATE | YES  | NULL | NULL    | NULL  |
   +-------+------+------+-----+---------+-------+
   1 row in set
   

2. Insert a valid value based on the field type.

   obclient> INSERT INTO ty2 VALUES(date'1970-01-01');
   Query OK, 1 row affected
   

3. View the inserted data.

   obclient> SELECT * FROM ty2;
   +-----------+
   | C1        |
   +-----------+
   | 01-JAN-70 |
   +-----------+
   1 row in set