We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
CREATE DOMAIN DOMAIN_REGION VARCHAR(5); CREATE TABLE REGION (NAME DOMAIN_REGION ); CREATE INDEX IXAE_REGION__NAME ON REGION COMPUTED BY(UPPER(NAME)); commit; INSERT INTO REGION(NAME) VALUES('12345'); INSERT INTO REGION(NAME) VALUES('abcde'); commit; ALTER DOMAIN DOMAIN_REGION TYPE VARCHAR(20); commit;
now try to update table to use extended length of the domain.
UPDATE REGION SET NAME = NAME || '67890';
Message: isc_dsql_execute2 failed Engine Code : 335545153 Engine Message : unknown ISC error 335545153 arithmetic exception, numeric overflow, or string truncation string right truncation expected length 5, actual 10
If you drop index IXAE_REGION__NAME, then above update is working.
IXAE_REGION__NAME
3 things to improve this:
Now it is nightmare to find exect reason what happened, where this truncation occur, especially if db structure is not trivial as above sample ;-)
The text was updated successfully, but these errors were encountered:
No branches or pull requests
now try to update table to use extended length of the domain.
If you drop index
IXAE_REGION__NAME
, then above update is working.3 things to improve this:
or
or
IXAE_REGION__NAME
.Now it is nightmare to find exect reason what happened, where this truncation occur, especially if db structure is not trivial as above sample ;-)
The text was updated successfully, but these errors were encountered: