Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

MYSQL : orderBy() considers CASE statement as a column #1528

Closed
TatwiraT opened this issue Nov 23, 2018 · 1 comment
Closed

MYSQL : orderBy() considers CASE statement as a column #1528

TatwiraT opened this issue Nov 23, 2018 · 1 comment
Labels
database Issues or pull requests that affect the database layer

Comments

@TatwiraT
Copy link

name: Bug report
orderBy() method considers the CASE statement as DB column

Describe the bug
A clear and concise description of what the bug is.
the orderBy() method considers the CASE ** END statement as DB column , hence it quotes it with magic quotes.

CodeIgniter 4 version
CI4 Alpha 2 : commit 2047b5a

Affected module(s)
DB : MySQL DRIVER

Context

  • OS: Arch Linux
  • Web server : Apache 3.4
  • PHP version : 7.2.9
@jim-parry jim-parry added the database Issues or pull requests that affect the database layer label Dec 10, 2018
@lonnieezell
Copy link
Member

This can be solved by using the $escape flag on the orderBy method.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
database Issues or pull requests that affect the database layer
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@lonnieezell @jim-parry @TatwiraT