Re: [sqlite] Bug report

Well, I kinda thought that this would be fixed on the next release. The "value_frombind" typo in particular prevents FTS3/4 from being built as a loadable extension. I only have one legacy application that uses FTS3/4 that way, and fixing these typos whenever I do a Fossil pull of the latest

[sqlite] lemon - namespace support

/Development/openfoam/blob/develop/wmake/etc/lempar.c.patch Cheers, /mark ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Recommended compiler options

Is SQLITE_MAX_EXPR_DEPTH=0 still a recommended compiler option? According to https://www.sqlite.org/draft/compile.html SQLITE_MAX_EXPR_DEPTH=0. Setting the maximum expression parse-tree depth to zero disables all checking of the expression parse-tree depth, which simplifies the code

[sqlite] Bug report

In version 3.30.1 ( check-in [9b14eb77] ), file "sqlite3ext.h" 618 #define sqlite3_stmt_isexplain sqlite3_api->isexplain 619 #define sqlite3_value_frombind sqlite3_api->frombind should be 618 #define sqlite3_stmt_isexplain sqlite3_api->stmt_isexplain 619 #define

[sqlite] Documentation Bug

The documentation at https://sqlite.org/quirks.html#no_separate_datetime_datatype refers to ISO 8610. I should be ISO 8601. Best Regards, Mark -- Mark Simon Manngo Net Pty Ltd mobile:0411 246 672 email:m...@manngo.net <mailto:m...@comparity.net> web:http://www.manngo.net Resum

Re: [sqlite] Date time input

On 10/10/2019 07:50, J Decker wrote: It's 'ite' as in 'stalagmite' or 'meteorite' as in rock solid... https://changelog.com/podcast/201 " RICHARD HIPP How do I pronounce the name of the product? I say S-Q-L-ite, like a mineral. So probably

Re: [sqlite] SQLite Encryption Extension For Use with With PHP 7.x Code

this is outside of the scope of SQLite when asking for help with PHP's PDO interface. I'm just hoping that people on here have experience with PHP might have a solution. On Tue, Aug 20, 2019 at 2:56 PM Richard Hipp wrote: > On 8/20/19, Mark Tomlin wrote: > > I would like to use SQLite's E

[sqlite] SQLite Encryption Extension For Use with With PHP 7.x Code

also guessing I would have to modify the (see-)sqlite.c code to make a call to sqlite3_key from within the sqlite3 function call so that the encryption is always on and would not require any modifications to the PHP source code. Has anyone done this before? -- Mark Tomlin, CEO. MimoCAD, Inc

Re: [sqlite] How to insert the BLOB in database?

On Monday, June 10, 2019 03:46:02 AM Simon Slavin wrote: > On 10 Jun 2019, at 3:44am, Mark Halegua wrote: > > I probably should figure this out, but in a GUI, how do I recover a > > graphic from the database? > Programming. SQLite can't do it since it doesn't even understand th

Re: [sqlite] How to insert the BLOB in database?

; I probably should figure this out, but in a GUI, how do I recover a graphic from the database? I can see how it's easily saved in a database field. MaRK ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.o

[sqlite] is this possible

ious. Thanks! -- Mark ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] why no unique columns on alter table

This is mainly for my curiosity. Is there any particular reason that one can't add a unique column on an alter table? With a default value of null they would all have unique values by default. Any insight into this would be great. Perhaps there' something obvious I'm missing. -- Mark

Re: [sqlite] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW

Am Do., 27. Dez. 2018 um 02:53 Uhr schrieb Mark Johnson < mj10...@googlemail.com>: > (summery of the last messages that were sent as email) > > >> Please add the list of column names after the view name: > >> CREATE VIEW middle_earth_admin_general(a,b,c,e) AS ...

Re: [sqlite] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW

(summery of the last messages that were sent as email) >> Please add the list of column names after the view name: >> CREATE VIEW middle_earth_admin_general(a,b,c,e) AS ... >> I have a note to improve the documentation about this point. So would the following be true: To insure that a constant,

Re: [sqlite] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW

Am Do., 20. Dez. 2018 um 16:34 Uhr schrieb Mark Johnson < mj10...@googlemail.com>: > Based on ticket > > https://www.sqlite.org/src/tktview?name=43ddc85a63 > > > > However, the column count is not correct. > In my case 2 columns are missing: which should be 19. >

[sqlite] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW

l->zName[id_belongs_to]==zCol[text] -I-> lookupName -202a loop - iCol[16] pCol->zName[id_belongs_to]==zCol[eur_point] resulting in the error: error in trigger vw_ins_middle_earth_general: no such column: NEW.id_belongs_to. Mark Johnson mj10...@googlemail.com ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to

tains 11,12: > WITH SETS(PSet, PContent, PCount) AS ( > SELECT c, GROUP_CONCAT(p,','), COUNT(*) FROM (SELECT * FROM t ORDER > BY c,p) GROUP BY c > ) > SELECT * >FROM SETS > WHERE PContent LIKE '%11,12%' > ; > >-- PSet | PContent | PCount >

[sqlite] how to

Given a table with two columns, A and B, with no constraints what would be the best way to query for those values of A such that there are corresponding values of B in a specified set. For example, given this data, below, and ignoring the primary key, I would want the following results: for p

Re: [sqlite] SQLite for datalogging - best practices

Going back to the comments from Dr. Hipp regarding WAL vs DELETE mode on F2FS devices, I just wanted to confirm my understanding. Given a device with F2FS and with sqlite compiled with SQLITE_ENABLE_BATCH_ATOMIC_WRITE, writes with DELETE mode will be considerably faster than with WAL mode. But a

[sqlite] downloading older versions

that I've tried various "year" components on the path as well. -- Mark ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlidiff --schema question

Just pining on this in case anyone knows more... ? On Tue, Aug 7, 2018 at 2:00 PM Mark Wagner wrote: > > I was surprised to see sqldiff --schema not report column constraints as > schema differences. Or am I missing something? > > $ echo .schema | sqlite3 /tmp/f1.db > CREATE

[sqlite] sqlidiff --schema question

I was surprised to see sqldiff --schema not report column constraints as schema differences. Or am I missing something? $ echo .schema | sqlite3 /tmp/f1.db CREATE TABLE t (foo text unique); $ echo .schema | sqlite3 /tmp/f2.db CREATE TABLE t (foo text); $ sqldiff --schema /tmp/f1.db /tmp/f2.db

Re: [sqlite] column types and constraints

Great explanation. Thanks. On Wed, Jun 27, 2018 at 7:43 PM Richard Hipp wrote: > On 6/27/18, Igor Tandetnik wrote: > > On 6/27/2018 9:14 PM, Richard Hipp wrote: > >> On 6/27/18, Mark Wagner wrote: > >>> Thanks for all the good background. FWIW this cam

Re: [sqlite] column types and constraints

Sorry, my typo (I had entered the corrected code). This: create table t1(x text non null); insert into t1(x) values(null); select * from t1; On Wed, Jun 27, 2018 at 6:14 PM Richard Hipp wrote: > On 6/27/18, Mark Wagner wrote: > > Thanks for all the good background. FWIW thi

Re: [sqlite] column types and constraints

Thanks for all the good background. FWIW this came up because someone had created a row with something like: (column_name non null). Needless to say, this created a column without a "not null" constraint. On Wed, Jun 27, 2018 at 5:02 PM Richard Hipp wrote: > On 6/27/18, Mark

[sqlite] column types and constraints

bar2 (x happy days); -- Mark ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] unexpected error with "GROUP BY 0"

lumn list where it is defined. Mark On 31/05/18 18:27, Hick Gunter wrote: Ponder the following select fragment SELECT name, year * 100 + month as period, day + hour / 24.0 from some_table Then you can have ORDER BY 1,2,3 -- integer output column numbers which is equivalent to ORDER BY n

Re: [sqlite] [EXTERNAL] unexpected error with "GROUP BY 0"

eger value, gets interpreted after GROUP BY or ORDER BY as a result column number. Fortunately, SQLite isn't to blame for designing this. By the way, this feature is documented for ORDER BY, but I don't see it for GROUP BY. Mark On 30/05/18 13:28, Hick Gunter wrote: You have constant integers,

Re: [sqlite] [EXTERNAL] unexpected error with "GROUP BY 0"

Thanks. I had forgotten that GROUP BY considers a literal integer in this context to be a column number, a feature I don't use. These, on the other hand, work as I would have expected: sqlite> select 0 group by cast (0 as int); 0 sqlite> select 0 group by (select 0); 0 Mark On 30/05

[sqlite] unexpected error with "GROUP BY 0"

Hi, Is there a good reason for this error: sqlite> SELECT  0 GROUP BY 0; Error: 1st GROUP BY term out of range - should be between 1 and 1 sqlite> SELECT 0 GROUP BY 1; 0 ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] unique constraint

Thanks for the responses. Just a brain error. Not sure what I was thinking :) On Tue, May 15, 2018 at 6:55 PM R Smith <ryansmit...@gmail.com> wrote: > > On 2018/05/16 1:25 AM, Mark Wagner wrote: > > OK, at the risk of exposing my lack of edification... > > Som

Re: [sqlite] unique constraint

I am confused. Too much experimenting :( On Tue, May 15, 2018 at 4:55 PM Simon Slavin <slav...@bigfraud.org> wrote: > On 16 May 2018, at 12:25am, Mark Wagner <m...@google.com> wrote: > > > I'm wondering if > > someone can explain why this simple test of unique

[sqlite] unique constraint

OK, at the risk of exposing my lack of edification, I'm wondering if someone can explain why this simple test of unique column constraints doesn't work. At least it doesn't work as I expected it would (i.e. that the second insert would yield a unique constraint violation). create table t (k

[sqlite] Problem b building sqlite on macOS android.

Hi, I am having problems building sqlite with the android NDK for macos. Weirdly, it *does* build fine on windows ndk. The errors I am getting are shown below. Bye, Mark '-- errors building sqlite on macOS android ndk jni/../../../sqlite-amalgamation/sqlite3.c

Re: [sqlite] crash dropping table

18 at 9:56 AM Simon Slavin <slav...@bigfraud.org> wrote: > On 18 Apr 2018, at 4:47pm, Mark Wagner <m...@google.com> wrote: > > > I have a simple test case wherein I delete from a number of tables and > then > > drop one of those tables. This crashes sqlite3. &g

[sqlite] crash dropping table

I have a simple test case wherein I delete from a number of tables and then drop one of those tables. This crashes sqlite3. So something like this: begin; delete from x; delete from y; delete from z; drop x; << crashes here Sorry for my ignorance but is there a procedure for submitting bugs

Re: [sqlite] feature request: MIN() and MAX() of set of row values

On 13/04/18 14:12, Simon Slavin wrote: On 13 Apr 2018, at 8:40am, Mark Brand <mabr...@mabrand.nl> wrote: It also occurs to me that COUNT() should work (but doesn't) over sets of row values: sqlite> select count((1,2)); Error: row value misused I would expect it

Re: [sqlite] feature request: MIN() and MAX() of set of row values

On 13/04/18 09:32, Mark Brand wrote: On 30/03/18 18:55, Igor Tandetnik wrote: Row values support less-than comparison, so it kind of makes sense to expect MIN to work on them, too. That's what I was thinking too. One would expect aggregate MIN() and MAX() to work over row values. While

Re: [sqlite] feature request: MIN() and MAX() of set of row values

, the error on the first query below seems unexpected:    sqlite> select (2, 3) = (select (2, 3));     Error: row value misused     sqlite> select (2, 3) = (2, 3);     1     sqlite> select (2, 3) = (values(2, 3));     1 Mark ___ sqlite-user

[sqlite] MIN() and MAX() of set of row values

Hi, Row values make life easier in so many ways, but I was just wondering if there is (or should be or could be) a way to use aggregate MIN() and MAX() on a set of row values. Mark CREATE TABLE T (a, b); INSERT INTO T (a, b) VALUES (1, 2), (1, 3), (2, 3); SELECT MIN((a,b)) = (1, 2) ok

Re: [sqlite] How to get ORDER BY / LIMIT to stick to the fast-path?

When I saw this post I just assumed there wasn't a sufficient index to handle the select and the order by. Curious about the suggestion of adding + to the order by first term. On Thu, Mar 22, 2018 at 3:14 PM Simon Slavin wrote: > On 22 Mar 2018, at 10:09pm, Jonathan

Re: [sqlite] pragma foreign_key_check

TS3_PARENTHESIS > ENABLE_FTS4 > ENABLE_FTS5 > ENABLE_JSON1 > ENABLE_LOAD_EXTENSION > ENABLE_LOCKING_STYLE=1 > ENABLE_MEMORY_MANAGEMENT > ENABLE_MEMSYS5 > ENABLE_PREUPDATE_HOOK > ENABLE_RBU > ENABLE_RTREE > ENABLE_SESSION > ENABLE_STAT4 > ENABLE_STMTVTAB > EXT

[sqlite] pragma foreign_key_check

The documentation for foreign_key_check says I should be receiving 4 columns per violation. I only seem to be getting 1. Am I doing it wrong? Perhaps it's a version issue? Thanks sqlite> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE t (id int primary key, value); CREATE TABLE

Re: [sqlite] EXTERNAL: Re: Bug in fsdir

I put the amalgamated 3.22.0 release into my production code. Windows 10 is the customer execution platform. Do I need to update? ___ Mark C Edwards Chief Scientist, C2 Systems Engineering & Integration 779 Monika Ct Chubbuck, ID 83202 mark.c.

Re: [sqlite] multiple table constraints

Thanks for the detailed response. I was really confused for a few minutes this morning noticing both forms in my code. :) On Wed, Mar 7, 2018 at 9:44 AM, Richard Hipp <d...@sqlite.org> wrote: > On 3/7/18, Mark Wagner <m...@google.com> wrote: > > > > e.g. both are ac

[sqlite] multiple table constraints

The syntax for multiple table constraints seems to specify a comma between each constraint but I noticed that no comma separator seems to be accepted as well. e.g. both are accepted CREATE TABLE foo(_id primary key, x, y, unique(x), unique(y)); CREATE TABLE foo(_id primary key, x, y, unique(x)

Re: [sqlite] question about covering index

rSort 1 49000 > >43 SorterData 1 16400 > >r[16]=data > >44 Column 4 0 14 00 r[14]=y > >45 Column 4 2 13 00 r[13]=x > >

Re: [sqlite] question about covering index

Slavin <slav...@bigfraud.org> wrote: > On 7 Feb 2018, at 12:43am, Mark Wagner <m...@google.com> wrote: > > > CREATE TABLE foo (_id integer primary key, x, y); > > CREATE INDEX i on foo(_id, x, y); > > > > And the following query > > > > sqlite

[sqlite] question about covering index

Given the following schema: CREATE TABLE foo (_id integer primary key, x, y); CREATE INDEX i on foo(_id, x, y); And the following query sqlite> EXPLAIN QUERY PLAN SELECT * FROM foo WHERE x=1 GROUP BY _id ORDER BY y; I would have expected it (hoped?) that it would use the covering index for the

Re: [sqlite] missing subquery flattening

On 26/01/18 19:35, Clemens Ladisch wrote: Mark Brand wrote: Shouldn't we expect subquery flattening to happen in V2 below? -- no flattening CREATE VIEW V2 AS SELECT * FROM X LEFT JOIN ( SELECT * FROM X LEFT JOIN Y ON Y.a = X.a ) Z ON Z.a = X.a

[sqlite] missing subquery flattening

Hi, Shouldn't we expect subquery flattening to happen in V2 below? Mark CREATE TABLE X ( a PRIMARY KEY, b ) WITHOUT ROWID; CREATE TABLE Y ( a PRIMARY KEY ) WITHOUT ROWID; /* WITH RECURSIVE Q AS (     SELECT 1 a     UNION ALL SELECT a + 1 FROM Q     WHERE a < 10 ) INSERT INTO X (a

[sqlite] documentation edits needed

Here are some suggested improvements for the constraints listed under:     https://www.sqlite.org/optoverview.html, section  10. Subquery flattening 3. The subquery is not the right operand of a LEFT JOIN then the subquery may not be a join, the FROM clause of the subquery may not contain

[sqlite] unexpected row value error

3.22.0, and also on 3.19.3. Mark CREATE TABLE x ( a, b, PRIMARY KEY (a, b) ); CREATE TABLE y ( a ); CREATE TABLE z ( a, b ); INSERT INTO x VALUES (1, 1), (1, 2); INSERT INTO y VALUES (1); INSERT INTO z VALUES (1, 1), (1, 2); SELECT sqlite_version(); -- CASE 1: OK SELECT * FROM x WHERE (SELECT

Re: [sqlite] EXTERNAL: SQLite 3.22.0 coming soon

Release mode/x86 Visual Studio 2015 Prono problems with the new snapshot ___ Mark C Edwards Chief Scientist, C2 Systems Engineering & Integration 779 Monika Ct Chubbuck, ID 83202 mark.c.edwa...@leidos.com Mobile: 208-241-7982 -Original Mes

Re: [sqlite] EXTERNAL: SQLite 3.22.0 coming soon

s. Thanks! ___ Mark C Edwards Chief Scientist, C2 Systems Engineering & Integration 779 Monika Ct Chubbuck, ID 83202 mark.c.edwa...@leidos.com Mobile: 208-241-7982 -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailingli

Re: [sqlite] EXTERNAL: SQLite 3.22.0 coming soon

Thanks Richard. I'll build the amalgamated version in Release mode/X86 in VS 2015 Pro to see if it completes without complaint. ___ Mark C Edwards Chief Scientist, C2 Systems Engineering & Integration 779 Monika Ct Chubbuck, ID 83202 mark.c.

Re: [sqlite] EXTERNAL: Re: Possibly uninitialized variables...compile time error

Thank you. I'm looking forward to a clean build on the next release. ___ Mark C Edwards Chief Scientist, C2 Systems Engineering & Integration 779 Monika Ct Chubbuck, ID 83202 mark.c.edwa...@leidos.com Mobile: 208-241-7982 -Original Message-

[sqlite] Possibly uninitialized variables...compile time error

2015 Pro and link time code generation. ___ Mark C Edwards Chief Scientist, C2 Systems Engineering & Integration 779 Monika Ct Chubbuck, ID 83202 mark.c.edwa...@leidos.com Mobile: 208-241-7982 ___ sqlite-u

Re: [sqlite] values ?

or "where" or "order by", where would this > come in useful? > > On Tue, Dec 12, 2017 at 1:48 PM, Mark Wagner <m...@google.com> wrote: > > > Argh. Yes, I was on 3.8.2. Thanks! > > > > On Tue, Dec 12, 2017 at 10:45 AM, Richard Hipp <d...@sq

Re: [sqlite] values ?

Argh. Yes, I was on 3.8.2. Thanks! On Tue, Dec 12, 2017 at 10:45 AM, Richard Hipp <d...@sqlite.org> wrote: > On 12/12/17, Mark Wagner <m...@google.com> wrote: > > My reading of https://sqlite.org/syntax/select-core.html makes me think > > that I should be able to

[sqlite] values ?

My reading of https://sqlite.org/syntax/select-core.html makes me think that I should be able to issue something like values('foo'); and get a row with a single column whose value is 'foo'. But I get a syntax error. Probably obvious to the right people but what am I missing? sqlite>

[sqlite] tiny doc suggestion for FTS5

, -- Mark Summerfield, Qtrac Ltd. DiffPDF for Windows - PDF comparison tool http://www.qtrac.eu/diffpdf.html ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Typo & missing link

links on the main SQLite download page. Best wishes, -- Mark Summerfield, Qtrac Ltd. XindeX - easy to learn and use software for creating book indexes http://www.qtrac.eu/xindex.html ___ sqlite-users mailing list sqlite-users

[sqlite] compiling for android

#endif Bye! Mark ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Syntax Restrictions On UPDATE, DELETE, and INSERT Statements Within Triggers

he trigger, what is the rationale for this syntactic restriction that applies specifically to the modification case? As far as I can tell, this leaves the programmer no way to disambiguate. Is there a good workaround? Mark ___ sqlite-users mailing l

Re: [sqlite] Syntax Restrictions On UPDATE, DELETE, and INSERT Statements Within Triggers

On 09/06/17 14:47, Richard Hipp wrote: The documentation has been updated to clarify the ambiguity and to hopefully make it easier to understand. Thanks. The exception for non-TEMP triggers is something I was hoping for too: For non-TEMP triggers, the table to be modified or queried must

[sqlite] Syntax Restrictions On UPDATE, DELETE, and INSERT Statements Within Triggers

According to the documentation: The name of the table to be modified in an UPDATE, DELETE, or INSERT statement must be an unqualified table name. In other words, one must use just "tablename" not "database.tablename" when specifying the table. *The table to be modified must exist in

[sqlite] SQLite on .NET Standard

System.Data.SQLite is available for .NET Framework 2.0+, but as far as I can tell it does not support .NET Core or .NET Standard. Are there any plans to bring System.Data.SQLite to .NET Standard, or failing that .NET Core, so that I can write cross-platform .NET code using SQLite?

Re: [sqlite] foreign key constraint failure

n table t2 gives the id of the t1 row which can not be deleted: > > SELECT id1 FROM t2 WHERE id = 456 > -- id1:123 > > This is row 123 of t1 which can not be deleted. > > Make sure to rollback the failed transaction, and restore foreign key > checks: > >

[sqlite] foreign key constraint failure

Is there a way to get sqlite to tell which foreign key constraint is causing a failure? Some kind of verbose mode? Thanks! sqlite> delete from t; Error: FOREIGN KEY constraint failed sqlite> ___ sqlite-users mailing list

Re: [sqlite] BUG?: operation unexpectedly applied to both main and temp

On 30/03/17 21:06, David Raymond wrote: Close. It rests on the backs of 4 elephants, who in turn stand on the back of the Great A'Tuin I don't know but I've been told it's turtles all the way down. ___ sqlite-users mailing list

Re: [sqlite] BUG?: operation unexpectedly applied to both main and temp

On 30/03/17 19:10, Simon Slavin wrote: On 30 Mar 2017, at 5:53pm, Mark Brand <mabr...@mabrand.nl> wrote: The documentation actually says "*least* recently attached". https://www.sqlite.org/lang_attach.html, paragraph 4. I’m unsure whether you can legitimately say that the

Re: [sqlite] BUG?: operation unexpectedly applied to both main and temp

tached compared to main. :) The documentation actually says "*least* recently attached". https://www.sqlite.org/lang_attach.html, paragraph 4. Mark ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.

Re: [sqlite] operation unexpectedly applied to both main and temp?

d than main, which wasn't an obvious fact to me. Mark ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] BUG?: operation unexpectedly applied to both main and temp

On 29/03/17 02:12, Mark Brand wrote: On 29/03/17 01:35, Simon Slavin wrote: On 28 Mar 2017, at 11:02pm, Mark Brand <mabr...@mabrand.nl> wrote: create temp table t (db, val); insert into t select 'temp', 'original'; create table t (db, val); insert into t select 'main', 'or

Re: [sqlite] BUG?: operation unexpectedly applied to both main and temp

On 29/03/17 01:35, Simon Slavin wrote: On 28 Mar 2017, at 11:02pm, Mark Brand <mabr...@mabrand.nl> wrote: create temp table t (db, val); insert into t select 'temp', 'original'; create table t (db, val); insert into t select 'main', 'original'; Here’s your problem: SQLite version

[sqlite] BUG?: operation unexpectedly applied to both main and temp

HI, Something seems to go wrong in this example where an operation unexpectedly gets applied both main and temp. The order of table creation seems to be one crucial factor. I ran into this while trying to get my head around the use of temporary triggers, which seems to be the other

[sqlite] 'start of day' modifier and Julian day timestring

Hi, I am wondering why the 'start of day' and 'start of year' modifiers don't seem to work on Julian day timestrings. What is the explanation for the NULLs in examples 2 and 3 below? SELECT example, timestring, strftime('%J', timestring), strftime('%Y-%m-%d %H:%M',

[sqlite] SQL logic anomaly

Hi, Using SQLite version 3.15.2, the following SQL returns 0 rows, whereas I believe it should return 1 row. Any of the commented out alternatives produces the expected 1 row. Mark CREATE VIEW W AS SELECT 0 show_a; CREATE VIEW X AS SELECT 'A' a, 1 v UNION SELECT 'B

Re: [sqlite] Read-only access which does not block writers

On Nov 29, 2016, at 9:09 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > >> On 29 Nov 2016, at 4:18pm, Mark Hamburg <mhamburg...@gmail.com> wrote: >> >> Does this make sense? Does it seem useful? (It seems useful to me when I see >> multi-megabyte

Re: [sqlite] Read-only access which does not block writers

in this regard or is this the sort of question where the answer is "experiment". Mark ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Read-only access which does not block writers

stream of small read operations blocking WAL reset. Does this make sense? Does it seem useful? (It seems useful to me when I see multi-megabyte WAL files.) Mark ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

[sqlite] row values with BETWEEN

Hi, i hope I'm not overlooking something obvious, but the last result below is not what I would expect. Just wondering if this could somehow be correct and, if so, how to understand it. regards, Mark $ sqlite3 SQLite version 3.15.1 2016-11-04 12:08:49 Enter ".help" for u

[sqlite] column type impact on index usage

. Note that in the case when the columns are both integer an index is used and when one is integer and one is not specified no index is used. Any thoughts on this? Thanks. -- Mark sqlite> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE seq (value integer); CREATE TABLE bar (va

[sqlite] System.Data.SQLite version 1.0.102.0

eFunction f = pair.Value; if ((f == null) || !sqlbase.UnbindFunction(pr, flags)) <<<=== { result = false; } } } Mark Benningfield ___ sqlit

[sqlite] deprecated windows OS calls

s: WarningC4996'GetVersionExA': was declared deprecated sqlite3 WarningC4996'GetVersionExW': was declared deprecated sqlite3 Is this something I should be concerned about with deployment on Windows 8/10 boxes? Mark Benningfield ___ sqlit

Re: [sqlite] Segmentation fault on OpenBSD

) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) ; At least that is what I am passing to Perl's DBD::SQLite prepare() method. I am then binding the following values before running execute: $VAR1 = [ 'Mark Lawrence', 'em...@address.net',

Re: [sqlite] Segmentation fault on OpenBSD

On Tue Nov 01, 2016 at 02:21:02AM +0100, mark wrote: > assertion "0" failed: file "sqlite3.c", line 70020, function > "valueFromExpr" I read the source code a little further and found that the NEVER at line 70020 is actually a macro: if( NEVE

Re: [sqlite] Segmentation fault on OpenBSD

On Mon Oct 31, 2016 at 05:42:32PM -0400, Richard Hipp wrote: > On 10/31/16, mark <no...@null.net> wrote: > > On Mon Oct 31, 2016 at 04:04:00PM -0400, Richard Hipp wrote: > >> Is this reproducible? > > > > Yes... in that I can reliably get it to segfault. Duplica

[sqlite] Partial Indexes and use of LIKE

LIKE to use an index it has to be a full index? Regards, Mark -- Mark Lawrence ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Segmentation fault on OpenBSD

ot;INSERT INTO\nfunc_merge_deltas(\nmerge\n )\nVALUES\n(\n?\n)\n;", pFree = 0x0, pFrame = 0xb148a5c8008, pDelFrame = 0x0, nFrame = 5, expmask = 0, pProgram = 0xb146b8be548, pAuxData = 0x0} -- Mark Lawrence _

Re: [sqlite] Bus Error on OpenBSD

e error: I was keeping (Perl) statement handles around after the database handles had expired. That doesn't mean that there isn't an issue with how DBD::SQLite is using SQLite, but I no longer have the motivation to track down that error when the easy answer to my problem is "don't do that."

[sqlite] Spelling error on current https://sqlite.org/csv.html

Search for "scheam=" to find it. -- Mark Lawrence ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] json1 as loadable extension

>> On 28/09/2016, at 4:22 AM, Mark Woodward <mark.woodw...@chemringts.com> >> wrote: >> >> I've built the JSON1 module as a loadable extension, and this loads fine if >> I >> also compile sqlite myself. This is on windows as x86 (32 bit). >>

[sqlite] json1 as loadable extension

pre built versions do not have symbols. This seems similar to the following SO question http://stackoverflow.com/questions/39319280/python-sqlite-json1-load-extension. Thanks for any help. Mark Follow Us: LinkedIn | Google+ | Twitter |

Re: [sqlite] when to expect "no such table"

On 23/06/16 16:08, Richard Hipp wrote: On Thu, Jun 23, 2016 at 9:54 AM, Mark Brand <mabr...@mabrand.nl> wrote: Hi, Just wondering about the apparent variation among sqlite3 versions and/or configurations with respect to the "no such table" error. In some cases it's enforced

[sqlite] when to expect "no such table"

Hi, Just wondering about the apparent variation among sqlite3 versions and/or configurations with respect to the "no such table" error. In some cases it's enforced at view creation and in others at execution. Mark SQLite version 3.8.7.1 2014-10-29 13:59:56 Enter ".help&q

[sqlite] sqlite3 command line, read-only

right? Can sqlite handle contention among multiple accessors with read/write if the accessors are not on the same host? I.e. is locking intrinsic in sqlite and any accessor from any host is able to determine and set a row/table lock? --Mark -Original Message- > Date: Tue, 26 Apr 2016

[sqlite] sqlite3 command line, read-only

the cron script, not an update to the database. THX --Mark

[sqlite] sqlite3 command line, read-only

ry Purple Category Blue Category,Holidays Personal I *told* you I was obtuse!!! So, I'll use that in combination with the "-cmd timeout=5000" just to be sure a writer doesn't lock me out anyway! Thanks a bunch --Mark -Original Message- Date: Mon, 25 Apr 2016 18:21:33 +0200 Fro

  1   2   3   4   5   6   >