Re: [SQLObject] FloatCol, distinct+count and others

[Ian B. <ia...@co...>]

Marcin Wojdyr wrote:
> Hi,
> I will write about a few things, that make me not 100% happy
> with SQLObject, in one mail.
> 
> First about MultipleJoin: as Robert wrote in
> http://sourceforge.net/mailarchive/forum.php?thread_id=5435228&forum_id=30269
> person.addresses will generate n+1 queries to DB.

I don't think that is what happens...?  It's certainly not intended to 
cause that many selects.

> About FloatCol, what do you think should be a type of FloatCol?
> I think double precision in every database (but I'm not sure if other
> people agree), as I wrote in
> http://sourceforge.net/mailarchive/forum.php?thread_id=5604389&forum_id=30269

Sure, I guess that's fine.

> About count() in distinct'ed select: now it silently returns not-distincted
> count. 

Right now it's supposed to fail with an assertion error.  If it's not, 
I'll have to look into it.  Or...

> As Jeremy wrote, SQLite doesn't support count(distinct ...),
> but I think the patch from
> http://sourceforge.net/mailarchive/forum.php?thread_id=5545866&forum_id=30269
> would work fine - it works as expected in dbms that support count(distinct),
> and probably raises exception in SQLite, what is better than returning
> wrong value.

I can just apply that patch.  It's probably fine even without 
cross-database support.

> And when I found SQLObject, I first downloaded "Mostly Live CVS Tarball".
> It took me a while to realize, that it is outdated. Now it seems to be
> older than 0.5.2 tarball.

Oops, I have to get rid of that link, thanks.

-- 
Ian Bicking  /  ia...@co...  /  http://blog.ianbicking.org