dynamobi/dynamobi — Issue #143: [LDB-179] index-only scans return different results when character data contains trailing spaces
Author: dynamobi-build
Created: 2011-12-30 02:16:49+00:00
State: open
Labels: LBM, LDB

[reporter="jvs", created="Tue, 12 Aug 2008 14:22:17 -0500 (GMT-05:00)"]
create or replace jar sys_boot.sys_boot.luciddb_index_only_plugin

library 'class com.lucidera.farrago.LucidDbIndexOnlySessionFactory'

options(0);

create schema s;

create table s.t(v varchar(128));

insert into s.t values('popcorn');

insert into s.t select * from s.t;

insert into s.t select * from s.t;

insert into s.t select * from s.t;

insert into s.t select * from s.t;

insert into s.t select * from s.t;

insert into s.t select * from s.t;

insert into s.t select * from s.t;

insert into s.t select * from s.t;

insert into s.t select * from s.t;

insert into s.t values ('dingdongs ');

insert into s.t values ('dingdongs');

insert into s.t values ('dingdongs ');

create index i on s.t(v);

analyze table s.t estimate statistics for all columns;

!set outputformat csv

select * from s.t where v = 'dingdongs';

'V'

'dingdongs '

'dingdongs'

'dingdongs '

alter session implementation set jar

sys_boot.sys_boot.luciddb_index_only_plugin;

call sys_root.flush_code_cache();

select * from s.t where v = 'dingdongs';

'V'

'dingdongs '

'dingdongs '

'dingdongs '