Welcome Guest, Not a member yet? Register   Sign In
Join with calculation
#1

After upgrading from CI 2.x.x to CI 3.0.0 i've got several problems, and some of them i could fix and i understood why it was changed. But i'm not sure if i found a bug at this problem:

I'm doing a select statement and having the following kind of a join:

->join('table', 'table.x = (y - z)')

I've changed the variables to letters, because their content doesn't matter. CI framework is converting this to the following snippet:

JOIN `table` ON `table`.`x` = (`y-` `z)`

But it should convert it to the following snippet:

JOIN `table` ON `table`.`x` = (`y`-`z`)

So it's a bug or do i have to change sth. for CI 3.0.0?

Thanks in advance.
Reply
#2

(07-04-2015, 02:59 PM)Petrusilius Wrote: After upgrading from CI 2.x.x to CI 3.0.0 i've got several problems, and some of them i could fix and i understood why it was changed. But i'm not sure if i found a bug at this problem:

I'm doing a select statement and having the following kind of a join:

->join('table', 'table.x = (y - z)')

I've changed the variables to letters, because their content doesn't matter. CI framework is converting this to the following snippet:

JOIN `table` ON `table`.`x` = (`y-` `z)`

But it should convert it to the following snippet:

JOIN `table` ON `table`.`x` = (`y`-`z`)

So it's a bug or do i have to change sth. for CI 3.0.0?

Thanks in advance.

Hello,

try

Code:
->join('table', 'table.x = (y - z)', FALSE)

This will disable escaping
Reply




Theme © iAndrew 2016 - Forum software by © MyBB