Re: [sqlite] Salt endianness

On 4/12/18, Harmen <har...@lijzij.de> wrote: > > So I guess that's not true for the salt1 and salt2 values? They are to be > interpreted as either bigendian? > The documentation has been updated. Thanks. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] memory leak?

On 4/12/18, king3306 <1809860...@qq.com> wrote: > > I am use SQLite version 3.3.6 Version 3.3.6 dates from 2006-06-06. Version 3.23.1 is current. Please upgrade. Report back if you are still having problems. -- D. Richard Hipp d..

Re: [sqlite] An artificial query whose outcome is changed after left join reduction

> left join t2 using (a) > where a in (b,3) > ; > 2|2 > > In version 3.22: > 2|2 > 3| > > > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://maili

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

nary from 485808 bytes down to 483245 bytes - a savings of 2563 bytes or 0.53%. (Built with gcc 5.4.0 and -Os.) -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bi

Re: [sqlite] without rowid and secondary indexes

, > Olivier Mascia > > > ___ > 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] Build error in SQLite 3.18 if SQLITE_UNTESTABLE is defined

On 4/10/18, Priebe, Sebastian <sebastian.pri...@de.sii.group> wrote: > this error still exists. > Please fix it. You still have not answered my question: Why do you want to make SQLite untestable? -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] sqlite bug? .mode insert does not quote identifiers

PHP to modify the output, but figured it > would be useful to report the issue in the hope that it could be fixed > (or I could be shown a way to have this work correctly) That is fixed in 3.19.0. Suggest you update to the latest - 3.23.0. -- D

Re: [sqlite] Import zipped csv file

e='csv_file.csv'); > works. > How to pass the data extracted by zipfile to csv extension ? > Thanks. I don't think that can be done right now. It will require an enhancement to the csv virtual table. I have your request. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Bug when opening a database file in a deep directory

glists.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] What does this assert mean? (sqlite3_mutex_held)

On 4/4/18, Deon Brewis <de...@outlook.com> wrote: > assert( sqlite3_mutex_held(pPage->pBt->mutex) ); This verifies that the current thread holds the pPage->pBt->mutex mutex. The assert() will fire an abort() if the mutex is not held. -- D. Richard

Re: [sqlite] generate_series can theoretically behave differently in SQLite 3.23.0

On 4/3/18, Richard Hipp <d...@sqlite.org> wrote: > > Probably there will be a 3.23.1 patch release later today. > Or, maybe not. If the series.c file is compiled with -DSQLITE_SERIES_CONSTRAINT_VERIFY=1 then the generate_series() virtual table behaves correctly, and Edzard'

Re: [sqlite] generate_series can theoretically behave differently in SQLite 3.23.0

22.0 2018-01-09 15:28:25 > 6b3f4349d7156501f05270d494d6002ee03a0860b6e77b46d17effcab027b753 > .echo off > 1|4 > 1|5 > 2|0 > 2|1 > 2|2 > 2|3 > 2|4 > 2|5 > > _______ > sqlite-users mailing list > sqlite-users@mailinglis

Re: [sqlite] Fossil Feature Request

ine READ_UTF8(zIn, zTerm, c) > https://www.sqlite.org/src/artifact/810fbfebe12359f1 Just add the "ln=155-165" query parameter. Like this: https://www.sqlite.org/src/artifact/810fbfebe12359f1?ln=155-165 -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] .dump command and user_version

On 3/29/18, Scott Robison <sc...@casaderobison.com> wrote: > It seems a > reasonable to suggestion to add it. Version 3.23.0 is in bug-fix-only mode. It'll have to wait. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Estimating flash write io of SQLite operations

m and use PRAGMA journal_mode=DELETE. If you cannot use the F2FS filesystem, then PRAGMA journal_mode=WAL with PRAGMA synchronous=NORMAL is probably your best bet. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlit

[sqlite] Yet another beta-test success!

, and LEFT JOINs. Report any problems or concerns to this mailing list, or directly to me. [1] https://sqlite.org/draft/optoverview.html#pushdown [2] https://sqlite.org/src/info/f08c1731b0b1dddc [3] https://sqlite.org/download.html -- D. Richard Hipp d...@

Re: [sqlite] Determine sort order of query

> sqlite3_step. The only practical way to determine the order is to run it and see. -- 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] Determine sort order of query

nes a row order shift can happen at any time. You can expect to sometimes see rows in different orders if you run the same query on two different versions of SQLite. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailingl

[sqlite] Beta-testing success story! Was: The upcoming 3.23.0 release

bit4 AND parent5=node4 > ; > > _______ > 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] sqlite3rebaser_* function declaration error

\sqlite3.c:11413:6: note: previous declaration of > 'sqlite3rebaser_delete' was here > void sqlite3rebaser_delete(sqlite3_rebaser *p); > ^ > > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says a > lot about anticipated traffic volume. > > > > > > ___ > 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] The upcoming 3.23.0 release

true" or "false" as column names. -- 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] Index on expression goes corrupt from valid SQL

me. If it does not (if the function is not "pure") then the index can go corrupt. -- 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] How to get ORDER BY / LIMIT to stick to the fast-path?

32600 > 73Column942700 > 74ResultRow253000 > 75Next971000 > 76Halt00000 > 77 Transaction00496001 > 78TableLock090lookups00 > 7

[sqlite] The upcoming 3.23.0 release

that soon. You can follow our progress on the checklist. 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

Re: [sqlite] Unexpected optimization

TABLE Rea VIRTUAL TABLE INDEX 2: > > > Can I manually affect the plan for this query or probably by further > tweaking the virtual table costs? > > Thanks > > > > Thanks > ___ > sqlite-users mailing list

Re: [sqlite] How many AUTOINCREMENT tables are in your schema?

he potential for a performance benefit. -- 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] How to optimise a somewhat-recursive query?

On 3/21/18, Jonathan Moules <jonathan-li...@lightpear.com> wrote: > I've spent the last ~90 minutes trying to build this but to no avail The query planner enhancements are now available in the pre-release snapshot on the https://sqlite.org/download.html page. -- D. Richard Hipp d...@s

Re: [sqlite] How to optimise a somewhat-recursive query?

archive (or SQLite Archive) and unpack it. (2) Run "nmake /f makefile.msc sqlite3.c" On unix: (1) Download and unpack as before (2) ./configure; make sqlite3.c The only dependence for the above is having a "tclsh" somewhere on your $PATH

Re: [sqlite] cannot connect to host www3.sqlite.org:443 (Connection refused)

s crashed, and nobody noticed. Thanks for the report. The process has now been restarted. -- 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] Query speed Regression: 3.15 much faster than 3.22 (Was: How to optimise a somewhat-recursive query? )

On 3/18/18, Jonathan Moules <jonathan-li...@lightpear.com> wrote: > > I can provide a small replication database if desired. Please do. Send it as an attachment directly to me. Also please send the exact text of the query that is running slowly. -- D. Richard Hipp d..

Re: [sqlite] sqlite3_serialize / sqlite3_deserialize (3.23.0 draft)

a :memory: database, the pages are spread out in memory at arbitrary locations. But with sqlite3_deserialize(), SQLite keeps all the pages in one contiguous blob. As for size, I have found that using page_size=512 gives maximum space efficiency. --

Re: [sqlite] sqlite3_serialize / sqlite3_deserialize (3.23.0 draft)

fuzzer input. The sqlite3_deserialize() interface streamlines the decoding process in cases where the chunk of memory containing the file does begin with "SQLite format 3". -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing lis

Re: [sqlite] Lazy virtual table creation

create them > lazily, on first access. > Is there a hook we can use so when an SQL statement refers to a non existing > table it asks a callback for a VT definition? It is fine if these dynamic > table requires a specific prefix similar to the "temp” one. There is no such hook. Sorry.

Re: [sqlite] How many AUTOINCREMENT tables are in your schema?

o do some kind of indexed lookup. For a schema with just a few AUTOINCREMENT tables, there is really no point in trying to use an index. But if you have hundreds of AUTOINCREMENT tables, some kind of index might be worthwhile. -- D. Richard Hipp d...@s

Re: [sqlite] Site error

On 3/16/18, David Raymond <david.raym...@tomtom.com> wrote: > Getting same error message trying to search today. Fixed. Apparently one of the automatic site-update scripts is messing up the file permissions on the full-text search databases... -- D. Richard Hipp d...@s

Re: [sqlite] Programmatically corrupting a database

ite_master table to do things like change the root page number of the table or one of its indexes. -- 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] [EXTERNAL] Indexing multiple values per row

know of to > do that, but I'm open to other ideas. Perhaps use FTS4 or FTS5 with a custom tokenizer that understands JSON? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.o

[sqlite] How many AUTOINCREMENT tables are in your schema?

' | grep -i autoincrement | wc -l Private email to me is fine. Thanks for participating in this survey! -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman

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

any problems. Note that I ran a complete TH3 test overnight last night (on linux) with no issues reported. That's 197,490,286 tests. The snapshot is table. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sql

Re: [sqlite] Bug in fsdir

On 3/15/18, Kees Nuyt <k.n...@zonnet.nl> wrote: > On Thu, 15 Mar 2018 15:55:05 +1100, Jake Thaw > <jaket...@gmail.com> wrote: > >>The following query causes a crash in fsdirNext on Windows 10. > > Fixed by Richard Hipp on trunk: > https://www.sqlite.org/src/

Re: [sqlite] Help getting started

On 3/9/18, Larry Mullings <lardog_...@yahoo.com> wrote: > I have a SQLite Bible database. It has > Bible verses with Strong's numbers and Hebrew. Are you willing to share your database? Can you send me a copy via private email attachment? -- D. Richard Hipp d..

Re: [sqlite] How to get the entry from sqlite db without primary key or rowid order?

ER BY y; -- 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] How to get the entry from sqlite db without primary key or rowid order?

t that lacks an ORDER BY clause. If you need to output rows in a particular order, then please devise an ORDER BY clause that expresses that ordering. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sql

Re: [sqlite] multiple table constraints

reak if we "fix" it. Hence, I won't document the second form as valid syntax, but I will add test cases to make sure the second form continues to be accepted, to ensure future compatibility. -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Daily test coverage results published online

./configure --disable-amalgamation; make test And it ran fine for me. No errors. This is on ubuntu. If you continue to have problems, please send additional information and we will look into it. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users maili

Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

ture that is added has to be supported, therefore, for 30 years. This encourages us to avoid adding new features whenever possible. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqli

Re: [sqlite] Question regarding 3.23.0 (pending) and TRUE/FALSE

the names of columns in tables or views. -- 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 regarding 3.23.0 (pending) and TRUE/FALSE

On 3/2/18, J Decker <d3c...@gmail.com> wrote: > On Fri, Mar 2, 2018 at 4:19 AM, Richard Hipp <d...@sqlite.org> wrote: > >> On 3/2/18, Olivier Mascia <o...@integral.be> wrote: >> > >> > What values will be considered FALSE, and hence will TRUE

Re: [sqlite] Question regarding 3.23.0 (pending) and TRUE/FALSE

ut '0abc', 'abc', and '' are all FALSE. > Will insert into T values(FALSE) actually store integer 0 no matter column > affinity or will it follow affinity? No. FALSE is merely an alias for 0. Affinity still applies. If the column is of type TEXT, then it will store '0', not 0. -- D. Richard

Re: [sqlite] String Too Long

On 3/1/18, Matías Badin <matias.ba...@wildar.com> wrote: > The string is over 55000 characters and i'm using SQLiteCommand in C# That might be something in C#. SQLite can easily handle a 55K character string. It commonly does much more than that in applications such as Fossil. -- D

Re: [sqlite] Bug report

On 2/27/18, Alexander Ananin <aana...@topcon.com> wrote: > > I've found the strange behavior in the rtree.c file. Are you trying to compile rtree.c separately, rather than using the version that is bundled into the sqlite3.c amalgmation? May I ask why you want to do that? -- D. Ri

Re: [sqlite] Format of sqlite-users digests.

MailMan code. -- 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] Shell CSV bug

On 2/24/18, David Burgess <dburg...@gmail.com> wrote: > Version SQLite 3.22.0 > Linux 3.19.0-32-generic > > The header line when output to file is terminated by \x0a > all other lines are terminated with \x0d\x0a Unable to repro. Do you have a complete test script?

Re: [sqlite] error SQLite will not work correctly with the -ffast-math option of GCC.

d with #sqlite3.h and removed the dependencies > from the previous library but I think I'm missing something. Disable the -ffast-math compile-time option since it is incompatible with SQLite. -- D. Richard Hipp d...@sqlite.org ___ sqlit

Re: [sqlite] iOS Watchdog and database corruption

send corrupt database files (and corresponding journals) directly to my private email and they will be shared only among the SQLite developers: me, Dan, and Joe. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailing

Re: [sqlite] iOS Watchdog and database corruption

te.org/c3ref/c_dbconfig_enable_fkey.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] Improper error message

quot;left" and "right" are keywords in SQL. SQLite understands the RIGHT keyword, even though it does not (yet) implement a RIGHT JOIN. You can force any word to be an identifier by enclosing it in double quotes: SELECT "left"('abc', 2); And it that

Re: [sqlite] Clarification on Storage

in declaration types on the >> tables field. SQLITE3.EXE does not. >> >> Case in point: >> >> > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mail

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

the standard library in this regard. So I'm not sure whether or not this is something that ought to be "fixed". -- 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] More sqlite header questions

plication prior to the application being forcibly terminated. -- 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] More sqlite header questions

y process. If you delete the information that SQLite needs to recover then it won't, and the database will be left in its weird state, which is now considered corrupt. Do not do any of the bad things listed under https://www.sqlite.org/howtocorrupt.html and you will be fine. -- D. Richard Hi

Re: [sqlite] Help with row values

Now fixed on trunk. Thanks for the bug report. -- 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 with row values

On 2/13/18, Simon Slavin <slav...@bigfraud.org> wrote: > On 13 Feb 2018, at 5:32pm, x <tam118...@hotmail.com> wrote: > >> Surely it should be 3 in both cases? > > I agree. Here's verification with a version number: https://www.sqlite.org/src/tktview/f484b65f

Re: [sqlite] Crash when writing header

er in the rollback-journal or in the write-head log (depending on whether or not you are in WAL mode) and will be recovered automatically when the database is first opened after power has been restored. See https://www.sqlite.org/atomiccommit.html for further information. -- D. Richard Hi

Re: [sqlite] About to know that Table-Level Encryption is possible in SQLite or not.

TACH the encrypted file, or vice versa. SQLite does allow connections where there are multiple attached databases, some of which are encrypted and others not. [1] https://www.hwaci.com/sw/sqlite/see.html -- D. Richard Hipp d...@sqlite.org ___ sqlite-

Re: [sqlite] sqlite 3.22.0 read-only WAL mode clarifications

ways be present? > https://www.sqlite.org/c3ref/c_fcntl_begin_atomic_write.html#sqlitefcntlpersistwal -- 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] -Wsign-compare warning in lempar.c

can get an unexpected result if the signed value is > negative, but in this case we first check that i is positive, so that > issue never occurs. Correct. The previous term of the assert() guarantees that variable i is non-negative. This is nuisance warning (as are most warnings, actual

Re: [sqlite] Header corruption

d" and not "jfd" or "sjfd". I think there are four separate places you will need to insert your patch. -- 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_expanded_sql is reading freed heap memory

gt; #12 0x102682f80 in sqlite3VdbeHalt sqlite3.c:74890 > #13 0x1026a6aab in sqlite3VdbeExec sqlite3.c:82236 > #14 0x1025e8c41 in sqlite3Step sqlite3.c:77535 > #15 0x1025e7b79 in sqlite3_step sqlite3.c:77598 > #16 0x10

Re: [sqlite] Vetting SQLite

On 2/5/18, Stephen Chrzanowski <pontia...@gmail.com> wrote: > I was surprised to see that statement, so, checking my system, this isn't > true. Win7Pro-x64. It's on Windows10. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing

Re: [sqlite] Vetting SQLite

On 2/5/18, Drago, William @ CSG - NARDA-MITEQ <william.dr...@l3t.com> wrote: > > Most of the software we use here, Microsoft and other well-known and > paid-for products, You know that every copy of Windows comes with SQLite preinstalled, right? C:\Windows\System32\winsqlite3.dll

Re: [sqlite] Vetting SQLite

since 2010, and nothing has come up during the subsequent 8 years of development and maintenance. Since 2011, all check-ins to the SDS source code have come from just 3 individuals, with all but about 8 check-ins from a single programmer who is a US citizen and fully vetted and known personally t

Re: [sqlite] Optimization - don't understand.

e > size, of course) (1) the database file is larger. (2) When doing UPDATE on one of the columns added to the index, then the index must be updated too, in addition to the table. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@m

Re: [sqlite] Optimization - don't understand.

I/O required to scan the whole thing. But the index only provides access to the id, threadid, and userid columns. If content of other columns is needed, then the whole table must be scanned instead. -- 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] Performance issue in different versions

h at https://www.sqlite.org/cpu.html for example. Since in your case, the 3.9.2 was compiled by Google and you compiled 3.16.2 yourself, I suggest that there might be some difference in your compiler or compiler settings. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Documentation update 2

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] I encounter a problem when build sqlite for iOS

; Many guys encountered such problem & still not found good solutions: > https://github.com/sqlcipher/sqlcipher/issues/240 > https://github.com/cocos2d/cocos2d-x/issues/17907 > https://github.com/HaxeFlixel/flixel/issues/2112 > > > On 1/30/18, 10:30 PM, "drhsql...@gma

Re: [sqlite] I encounter a problem when build sqlite for iOS

> ^ > 1 error generated. > make: *** [sqlite3-shell.o] Error 1 > ___ > 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] Website security issue

On 1/29/18, Georges Taupin <g.taupi...@gmail.com> wrote: > > How can i report a security issue on the website please ? > Send an email - either to the public mailing list, or directly to me. -- D. Richard Hipp d...@sqlite.org ___ sqlit

Re: [sqlite] Convincing SQLITE to use alternate index for count(*)

dId); Can you send the output of sqlite3_analyzer for your database so that we can compare the actual table and index sizes? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlit

Re: [sqlite] regression since 3.20.0

on trunk The ticket: https://www.sqlite.org/src/info/ec32177c99ccac2b1 The patch: https://www.sqlite.org/src/fdiff?v1=caf0b6c9d31f22f0=10c7e13c909e4dc9 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailing

Re: [sqlite] regression since 3.20.0

also >> return the expected one. >> >> Best regards, >> >> Kenichi Ishigaki >> ___ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > ___ > 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] Queries using json_each in a JOIN are not working

Proper fix is now on trunk and will appear in the next release. On 1/26/18, Jens Alfke <j...@mooseyard.com> wrote: > > >> On Jan 26, 2018, at 1:36 PM, Richard Hipp <d...@sqlite.org> wrote: >> >> For now, please use CROSS JOIN instead of INNER JOIN to force t

Re: [sqlite] Queries using json_each in a JOIN are not working

I'll investigate further to see if this is something SQLite ought to be doing automatically. -- 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] Convincing SQLITE to use alternate index for count(*)

. Any ideas? > > - Deon > > ___ > 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] json1 extenstion won't load in command shell

> 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] SQLite DELUXE Re: sqlite command line tool NUL support

On 1/24/18, petern <peter.nichvolo...@gmail.com> wrote: > Have you worked out an automated way for your changes to shadow and > auto-merge from the official trunk? https://www.sqlite.org/privatebranch.html -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] sqlite 3.21.0 fts3rank test failure on big-endian linux

d stuff on eBay? -- 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_btreeinfo causes sql logic error

rmsg16(DB) returns “SQL logic error”. > > > > I’m using the amalgamation in c++ builder 10.2, 64 bit clang compiler on > windows 10 Please add -DSQLITE_ENABLE_DBPAGE_VTAB to your build. -- D. Richard Hipp d...@sqlite.org ___ sqlit

Re: [sqlite] sqlite3_btreeinfo causes sql logic error

On 1/24/18, x <tam118...@hotmail.com> wrote: > Works OK for > > SELECT name FROM sqlite_btreeinfo WHERE type='table' > > But crashes with > > SELECT name, nEntry FROM sqlite_btreeinfo WHERE type='table' Do it crash, or does it return an error? There is a differe

Re: [sqlite] Using SQLite internal recognizers eg: SQLITE_PRIVATE int sqlite3AtoF()

ype()" is suppose to do? -- 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 SQLite internal recognizers eg: SQLITE_PRIVATE int sqlite3AtoF()

no telling how many others I have overlooked. Furthermore, the internal interfaces are not hardened for general use and are not general purpose. They will typically have quirks and caveats and corner-cases that need to be avoided. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Tcl binding: Quirk with Tcl variable reference in eval method

nly for "simple" Tcl variable references. That is correct. You can use an array variable, but the index part must be a constant. For example: set x(name) "whatever" db eval {SELECT * FROM tab WHERE col = $x(name)} As you observce, you cannot use another variable as

Re: [sqlite] sqlite 3.21.0 bug? SELECT CAST ('9223372036854775807 ' AS NUMERIC);

ovided the information I needed, which was a method of reproducing the problem. It is now fixed on trunk. See https://www.sqlite.org/src/info/1b02731962c21bb0 for the patch. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] sqlite 3.21.0 bug? SELECT CAST ('9223372036854775807 ' AS NUMERIC);

mailinglists.sqlite.org >>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> >> ___ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > ___ > 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] Minor JSON output bug (infinity)

_ > 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] "Error: NOT NULL constraint failed ..." when no such constraint exists

ompromise the simplicity of the design, or to document bugs rather than fix them, in order to avoid breaking legacy applications. This is such an instance. There are others, which you will no doubt encounter from time to time if you use SQLite intensely. -- D. Richard Hipp d...@s

Re: [sqlite] Crash in libsqlite3 with sqlite-3.21.0 and KDE plasmashell

tion on this. (4) We will reconsider (3) if you can provide a scintilla of evidence that SQLite is at fault. -- 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] IN clause

here (statNumber, question) in (select statNumber, > question from card) > > Why? > > thanks and best regards > > Szyk Cech > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mail

Re: [sqlite] c program which performs the same function as the SQLite shell command ".import"

On 1/17/18, petern <peter.nichvolo...@gmail.com> wrote: > > Richard, since you're responding to questions, let me ask again about 3.22 > INTROPECTION_PRAGMAS release. No. We are past pencils-down. No new features at this point. -- D. Richard Hipp

<    3   4   5   6   7   8   9   10   11   12   >