You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Kathey Marsden <km...@sbcglobal.net> on 2007/08/11 01:35:24 UTC
Should getTableTypes() return GLOBAL TEMPORARY as a tab;e type?
In looking at DERBY-3000 it occurred to me that perhaps we should return
GLOBAL TEMPORARY in getTableTypes() or is there a reason that we do not?
Thanks
Kathey
Re: Should getTableTypes() return GLOBAL TEMPORARY as a tab;e type?
Posted by Ravinder Reddy Pandiri <pa...@students.iiit.ac.in>.
On Mon, 13 Aug 2007, Daniel John Debrunner wrote:
> Daniel John Debrunner wrote:
>> Kathey Marsden wrote:
>>> In looking at DERBY-3000 it occurred to me that perhaps we should return
>>> GLOBAL TEMPORARY in getTableTypes() or is there a reason that we do not?
>>
>> Why would we?
>>
>> getTableTypes(): Retrieves the table types available in this database.
>
> Sorry, always get confused that 'global' tempoary tables are not what I would
> call global (to me global would mean available outside of the connection).
>
> However, Derby's GLOBAL TEMPORARY tables do not appear in JDBC meta data so
> probably getTableTypes() should not return them.
>
> Dan.
>
Yes , with referring to DERBY-2750 I agree with John.
>
>
--
******************************************************************************
Every problem that has been solved can be solved again in a better way
- Ravinder Reddy
*******************************************************************************
Re: Should getTableTypes() return GLOBAL TEMPORARY as a tab;e type?
Posted by Daniel John Debrunner <dj...@apache.org>.
Daniel John Debrunner wrote:
> Kathey Marsden wrote:
>> In looking at DERBY-3000 it occurred to me that perhaps we should
>> return GLOBAL TEMPORARY in getTableTypes() or is there a reason that
>> we do not?
>
> Why would we?
>
> getTableTypes(): Retrieves the table types available in this database.
Sorry, always get confused that 'global' tempoary tables are not what I
would call global (to me global would mean available outside of the
connection).
However, Derby's GLOBAL TEMPORARY tables do not appear in JDBC meta data
so probably getTableTypes() should not return them.
Dan.
Re: Should getTableTypes() return GLOBAL TEMPORARY as a tab;e type?
Posted by Daniel John Debrunner <dj...@apache.org>.
Kathey Marsden wrote:
> In looking at DERBY-3000 it occurred to me that perhaps we should return
> GLOBAL TEMPORARY in getTableTypes() or is there a reason that we do not?
Why would we?
getTableTypes(): Retrieves the table types available in this database.
Dan.