Hi,
My storage engine is very similar to http://www.sphinxsearch.com/,
seehttp://www.sphinxsearch.com/doc.html#sphinxse
I think it is very needed when writing fulltext engine, because of different "sql
synax".
Adding a prepare_create virtual function is very easy, but some other thing will be
very difficult.
Such as how to make the hidden column visible in 'DESC', and work well in SELECT.
So I am waiting for 5.2, :)
Thanks.
----- Original Message -----
From: "Paul McCullagh" <paul.mccullagh@stripped>
To: "xiao feng" <cnstar9988@stripped>
Cc: "MySQL Internal" <internals@stripped>
Sent: Saturday, April 21, 2007 9:52 PM
Subject: Re: How to create hidden Field in Storage Engine?
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
>
