#9862: Non-standard SQL generated in column definition for nullable columns in
create table DDL
-----------------------------+----------------------------------------------
Reporter: Ambrish | Owner: nobody
Status: new | Milestone:
Component: Uncategorized | Version: 1.0
Keywords: | Stage: Unreviewed
Has_patch: 0 | Needs_docs: 0
Needs_tests: 0 | Needs_better_patch: 0
-----------------------------+----------------------------------------------
Hi,
While doing backend testing for new DB2 adapter (I am developing it), I
found that in CREATE TABLE DDL generation, it contains some non-standard
SQL syntax.
Here is one example of model.
{{{
class User(models.Model):
first_name = models.CharField(max_length=20, null=False)
last_name = models.CharField(max_length=20, null=True)
class Meta:
db_table = "temp_user"
}}}
For the column '''last_name''', the SQL that gets generated is
'''LAST_NAME VARCHAR(20) NULL'''. The trailing '''NULL''' is not a
standard SQL. This can be validated by the SQL validator tool -
http://developer.mimer.com/validator/parser200x/index.tml Needless to say,
this will fail in DB2 and so too in Oracle.
I find only one method in the docs which deals with the table DDL
generation '''BaseDatabaseCreation.sql_create_model'''.
Regards,[[BR]]
Ambrish Bhargava
--
Ticket URL: <http://code.djangoproject.com/ticket/9862>
Django <http://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
