On Apr 21, 2007, at 2:56 PM, xiao feng wrote:
> Hi,
> I wan to create a hidden column with index , and the hidden
> column not visible in table's desc.
> With a hidden row like Oracle's 'rowid', Some Web Application can
> show detail search record using $ROWID.
>
> I also want another hidden column $SQL for passing "Full Text
> Search Synax"(not SQL92 standard), :）
>
> for user's conveince, I want to create hidden columns automately.
Yes, I can see the advantage from the user's point of view for
creating such columns automatically.
However, this feature is not available in MySQL today. So all I can
do is suggest that you prepare a patch which does the job, and submit
it for inclusion.
And I think this would have to be for version 5.2. As far as I know
new features are not being accepted for 5.1 anymore.
> Thanks.
>
> ----- Original Message -----
> From: "Paul McCullagh" <paul.mccullagh@stripped>
> To: "xiao feng" <cnstar9988@stripped>
> Cc: <peter@stripped>; "Sergei Golubchik" <serg@stripped>;
> "MySQL Internal" <internals@stripped>
> Sent: Saturday, April 21, 2007 7:37 PM
> Subject: Re: How to create hidden Field in Storage Engine?
>
>
> Hi Xiao,
>
> Why not just insist that the table be created with a column with a
> specific name, like "row#". The table definition would also have to
> include a unique index definition on this column.
>
> Your engine can then handle this column internally as the rowid
> column. So the engine would generate an error if the column is
> inserted or updated (or just ignore such operations), and handle
> index access on this column as a special case.
>
> With this method the rowID column would not be hidden, but does it
> really have to be?
>
> Best regards,
>
> Paul
>
>
> On Apr 21, 2007, at 11:42 AM, xiao feng wrote:
>
>> Hi,
>> I have a db engine, I have use it as an mysql Storage Engine.
>> I wan to auto create some hidden fields in table, such as
>> Oracle's rownum/rowid, it can be used for query data, but not in
>> tables "desc”。
>> So I think storage should have a vritual function like
>> prepare_create , allow user can add their own hidden fields before
>> create table.
>> Thanks!
>>
>> ----- Original Message -----
>> From: <peter@stripped>
>> To: "xiao feng" <cnstar9988@stripped>
>> Cc: <peter@stripped>; "Sergei Golubchik" <serg@stripped>;
>> "MySQL Internal" <internals@stripped>
>> Sent: Wednesday, April 11, 2007 3:07 PM
>> Subject: Re: How to create hidden Field in Storage Engine?
>>
>>
>>> Hi Xiao,
>>>
>>>> I think storage should have a vritual function like
>>>> prepare_create ,
>>>> allow user can add their own hidden fields before create table.
>>>
>>> if you could explain a bit more in detail what you trying to
>>> implement it
>>> would be better to understand why you need it. Also what type of
>>> storage
>>> engine are you trying to implement?
>>>
>>> Cheers,
>>> Peter
>>>
>>
>> --
>> MySQL Internals Mailing List
>> For list archives: http://lists.mysql.com/internals
>> To unsubscribe: http://lists.mysql.com/internals?
>> unsub=paul.mccullagh@stripped
>>
>
>
> --
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe: http://lists.mysql.com/internals?
> unsub=paul.mccullagh@stripped
>
