arithmetic exception, numeric overflow, or string truncation in utf8 tables [CORE1690] #2116
Labels
affect-version: 2.0.0
affect-version: 2.0.1
affect-version: 2.0.2
affect-version: 2.0.3
affect-version: 2.1 Alpha 1
affect-version: 2.1 Beta 1
affect-version: 2.1 Beta 2
affect-version: 2.1 RC1
component: charsets/collation
fix-version: 2.1.3
fix-version: 2.5 Beta 1
priority: major
qa: done successfully
type: bug
Submitted by: Kamil Pawlowski (kamilpe)
Is duplicated by CORE2391
Is related to QA232
$ /opt/firebird/bin/isql /home/kamil/huckster.fdb -u kamil -p . -ch utf8
Database: /home/kamil/huckster.fdb, User: kamil
SQL> create table some_table (id int primary key, title varchar(64) unique not null);
SQL> show table some_table;
ID INTEGER Not Null
TITLE VARCHAR(64) Not Null
Statement failed, SQLCODE = -802
arithmetic exception, numeric overflow, or string truncation
Command error: show table some_table
SQL> exit;
$ /opt/firebird/bin/isql /home/kamil/huckster.fdb -u kamil -p .
Database: /home/kamil/huckster.fdb, User: kamil
SQL> show table some_table;
ID INTEGER Not Null
TITLE VARCHAR(64) Not Null
CONSTRAINT INTEG_14:
Primary key (ID)
CONSTRAINT INTEG_15:
Unique key (TITLE)
Commits: eb3a3ed aeef076
The text was updated successfully, but these errors were encountered: