ZF2-385: Sql\Select produces an incorrect sql query for predicates that contain '%' characters

Issue Type:
Bug
Created:
2012-07-03T07:53:45.000+0000
Last Updated:
2012-07-03T08:17:21.000+0000
Status:
Resolved
Fix version(s):
    Reporter:
    Yonni Mendes (yonman)
    Assignee:
    Martin Meredith (mez)
    Tags:
    • Zend\Db
    • Predicate
    • Sql\Select
    Related issues:
    Attachments:

    Description

    Steps: Create a Sql\Select object Add a string predicate through where('file_name like '%a') use getSqlString to retrieve the result

    Expected SELECT * FROM

    <

    table> WHERE file_name like '%a'

    Actual 'SELECT * FROM

    <

    table> WHERE '

    If I remove the "%" character, everything works fine. Same result if I pass the predicate as an array

    Comments

    Posted by Martin Meredith (mez) on 2012-07-03T08:08:42.000+0000

    https://github.com/zendframework/zf2/pull/1715

    Posted by Evan Coury (evan.pro) on 2012-07-03T08:17:21.000+0000

    This actually got merged as part of https://github.com/zendframework/zf2/pull/1704