MMBase

Query does not support SQL functions

Details

  • Type: Improvement Improvement
  • Status: Open Open
  • Priority: Minor Minor
  • Resolution: Unresolved
  • Affects Version/s: 1.7.0
  • Fix Version/s: 2.0.0
  • Component/s: Database Layer
  • Description:
    Hide
    original bugid: #5949
    It is, for instance, not possible to use a function like 'concat' in your constraints, i.e. specifying:

    concat([firstname],' ',[lastname]) like '%searchvalue%'

    in the constraints of mm:list causes the system to fall back to legacy code after logging the error:

    "Failed to parse Constraint from search condition string"

    and a stacktrace.
    Show
    original bugid: #5949 It is, for instance, not possible to use a function like 'concat' in your constraints, i.e. specifying: concat([firstname],' ',[lastname]) like '%searchvalue%' in the constraints of mm:list causes the system to fall back to legacy code after logging the error: "Failed to parse Constraint from search condition string" and a stacktrace.

Activity

Hide
Henk Hangyi added a comment - 2007-02-25 13:27
IMO the issues fits best in the transaction improvement project for the 2.0 release
Show
Henk Hangyi added a comment - 2007-02-25 13:27 IMO the issues fits best in the transaction improvement project for the 2.0 release

People

Dates

  • Created:
    2003-03-19 14:46
    Updated:
    2007-02-25 13:27