[TYPO3-dam-devel] RFC #12525: Adding metadata or category to a file duplicates the file in table tx_dam [DBAL]

[Xavier Perseguers]

Hi,

This is an SVN patch request.

Type: Bugfix when using DBAL

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

Problem:
After indexing a file, trying to add metadata or a category duplicates 
the file before adding information to a copy of the original record in 
table tx_dam.

DBAL Debug shows errors for typo3conf/ext/dam/mod_file/index.php:

ORA-00932: inconsistent datatypes: expected - got CLOB

Problem is related to file_path of table tx_dam that is defined as 
"text". This leads to queries such as

WHERE ... AND file_path = '/path/to/file'

which is invalid as the text column has been mapped as a CLOB in Oracle. 
Using varchar(4000) which is the limit of number of characters for a 
variable-length string column in Oracle solves the problem as the column 
is then mapped to VARCHAR2(4000)

Regards

Xavier Perseguers
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 12525.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-dam/attachments/20100709/fbe5e616/attachment.asc>