Re: [sqlite] Regression with sqlite 3.8.7

thanks for answers Luigi. 2014-10-25 15:46 GMT+02:00 Richard Hipp : > On Thu, Oct 23, 2014 at 11:55 AM, Luigi Iemma > wrote: > > > Hi, > > > > SELECT TdoIdoc,RdoCart,RdoQuat > > FROM Tesdoc > > INNER JOIN Rigdoc ON RdoIdoc BETWEEN TdoIdoc*1000 AND

Re: [sqlite] Regression with sqlite 3.8.7

oc',NULL,'39120'); INSERT INTO sqlite_stat1 VALUES('tesdoc',NULL,'11218'); ANALYZE sqlite_master; Luigi. 2014-10-24 14:48 GMT+02:00 Richard Hipp : > On Fri, Oct 24, 2014 at 7:45 AM, Luigi Iemma wrote: > > > Hi, > > > > if I d

Re: [sqlite] Regression with sqlite 3.8.7

/ Thanks in advance, Luigi. 2014-10-23 18:23 GMT+02:00 Richard Hipp : > On Thu, Oct 23, 2014 at 11:55 AM, Luigi Iemma > wrote: > > > Hi, > > > > SELECT TdoIdoc,RdoCart,RdoQuat > > FROM Tesdoc > > INNER JOIN Rigdoc ON RdoIdoc BETWEEN TdoIdoc*1000

[sqlite] Regression with sqlite 3.8.7

17.37 seconds if I change 'INNER JOIN Rigdoc' with 'LEFT JOIN Rigdoc' it takes 0.063 seconds the table Rigdoc have column RdoIdoc as PRIMARY KEY Best regards Luigi. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sql

[sqlite] error group_concat

INTEGER NOT NULL,B4 INTEGER NOT NULL,PRIMARY KEY(B1)); REPLACE INTO t2 VALUES(1,88,888,); REPLACE INTO t2 VALUES(2,99,999,); SELECT (SELECT GROUP_CONCAT(CASE WHEN a1=1 THEN'A' ELSE 'B' END) FROM t2),t1.* FROM t1; from Sqlite 3.7.12 return error misuse of aggregate Thank

[sqlite] error group_concat

CREATE TABLE t1 (A1 INTEGER NOT NULL,A2 INTEGER NOT NULL,A3 INTEGER NOT NULL,A4 INTEGER NOT NULL,PRIMARY KEY(A1)); REPLACE INTO t1 VALUES(1,11,111,); REPLACE INTO t1 VALUES(2,22,222,); REPLACE INTO t1 VALUES(3,33,333,); CREATE TABLE t2 (B1 INTEGER NOT NULL,B2 INTEGER NOT NULL,B3 INTEGE