This documentation is not using the current rendering mechanism and will be deleted by December 31st, 2020. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.
text columns as part of a
WHERE clause using equality
while Oracle for instance does not. This means that if you need to do
something like that:
SELECT * FROM tx_ext WHERE column = 'something'
Make sure not to use
text as column type but instead use
varchar(4000) which is the limit for Oracle. The other solution is
to use a
SELECT * FROM tx_ext WHERE column LIKE 'something'
The SQL parser is not as powerful as it could be. Typical problems occur with calculated conditions such as
... WHERE column1 + number1 >= number2
Rules of thumb¶
- The calculated part (
column1 + number1) must start with a column name
- The calculated part may have a column name or a number as second operand
- The part after the operator (
number2) must be a number
- The calculated part can only occur on the left hand of the comparison operator
- More than two operands on the left hand are not supported