Project

General

Profile

Actions
Copy link

Bug #22250

closed

Auto-increment does not work with driver odbc_mssql

Added by Xavier Perseguers over 14 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Xavier Perseguers
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2010-03-07
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

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)

Files

13766.diff (630 Bytes) 13766.diff Administrator Admin, 2010-03-08 19:15
Actions
Copy link

Also available in: Atom PDF