Welcome Guest, Not a member yet? Register   Sign In
Issue with get_where and where methods in query builder.
#1

I just "answered" a Stack Overflow question that seems to point out a bug in get_where and where methods in the query builder:

https://stackoverflow.com/questions/48507219

This is using the current version of CodeIgniter, 3.1.7.

Basically, if a string is used as the where condition that contains " and x between x and ", then the query builder is inserting a bunch of backticks.

The query bindings feature doesn't have this problem.

I don't have a good enough understanding of the DB classes to help fix this, or know if it can be fixed.
Reply
#2

That's what happens when we try to make everybody happy ...

https://github.com/bcit-ci/CodeIgniter/c...79117bda42

I'm hoping this is the 1% case where a fix to the QB doesn't cause another bug. Smile
Reply
#3

(01-30-2018, 06:17 AM)Narf Wrote: That's what happens when we try to make everybody happy ...

https://github.com/bcit-ci/CodeIgniter/c...79117bda42

I'm hoping this is the 1% case where a fix to the QB doesn't cause another bug. Smile

I was a little worried about that. Seems like it would be super rare that somebody would build up a query like that. Fingers crossed!
Reply
#4

Hope died pretty quickly on this one: https://github.com/bcit-ci/CodeIgniter/issues/5448
Reply




Theme © iAndrew 2016 - Forum software by © MyBB