Whenever an alias is included in a Group By statement, it fails with an exception similar to the following:

ORA-00904: "UC_PRODUCTS_SELL_PRICE": invalid identifier

Apparently the SQL Server driver expands those Group By clauses automatically. Is it possible to do the same here?

Thanks!

Comments

aaaristo’s picture

aaaristo commented
Status: Active » Needs work

we also expand it... going to look at the SQL Server driver implementation probably is more roubust here

aaaristo’s picture

aaaristo commented

i looked at it, and it looks like they address only db_select() statements... i would like somenthing that works with db_query too...

aaaristo’s picture

aaaristo commented

meanwhile added same group by expansion for db_select

aaaristo’s picture

aaaristo commented
Status: Needs work » Closed (duplicate)

http://drupal.org/node/1127298