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üssen,
>> Sergei
>>
>> --
>> __ ___ ___ ____ __
>> / |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
>> / /|_/ / // /\ \/ /_/ / /__ Senior Software Developer
>> /_/ /_/\_, /___/\___\_\___/ MySQL GmbH, Radlkoferstr. 2, D-81373
>> München
>> <___/ Geschäftsführer: Hans von Bell, Kaj Arn?- HRB
> München
>> 162140
>
> --
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe:
> http://lists.mysql.com/internals?unsub=1
>
>
