PostGIS: 0 is wrote instead of "null"

[qgib]

Author Name: Seb Radzimski (Seb Radzimski)
Original Redmine Issue: 11777
Affected QGIS version: 2.6.1
Redmine category:attribute_table

---

Hi.
While working with QGIS 2.6 and Postgres/Postgis 9.3/2.1 on Ubuntu (or 9.1/1.5 on Windows) I found a bug.
I have to explain that on a simple table like:

CREATE TABLE test ( gid serial NOT NULL, "int" integer, "real" real, "double" double precision, "text" text, the_geom geometry, CONSTRAINT test_pkey PRIMARY KEY (gid ) )

When I add first object (in QGIS) without any data (every attribute is null, except of gid) and I save it, all of them will be null in database. So far so good!
If I add a second object (without any data) and third one (with int=1, real=2 double=3) and save it, attributes of previus object (second one) will be 0 instead of null. If you would check attributes of second object before saving into database, QGIS show them as null. But while saving QGIS sends 0 instead of null to the database attributes of second object. It happens every time when attribute (integer, real, double) has been changed.
I belive I don't have to explain how big is the difference between 0 and null value ;) Because of that error it is impossible to use constraints in database to keep data in right order.
I have check that sytuation on QGIS 2.0/2.2 and there was no problem. It starts in 2.4...

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

confirmed here as a regression.

---

• version was changed from 2.6.0 to 2.6.1
• os_version was changed from 7,8 / 12.04 to
• operating_system was changed from Windows/Ubuntu to
• priority_id was changed from Normal to Severe/Regression
• subject was changed from 0 instead of null to PostGIS: 0 is wrote instead of "null"

[qgib]

Author Name: Jürgen Fischer (@jef-n)

---

Fixed in changeset "03713ce65668bfb7e7ce4bcde06a26746ab1b352".

---

• status_id was changed from Open to Closed