Re: [sqlite] Bug report: column name includes table alias when CTE is used

On 21 Apr 2014, at 6:16am, Andre wrote: > Apparently when a CTE is used, the column name includes the table alias. > However, when no CTE is used, the alias is not present in the returned > column name. SQLite has no standards at all about column names unless you

[sqlite] Bug report: column name includes table alias when CTE is used

Hi, Apparently when a CTE is used, the column name includes the table alias. However, when no CTE is used, the alias is not present in the returned column name. SQLite version 3.8.4.3 2014-04-03 16:53:12 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open

Re: [sqlite] Remote access to SQLite in Linux from Windows.

On 21 Apr 2014, at 12:43am, Stephen Chrzanowski wrote: > Short of writing a server type application that listens for incoming > communication, I'm not aware of anything of the sort. SQLite is an > embedded library which compiles with your code, or, with references to >

Re: [sqlite] Remote access to SQLite in Linux from Windows.

Short of writing a server type application that listens for incoming communication, I'm not aware of anything of the sort. SQLite is an embedded library which compiles with your code, or, with references to external libraries installed on your local machine. SQLite doesn't behave well with ANY

Re: [sqlite] detach failed with error code 1

On 20 Apr 2014, at 12:58pm, dd wrote: > Given different database name for in-memory database for every > iteration(looped for 1000 times). Still, it's throwing Database Locked at > least once on Windows, not on Mac/Linux. Is there any way to track this > issue? I am using

Re: [sqlite] detach failed with error code 1

Given different database name for in-memory database for every iteration(looped for 1000 times). Still, it's throwing Database Locked at least once on Windows, not on Mac/Linux. Is there any way to track this issue? I am using 3.7.11. Any ideas? On Thu, Apr 17, 2014 at 5:11 PM, Richard Hipp

Re: [sqlite] Bug report: ORDER BY ignored in presence of GROUP BY and index

On Sat, Apr 19, 2014 at 11:14 PM, foxlit wrote: > Hi, > > I recently noticed something similar to the following behaviour: > > sqlite> .version > SQLite 3.8.4.3 2014-04-03 16:53:12 a611fa96c4a848614efe899130359c9f6fb889c3 > sqlite> CREATE TABLE t1 (x, y); > sqlite>

[sqlite] Bug report: ORDER BY ignored in presence of GROUP BY and index

Hi, I recently noticed something similar to the following behaviour: sqlite> .version SQLite 3.8.4.3 2014-04-03 16:53:12 a611fa96c4a848614efe899130359c9f6fb889c3 sqlite> CREATE TABLE t1 (x, y); sqlite> INSERT INTO t1 VALUES (1, 1), (2, 0); sqlite> SELECT x, y FROM t1 GROUP BY x, y ORDER BY x,y;

[sqlite] CTE in views for older versions

Hi, noticed that attempt to open a database containing a view Create vew ... with recursive ... ... with older (non-cte) versions of sqlite failed. The call to open_v2 was ok, but any access for example to PRAGMA encoding led to "malformed database schema" error. Although it came as no big

Re: [sqlite] cannot set connection while a datareader is active

Il 20/04/2014 6.00, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Is a big project wich re-call many function and interacts many times with sqlite provider... i could try to isolate a piece of code but isolating the code i don't know if the error will be reproduced...but i will try is

Re: [sqlite] how can i omit the number/0 in the result in sqlite?

On Fri, Apr 18, 2014 at 8:35 PM, 水静流深 <1248283...@qq.com> wrote: > sqlite3 test.db create table data(num1 float,num2 float); insert into > data values(1.2,3.4); insert into data values(4,0); insert into data > values(2,5); insert into data values(3,0); insert into data values(5.2,3); > sqlite>