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 specifically set a
column name
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 FILENA
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
> external libraries instal
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 so
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 3.7.11. Any ideas?
Tec
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 wrot
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> INSERT INTO t1 VALUES (1, 1), (
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;
1
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
surpri
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 al
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> se
11 matches
Mail list logo