mssql default attribute values not supported by attribute table

[qgib]

Author Name: Jaemes Driver (Jaemes Driver)
Original Redmine Issue: 8800
Affected QGIS version: 2.0.1
Redmine category:data_provider/mssql

---

It seems that default attribute values (SQL Server table default values) are missing in the QGIS 2.0 attribute table? (they existed in the attribute table as at 1.8)

The default values appear (as expected) in the 'Edit feature form' for a newly created features but not in the 'attribute table view.

For example: when a feature is copied from a shapefile then pasted into the SQL Server table the default values are not utilised.

QGIS version 2.0.1-Dufour
QGIS code revision 34139bc
SQL Server 2008 R2

Here's the odbc error received (the same operation works in QGIS 1.8 -

Provider errors:
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'EDIT_USER', table 'CIMS.cimsadmin.LF_DesignPackage'; column does not allow nulls. INSERT fails. [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. QODBC3: Unable to execute statement

[qgib]

Author Name: Paolo Cavallini (@pcav)

---

• fixed_version_id was changed from Version 2.0.0 to Future Release - High Priority

[qgib]

Author Name: Nathan Woodrow (@NathanW2)

---

• assigned_to_id was configured as Nathan Woodrow
• category_id was changed from Digitising to Data Provider/MSSQL

[qgib]

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

---

• subject was changed from QGIS 2.0 / SQL Server - Default attribute values not supported by attribute table? to Default attribute values not supported by attribute table?

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

• subject was changed from Default attribute values not supported by attribute table? to mssql default attribute values not supported by attribute table

[qgib]

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

---

• assigned_to_id removed Nathan Woodrow

[qgib]

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

---

Fixed in changeset "174d112da889e2301306bc298bfe9c4c1fc6c9a5".

---

• status_id was changed from Open to Closed