[Solar-talk] Patch for Solar_Content_Abstract

[Travis Swicegood]

Howdy all,

Yet another patch.  The bookmark app was working until I tried to view 
by tags.  Here's the latest changes.  You'll see the tags.name changes 
at the top still, plus two new sets of changes.

The first one has to do with the count().  SQLite (possibly just my 
version, 3.2.8?) doesn't like this type of query:

SELECT
    COUNT(nodes.id)
FROM
    (SELECT nodes.id FROM nodes) AS nodes

The COUNT() can't figure out what it's counting on because apparently 
(and probably a bug) SQLite doesn't carry column names from sub-queries 
properly back - at least for COUNT()s.  I didn't try just doing a 
straight select.

The second block removes the having() call.  I'm not sure what that's 
there for.  As soon as I add a having to the query, I get nothing back.  
As soon as I remove it, the sub-query performs like it's supposed to.  
What is the reasoning behind the having?

With this patch applied, the Bookmarks app works against trunk for me.

-Travis
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Solar_Content_Abstract.patch
Type: text/x-patch
Size: 1234 bytes
Desc: not available
Url : http://mail.killersoft.com/pipermail/solar-talk/attachments/20061001/c0f6e888/attachment.bin