DataMapper ORM v1.8.2

[eluser]cahva[/eluser]
Hi,

I have a REALLY annoying problem with identifiers. This might not be DM related but maybe someone can shed some light because I'm frustrated as hell.

I have multiple sites, they are CI 1.7.2 and use the same symlinked system and application(for most parts) directories so no conflicts with different versions.

When running this on 2 different sites(both with same DM(1.8.0) and CI). It has lots of other stuff going on before this(subqueries etc.) but this is the relevant one:

Code:

echo $products->order_by_func('IF', '@special_price IS NOT NULL, special_price, price', $pr_data['order_dir'])->where('active',1)->get_sql();

Working site gives this:

Code:

SELECT products.*, products_description.name AS products_description_name, products_description.description AS products_description_description, products_description.key AS products_description_key, products_description.language_id AS products_description_language_id, tax.amount AS tax_amount, (SELECT product_specials.price
FROM (product_specials)
WHERE `product_specials`.`customer_group_id` = '1'
AND product_specials.product_id =products.id
AND  (
  (
`product_specials`.`date_start` = '0000-00-00'
OR `product_specials`.`date_start` <= '2012-07-17'
)
AND  (
`product_specials`.`date_end` = '0000-00-00'
OR `product_specials`.`date_end` >= '2012-07-17'
)
)
LIMIT 1) AS special_price
FROM (products)
LEFT OUTER JOIN products_description products_description ON products.id = products_description.product_id
LEFT OUTER JOIN tax tax ON tax.id = products.tax_id
WHERE `products_description`.`language_id` = 1
AND `products`.`active` = 1
ORDER BY IF(special_price IS NOT NULL, special_price, products.price) asc

Non-working site gives this:

Code:

SELECT `products`.*, `products_description`.`name` AS products_description_name, `products_description`.`description` AS products_description_description, `products_description`.`key` AS products_description_key, `products_description`.`language_id` AS products_description_language_id, `tax`.`amount` AS tax_amount, (SELECT `product_specials`.`price`
FROM (`product_specials`)
WHERE `product_specials`.`customer_group_id` = '1'
AND product_specials.product_id =products.id
AND  (
  (
`product_specials`.`date_start` = '0000-00-00'
OR `product_specials`.`date_start` <= '2012-07-17'
)
AND  (
`product_specials`.`date_end` = '0000-00-00'
OR `product_specials`.`date_end` >= '2012-07-17'
)
)
LIMIT 1) AS special_price
FROM (`products`)
LEFT OUTER JOIN `products_description` products_description ON `products`.`id` = `products_description`.`product_id`
LEFT OUTER JOIN `tax` tax ON `tax`.`id` = `products`.`tax_id`
WHERE `products_description`.`language_id` = 1
AND `products`.`active` = 1
ORDER BY IF(`special_price` IS NOT NULL, `special_price`, `products`.`price)` asc

The actual error will come from the last ORDER BY line with `products`.`price)`. But the non-working query also has identifiers all over the place and this is puzzling me. Database, datamapper and other configs are identical so what possibly could cause this kind of behaviour?

I've made the fix stated here also but it has no effect to the identifiers at all and working site works without the fix no problem.