|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
Fedora amd64
|
|
Issue Links:
|
Duplicate
|
|
|
|
This issue is duplicated by:
|
|
CORE-2391
isql: show table T; => Statement failed, SQLCODE = -802
|
|
|
|
|
Relate
|
|
|
|
This issue is related to:
|
|
|
|
|
|
|
|
|
|
$ /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)
|
|
Description
|
$ /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)
|
Show » |
|
Bug
arithmetic exception, numeric overflow, or string truncation in utf8 tables