Hi,
I think storage should have a vritual function like prepare_create , allow user can add
their own hidden fields before create table.
----- Original Message -----
From: <peter@stripped>
To: "xiao feng" <cnstar9988@stripped>
Cc: "Sergei Golubchik" <serg@stripped>; "MySQL Internal"
<internals@stripped>
Sent: Monday, April 09, 2007 9:57 PM
Subject: Re: How to create hidden Field in Storage Engine?
> Hi,
>
> I have had this problem before too.
>
> as far as I know it is not possible to add a default field for a storage
> engine that is also visible to the upper parts of MySQL. The meta data to
> a table is computed before the storage engine is opened. The parser only
> looks at the meta data. The storage engine can not change the meta data.
>
> The only way to force that a field is mandatory in a table is when you (as
> the storage engine) receive a create table command check if the field is
> available. If not then it will through an error. If it does exist then you
> can continue with the table creation process.
>
> Cheers,
> Peter
>
>> hi,
>> I have asked this question some moths.
>>
>> How to create hidden fields in Storage Engine?
>> when use create a table, I can add a hidden field to it, it can't show
>> when client show tables, but it can be used for select or insert or
>> delete?
>> table1:
>> field1, field2.
>> SQL:
>> select * from table1 where hidden_field = "hidden_data".
>> I want to use a hidden_field as "myrowid", or some thing else.
>>
>> Thanks!
>>
>>
>>
>> ----- Original Message -----
>> From: "Sergei Golubchik" <serg@stripped>
>> To: "xiao feng" <cnstar9988@stripped>
>> Cc: "MySQL Internal" <internals@stripped>
>> Sent: Monday, April 09, 2007 7:06 PM
>> Subject: Re: How to Create Session Variable in my storage engine?
>>
>>
>>> Hi!
>>>
>>> On Apr 09, xiao feng wrote:
>>>> hi,
>>>> How to Create Session Variable in my storage engine?
>>>> Thanks!
>>>
>>> Wait for WL#2936 (http://forge.mysql.com/worklog/task.php?id=2936) to be
>>> pushed.
>>>
>>> Regards / Mit vielen Gr>>> Sergei
>>>
>>> --
>>> __ ___ ___ ____ __
>>> / |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
>>> / /|_/ / // /\ \/ /_/ / /__ Senior Software Developer
>>> /_/ /_/\_, /___/\___\_\___/ MySQL GmbH, Radlkoferstr. 2, D-81373
>>> M>>> <___/ Gesch>>> 162140
>>
>> --
>> MySQL Internals Mailing List
>> For list archives: http://lists.mysql.com/internals
>> To unsubscribe:
>> http://lists.mysql.com/internals?unsub=1
>>
>>
>
>
