dynamobi/dynamobi — Issue #276: [LDB-45] java.lang.OutOfMemoryError: Java Heap Space error when selecting all rows in 100K table
Author: dynamobi-build
Created: 2011-12-30 02:26:17+00:00
State: open
Labels: LDB

[reporter="elin", created="Wed, 8 Mar 2006 18:04:44 -0500 (GMT-05:00)"]

To reproduce:

create foreign data wrapper csv_jdbc

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

language java;

create server csv_server

foreign data wrapper csv_jdbc

options(

url 'jdbc:relique:csv:/home/elin/open/luciddb/test/sql/VI/tbs/csv-copy',

schema_name 'TESTDATA',

driver_class 'org.relique.jdbc.csv.CsvDriver'

);

create schema csv_schema;

create schema s;

set schema 's';

CREATE TABLE BENCH100K (

KSEQ INTEGER

,K2 INTEGER

,K4 INTEGER

,K5 INTEGER

,K10 INTEGER

,K25 INTEGER

,K100 INTEGER

,K1K INTEGER

,K10K INTEGER

,K40K INTEGER

,K100K INTEGER

,K250K INTEGER

,K500K INTEGER )

;

set schema 'csv_schema';

CREATE foreign table csv_schema.BENCH_SOURCE_100K (

C1 INTEGER,

C2 INTEGER,

C4 INTEGER,

C5 INTEGER,

C10 INTEGER,

C25 INTEGER,

C100 INTEGER,

C1K INTEGER,

C10K INTEGER,

C40K INTEGER,

C100K INTEGER,

C250K INTEGER,

C500K INTEGER)

server csv_server

options (

table_name 'bench100K'

);

set schema 's';

INSERT INTO BENCH100K (KSEQ,K2,K4,K5,K10,K25,K100,K1K,K10K,K40K,K100K,K250K,

K500K) SELECT C1,C2,C4,C5,C10,C25,C100,C1K,C10K,C40K,C100K,C250K,C500K

FROM csv_schema.BENCH_SOURCE_100K

;

select KSEQ,K2,K4,K5,K10,K25,K100,K1K,K10K,K40K,K100K,K250K,K500K

FROM BENCH100K

order by 1;