On 6/30/07 11:45 PM, Michael Lackhoff wrote: > On 30 Jun 2007 at 17:10, John Siracusa wrote: >> Tables are only aliased as tN when more than one table is involved in the >> query. This "more than one" count does not include literal subqueries like >> yours, however. I'm thinking of changing it in 0.765 so that the tN aliases >> are always used, which would solve your problem (and many of my own too :) >> > But why did you change it then to the current behaviour? As I said, the alias > was there in an earlier version of RDBO.
I'm pretty sure single table queries haven't used the tN aliases for a while. Turn on debugging and show the SQL produced by your old version to find out for sure. -John ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
