Mailing List Archive


Back to the month index Back to the list index
Gary Bickford (garyb@outlawnet.com)
Tue, 7 Jan 1997 18:45:52 -0800 

Message-Id: <v01540b00aef8b844e819@[208.192.38.89]>
Date: Tue, 7 Jan 1997 18:45:52 -0800
From: garyb@outlawnet.com (Gary Bickford)
Subject: Re: [mSQL] ORDER BY + _rowid == bug?

How about keeping the original value for _rowid, and have another internal
column, instead, _tmprowid or something, or conversely, use _oldrowid for
the original table? This, of course, begs the question, which rowid do you
use for table joins output? Maintain _table1_rowid, _table2_rowid columns?
This could get messy.

>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

end
=======
Gary Bickford, FXT Corporation http://www.fxt.com
System integration, active web site design, intranets.
garyb@fxt.com 541-923-3060

--------------------------------------------------------------------------
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!