List:MySQL ODBC« Previous MessageNext Message »
From:Paul DuBois Date:June 17 2001 1:19am
Subject:RE: MySQL + Win2000 = AUTO_INCREMENT field bug?
View as plain text  
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
Thread
Cold Fusion + Solaris + mySQL + MyODBC = problemsAndy Ingham13 Jun
  • Re: Cold Fusion + Solaris + mySQL + MyODBC = problemsHans Christiansen13 Jun
    • Re: Cold Fusion + Solaris + mySQL + MyODBC = problemsAndy Ingham13 Jun
    • RE: Cold Fusion + Solaris + mySQL + MyODBC = problemsfcanavati15 Jun
      • RE: Cold Fusion + Solaris + mySQL + MyODBC = problemsFederico Balbi15 Jun
        • Re: Cold Fusion + Solaris + mySQL + MyODBC = problemsAndy Ingham15 Jun
          • MySQL + Win2000 = AUTO_INCREMENT field bug?Andres Becerra16 Jun
            • Re: MySQL + Win2000 = AUTO_INCREMENT field bug?Paul DuBois17 Jun
              • RE: MySQL + Win2000 = AUTO_INCREMENT field bug?Andres Becerra17 Jun
                • RE: MySQL + Win2000 = AUTO_INCREMENT field bug?Paul DuBois17 Jun