Hi,
We agree that statements of the form
CREATE TABLE table-name (column1 INT PRIMARY KEY)
should be legal -- it should not be necessary to say
CREATE TABLE table-name (column1 INT PRIMARY KEY NOT NULL)
The requirement, that primary keys should explicitly be
declared as NOT NULL, was once necessary: that is the
SQL-92 entry-level requirement. In SQL-92
intermediate, and in SQL-99, the NOT NULL is implied.
MySQL is now moving to SQL-99 compliance, therefore
(1) it's true, NOT NULL should be assumed
(2) the behaviour has been changed, starting with version
4.0.13.
So, in the current MySQL release,
CREATE TABLE t (s1 INT PRIMARY KEY)
does not return an error message.
Regards,
Peter Gulutzan
2003-06-04
--
For technical support contracts, visit https://order.mysql.com/?ref=mpgu
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Peter Gulutzan <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Software Architect
/_/ /_/\_, /___/\___\_\___/ Edmonton, Canada
<___/ www.mysql.com Office: +1 780 472-6838
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
