Issue Bug Closed

#22250Auto-increment does not work with driver odbc_mssql

Xavier Perseguers 03/07/10, 23:43 updated 04/14/10, 01:10

Description

When connecting to a MSSQL database using driver odbc_mssql, records are not given a proper auto-increment value (column ‘uid’). Instead it is set to 0 (this has the side-effect to prevent more than 1 record to be created btw).

The sequence table is properly created though.

How to reproduce

- Drop all user tables
- Use install tool to create all tables
- Create an admin user:
– Record is created in be_users with uid = 0
– Table be_users_uid is created and initialized to 100

Do the same using native mssql driver:

- …
- Create an adnim user:
– Record is created in be_users with uid = 1
– Table be_users_uid is created and initialized to 1
(issue imported from #M13766)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.