Issue Details (XML | Word | Printable)

Key: CORE-1690
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Kamil Pawlowski
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

arithmetic exception, numeric overflow, or string truncation in utf8 tables

Created: 13/Jan/08 03:23 PM   Updated: 20/Apr/11 10:31 AM
Component/s: Charsets/Collation
Affects Version/s: 2.0.0, 2.0.1, 2.1 Alpha 1, 2.1 Beta 1, 2.0.2, 2.0.3, 2.1 Beta 2, 2.1 RC1
Fix Version/s: 2.5 Beta 1, 2.1.3

Time Tracking:
Not Specified

Environment: Fedora amd64
Issue Links:
Duplicate
 
Relate
 


 Description  « Hide
$ /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)


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 20/Apr/11 10:31 AM
QA test added.