dynamobi/dynamobi — Issue #297: [LDB-24] load to table with bitmapped index on varchar column (source bigint) fails
Author: dynamobi-build
Created: 2011-12-30 02:27:42+00:00
State: open
Labels: LBM, LDB

[reporter="boris", created="Mon, 6 Feb 2006 23:36:37 -0500 (GMT-05:00)"]
SQL Script:

----------------

create foreign data wrapper orcl_jdbc

library '/home/boris/open/luciddb/plugin/FarragoMedJdbc3p.jar'

language java;

create server orcl_server

foreign data wrapper orcl_jdbc

options(

url 'jdbc:oracle:thin:@akela.lucidera.com:1521:XE',

user_name 'schoi',

password 'schoi',

driver_class 'oracle.jdbc.driver.OracleDriver'

);

create schema orcl_schema;

import foreign schema "SCHOI" from server orcl_server into orcl_schema;

-- local tables

create schema s;

set schema 's';

create table BENCH1MCH (

"kseq" bigint primary key,

"k2" varchar(100),

"k4" bigint,

"k5" bigint,

"k10" bigint,

"k25" bigint,

"k100" bigint,

"k1k" bigint,

"k10k" bigint,

"k40k" bigint,

"k100k" bigint,

"k250k" bigint,

"k500k" varchar(100))

server sys_column_store_data_server;

create index bench1m_k2 on bench1mch("k2");

INSERT INTO s.BENCH1MCH

SELECT "kseq","k2","k4","k5","k10","k25","k100","k1k","k10k","k40k","k100k","k250k","k500k"

FROM orcl_schema."bench1M";

Failure:

----------

0: jdbc:luciddb:> insert into s.bench1mch

. . . . . . . . > SELECT "kseq","k2","k4","k5","k10","k25","k100","k1k","k10k","k40k","k100k","k250k","k500k"

. . . . . . . . > FROM orcl_schema."bench1M";

java: TupleAccessor.cpp:438: void fennel::TupleAccessor::unmarshal(fennel::TupleData&, unsigned int) const: Assertion `value.cbData <= accessor.cbStorage' failed.

*** CAUGHT SIGNAL 6; BACKTRACE:

/home/boris/open/fennel/libfennel/.libs/libfennel_common-0.5.0.so(fennel::AutoBacktrace::signal_handler(int)+0x25) [0x3ae85]

[0xffffe420]

/lib/tls/libc.so.6(abort+0x129) [0x40057cd9]

/lib/tls/libc.so.6(__assert_fail+0x103) [0x20cd3]

/home/boris/open/fennel/libfennel/.libs/libfennel_tuple-0.5.0.so(fennel::TupleAccessor::unmarshal(fennel::TupleData&, unsigned) const+0x295) [0x26099]

/home/boris/open/fennel/libfennel/.libs/libfennel_ftrs-0.5.0.so(fennel::ExecStreamBufAccessor::unmarshalTuple(fennel::TupleData&, unsigned)+0x38) [0x3dff8]

/home/boris/open/fennel/lucidera/libfennel_lu/.libs/libfennel_lu_bitmap-0.5.0.so(fennel::LbmSplicerExecStream::execute(fennel::ExecStreamQuantum const&)+0x220) [0x38cd0]

/home/boris/open/fennel/libfennel/.libs/libfennel_exec-0.5.0.so(fennel::ExecStreamScheduler::executeStream(fennel::ExecStream&, fennel::ExecStreamQuantum const&)+0x7d) [0xbc407]

/home/boris/open/fennel/libfennel/.libs/libfennel_exec-0.5.0.so(fennel::DfsTreeExecStreamScheduler::readStream(fennel::ExecStream&)+0x48f) [0xba56b]

/home/boris/open/fennel/farrago/.libs/libfarrago-0.5.0.so(Java_net_sf_farrago_fennel_FennelStorage_tupleStreamFetch+0x98) [0x6b441b98]