dynamobi/dynamobi — Issue #316: [LDB-4] cached plan for insert statement crashes after truncate
Author: dynamobi-build
Created: 2011-12-30 02:29:11+00:00
State: open
Labels: LCS, LDB

[reporter="jvs", created="Mon, 26 Dec 2005 22:44:36 -0500 (GMT-05:00)"]
Steps to reproduce:

create schema s;

set schema 's';

create table t(i int);

insert into t values (20);

truncate table t;

insert into t values (20);

select * from t;

This should cause an assertion failure:

java: LcsClusterReader.cpp:138: bool fennel::LcsClusterReader::searchForRid(fennel::OpaqueInteger): Assertion `key <= rid' failed.

I'm pretty sure this is due to some state not being reset during graph close/reopen because if I prevent plan caching, there's no failure. Plan caching can be prevented either by using a different constant instead of 20 in one of the inserts, or via:

alter system set "codeCacheMaxBytes" = 0;