dynamobi/dynamobi — Issue #535: [FRG-337] select from global temporary table causes null pointer exception
Author: dynamobi-build
Created: 2011-12-30 03:34:02+00:00
State: open
Labels: FRG

[reporter="nigel.thomas", created="Thu, 21 Aug 2008 03:22:00 -0500 (GMT-05:00)"]
0: jdbc:farrago:rmi://localhost> set schema 'test';

No rows affected (0.032 seconds)

0: jdbc:farrago:rmi://localhost> create global temporary table gtt (id integer primary key, textvalue varchar(20)) on commit preserve rows;

No rows affected (0.234 seconds)

0: jdbc:farrago:rmi://localhost>insert into gtt values(2,'a test 2');

1 row affected (0.391 seconds)

0: jdbc:farrago:rmi://localhost> insert into gtt values(1,'a test 1');

1 row affected (0.25 seconds)

0: jdbc:farrago:rmi://localhost> select * from gtt;

+-----+------------+

| ID | TEXTVALUE |

+-----+------------+

| 1 | a test 1 |

| 2 | a test 2 |

+-----+------------+

2 rows selected (0.281 seconds)

0: jdbc:farrago:rmi://localhost> !quit

Closing: de.simplicit.vjdbc.VirtualConnection

C:\eigenbase\eigenbase-0.7.3\bin>sqllineClient

Connecting to jdbc:farrago:rmi://localhost

Connected to: Eigenbase Data Management System (version 0.7.3)

Driver: FarragoJdbcDriver (version 0.7)

Autocommit status: true

Transaction isolation: TRANSACTION_REPEATABLE_READ

sqlline version 1.0.4-jh by Marc Prud'hommeaux

0: jdbc:farrago:rmi://localhost> set schema 'test';

No rows affected (0.032 seconds)

0: jdbc:farrago:rmi://localhost> select * from gtt;

Error: java.lang.NullPointerException: null (state=,code=0)

0: jdbc:farrago:rmi://localhost>

(following notes from http://farrago.sourceforge.net/status.html)