[TYPO3-mvc] Re: How does query->contains work

[Philipp]

Its so much easier. Just enable the sql debug in the install tool.

anyway-

Found the problem, i think its a bug.

When writing the subquery 
#####
SELECT tx_regionalobject_domain_model_regionalobject.*
FROM tx_regionalobject_domain_model_regionalobject
WHERE (
	(
		tx_regionalobject_domain_model_regionalobject.sub_type IN ('14','18')
		AND tx_regionalobject_domain_model_regionalobject.uid IN (SELECT uid_foreign FROM sys_category_record_mm WHERE uid_local='74')
	)
	AND tx_regionalobject_domain_model_regionalobject.uid IN (
		SELECT uid_foreign FROM sys_category_record_mm WHERE uid_local='11')
	)
	AND (
		   tx_regionalobject_domain_model_regionalobject.type='default'
		OR tx_regionalobject_domain_model_regionalobject.type='poi'
		OR tx_regionalobject_domain_model_regionalobject.type='package'
		OR tx_regionalobject_domain_model_regionalobject.type='event'
		OR tx_regionalobject_domain_model_regionalobject.type='area'
	)
	AND tx_regionalobject_domain_model_regionalobject.deleted=0
	AND tx_regionalobject_domain_model_regionalobject.t3ver_state<=0
	AND tx_regionalobject_domain_model_regionalobject.pid<>-1
	AND tx_regionalobject_domain_model_regionalobject.hidden=0
	AND tx_regionalobject_domain_model_regionalobject.starttime<=1365258360
	AND (
		   tx_regionalobject_domain_model_regionalobject.endtime=0
		OR tx_regionalobject_domain_model_regionalobject.endtime>1365258360
	)
	AND (
		tx_regionalobject_domain_model_regionalobject.sys_language_uid IN (0,-1)
	)
	ORDER BY tx_regionalobject_domain_model_regionalobject.promote DESC LIMIT 10;
####

the field tablenames is not respected, its just missing in the subquery.

So either the makeCategorizeable method adds an incomplete TCA Config or the subquery itself for contains is bugged.

I will try to fix it using the options param and adding some TCA config.