Re: [sqlite] aggregate functions with DISTINCT

Just to add: my questions were - why this limitation with DISTINCT, and can it be changed at least for GROUP_CONCAT? On Sun, Jan 11, 2015 at 1:23 AM, Staffan Tylen wrote: > Well, the SELECT is actually over 400 lines long so 'visualizing' it > wouldn't be very easy :)

Re: [sqlite] aggregate functions with DISTINCT

Well, the SELECT is actually over 400 lines long so 'visualizing' it wouldn't be very easy :) But it's along these lines: SELECT X FROM (SELECT 'ABC'|| IFNULL(' PARM('||GROUP_CONCAT(COL1,' ')||')'),' ')|| etc FROM T1 LEFT JOIN T2 LEFT JOIN T3 etc etc (lots of joins) UNION SELECT 'DEF'|| etc

Re: [sqlite] aggregate functions with DISTINCT

On Sat, Jan 10, 2015 at 5:56 PM, Staffan Tylen wrote: > Thanks Richard but unfortunately I cannot use DISTINCT in that way, since > it affects all the selected columns and they are MANY. > > Staffan > ​I am having trouble visualizing what your actual SELECT is. Would

Re: [sqlite] aggregate functions with DISTINCT

Hmm, maybe I'm wrong there, it would remove duplicates of the entire collection combined, wouldn't it? Yes, it might work. Staffan On Sun, Jan 11, 2015 at 12:56 AM, Staffan Tylen wrote: > Thanks Richard but unfortunately I cannot use DISTINCT in that way, since > it

Re: [sqlite] aggregate functions with DISTINCT

Thanks Richard but unfortunately I cannot use DISTINCT in that way, since it affects all the selected columns and they are MANY. Staffan On Sun, Jan 11, 2015 at 12:43 AM, Richard Hipp wrote: > On 1/10/15, Staffan Tylen wrote: > > I'm in the situation

Re: [sqlite] aggregate functions with DISTINCT

On 1/10/15, Staffan Tylen wrote: > I'm in the situation where I need to use GROUP_CONCAT and filter out > duplicates at the same time. And the default comma separator in > GROUP_CONCAT needs to be replaced by a space. I've tried to use function > REPLACE to get rid of the

[sqlite] aggregate functions with DISTINCT

The documentation for aggregate functions states that "In any aggregate function that takes a single argument, that argument can be preceded by the keyword DISTINCT". My questions are: Why is DISTINCT only allowed with a single argument in a function like GROUP_CONCAT? Can that limitation be

Re: [sqlite] Win 64 SQLLite 90 - badimageformatexception

Taylor, Jill (RBI-US) wrote: > > My application calls a DLL that uses the sqllite dll to open a database. However, > when I am debugging I get the BADImageFormatException error "An attempt was made > to load a program with an incorrect format error" > These are typically caused by a 32-bit

Re: [sqlite] SQLite 3.8.8 expected in January

On 1/9/15, RSmith wrote: > The pre-compiled and supplied DLL (sqlite3.dll) seem to be missing an entry > point for "sqlite3_enable_load_extension" - I do not see > any mention in the update text about altering or removing this feature so I > am assuming this might be a

[sqlite] Win 64 SQLLite 90 - badimageformatexception

Hi I have application compiled under Visual Studio 2012 on a Window 7 64 bit machine. I am trying to use the sqllite dll .90. My application calls a DLL that uses the sqllite dll to open a database. However, when I am debugging I get the BADImageFormatException error "An attempt was made

Re: [sqlite] Segfault with Evolution and patched SQLite 3.8.7.4

Am Freitag, den 09.01.2015, 21:04 -0500 schrieb Richard Hipp: > On 1/9/15, Paul Menzel wrote: > > Am Dienstag, den 30.12.2014, 16:15 +0100 schrieb Paul Menzel: > > > > With still around 1.3 GB free on the partition mounted to `/var/`, > > Evolution crashed with the f received the following