Add expression index name to exception message if computation failed
--------------------------------------------------------------------

                 Key: CORE-5606
                 URL: http://tracker.firebirdsql.org/browse/CORE-5606
             Project: Firebird Core
          Issue Type: Improvement
            Reporter: Karol Bieniaszewski
            Priority: Minor


Will be good to see in which expression index exception was raised and at last 
that exception was raised by calculated index at all.

e.g.

CREATE TABLE TEST
(
ID INTEGER,
WARTOSC NUMERIC(16,2)
);
CREATE INDEX IXAE_TEST__CALC ON TEST COMPUTED BY((ID+WARTOSC)/0);

INSERT INTO TEST (ID,WARTOSC) VALUES ('4','6.50');
we got exception:
SQL Message : -802
Arithmetic overflow or division by zero has occurred.

Engine Code    : 335544321
Engine Message :
arithmetic exception, numeric overflow, or string truncation
Integer divide by zero.  The code attempted to divide an integer value by an 
integer divisor of zero.

and we do not know that this error occured inside expression index at all and 
do not know in which one.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to