Skip to content

joinWhere does not work when table prefixes are set #513

@thurinus

Description

@thurinus

Additional conditions added via joinWhere and joinOrWhere were not being honored on MysqliDb configurations with prefixes. A bit of debugging revealed that in _buildJoin, the table name stored in _join had the prefix, but the one in _joinAnd did not. This caused the condition isset($this->_joinAnd[$joinStr]) to fail and never consider any of the extra join conditions.

Problem stems from joinWhere commands being keyed by the raw table name as provided, without conditioning it like the way join does it.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions