LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
52 stars 24 forks source link

[FRG-38] assertion doing select with filtering, on a table with a 'real' datatype column #832

Closed dynamobi-build closed 12 years ago

dynamobi-build commented 12 years ago

[reporter="schoi", created="Thu, 9 Feb 2006 17:20:37 -0500 (GMT-05:00)"] repro steps:
-------------------
create schema s;
set schema 's';

create table rtable (r real primary key);

insert into rtable values(1);

select * from rtable;
--
-- +------+
-- | R |
-- +------+
-- | 1.0 |
-- +------+
--

select * from rtable where r > 1.0;

failure:
-----------
java: ../../fennel/btree/BTreeReaderImpl.h:160: bool fennel::BTreeReader::searchForKeyTemplate(const fennel::TupleData&, fennel::DuplicateSeek, bool, PageStack&) [with bool leafLockCoupling = false, PageStack = fennel::BTreeReader::NullPageStack]: Assertion `!found' failed.
*\ CAUGHT SIGNAL 6; BACKTRACE:
/home/schoi/open/fennel/libfennel/.libs/libfennel_common-0.5.0.so(fennel::AutoBacktrace::signal_handler(int)+0x29) [0x3ae41]
[0xffffe420]
[0xffffe410]
/lib/tls/i686/cmov/libc.so.6(gsignal+0x51) [0xb7e5a9b1]
/lib/tls/i686/cmov/libc.so.6(abort+0xe9) [0xb7e5c2c9]
/lib/tls/i686/cmov/libc.so.6(__assert_fail+0x101) [0x21f51]
/home/schoi/open/fennel/libfennel/.libs/libfennel_btree-0.5.0.so(bool fennel::BTreeReader::searchForKeyTemplate<false, fennel::BTreeReader::NullPageStack>(fennel::TupleData const&, fennel::DuplicateSeek, bool, fennel::BTreeReader::NullPageStack&)+0x27d) [0x38a2f]
/home/schoi/open/fennel/libfennel/.libs/libfennel_btree-0.5.0.so(fennel::BTreeReader::searchForKey(fennel::TupleData const&, fennel::DuplicateSeek, bool)+0x4a) [0x3834a]
/home/schoi/open/fennel/libfennel/.libs/libfennel_ftrs-0.5.0.so(fennel::BTreeSearchExecStream::innerSearchLoop()+0x17d) [0x32af7]
/home/schoi/open/fennel/libfennel/.libs/libfennel_ftrs-0.5.0.so(fennel::BTreeSearchExecStream::execute(fennel::ExecStreamQuantum const&)+0x7b) [0x327c7]
/home/schoi/open/fennel/libfennel/.libs/libfennel_exec-0.5.0.so(fennel::ExecStreamScheduler::executeStream(fennel::ExecStream&, fennel::ExecStreamQuantum const&)+0x8c) [0xbc6c0]
/home/schoi/open/fennel/libfennel/.libs/libfennel_exec-0.5.0.so(fennel::DfsTreeExecStreamScheduler::readStream(fennel::ExecStream&)+0x4a5) [0xba833]
/home/schoi/open/fennel/farrago/.libs/libfarrago-0.5.0.so(Java_net_sf_farrago_fennel_FennelStorage_tupleStreamFetch+0xa6) [0xb1136cce]

dynamobi-build commented 12 years ago

[author="jvs", created="Fri, 10 Feb 2006 10:53:44 -0500 (GMT-05:00)"] Fixed by eigenchange 5395. Assert was spurious in this case, so I loosened it to what it should have been.