[TYPO3-core] FYI #13504: Cannot parse TRUNCATE TABLE in install tool

[Xavier Perseguers]

Hi,

FYI, following patches were committed to Core trunk (rev. 6895) and DBAL trunk (rev. 29911).

Type: Bugfix / Feature

Bugtracker reference:
http://bugs.typo3.org/view.php?id=13504

Branch: trunk

Problem:
When using Typo3 (4.3.1) with a MS-SQL DB the Database Analyser can not update the tables in the "COMPARE" section and results in an error message like this:

ERROR: Query could not be parsed: "SQL engine parse ERROR: "" is not a keyword: near "TRUNCATE TABLE be_groups "". Query: "TRUNCATE TABLE be_groups;"

Additional Information:
This is/should be well known that many if not "all" (99%) suggestions made by the Install Tool when dealing with non-MySQL databases -- once the tables have been created -- are just nothing to worry 
about. Anyway, this was not great that Install Tool suggests to truncate tables while not being able to perform the operation.

Type is bugfix and feature at the same time because it enhances the t3lib_db API with truncate methods. As such and even if it fixes a "bug", I decided only to commit it to trunk as it is only a "nice 
to have".

Cheers

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 13504_core.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100210/65767e6c/attachment.txt>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 13504_dbal.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100210/65767e6c/attachment.asc>