Re: [sqlite] sqlite Issue

If you're using SQLite3.exe (or equivalent CLI - Command Line Interface) then by default the database id written to memory, not to the disk. Doing something like [ sqlite3.exe test.db3] will create a test.db3 file once you do an actual transaction like creating a table. I THINK even doing a

[sqlite] [PATCH][really] add missing autoconf feature detection

Yuriy Kaminskiy wrote: > Use of some function/features protected by #ifdefs, but lacks autoconf magic > to > automatically enable them when possible. Of course, they can be manually > enabled, but it is not very likely. And unused code tends to bitrot. Oops, last time patch attachment with

[sqlite] [PATCH] add missing autoconf feature detection

Use of some function/features protected by #ifdefs, but lacks autoconf magic to automatically enable them when possible. Of course, they can be manually enabled, but it is not very likely. And unused code tends to bitrot. ___ sqlite-users mailing list

Re: [sqlite] Recursive CTE on joined table

On Fri, Nov 14, 2014 at 6:16 PM, Paul Sanderson < sandersonforens...@gmail.com> wrote: > I can simplify the SQL by creating a view andthen use the ciew in my > recursive cte, but for various reasons I would rather not do this. > > Is it possible to use a recursive cte that refers to a cte? >

[sqlite] Recursive CTE on joined table

I have a recursive cte on a joined table and altough it works fine the SQL is a little complex and teh join makes it a little difficult to follow. I can simplify the SQL by creating a view andthen use the ciew in my recursive cte, but for various reasons I would rather not do this. Is it

Re: [sqlite] sliteonline or sqlite in js

On Fri, Nov 14, 2014 at 4:31 PM, Clemens Ladisch wrote: > I understand the desire to avoid storing data on the web server, but it > would > It doesn't - you can load local files. -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom

Re: [sqlite] BUGREPORT: LIMIT in a subquery has effect on the entire select

The ticket describing the cause of this problem is https://www.sqlite.org/src/tktview/db872294979b The problem should be fixed in 3.8.7.2 (due early next week) and in the next main release 3.8.8, and later today on trunk and on the branch-3.8.7 branch. On Fri, Nov 14, 2014 at 9:45 AM, Igor

Re: [sqlite] sliteonline or sqlite in js

Dan Kennedy wrote: > Perhaps not as functional as a native app (so far), but looking really good! > And you can't beat the deployment. Well, it does not replace SQL Fiddle. I understand the desire to avoid storing data on the web server, but it would be nice if the initial schema/query could be

Re: [sqlite] querying with BLOB in WHERE clause, possible?

bjdodo wrote: > Sorry for resurrecting an old thread. I got the where clause working for > queries with byte array arguments based on this discussion. I cannot find > the way to use byte arrays in where clauses for update and delete > statements. In the Android database API, execSQL() is the only

Re: [sqlite] Null rowid when using CTEs

On 11/14/2014 08:33 AM, RP McMurphy wrote: When using CTEs the rowid is null. The following returns "--NULL--" .null --NULL-- with c(x) as (select 1) select rowid from c; I guess that's expected. The same behaviour as for reading the rowid of a view or sub-select. It

Re: [sqlite] querying with BLOB in WHERE clause, possible?

On Fri, 14 Nov 2014 04:59:58 -0700 (MST), bjdodo wrote: >Hi > >Sorry for resurrecting an old thread. I got the where clause working for >queries with byte array arguments based on this discussion. I cannot find >the way to use byte arrays in where clauses for update and

Re: [sqlite] BUGREPORT: LIMIT in a subquery has effect on the entire select

this was found in a larger query during testing (the number of ids was larger in the IN statement, however the query was the same) the bug was found with version 3.8.7.1 on: Linux 3.13.0-39-generic #66-Ubuntu x86_64 GNU/Linux on 3.8.2 the error did not occur on Ubuntu, but occured on Darwin

Re: [sqlite] BUGREPORT: LIMIT in a subquery has effect on the entire select

Thanks for the succinct script for reproducing the problem. We are working on it now. Just curious: Did you find this problem when a larger and more complex query failed in a real application? On Thu, Nov 13, 2014 at 9:05 AM, Igor Stassiy wrote: > CREATE TABLE A(id

Re: [sqlite] sqlite Issue

On 14 Nov 2014, at 10:40am, ARVIND KUMAR wrote: > I am new for SQLite. I am trying to create database. But its not creating. > I have attached the screenshot. Please find and do needful. You cannot post screenshots to this mailing list. Most problems with creating a

Re: [sqlite] [SQLite] Support for 23,10 Precision number format

On 14 Nov 2014, at 3:42am, James K. Lowden wrote: > Simon Slavin wrote: > >> I'm not aware of >> any usable libraries which actually support 23,10 outside the world >> of physics. > > http://www.mpfr.org/#free-sw > > I'm sure you're aware of

Re: [sqlite] querying with BLOB in WHERE clause, possible?

Hi Sorry for resurrecting an old thread. I got the where clause working for queries with byte array arguments based on this discussion. I cannot find the way to use byte arrays in where clauses for update and delete statements. I know it is terrible to use byte arrays as query arguments, I need

[sqlite] BUGREPORT: LIMIT in a subquery has effect on the entire select

CREATE TABLE A(id UNSIGNED INT, tag NVARCHAR(256), value NVARCHAR(256)); CREATE TABLE B(tag NVARCHAR(256), hash NVARCHAR(256)); INSERT INTO A VALUES(1, "color", "red"); INSERT INTO A VALUES(1, "size", "big"); INSERT INTO A VALUES(2, "color", "green"); INSERT INTO A VALUES(2, "size", "small");

[sqlite] sqlite Issue

Hi, I am new for SQLite. I am trying to create database. But its not creating. I have attached the screenshot. Please find and do needful. Thanks & Regards Arvind ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Null rowid when using CTEs

When using CTEs the rowid is null. The following returns "--NULL--" .null --NULL-- with c(x) as (select 1) select rowid from c; RP ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] sliteonline or sqlite in js

On 11/14/2014 03:37 PM, Noel Frankinet wrote: Impressive ! It is that. Perhaps not as functional as a native app (so far), but looking really good! And you can't beat the deployment. Dan. On 12 November 2014 12:08, Kirill wrote: Good day, Full line manager to

Re: [sqlite] sliteonline or sqlite in js

Impressive ! On 12 November 2014 12:08, Kirill wrote: > Good day, > > Full line manager to work with sqlite directly > from the browser on any platform: > http://sqliteonline.com/ > > ___ > sqlite-users mailing list >

Re: [sqlite] [SQLite] Support for 23,10 Precision number format

On Thu, Nov 13, 2014 at 6:53 PM, RSmith wrote: > By the way, my Oracle friends should intersect here if need be, but I > believe the oracle method of /decimal(n,m)/ is simply a representation > directive and constraint, there is no native datatype that actually stores > or