[Lift] Excessive select DISTINCT

2010-01-14 Thread aw
I enabled SQL logging recently, and started looking at the generated SQL from Mapper. I was surprised to see that select DISTINCT was generally being done for queries when it is not necessary. Is that really necessary? For example: Team.findAll(OrderBy(Team.name, Ascending)) translated to:

Re: [Lift] Excessive select DISTINCT

2010-01-14 Thread David Pollak
Okay... I found the problem and fixed it. The fix will be on review board in a little while. On Thu, Jan 14, 2010 at 12:33 AM, aw anth...@whitford.com wrote: I enabled SQL logging recently, and started looking at the generated SQL from Mapper. I was surprised to see that select DISTINCT was