#3 Exported SQL is incorrect

closed-fixed
nobody
None
5
2008-02-17
2007-12-06
Justin Forest
No

It looks like NULL values in the exported SQL dump are replaced with ''. This is wrong, because if you have a varchar field with an unique index, multiple NULL values in that field are ok, while '' is only allowed once.

Moreover, '' is issued even for integer fields. This effectively makes the export function unusable.

Discussion

  • Oleg Savchuk
    Oleg Savchuk
    2008-02-17

    • status: open --> closed-fixed
     
  • Oleg Savchuk
    Oleg Savchuk
    2008-02-17

    Logged In: YES
    user_id=1631629
    Originator: NO

    FIXED.

    now NULL values exported correctly.