At 8:18 PM -0400 6/16/01, Andres Becerra wrote:
>Ahhh I didn't realize that. Actually, the real MySQL database is running on
>Solaris and it allows the create table statement with an auto_increment
>decimal column. I guess there are some hidden differences between Solaris
>and Win32 implementations of MySQL.
The parser allows AUTO_INCREMENT to be applied to any column type,
even though it only makes sense for integer columns. The parser probably
shouldn't allow that, but it does.
>
>Thanks Paul.
>
>-----Original Message-----
>From: Paul DuBois [mailto:paul@stripped]
>Sent: Saturday, June 16, 2001 7:54 PM
>To: Andres@stripped; myodbc@stripped
>Subject: Re: MySQL + Win2000 = AUTO_INCREMENT field bug?
>
>
>At 4:08 PM -0400 6/16/01, Andres Becerra wrote:
>>I can't seem to create a table with an AUTO_INCREMENT column on the Win2000
>>version of MySQL
>>
>>create table tbOrder (
>> OrderID decimal(9,0) PRIMARY KEY
>>auto_increment default 0,
>> ...etc...
>>);
>>
>>Has anybody comes across this before? I can find nothing in the docs on
>>this...
>
>AUTO_INCREMENT is for integer types, not DECIMAL.
>
>>
>>Thanks,
>>Andres
>
>
>--
>Paul DuBois, paul@stripped
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail myodbc-thread3446@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail myodbc-unsubscribe@stripped instead.
>
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail myodbc-thread3447@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail myodbc-unsubscribe@stripped instead.
--
Paul DuBois, paul@stripped
