Re: [sqlite] Can I assign negative value to the INTEGER PRIMARY KEY column?

pace compactness issue, and in the OPs case there are only two rows involved, so the impact will be unmeasurably small. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/m

Re: [sqlite] Vacuum into

mal VACUUM copies the new database back over top of itself. It is having to do two complete copies of the database, not just one. So you may well get more than 2x better performance. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@

Re: [sqlite] Was there an announcement of 3.27?

"--stmt", and "--close" to the ".trace" command." > > Is there a discussion of these anywhere ? Not that I know of, apart from the ".help" text in the CLI. -- 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] Vacuum into

___ > 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] GROUP BY and ICU collation

? > > Michael > ___ > 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

Re: [sqlite] Bug due to left join strength reduction optimization?

On 2/6/19, Danny wrote: > This has been fixed by revision d840e. Thanks for the quick response, drh! Just to be clear: Dan found the fix. I merely checked it in. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-us

Re: [sqlite] ISO8601 vs Numeric Timestamp for Date Storage

fractional Julian Day numbers to represent dates and times, according to whichever worked best in that particular application. Since it is easy to convert between them all, this has never been a big problem. -- D. Richard Hipp d...@sqlite.org ___ sqli

Re: [sqlite] althttpd.c CGI Script Requires a Throw Away First Line of Output?

> 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] Custom aggregate functions in Tcl

ish the aggregate function project first. > > Another good follow-on project would be adding support for window > functions. Before I can take that on, I need to gain some experience > using, let alone writing, window functions. > > -- > Andy Goth | >

Re: [sqlite] Custom aggregate functions in Tcl

nctions.html#user_defined_aggregate_window_functions for additional information. -- 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] SEE Temp Files

e on Windows. -- 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] SEE Temp Files

icy> > Marketing > Preferences<http://info.couchbase.com/unsubscribe-or-manage-preferences> > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@s

Re: [sqlite] -wal and -shm files left behind by libsqlite3.dylib

of the SQLite library. -- 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 slow when lots of tables

ading and parsing 20,000 CREATE TABLE statements. -- 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] Skip-scan optimization

On 1/24/19, Gerlando Falauto wrote: > What is the purpose of ANALYZE sqlite_master; ? Causes the content of sqlite_stat1 to be reloaded into the query planner after making out-of-band changes using UPDATE. -- D. Richard Hipp d...@sqlite.org ___ sql

Re: [sqlite] pragma database_list

On 1/24/19, x wrote: > Forgetting the temp db, Is the list guaranteed to be in the same order the > databases were attached in? No There might not be a counter example in the current implementation, but that could change at any moment. -- D. Richard Hipp d...@sqli

Re: [sqlite] Skip-scan optimization

inglists.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] sqlite-src-3260000 tests throw Error: couldn't fork child process: not enough memory

On 1/23/19, Dennis Clarke wrote: > > Perhaps I was mistaken to enable --enable-tempstore=yes during configure ? > Maybe. Does it work if you omit that option? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sql

Re: [sqlite] Request for documentation improvement: transactions

m (https://www.sqlite.org/copyright-release.pdf) again with your complete contact information and send me just an email scan this time, via private email. I will reply with your login credentials for https://sqlite.org/docsrc/ -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Request for documentation improvement: transactions

ements. -- 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 locking problems

't be merged at some > stage, there is no point for me to investigate/test/learn about it. The > opposite is also true, and preferred. "merged at some stage" and "merged into the next release" are different things. The latter will likely not happen, but I cannot say about

Re: [sqlite] Solaris Studio 12.6 compilation failure

Lite you are compiling, the line numbers are meaningless and we cannot investigate. -- 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 locking problems

On 1/19/19, R Smith wrote: > Hi RIchard, any chance this BEGIN CONCURRENT branch will make it into a > next SQLite standard release? You can always pull it from the branch. The branch will not go away. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Database locking problems

E_STDINT_H > sqlite3.o: CPPFLAGS += -DHAVE_FDATASYNC > sqlite3.o: CPPFLAGS += -DHAVE_USLEEP > sqlite3.o: CPPFLAGS += -DHAVE_LOCALTIME_R > sqlite3.o: CPPFLAGS += -DHAVE_GMTIME_R > sqlite3.o: CPPFLAGS += -DHAVE_STRERROR_R > sqlite3.o: CPPFLAGS +

Re: [sqlite] Bug report: Data race in pcache1.c

o, the fix should be pretty simple. Can you please look into this or > should I provide a patch? > > Best regards, > Jan > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org &g

Re: [sqlite] Arrangement of VACUUM, INTEGRITY_CHECK and OPTIMIZE

ses statistics gathered from execution of prior queries on the same database connection, it is pointless to run it until later in the lifecycle of the database connection. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-us

Re: [sqlite] sqlite3_open_v2 and sqlite3_prepare_v2 string lifetimes

ds)? SQLite makes copies. You can free strings after those routine return. -- 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] sqlite3Init null pointer bug

; > Attach is the poc sql file. > I used the following command: > > ./sqlite3 > > sqlite >.read crash.sql > > > -- > Best regards， > Xingwei Lin > ___ > 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] Using sqlite3_interrupt with a timeout

On 1/2/19, James K. Lowden wrote: > > can I call sqlite3_interrupt from a > signal handler? > Yes. It was designed for that very purpose, and more specifically to catch Ctrl-C in the CLI and stop the running query rather than kill off the whole process. -- D. Richard Hipp d..

Re: [sqlite] Documentation error

lite.org/src/timeline?c=0f65a7e2e09f8 -- 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] Thread-Safety of Multi-Thread Connection

d-only feature. Yes to all of the above. -- 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] btree02-110 test failing

> > > > > -- > Sent from: http://sqlite.1065341.n5.nabble.com/ > ___ > 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] ALTER TABLE fails when there is an INSTEAD-OF trigger of a VIEW

der for us to investigate this new problem you are having, please supply us with the VIEW, CREATE TRIGGER, and ALTER TABLE statements that are giving you trouble. -- 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] Unable to import CSV file correctly when using ext/misc/csv.c as the csv module.

-- > > Best regards. > > > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] Typo

; files." > > Should be "... even when presented with ..." IMO. > > Wolfgang > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman

Re: [sqlite] Typo

On 12/25/18, Mike King wrote: > It’s > Christmas Day so surely you deserve a mince pie and a fine single malt :) Sounds great! Send me your address and I'll be right over! ;-) -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Typo

ead of pbIncorrect. > Regards. > ___ > 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

Re: [sqlite] SQLite 3.26.0 recursive CTE performance regression

ance problem. Since you seem to be someone who writes intense SQL, it would be really cool if you could try out that branch and see if it solves or causes any other problems. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] "make test" fails on Mageia Linux v7 x86-64

n using the latest trunk version of SQLite (go to https://www.sqlite.org/src/info/trunk and click on the Tarball link) and then report back whether or not you are still having issues. Thanks. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users m

Re: [sqlite] SQLite 3.26.0 recursive CTE performance regression

reaking the fix. -- 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] Claimed vulnerability in SQLite: Info or Intox?

indeed to give a graceful and helpful response. And we are working hard to make sure that is always the case. As the magellan incident shows, we are not 100% there yet, but we are getting closer every day. -- D. Richard Hipp d...@sqlite.org ___ sqlite

Re: [sqlite] Claimed vulnerability in SQLite: Info or Intox?

ke use of the ability to write directly into shadow tables. For example, when you restore a database using the output of the ".dump" command, that requires writing directly into shadow tables. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mai

Re: [sqlite] Claimed vulnerability in SQLite: Info or Intox?

dditional defense-in-depth measures now. I do not know of any other exploits against FTS3 or SQLite or any other common SQLite extensions. But we are working to make sure no new ones are discovered. -- D. Richard Hipp d...@sqlite.org ___ sql

Re: [sqlite] [Question] Non-EXCLUSIVE modes in dot-file locking strategy

lse know how to implement reader/writer locks using lock files? -- 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] [Question] Non-EXCLUSIVE modes in dot-file locking strategy

e correct me if I'm wrong. > No. Unfortunately, if all you have is the presence or absence of a directory to determine if the file is locked, then that is only one bit of information. And there is no way to encode all the other locking states in

Re: [sqlite] ALTER TABLE, modifying columns

s exactly what you are trying to do when you get the error? -- 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] ALTER TABLE, modifying columns

been having the same problem you are currently having. Had I known in advance that so many people were doing the "incorrect" procedure for making schema modifications, I never would have allowed the recent enhancements to ALTER TABLE that broke it. But I didn't know. And that is now water

Re: [sqlite] Index with calculated value not covering?

t the latter query to use COVERING index. Is there a way to > hint this? > The query planner does not currently implement that 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] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Machine backup

ring when TimeMachine makes its backup, or is occurring when the backed up database is restored? Can you capture some unrestored TimeMachine backups to see if they are corrupt? Can you send us one of your corrupted database files for analysis? -- D. Richard Hipp d...@s

Re: [sqlite] [EXTERNAL] Re: SQLITE gives incorrect results for 'NOT IN' query if partial index exists

o messages from Ms. Sexton are spam. The sender is not a member of the mailing list and so the messages went to moderation. I approved them because they referenced a valid thread, but I think I should have read more closely before clicking the approve button. Sorry. -- D. Richard Hipp

Re: [sqlite] Again https://www3.sqlite.org is down

On 12/12/18, Domingo Alvarez Duarte wrote: > Hello Richard ! > > It seems that https://www3.sqlite.org is down for a few days. Fixed now. Thanks for the report. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sql

Re: [sqlite] SQLITE gives incorrect results for 'NOT IN' query if partial index exists

rpreter by typing ./configure; make testfixture Or on windows: nmake /f Makefile.msc testfixture.exe Then you say "./testfixture test/index6.test" to run that particular test file. -- D. Richard Hipp d...@sqlite.org ___ sqlit

Re: [sqlite] SQLITE gives incorrect results for 'NOT IN' query if partial index exists

to the > partial index expression, with the result is doing a NOT IN over it returns > incorrect results. > > - Deon > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org >

Re: [sqlite] Segmentation fault when using window function with (nested?) subquery

is an issue with the byte-code generator for window functions. If you run with assert()s enabled, it hits an assert() early on. This problem has existed ever since window functions were added in version 3.25.0. It is not something new to 3.26.0. -- D. Richard Hipp d..

Re: [sqlite] Allow inclusion of generate_series function

te to add things that grow the size of the library unless there is a compelling need. -- 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] Support function_list in pre-built binaries from SQLite download page

On 12/4/18, Dominique Devienne wrote: > Wrong pragma never give errors AFAIK, That is how pragmas are designed to work, yes. Unknown pragmas are silently ignored. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-us

Re: [sqlite] geopoly_contains_point(P,X,Y) doc is overly modest

a language that behaves as the underlying hardware > (CPU) behaves). Yeah, but Mr. Damon is probably right that the documentation should be more precise. So I have now updated it. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@m

Re: [sqlite] geopoly_contains_point(P,X,Y) doc is overly modest

ecause I wanted to leave myself some wiggle room in case I need to change the behavior in the future. -- 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] function named geopolyCosine is a misnomer

On 12/1/18, John G wrote: > Is there any documentation on the > geopoly extension? > https://www.sqlite.org/search?s=d=geopoly https://www.sqlite.org/geopoly.html -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sql

Re: [sqlite] sqlite3_bind_text() and WHERE x IN (?)

/printf.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] Detecting erroneous multi-row subqueries

On 11/29/18, J. King wrote: > Is it possible to make SQLite fail like > PostgreSQL does? That is possible in theory, but how many of the millions of existing applications would that break? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users m

Re: [sqlite] Boosting insert and indexing performance for 10 billion rows (?)

sqlite3_analyzer your-big-file.db >analysis.txt Then copy/paste analysis.txt into an email to this list. -- 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] function named geopolyCosine is a misnomer

unk, is in the latest "prerelease snapshot", and will appear in the next official release (which will also be the first official release that includes the new capability). -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Strange query result

On 11/29/18, Maurice van der Stee wrote: > This returns 0 rows: > > select config_flags from config where (config_flags & > WANTED_FLAG) = WANTED_FLAG. Can you provide a concrete example - something we can actually run in the sqlite3 command-line shell? -- D. Richard Hipp

Re: [sqlite] Crashes in SQLite Version 3.19.3

; when system is under stress. I think due to that this crash is not easily > reproducible. > 3) We have tried several ways to reproduce but are not able to reproduce. > > Any suggestions on reproducing this issue is welcome. > Please let me know if this is known issue (did not find any reference) or > need any further details from the core. > > Thanks > Ashish > ___ > 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 bug in Alter Table

; for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> select DATE'1998-12-25'; Error: no such column: DATE sqlite> select DATE '1998-12-25'; Error: no such column: DATE sqlite> -- D. Richard Hipp d...@sql

Re: [sqlite] Possible bug in Alter Table

I will also add a "warning" mechanism to alert programmers to gotchas like this in some subsequent release, though there probably is not time to get warnings in to the forthcoming 3.26.0 release. -- D. Richard Hipp d...@sqlite.org ___ sqlite

Re: [sqlite] [EXTERNAL] Re: WAL file size increase

might be causing it. Can you perhaps provide a SQL script that runs in the command-line shell that will reproduce the problem? If not, can you provide source code to a short program that will reproduce the problem? -- D. Richard Hipp d...@sqli

Re: [sqlite] PRIMARY KEY not enforcing NOT NULL, WITHOUT ROWID default - suggestions

a new database connection opens the database file. This can lead to compatibility problems if the meaning of a CREATE TABLE statement is somehow affected by PRAGMAs. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite

Re: [sqlite] Documentation wording problem

satile and reliable database software. > > Nayuki > ___ > 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

Re: [sqlite] 'Database table is locked' error with libgpkg and SQLite >= 3.24.0

of one of the ORDER BY terms. Perhaps: "ORDER BY +rowid". Adding an ORDER BY in this way will fix the problem because it will run the entire R-Tree query to completion, storing the results in a buffer for sorting, prior to returning any rows.

Re: [sqlite] Creating and dropping tables with multiple connections

table still exists, and thus throws the error. If you proceed the CREATE TABLE by some other SQL that does require reading the database files (example: "SELECT 1 FROM sqlite_master LIMIT 1") then sqlite3_prepare_v2() will know that the table has been deleted and will work as you e

Re: [sqlite] geopoly - rules re data entry

3.25.3) Please download and try the prerelease snapshot from https://sqlite.org/download.html as both issues should now be fixed. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sql

Re: [sqlite] geopoly - rules re data entry

eoJSON files do not follow the rules and put polygon vertexes in CW order. I suppose it can also be used after geopoly_xform() to make sure that the vertexes are in the correct order there, too. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Bug: Incorrect fsdir result

_________ > 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

[sqlite] Spam on the sqlite-users mailing list

vulnerability in Mailman that allows posts for non-subscribers? I don't know. I am continuing to monitor the situation and will take corrective action as soon as I can figure out what that action is. In the meantime, please ignore the spam. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Shell page cache option not working (?)

some systems. (Hint: Unless you are working on a safety-critical embedded system, this probably is not important to 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] WAL file size increase

endent systems. -- 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 Crash in sqlite3DbMallocRawNN.

0f8dbc in NMedia::CMediaPlayer::importPlayListWork (this=0x329c70, > worker=0x32ecd8, job=0x497c88) > at > /home/jenkins-build/workspace/0EP21_SOP_Compile/ZXQ/workspace/multimedia/common/source/player/CMediaPlayer.cpp:452 > #16 0x0010a848 in CMethodJob::run (this=0x497c88, > worker=0x32ecd8) at

Re: [sqlite] Problem with https://www3.sqlite.org

On 11/10/18, Domingo Alvarez Duarte wrote: > Hello Richard ! > > It seems that you have a problem again with https://www3.sqlite.org for > several days now. > > It can't be reached. Thanks. Rebooted now and working again. -- D. Richard Hi

Re: [sqlite] Segmentation Fault When Using Window Function

to debug it. -- 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] Segmentation Fault When Using Window Function

cord); /* Jump here when skipping the initialization */ sqlite3VdbeJumpHere(v, addrInit); -- 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] Segmentation Fault When Using Window Function

On 11/8/18, J. King wrote: > On 2018-11-08 16:05:11, "Richard Hipp" wrote: > >>In case you are not following the ticket at >>https://www.sqlite.org/src/tktview/787fa716be3a7f650cac1b1413f12f95f5e7639d, >>we have simplified the test case to the following: >&g

Re: [sqlite] Segmentation Fault When Using Window Function

t; nVmStep = 291 > nProgressLimit = 4294967295 > aMem = (Mem *) 0x16ae544184b0 > pIn1 = (Mem *) 0x16ae54418600 > pIn2 = (Mem *) 0x16ae544187f8 > pIn3 = (Mem *) 0x16ae54418590 > pOut = (Mem *) 0x16ae54418a60 > > If other gdb information would be helpful, please let me know. > > Thanks,

Re: [sqlite] about upsert feature.

ror. > I think we can't use upsert-clause with select-stmt. > Is this thought right? Does your select-stmt include a WHERE clause? It should, even if it is a no-op like "WHERE true". Try adding the WHERE clause and let us know if that fixes your p

Re: [sqlite] json_each() in a table trigger for an 'attached' db causes an error

Please try your test script on the latest trunk check-in and let us know whether or not it is working for you. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

Re: [sqlite] json_each() in a table trigger for an 'attached' db causes an error

On 11/2/18, Lindsay Lawrence wrote: > Has anyone else run into this issue? I can confirm that it is an issue and that we are working on it. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org h

Re: [sqlite] Sqlite intarray issue

rray.html The intarray virtual table predates the ability to have table valued functions in SQLite. Intarray continues to be used for testing purposes but is no longer recommended for production use. I have added a warning to this effect in the header comment. -- D. Richard Hipp d...@s

Re: [sqlite] SQLite for datalogging - best practices

You would have multiple database files in play at any given moment, and you would need to query across all of them using a UNION ALL query, or something similar. Partitioning would probably do about the same thing, just with more convenient syntax. -- D. Rich

Re: [sqlite] Database identified as zip

ed. That bug is fixed with check-in https://www.sqlite.org/src/info/7989bbda70a24611 -- 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 identified as zip

On 10/30/18, Dingyuan Wang wrote: > > Is this considered a bug? Should be fixed on trunk, now. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/m

Re: [sqlite] Database identified as zip

Perhaps we should only look for the EOCD record at the end of the file if the file does not begin with the proper SQLite database prefix. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sql

Re: [sqlite] SQLite for datalogging - best practices

umstances -- even with F2FS since reads can be happening in parallel. > Am I missing something? It sounds to me like you understand it. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mai

Re: [sqlite] How to use SQLite Encryption Extension in Oracle MAF app

you know how to compile public-domain "sqlite3.c" into your application, switching over to SEE is simple. After acquiring a one-time license for your development team, simply substitute the SEE-enabled "sqlite3.c" source file for the public-domain "s

Re: [sqlite] curious discovery about geopoly module

quot;SELECT sqlite_source_id();" Are you certain that you enabled GeoPoly when you built your custom DLL? Remember that GeoPoly is an extension that defaults off. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists

Re: [sqlite] SQLite for datalogging - best practices

are true or not and they are rare in any event, but F2FS is relatively new technology (compared to EXT4) so there *might* still be some obscure problems on optimized code paths. Having the WAL file on a ramdisk could result in database corruption if you take a power failure in the middle of a

Re: [sqlite] Invalid results on join and duplicate where clause (in-memory db only)

omehow using a different (older) version of SQLite that predates the problem when accessing database file from disk? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mail

Re: [sqlite] Regarding CoC

? -- 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] Invalid results on join and duplicate where clause (in-memory db only)

. Sebastian: Presumably this problem arose for you in a much larger and more complex application. Can you please apply the patch from the check-in above (or recompile using the latest trunk version of SQLite) and verify for us that this fixes the problem for you? On 10/25/18, Richard Hipp wrote

Re: [sqlite] Invalid results on join and duplicate where clause (in-memory db only)

the first to change into "1=1". This can only happen if there are two or more "x.b=" constraints in the WHERE clause, which is apparently not one of the millions of test cases in our test suite. (It will be soon!) -- D. Richard Hipp d...@sqlite.org

<    1   2   3   4   5   6   7   8   9   10   >