[Typo3-dev] Versioning in old MySQL versions (+ DBAL)

[Martin T. Kutschker]

Ries van Twisk wrote:
> Martin T. Kutschker wrote:
> 
>> Mathias Schreiber [wmdb] wrote:
>>
>>>> It doesn't work on 3.23, which is still found on many servers.
>>>
>>> Does this mean making UIDs negative does not work or that our 
>>> extension does not work.
>>
>> From what I understood assigning a negative number to the primary key 
>> of any table with auto_inc corrupts the key incrementor. Looks like 
>> the signed -1, is taken as an unsigned int, which makes a pretty high 
>> number for the next key.
> 
> This is not true on PostgreSQL

My answer was *only* refering to Mysql ( < 4.0.18 ). And so I believe 
was the question.

As for the impact on other DBs. It may work on PostgreSQL, but does it 
work on other DBs? The point was that we don't know and so some here 
(I'm among them) feel that the negative uid trick should be removed to 
avoid possible problems.

Masi