Spatialite column with AUTOINCREMENT block with forms

[qgib]

Author Name: Loïc BARTOLETTI (@lbartoletti)
Original Redmine Issue: 19940
Affected QGIS version: 3.3(master)
Redmine category:forms

---

When adding an entity to a spatialite table with a field with AUTOINCREMENT, the input in the form is blocked, because the value must be added manually. The form does not know how to retrieve the last value and expects a non NULL value. There is no such problem by going through the entry in the attribute table

---

• autoincrement.mp4 (Loïc BARTOLETTI)

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

Did it worked as expected on 2.18?

---

• category_id was changed from Editing to Forms
• status_id was changed from Open to Feedback

[qgib]

Author Name: Gerhard Spieles (Gerhard Spieles)

---

This was issue #25484 in master between 2.18.14 an 2.18.16 and seems now a regression.

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• priority_id was changed from Normal to High
• status_id was changed from Feedback to Open

[qgib]

Author Name: Alessandro Pasotti (@elpaso)

---

I cannot reproduce on current master, can you share a project?

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Loïc BARTOLETTI (@lbartoletti)

---

If you create the spatialite from "Create New Spatialite Layer" it works but a spatialite created from DB Manager (was my case) doesn't works.

---

• status_id was changed from Feedback to Open

[qgib]

Author Name: Regis Haubourg (@haubourg)

---

Can you share your database? I created a spatialite from dbmanager using the "export to file" button, and I couldn't reproduct the issue.

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Loïc BARTOLETTI (@lbartoletti)

---

Couldn't reproduct too... Maybe I did a bad action at another time... a bad monkey tester :)

[qgib]

Author Name: Loïc BARTOLETTI (@lbartoletti)

---

• resolution was changed from to invalid
• status_id was changed from Feedback to Closed

[EnFiore]

Hi,
I have noticed the same issue in QGIS 3.10.3.
If Spatialite is created by a geojson or by command 'new spatialite' the issue is the same as described. If spatialite is created starting by shapefile the issue not happens.