Details
-
Bug
-
Resolution: Done
-
P2: Important
-
5.0.0, 5.0.1
-
None
-
Windows 7 x64
-
33c212b7d25726b78c4bf630548a76feaab872f0
Description
Consider the table below:
CREATE TABLE IF NOT EXISTS collection ( id INTEGER PRIMARY KEY AUTOINCREMENT, parent_id INTEGER, order_num INTEGER NOT NULL )
When I insert QSqlRecord built with values fetched from QTextEdit's, i.e. pair of strings (parent_id, order_num), I end up with the following results:
- ("", "0") — QSqlError(-1, "No Fields to update", "")
- ("", "1") — No error. Row is actually inserted
- ("0", "0") — QSqlError(-1, "No Fields to update", "")
- ("1", "0") — QSqlError(19, "Unable to fetch row", "collection.order_num may not be NULL")
See attachment test2.zip for the minimal demo.