On Tuesday 22 September 2015 09:39:17 Jose Paul wrote:
> Dear All,
>
> I am trying to run DJango 1.8 test cases with DB2
>
>
> Several insert statement fails
>
> Here is the insert command generated by test case.
>
> INSERT INTO "AUTH_USER" ("PASSWORD", "LAST_LOGIN", "IS_SUPERUSER",
> "USERNAME", "FIRST_NAME", "LAST_NAME", "EMAIL", "IS_STAFF", "IS_ACTIVE",
> "DATE_JOINED") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)
>
> Value : (None, None, True, u'superuser', None, None, None, False, True,
> u'2015-09-17 12:31:09.562000')
>
> ibm_db_dbi::IntegrityError: Statement Execute Failed: [IBM][CLI
> Driver][DB2/NT] SQL0407N Assignment of a NULL value to a NOT NULL column
> "TBSPACEID=2, TABLEID=24, COLNO=1" is not allowed. SQLSTATE=23502\r
> SQLCODE=-407
>
>
> Except last_login none of the field are nullable .
> But still DJango testcase generate insert statement as above and pass None
> as value which fails .
>
> Why this happens ?.
Does the DB2 backend has the feature interprets_empty_strings_as_null set to
True?
If it does, it should also make sure to generate the CharField's datbase
columns as nullable, whether or not the fields are defined null=True.
HTH,
Shai.
