Difference in generated sql when using defining query
Posted: Tue 21 Apr 2009 07:56
When I have an entity set which is a table, the generated sql is something like:
select "extent1".column1, "extent1".column2 from table "extent1"
But if I use a defining query instead of a table name, the generated sql is something like:
select "extent1"."column1", "extent1"."column2" from (...) "extent1"
and my inner sql statement is something like :
select column1, column2 from table
Why in normal mode there are no double-quotes on the columns and in defnining query there are? This requires me to change all my defining queries to the double-quote format (using aliases).
Is there some way to tell the provider to not use double-quotes?
Thanks in advance,
Ido.
select "extent1".column1, "extent1".column2 from table "extent1"
But if I use a defining query instead of a table name, the generated sql is something like:
select "extent1"."column1", "extent1"."column2" from (...) "extent1"
and my inner sql statement is something like :
select column1, column2 from table
Why in normal mode there are no double-quotes on the columns and in defnining query there are? This requires me to change all my defining queries to the double-quote format (using aliases).
Is there some way to tell the provider to not use double-quotes?
Thanks in advance,
Ido.