Inserting NULL value in Oracle spatial backend causes crash.
|Reported by:||Jani Tiainen||Owned by:||nobody|
|Component:||Database layer (models, ORM)||Version:||1.4|
|Severity:||Normal||Keywords:||gis oracle orm|
|Has patch:||no||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
Seem to be regression of #10888.
Main issue is that when inserting or updating spatial field value cx_Oracle interpreted NULL value for SDO_GEOMETRY field when placeholder (%s) as a CHAR. (since it's Oracle user type actually). Both insert and update failed.
As a solution it was implemented so that when ever encountering None value for geometry field placeholder and actual value was removed from the whole insert clause.