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

[Ries van Twisk]

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 since postgres does have a internal 
sequence number that is use for there 'auto increment system'  see : 
http://www.postgresql.org/files/documentation/books/aw_pgsql/node73.html
So it cannot currupt the internal counter...

but in any case, it's just bad practice....

Ries


>
> Masi
> _______________________________________________
> Typo3-dev mailing list
> Typo3-dev at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev



-- 
R. van Twisk
http://www.metamorf.net

Our Typo3 enabled website: http://www.livetravelguides.com
Instand help for Typo3?    irc:/irc.freenode.net/typo3
Looking for documentation? http://typo3.org/documentation/