Bug #17232
closed
Fieldmapping doenst work on the "right side" in where clause.
0%
Description
SELECT a,b FROM myTbl WHERE a=b
results in:
SELECT a1,b1 FROM myTbl WHERE a1=b
having the following:
$TYPO3_CONF_VARS['EXTCONF']['dbal']['mapping'] = array (
'tmyTbl' => array (
'mapFieldNames' => array (
'a' => 'a1',
'b' => 'b1',
)
)
)
(issue imported from #M5481)
Updated by Sebastian Fischer over 17 years ago
Hello Nikolas,
that generalises the problem a little bit more. My report 0005465 indicates the same problem. But i didnt checked all possibilities, so my version wasnt so clear like yours.
Thanks for bringing this in.
Updated by Karsten Dambekalns over 17 years ago
I added a fix for this to the SVN version, please give it a try. It will also map the right side of a comparison, if
- the value is a string
- and not quoted
- and present in the mapping configuration.
The field on the right side of the comparison will not be quoted, unless it is written in the form of table.field, that is an different problem.
@Ingo: Yes, a typo. I meant 4638.