Re: [sqlite] Tcl sqlite3 bindings - NULL handling in `$db eval $sql array { ... }`

ing analogous in sqlite3 but it’s possible I’m missing > something. The "db nullvalue STRING" command lets you translate NULL values into the string value of your choice. But there is not (currently) a way to cause NULL values to unset the corresponding me

Re: [sqlite] sqlite3 interactive shell failed assertions and segmentation faults

; sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] User Authentication Extension is broken in 3.19 branch

their support contract, so we have never bothered to properly document or test that extension, nor maintain it. What are you using it for? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mail

Re: [sqlite] Bug Report: https://www.sqlite.org/chronology.html out of date

t; sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Possible issue with 3.19.3

optimization. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Possible issue with 3.19.3

On 6/20/17, Eric Sink <e...@sourcegear.com> wrote: > > Would it be appropriate for me to send the database file to someone for > further investigation? > Yes, please. Send the database directly to me via private email. -- D. Richard Hi

Re: [sqlite] unusual but trivially reproducible bug

> sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 3.18, 3.19 branches

om 3.19.3. Some release managers are more comfortable shipping with 3.18.2 than with 3.19.3. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] imposter tables

pt the database. If you feel you ust use them, do so with with great care. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Daisy: A private blockchain where blocks are SQLite databases

See https://github.com/ivoras/daisy I have no connection with Daisy and am not endorsing it. I just thought it was interesting and wanted to share it with the wider SQLite community. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Outputting to CSV - row is not quoted when there are no spaces

rack:5vlDIGBTQmlyfERBnJOnbJ","Kiso","Circles",100.019 > > Thanks! > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >

Re: [sqlite] INTEGER PRIMARY KEY

ackwards compatibility - even with bugs like this. > -- > Scott Robison > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman

Re: [sqlite] invalid column constraint ignored

adays has fallen out of favor. It cannot be changed now because doing so might break some of the millions of applications that were written against SQLite over the past nearly two decades and which make use of SQLite's liberal parsing policies. -- D. Richard Hipp d...@s

Re: [sqlite] sqlite.org port 80 - can't connect

lite.org. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Something broke between version 3.15 and 3.19.3

n. The fix is here: https://www.sqlite.org/src/timeline?c=87aceb417a813a29 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] parser.y and SQLITE_OMIT_ATTACH

nm(X). {sqlite3Vacuum(pParse,);} > %endif SQLITE_OMIT_ATTACH > %endif SQLITE_OMIT_VACUUM > > Regards. > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cg

Re: [sqlite] Something broke between version 3.15 and 3.19.3

atience and kill the process with a ctrl-c. Thanks for the test case! Bisecting shows that the problem is the optimization introduced here: https://www.sqlite.org/src/timeline?c=9e35c89dbe744312 I still do not understand the details. But we'll be working on it. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] 3.11.0: Tcl sqlite3 extension can't do variable interpolation _and_ json_extract

Even if I make the JSON path its own variable and do the same, it fails: > > % set json_path {$.hash} > $.hash > % mydb eval {SELECT json FROM NotImportant WHERE json_extract(json, > $json_path) = $hash} > % > > So I'm kind of at a loss. > -- D. Richar

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

On 6/9/17, Mark Brand <mabr...@mabrand.nl> wrote: > > > 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

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

reate temp table t (x); > insert into temp.t values (0); > > update main.t set x = 0; > > update v set x = 1; > > select 'main', * from main.t > union select 'temp', * from temp.t; > > /* > main|0 > temp|1 > */ > > _

Re: [sqlite] Verison 3.19.2 no longer opens my database

leName value will return SQLITE_MISUSE - which is non-zero, but which should also be a clue that you are doing something wrong. I will update this documentation to make it clear that the table name parameter to sqlite3_table_column_metadata() may not be null. -- D. Richard Hipp d..

Re: [sqlite] SQLiteBlob.Create failing "No RowId is available"

____ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 3.11.0: Tcl sqlite3 extension can't do variable interpolation _and_ json_extract

ument to the eval method inside of curly brances. Please go back through all your code and fix that. Now. It's important. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Version 3.19.3 containing an important bug fix

ssil sql" command to activate auto_vacuum mode, in which case Fossil would be affected. But I've never heard of anybody actually doing that. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://m

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

n won't help there. And, database encryption requires no special privileges. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Version 3.19.3 containing an important bug fix

On 6/8/17, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote: > On Thu, 8 Jun 2017, Richard Hipp wrote: >>> >>> We are using 3.17.0 (under Linux on 32-bit MIPS) and have been getting >>> a database is corrupted report (as reported earlier to this

Re: [sqlite] Verison 3.19.2 no longer opens my database

ted. > > Cheers > > Martin > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

aterializations of views and subqueries are not encrypted. I recommend you set "PRAGMA temp_store=MEMORY" so that those objects are never written to disk. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-

Re: [sqlite] Version 3.19.3 containing an important bug fix

On 6/8/17, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote: > On Thu, 8 Jun 2017, D. Richard Hipp wrote: > >> A bug in the auto_vacuum logic for SQLite versions 3.16.0 through >> 3.19.2 can (rarely) lead to database corruption. SQLite version >> 3.19.3 has just

[sqlite] Version 3.19.3 containing an important bug fix

any database inconsistencies that might have been introduced by this bug. If you encounter any problems with this release, please send email to sqlite-users@mailinglists.sqlite.org or directly to me. Thanks. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Unnecessary calls to sqlite3AddColumn during ALTER TABLE ADD COLUMN

reparse, but that would add complexity and the resulting speed increase would be too small to measure. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Minor typo in SQLite documentation

g > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

ite source code, put it on github, and start your own fork. You can then add whatever new SQL commands you want. At this point, your chances of getting us to do your work for you are very close to zero. -- D. Richard Hipp d...@sqlite.org ___ sqlite-use

Re: [sqlite] WAL checkpoint starved?

On 6/7/17, Daniel Polski <dan...@agelektronik.se> wrote: > > > Den 2017-06-07 kl. 15:02, skrev Richard Hipp: >> On 6/7/17, Daniel Polski <dan...@agelektronik.se> wrote: >>> Does the [TRUNCATE] checkpoint call lock out new requests which might >>> p

Re: [sqlite] WAL checkpoint starved?

her connections new read/write requests during > the timeout while the checkpointing is running..? Readers proceed normally. Writers fail with an SQLITE_BUSY errors. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@maili

Re: [sqlite] WAL checkpoint starved?

On 6/5/17, Daniel Polski <dan...@agelektronik.se> wrote: > > > Den 2017-06-02 kl. 16:07, skrev Richard Hipp: >>> >>> and I thought that SQLITE_CHECKPOINT_TRUNCATE would force the checkpoint >>> to completion. >> Do you have a busy callback

Re: [sqlite] WAL checkpoint starved?

e to make them happen more often than default, and be called > from a specific thread. Do you have a busy callback handler registered (https://sqlite.org/c3ref/busy_handler.html) and are you checking the return code from sqlite3_wal_callback_v2()? -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] documentation flaws

On 6/2/17, Rob Golsteijn <rob.golste...@mapscape.eu> wrote: > > I found 2 flaws in the online documentation: > Should be fixed now. Thanks for the report. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing li

Re: [sqlite] [patch] configure.ac: wrong braces in appending OPT_FEATURE_FLAGS

On 6/2/17, Yuriy M. Kaminskiy <yum...@gmail.com> wrote: > While running configure, I noticed some noise about `OPT_FEATURE_FLAGS: > command not found`. I attempted to fix this problem in check-in https://www.sqlite.org/src/timeline?c=43ce3bd3 - Did I miss something? -- D. Ri

Re: [sqlite] Segfaults from lemon program

not the Lemon-generated parser, of course.) This is the right place to report bugs in Lemon. But AFL-induced segfaults do not seem like something we would be inclined to fix, though I do reserve the right to change my mind after seeing the bug. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Does prepare do arithmetic?

o. But I don't think it would make much difference in most applications, so it is not a huge priority. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SELECT WHERE with RTREE and second condition slow

PO Box 81244 > ** Windhoek, Namibia > ** http://www.quovadis-gps.com > ** mail t...@qvgps.com > ** +264 (0)81 3329923 > ** +49 (0)6182 8492599 > ***/ > _______ > sqlite-users mailing list > sqlite-users@mailinglists.

Re: [sqlite] Sqlite Linux support

On 5/29/17, Radhakant Kumar <radhakantku...@gmail.com> wrote: > if I get same version on Linux > as Precompiled binaries it might help me. That is what the "Precompiled Binaries For Linux" on the https://sqlite.org/download.html page is for. -- D. Richar

Re: [sqlite] 24hrs Formate Issue

8:56:00.because end user don't know whether > 08:56:00 Am or Pm. > Perhaps convert your data to 24-hour format like this: UPDATE yourtable SET Ts = CASE WHEN Ts LIKE '%PM' THEN datetime(trim(Ts,'PM '), '+12 hours')

Re: [sqlite] Does prepare do arithmetic?

the inner loop. The very last opcode of the expression is retained in the inner loop in order to refresh the result. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Does prepare do arithmetic?

once, and only the final "<<" operator is repeated for each row. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SELECT WHERE with RTREE and second condition slow

ois WHERE styleid IN > 1351,1362,1371,1374,1376,1542,1595,1597,1643,1762 > > is also slow for the first call. The second call is fast. > > (Using SQLite Expert Professional 3.5 for testing). > > Any ideas, how to speed this up? Have you tried running ANALYZE on your database?

Re: [sqlite] SELECT WHERE with RTREE and second condition slow

PO Box 81244 > ** Windhoek, Namibia > ** http://www.quovadis-gps.com > ** mail t...@qvgps.com > ** +264 (0)81 3329923 > ** +49 (0)6182 8492599 > ***/ > _______ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.o

Re: [sqlite] Memory Issue - GLOBs and Windows Active Mapped File

LE_FLAG_RANDOM_ACCESS but found that it made things run slower in our tests. That would have been years ago though - things might have changed since then. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailing

Re: [sqlite] C API: which calls have the biggest chance of latency?

s microseconds - SQLite's parser will normally churn though 100K or more SQL statements per second - but it can be longer depending on how big the schema is. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mai

Re: [sqlite] caching sqlite3_db_mutex()

in the early morning, before coffee!) -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite 3.16.3 crash on insert

sh is NOT so nice and it is better to recreate pSeqTab. > > > regards > > > > > > > -- > > Powersoft logo <http://www.powersoft.it> > > *Michele Dionisio |*Embedded System Manager > > *skype:* m.dionisio *| email:* michele.dioni...@powersoft.it &g

Re: [sqlite] Regarding Sqlite DB Index

what MySQL or Postgres would call a "hash join".) Do not be confused by these two completely different meanings for the term "automatic index". -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite3.Step fast forward / skipping rows

gh the 110th rows of the result, run: SELECT * FROM res WHERE rowid BETWEN 100 AND 110; Remember to "DROP TABLE res" when you are done. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org htt

Re: [sqlite] msvc.h

that file just prior to release and adding it seemed the safest thing to do. I plan to remove it again for the next release. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlit

Re: [sqlite] Tiny typo in doc.

On 5/22/17, Donald Griggs <dfgri...@gmail.com> wrote: > http://www.sqlite.org/releaselog/3_19_0.html > > "containing two ore more" > Thank you. And since "ore" is a real word, the spelling checker didn't catch this. :

Re: [sqlite] auntondex with unique and integer primary key

d be great, if we had caught the problem 15 years ago. But now, we have to keep the databases backwards compatible, and omitting the index would generate an incompatible database file. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mail

Re: [sqlite] Thank you for your work

that we did something right :-) -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bulk load strategy

e interval without any success. > > Anyone have any other suggestions? > > Thanks guys, > jlc > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sql

Re: [sqlite] Bulk load strategy

ll not be using ROLLBACK. Put the entire bulk load inside a single transaction, and make the cache as big as you can, depending on the amount of RAM you have on your system. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mai

Re: [sqlite] -shm and -wal files left after trivially simple select statement from command line

On 5/15/17, Richard Hipp <d...@sqlite.org> wrote: > On 5/15/17, Rob Willett <rob.sql...@robertwillett.com> wrote: >> >> As part of the testing we noticed that -shm and -wal files were being >> left after we used sqlite3 on the command line. This puzzled us as w

Re: [sqlite] -shm and -wal files left after trivially simple select statement from command line

ng ended. Are you inserting a ".quit" command? Are you somehow causing the shell to terminate prematurely, perhaps by piping the output into a filter (such as "head") that closes the input connection early? What version of the SQLite shell is running? What is the query

[sqlite] Version 3.19.0 about to enter testing

/checklists/319/index The release will occur when the checklist goes all-green. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Proposition: introduce a new SQLITE_READ_TABLE Authorizer Action Code

e referenced but not used. Also, the documentation has been updated to clearly state that any of the string arguments to the authorizer callback may be NULL. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sql

Re: [sqlite] Proposition: introduce a new SQLITE_READ_TABLE Authorizer Action Code

On 5/11/17, Clemens Ladisch <clem...@ladisch.de> wrote: > Richard Hipp wrote: >> ** ^When a table is referenced by a [SELECT] but no column values are >> ** extracted from that table (for example in a query like >> ** "SELECT count(*) FROM tab") then

Re: [sqlite] Corrupt index == disk full?

USIVE" and SQLite will use heap-memory for the SHM the SQLITE_SHM_DIRECTORY compile-time option will become irrelevant. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Proposition: introduce a new SQLITE_READ_TABLE Authorizer Action Code

-scm.org/fossil/artifact/ee53ffbf7?ln=161-221) continues to work fine, and with the enhanced SQLITE_READ, no prevents users from creating a report using SELECT count(*) FROM user That returns the number of users, for example. The fix is implemented by https://www.sqlite.org/src/timeline?c=92ab1f72

Re: [sqlite] how to run the SQLite test suite ?

plicitly trust their C compilers. In fact, both Apple and Google do their own builds of SQLite for MacOS/iOS and Android that use the SQLITE_UNTESTABLE (https://www.sqlite.org/compile.html#untestable) compile-time option, thereby preventing you from completely testing the machine code even if you w

Re: [sqlite] The cli truncates values containing null chars

On 5/9/17, Jens Alfke <j...@mooseyard.com> wrote: > > It has always annoyed me that the CLI just dumps blobs directly to stdout. Have you tried setting ".mode quote"? Perhaps add that to your ~/sqlite.rc file? -- D. Richar

Re: [sqlite] PRAGMA optimize after VACUUM results in Error: database schema has changed

0b35ffea8df which has not yet appeared in an official release. You can use the "prerelease snapshot" on the website until version 3.19.0 appears. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Column alignment wrong when using multibytr characters

e.org/src/timeline?c=f508aff8d1782abdff4d which has not yet appeared in an official release. But you can download the "Pre-release snapshot" from the website and use it. -- D. Richard Hipp d...@sqlite.org ___ sqlite-use

Re: [sqlite] Catching run-away queries

stop the long-running query? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite log - automatic index on sqlite_sq_25FA456860(ID) (284)

looks > like internal and temporary. What can I interpret from these? Yes. Those sqlite3_sq_... tables are going to be materializations of views and/or subqueries. The "sq" stands for "subquery". -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Duplicate and Missing results using an IN operator in the WHERE clause

; date on the ticket is 2017-04-24. Have you tried the "prerelease snapshot" from https://www.sqlite.org/download.html with a date of 2017-05-02? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] obscure bug: duplicate rowid after insert or replace

> ; > REPLACE INTO t VALUES > (NULL, 'generates row 2'), > (1, 'replaces row 1') > ; > Thanks for the bug report. This should now be fixed on trunk. The ticket is https://www.sqlite.org/src/info/f68dc596c4 -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] obscure bug: duplicate rowid after insert or replace

On 5/1/17, Richard Hipp <d...@sqlite.org> wrote: > > What were you expecting this to do? > Never mind. After actually running the test case, I see that it gives an assertion fault. We're working on it. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] obscure bug: duplicate rowid after insert or replace

INTO t VALUES > (NULL, 'generates row 2'), > (1, 'replaces row 1'); What were you expecting this to do? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.or

Re: [sqlite] Unary + isn't disabling use of index

you run ANALYZE and send us a dump of the sqlite_stat1 table? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] -shm grows with large transaction

On 4/26/17, Richard Hipp <d...@sqlite.org> wrote: > That would imply you are changing about a > half million pages of your database inside a single transaction. Correction: About 5 million pages. Missed a zero. (Time for coffee, I guess) -- D. Richard Hipp d..

Re: [sqlite] -shm grows with large transaction

half million pages of your database inside a single transaction. What is your page size, and how big does the -wal file get? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.

Re: [sqlite] Lemon-generated parser gives an assertion failure

ype==REDUCE || ap->type==SHIFTREDUCE ){ > 4164 ap->x.rp->doesReduce = i; > 4165} > 4166 } > 4167} > Well done. I fear that you have had to learn more about Lemon and LALR(1) parsing than perhaps you really ever wanted

Re: [sqlite] RTree and foreign keys

does not. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE AIX Driver

Rathnakumar P > Cell: +1 918 815 3229 > Phone: 918 977 5190 > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d.

Re: [sqlite] Build error in SQLite 3.18 if SQLITE_UNTESTABLE is defined

KG > Geschaeftsfuehrer: Robert Bauer > Sitz der Gesellschaft: 86368 Gersthofen > Registergericht: Amtsgericht Augsburg HRA 14521 > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org

Re: [sqlite] Security vulnerabilities prevalent in web tutorials for PHP, javascript, etc..

to make the TCL interface work better. Remember: SQLite is a TCL extension that escaped into the wild. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Security vulnerabilities prevalent in web tutorials for PHP, javascript, etc..

ess likely to make an SQL injection error by mistake. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database disk in malformed.

lem description is too vague for us to assist you. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] json_tree virtual table -- on disk or in memory?

strings that storing the entire string in memory at once is a problem? > > Is there any way to measure the size of this table? > Do you mean, how much memory does it use? You might use the sqlite3_memory_used() interface before and after starting the virtual table in order to figure th

Re: [sqlite] performing an UPDATE on a table-valued function

the past. I'm trying to do better. New features need to be a clear win before they are accepted. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_OMIT_* vs amalgamation

a C compiler and the ordinary tools. On unix, just run "./configure; make". On Windows with MSVC the command is "nmake /f makefile.msc" -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-us

Re: [sqlite] Database corruption, and PRAGMA fullfsync on macOS

on MacOS, just as we have had to do for OpenBSD. Thanks for letting us know that this is a problem. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database corruption, and PRAGMA fullfsync on macOS

d in section 2.4 of https://www.sqlite.org/howtocorrupt.html -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] strange behaviour on sqlite shell output…

ld width and precision of a printf() format are measured in bytes, not characters, and if the input is multi-byte UTF then it is possible for a single character to be cut in half, resulting in goofy output. I checked in a fix for this yesterday. See https://www.sqlite.org/src/timeline?c=f508aff8

Re: [sqlite] SQLite CVE-2015-6607 (Escalation of privilege issue )

can do harmful things. My response to this is "Duh!" -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite CVE-2015-6607 (Escalation of privilege issue )

that gives untrusted users the ability to run unvetted SQL. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite CVE-2015-6607 (Escalation of privilege issue )

igure out what it has to do with SQLite based on the link above. My assumption this is some kind of bug in the Android interface to SQLite, not in SQLite itself. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailing

Re: [sqlite] performing an UPDATE on a table-valued function

gest is a good idea is a different matter. I'm skeptical. A function is typically not an l-value and is hence not typically something that can be modified. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database corruption, and PRAGMA fullfsync on macOS

On 4/16/17, Richard Hipp <d...@sqlite.org> wrote: > I cannot seem to find the implementation for COLLATE JSON anywhere in > your source code. Can you give me a hint as to which source file I > should be looking in? I worked around the "COLLATE JSON" problem (by writ

Re: [sqlite] Database corruption, and PRAGMA fullfsync on macOS

ings I could try to resolve this problem would be greatly > appreciated by me and my customers. > > Thanks, > > Brendan Duddridge > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/

Re: [sqlite] Threadsafe and _config() question

On 4/15/17, Simon Slavin <slav...@bigfraud.org> wrote: > Suppose I compile a copy of SQLite3 with SQLITE_THREADSAFE = 0. > > Then suppose I execute > > sqlite3_config(SQLITE_CONFIG_SERIALIZED) > > Would I get an error back ? Yes. Did you try it? -- D. R

<    7   8   9   10   11   12   13   14   15   16   >