Here's the PATCH....

On Monday 14 July 2008 14:06:00 Kris Groves wrote:
> Hi,
>
> Here's the path for the 'select distinct' problem.  It's a patch against
> the cvs version.  However, I coded it against 0.8.3-1 release.  If there's
> any problems, let me know.
>
> Also, I think I should point out that there are a couple of caveats when
> using the sqlite3 driver, that I have mentioned in the code comments, but
> should also be mentioned in the driver documentation.
>
> 1. When using a function as a result column (e.g. count(*) ), the opening
> bracket MUST hug the function name.  The function call MUST also be
> aliased.
>
> 2. When using am expression as a result column (e.g. count(*) + 6 ), the
> entire expression MUST be enclosed in brackets and MUST be aliased.
>
> Simple enough.



-- 
Kris Groves

 Project Manager / Software Engineer                   mm-lab GmbH
 Phone:  +49 7154 827 323                      Stammheimer Str. 10
 Fax:    +49 7154 827 350                     D-70806 Kornwestheim
 [EMAIL PROTECTED]                                 www.mmlab.de

            Domicile of Company: Kornwestheim, Germany
   District Court - Court of Registration Stuttgart HRB 207257
          Managing Directors: Bernd Herrmann, Lothar Krank, 
                 Michael Meiser, Dr. Andreas Streit              


-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Libdbi-drivers-devel mailing list
Libdbi-drivers-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel

Reply via email to