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

2019-01-09 Thread Richard Hipp
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

2019-01-09 Thread Richard Hipp
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

2019-01-05 Thread Richard Hipp
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

2019-01-04 Thread Richard Hipp
; > 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

2019-01-02 Thread Richard Hipp
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

2019-01-02 Thread Richard Hipp
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

2018-12-31 Thread Richard Hipp
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

2018-12-27 Thread Richard Hipp
> > > > > -- > 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

2018-12-26 Thread Richard Hipp
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.

2018-12-26 Thread Richard Hipp
-- > > Best regards. > > > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] Typo

2018-12-26 Thread Richard Hipp
; 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

2018-12-25 Thread Richard Hipp
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

2018-12-25 Thread Richard Hipp
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

2018-12-24 Thread Richard Hipp
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

2018-12-22 Thread Richard Hipp
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

2018-12-22 Thread Richard Hipp
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?

2018-12-20 Thread Richard Hipp
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?

2018-12-19 Thread Richard Hipp
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?

2018-12-18 Thread Richard Hipp
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

2018-12-15 Thread Richard Hipp
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

2018-12-15 Thread Richard Hipp
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

2018-12-12 Thread Richard Hipp
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

2018-12-12 Thread Richard Hipp
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?

2018-12-12 Thread Richard Hipp
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

2018-12-12 Thread Richard Hipp
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

2018-12-12 Thread Richard Hipp
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

2018-12-12 Thread Richard Hipp
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

2018-12-08 Thread Richard Hipp
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

2018-12-08 Thread Richard Hipp
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

2018-12-06 Thread Richard Hipp
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

2018-12-04 Thread Richard Hipp
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

2018-12-04 Thread Richard Hipp
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

2018-12-01 Thread Richard Hipp
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

2018-12-01 Thread Richard Hipp
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

2018-12-01 Thread Richard Hipp
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 (?)

2018-11-30 Thread Richard Hipp
/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

2018-11-29 Thread Richard Hipp
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 (?)

2018-11-29 Thread Richard Hipp
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

2018-11-29 Thread Richard Hipp
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

2018-11-29 Thread Richard Hipp
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

2018-11-26 Thread Richard Hipp
; 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

2018-11-26 Thread Richard Hipp
; 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

2018-11-26 Thread Richard Hipp
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

2018-11-26 Thread Richard Hipp
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

2018-11-26 Thread Richard Hipp
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

2018-11-26 Thread Richard Hipp
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

2018-11-21 Thread Richard Hipp
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

2018-11-20 Thread Richard Hipp
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

2018-11-18 Thread Richard Hipp
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

2018-11-17 Thread Richard Hipp
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

2018-11-16 Thread Richard Hipp
_________ > 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

2018-11-15 Thread Richard Hipp
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 (?)

2018-11-15 Thread Richard Hipp
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

2018-11-13 Thread Richard Hipp
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.

2018-11-13 Thread Richard Hipp
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

2018-11-10 Thread Richard Hipp
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

2018-11-09 Thread Richard Hipp
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

2018-11-09 Thread Richard Hipp
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

2018-11-08 Thread Richard Hipp
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

2018-11-08 Thread Richard Hipp
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.

2018-11-07 Thread Richard Hipp
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

2018-11-02 Thread Richard Hipp
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

2018-11-02 Thread Richard Hipp
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

2018-10-31 Thread Richard Hipp
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

2018-10-30 Thread Richard Hipp
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

2018-10-30 Thread Richard Hipp
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

2018-10-30 Thread Richard Hipp
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

2018-10-30 Thread Richard Hipp
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

2018-10-30 Thread Richard Hipp
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

2018-10-30 Thread Richard Hipp
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

2018-10-30 Thread Richard Hipp
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

2018-10-29 Thread Richard Hipp
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)

2018-10-26 Thread Richard Hipp
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

2018-10-26 Thread Richard Hipp
? -- 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)

2018-10-25 Thread Richard Hipp
. 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)

2018-10-25 Thread Richard Hipp
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

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

2018-10-25 Thread Richard Hipp
> Regards > Sebastian > ___ > 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] Regarding CoC

2018-10-24 Thread Richard Hipp
simple as renaming the offensive "Code of Conduct" to "Code of Ethics", thus avoiding the name-of-special-significance, then drop in a pre-packaged CoC in place of the one that became the CoE, and all is well. Took less than 5 minutes once I figured out what t

Re: [sqlite] codeblocks thing happens when using codeblocks to compile sqlite with geopoly

2018-10-24 Thread Richard Hipp
POLY from the "PRAGMA compile_options" command. -- 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] Regarding CoC

2018-10-22 Thread Richard Hipp
On 10/19/18, Simon Slavin wrote: > > Yeah, that's gonna magically appear on Hacker News within the month. For > those curious ... It even made TheRegister: https://www.theregister.co.uk/2018/10/22/sqlite_code_of_conduct/ -- D. Richard Hipp d...@s

Re: [sqlite] Regarding CoC

2018-10-22 Thread Richard Hipp
ues in a way that modern twitter-ites can better understand, so do not hesitate to speak up if you have a plan. -- 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] Regarding CoC

2018-10-22 Thread Richard Hipp
On 10/19/18, Simon Slavin wrote: > > Yeah, that's gonna magically appear on Hacker News within the month. For > those curious ... > Looks like that happened this morning. https://news.ycombinator.com/item?id=18273530 -- D. Richard Hipp d..

Re: [sqlite] R*Tree performance

2018-10-22 Thread Richard Hipp
work on 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] help, sqlite3_get_table return 21,

2018-10-22 Thread Richard Hipp
n that breakpoint is hit. -- 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_ENABLE_DBSTAT_VTAB

2018-10-22 Thread Richard Hipp
o changes in processor cache behavior, but that differences is way, way down in the noise. -- 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] geopoly data input options

2018-10-19 Thread Richard Hipp
to me... Where can I find information about WKB? -- 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] geopoly data input options

2018-10-19 Thread Richard Hipp
ry format is smaller and faster. -- 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] Regarding CoC

2018-10-19 Thread Richard Hipp
to be a trendy thing nowadays.) So I looked around and came up with what you found, submitted the idea to the whole staff, and everybody approved. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.

Re: [sqlite] How to round to an Integer

2018-10-18 Thread Richard Hipp
On 10/18/18, John Harney wrote: > Recently figured this out. Seems to work fine > > trim(trim(round(1.111,0),'0'),'.') = 1 > CAST(1.111 AS integer) -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] [EXTERNAL] virtual tables, xBestIndex, pIdxInfo->aConstraint[].op, and 'NOT'...

2018-10-16 Thread Richard Hipp
oly_within(_shape,...)" and "WHERE geopoly_overlap(_shape,...)". There is little to no documentation on the SQLITE_INDEX_CONSTRAINT_FUNCTION mechanism yet. See the geopoly implementation for an example. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Bug Report: corrupted double-linked list

2018-10-10 Thread Richard Hipp
representation of any > work attached to this email, is suitable to be protected by copyright > enforcement by applicable law in your or sender's Country's and > International Legislation > > Trabajar, la mejor arma para tu superación > "de grano en grano, se hace la arena" (R) (en trámite, pero para los >

Re: [sqlite] Query performance slower in 3.25

2018-09-29 Thread Richard Hipp
the problem has been lurking just under the surface for a long time, apparently. The minor tweak in 3.25.0 (https://sqlite.org/src/info/85b9be) merely brought the problem to the surface. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sql

Re: [sqlite] Crash observation in certain conditions (SQLite v.3.25.2)

2018-09-29 Thread Richard Hipp
On 9/29/18, Vlad Khokholkov wrote: > Yes, you are right that is a link to compiler. > Please, see source code in the attached to prior letter file > (SQLiteDebug.zip). > Do you see attached files? Yes, thank you. I now see the source code buried amongst the other attachments. --

Re: [sqlite] Crash observation in certain conditions (SQLite v.3.25.2)

2018-09-29 Thread Richard Hipp
ntain any source code. It is all LIB, and EXE, and DLL. I need the source code to the program that is failing, please. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bi

Re: [sqlite] Query performance slower in 3.25

2018-09-29 Thread Richard Hipp
e-darwin18.2.0 > Thread model: posix > > What could be causing this performance hit in 3.25? > > Thanks, > Stephen > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/list

Re: [sqlite] SQLite bug: Malformed UTF16 leads to a 2-byte buffer overread

2018-09-29 Thread Richard Hipp
> version 3.12.1. Maybe we can learn from it to fix this problem. > > Best, > > Kelvin > ___ > 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] Crash observation in certain conditions (SQLite v.3.25.2)

2018-09-29 Thread Richard Hipp
about the issue. > > Once again, thanks alot for your efforts in creating so amazing System! > > Regards, > Vladimir. > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >

Re: [sqlite] How to retrieve table names for the given string

2018-09-27 Thread Richard Hipp
to execute the query using sqlitemaster. But it's displaying only > table names not column names. Let the column name be in the variable $c1 SELECT a.name FROM sqlite_master AS a JOIN pragma_table_info(a.name) AS b WHERE a.type='table' AND b.name=$c1; -- D

Re: [sqlite] Is SQLITE_DETERMINISTIC ignored on an aggregate?

2018-09-27 Thread Richard Hipp
On 9/27/18, Deon Brewis wrote: > Is there anything that SQLITE_DETERMINISTIC would ever be used for in an > aggregate? (Function with xStep/xFinal as opposed to just xFunc). > > I assume it's ignored, but just checking. I believe you are correct. But why are you asking? -- D. Ri

Re: [sqlite] Bug in 3.25.2 (RECURSIVE CTE + window function)

2018-09-27 Thread Richard Hipp
_ > 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

  1   2   3   4   5   6   7   8   9   10   >