[Typo3-dev] Versioning Fix
ben van 't ende [netcreators]
ben at netcreators.nl
Wed Jan 12 14:28:30 CET 2005
Kasper Skårhøj wrote:
> Hi Mattes,
>
>
>> I mean - please don't feel offended, but using SQL that works fine
>> on some versions of one (!) DB somewhat messes up my understanding
>> of high quality code.
>>
>
>
> When a field is a SIGNED integer, why can I not make its value
> negative? All IDs are at all times unique and it is therefore clearly
> a bug that the auto_increment feature in MySQL messes up the
> next-index value. This is THE BUG they fixed in later versions.
>
> So your argument is that high quality code should work on buggy
> implementations? At best you can claim that a requirement of MySQL
> 4.0.18+ is maybe a bit strict, nevertheless only required for
> versioning.
>
> Why it doesn't work on Oracle etc. I don't know.
Hi,
With my little knowledge of databases logic dictates that negative
values in auto_increment can not be allowed. Mattes's solution seems
cross-database so to speak.
gRTz
ben
--
netcreators :: creation and innovation
www.netcreators.nl - www.typo3.nl
More information about the TYPO3-dev
mailing list