db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: Temporary tables don't work?
Date Sat, 02 Jul 2005 00:28:03 GMT
John English wrote:

> My application needs to use a temporary table, but they don't seem to
> work with the embedded version. When I insert or update rows the commands
> appear to work, but when I look at the table there is sometimes some of
> the data there and somerimes (more often) not.
> 
> I tried it with ij as a sanity check...
> 
>   ij version 10.0
>   ij> connect 'foo';
>   ij> declare global temporary table t (n varchar(15), u varchar(15))
> not logged;
>   0 rows inserted/updated/deleted
>   ij> insert into session.t values('a','b');
>   1 row inserted/updated/deleted
>   ij> select * from session.t;
>   N              |U
>   -------------------------------
> 
>   0 rows selected
>   ij>
> 
> Is this a bug, or am I doing something stupid? Can'y find anything
> like this in the buglist...

Mamta replied to your earlier e-mail on the subject, here is her reply.

http://mail-archives.apache.org/mod_mbox/db-derby-user/200506.mbox/%3cd9619e4a05062221576e4e634a@mail.gmail.com%3e

Dan.


Mime
View raw message