[#FRG-337] select from global temporary table causes null pointer exception

Farrago

select from global temporary table causes null pointer exception

Created: 21/Aug/08 03:22 AM Updated: 19/Feb/10 12:15 PM

Component/s:

None

Affects Version/s:

0.7.3

Fix Version/s:

None

Environment:

Windows XP SP3

Description

« Hide

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)

All

Comments

Change History

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Nigel Thomas - 21/Aug/08 03:24 AM

Should have clarified - select works from same session as create; select fails from a new session. The farragoServer was running throughout.

Can't reproduce on 0.7.4 windows as the server refuses to start (time for a separate bug report).

[ Permlink | « Hide ]

Nigel Thomas - 21/Aug/08 06:30 AM

Repeating test on 0.7.4 on Ubuntu, can't repeat this problem:

0: jdbc:sqlstream:> create global temporary table gtt(id integer primary key
. . . . . . . . . > , textvalue varchar(20)) on commit preserve rows;
No rows affected (0.821 seconds)
0: jdbc:sqlstream:> insert into gtt values(1,'test string');
1 row affected (1.378 seconds)
0: jdbc:sqlstream:> select * from gtt;
+-----+--------------+
| ID | TEXTVALUE |
+-----+--------------+
| 1 | test string |
+-----+--------------+
1 row selected (1.039 seconds)
0: jdbc:sqlstream:> !quit
Closing: com.sqlstream.aspen.jdbc.AspenRJConnection
demo@bento:~/eigenbase/eigenbase-0.7.4/bin$ sqllineClient
Connecting to jdbc:sqlstream:;sessionName='sqllineClient@/dev/pts/2:demo@bento'
Connected to: SQLstream (version 1.1.2)
Driver: SQLstreamJdbcDriver (version 1.1-distrib)
Autocommit status: true
Transaction isolation: TRANSACTION_REPEATABLE_READ
sqlline version 1.0.4-jh by Marc Prud'hommeaux
0: jdbc:sqlstream:> set schema 'test';
No rows affected (0.187 seconds)
0: jdbc:sqlstream:> select * from gtt;
+-----+------------+
| ID | TEXTVALUE |
+-----+------------+
+-----+------------+
No rows selected (1.345 seconds)

[ Permlink | « Hide ]

John V. Sichi - 21/Aug/08 04:43 PM

I can reproduce this with my latest development build, so the problem is still there. See also FRG-298. Suffice it to say that Farrago support for global temporary tables is currently quarter-baked. I'll update the status page accordingly.