Issue Details (XML | Word | Printable)

Key: CORE-4075
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Thomas Beckmann
Votes: 0
Watchers: 1
Operations

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

Server bugchecks or crashes on exception in calculated index

Created: 08/Apr/13 10:07 PM   Updated: 25/Sep/15 01:05 PM
Component/s: Engine
Affects Version/s: 3.0 Initial, 2.5.3
Fix Version/s: 2.5.4, 3.0 Beta 2

Environment: W7/64, WI-T3.0.0.30317 Firebird 3.0 Unstable
Issue Links:
Duplicate
 
Relate
 

QA Status: Done successfully


 Description  « Hide
Consider the following example:

create table TEST (BIT smallint);
create index IDX_TEST_BIT on TEST computed by (bin_shl(1, TEST.BIT-1));

insert into test values (0);

Of course, insertion should lead to an exception. Unfortunately, it crashes the server.


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 09/Apr/13 04:21 AM
I see the following error:

expression evaluation not supported.
expression evaluation not supported.
Argument for BIN_SHL must be zero or positive.
internal Firebird consistency check (error during savepoint backout (290), file: exe.cpp line: 4133).

It could lead to abort in the debug build, but not in the release one.

The problem, however, is that v2.5.3 behaves the same way while v2.5.2 don't throw the bugcheck. Something has changed and this should be investigated.

Thomas Beckmann added a comment - 10/Apr/13 08:25 AM
Hm, we've been trying this with a non debug version and it still crashes the server.

Dmitry Yemanov added a comment - 10/Apr/13 08:41 AM
Perhaps you have BugcheckAbort = 1 in firebird.conf?

Thomas Beckmann added a comment - 10/Apr/13 08:55 AM
No, it was actually left to the default settings. The error persists even if I uncomment the line
BugcheckAbort = 0
in firebird.conf (and restart the server, of course).