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

[Dmitry Dulepov]

Hi!

Xavier Perseguers wrote:
> 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'

Doesn't that mean that mapping is incorrect? I do not know Oracle at all
but many extension use "text" as field type. Can't (shouldn't?) it be
solved on DBAL level? DBAL purpose is to provide exactly this: change
queries to be compatible with a corresponding database. But with this patch
we create an unclean and undocumented dependency on DBAL.

Xavier, could you explain this, please? Is there a problem for DBAL to map
"text" in some other way so that extensions do not need to use varchar(4000)?

-- 
Dmitry Dulepov
TYPO3 core&security teams member
Twitter: http://twitter.com/dmitryd
Read more @ http://dmitry-dulepov.com/