Mailing List Archive


Back to the month index Back to the list index
Thomas Baetzler (bath0011@fh-karlsruhe.de)
Wed, 8 Jan 1997 02:00:54 +0100 (CET) 

Message-Id: <m0vhmNy-0000zsC@rz03.FH-Karlsruhe.DE>
From: bath0011@fh-karlsruhe.de (Thomas Baetzler)
Subject: Re: [mSQL] ORDER BY + _rowid == bug?
Date: Wed, 8 Jan 1997 02:00:54 +0100 (CET)

David J. Hughes wrote:

:On Sat, 4 Jan 1997, Alex Tang wrote:
:> The _rowid variable is an "internal" variable (as per the documentation),
:> and is retreived off of the table data structure. The problem is that
:> when a temporary table is created, the _rowid returned in the select query
:> is the _rowid of the >temporary table<, not of the original table, so the
:> _rowid may not correspond with the original table.

:That's true. I guess that the rowid should be stored as a "real" column
:in the result table during processing. This would get over the problem
:(although it'd add to the logic a bit).

On the other hand this would give the perfect automagically generated
unique key.

Ciao, 

-- 
Thomas Baetzler, bath0011@fh-karlsruhe.de, thb@spectre.ka.sub.org
<A HREF="http://www.fh-karlsruhe.de/~bath0011/"> thb's homepage </A>
This product has been cruelly tested on cute little furry animals.
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com.  Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!