Re: [sqlite] The mailing list is deprecated...... [was: Re: [EXTERNAL] No such column error]

/msg119468.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] New SQLite Forum requires Javascript?

oc/trunk/www/antibot.wiki for details. Since the Forum does not (yet) have diffs and annotations and tarballs and all the other features of Fossil that cause mindless robots to burn CPU cycles on the server, I suppose I can disable that mechanism for the Forum, which I have now done. Please try again. --

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

On 3/13/20, Philip Bennefall wrote: > Should I write to you directly, or to the Fossil forum? Either one (or both) will be fine. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org h

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

at. I will build it into the system, assuming it works, does not have onerous external dependencies, and you can get me a signed CLA. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.or

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

trying to engineer an audible captcha. -- 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] New SQLite Forum requires Javascript?

en you load a new thread. So if you don't mind scrolling manually, I think everything else will just work. Did you try it? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

is mailing list and the Forum on Fossil regularly for two years now. The forum is so much nicer that I have come to dread having to work with the legacy mailing list, at least for complex subjects. It is time for a switch to better technology. -- D.

Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

On 3/12/20, no...@null.net wrote: > I am wondering what (apparently invisible) > anti-spam features are present. I will be happy to discuss that, and any other questions you have, on the Forum. :-) -- D. Richard Hipp d...@sqlite.org ___ sqlite

[sqlite] New SQLite Forum established - this mailing list is deprecated

by Fossil. It has been in active use in the Fossil community for a couple of years, and has worked well. See the second link above for more information. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short-circuit sometimes

ransaction0 0 1 0 01 usesStmtJournal=0 24Goto 0 1 0 00 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlit

Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short-circuit sometimes

On 3/12/20, Doug wrote: > Richard, what does the explain look like with your code change, please. Test case: CREATE TABLE t1(a); explain SELECT coalesce(a, abs(-9223372036854775808)) FROM t1; Before the change: addr opcode p1p2p3p4 p5 comm

Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short-circuit sometimes

qlite-users > > > ___ > Gunter Hick | Software Engineer | Scientific Games International GmbH | > Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) > +43 1 80100 - 0 > > May be privileged. May be confidential.

Re: [sqlite] [EXTERNAL] Re: COALESCE() does not short-circuit sometimes

ugh it seems more likely than not at this point. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite 3.31.1 crashes in SVN on OpenBSD/sparc64

le3.c" and "sqlite3.h" files. Or, you can update the "sqlite3.c" file you are currently using manually entering the 3-line patch shown. Please let us know what you find. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] sqlite 3.31.1 crashes in SVN on OpenBSD/sparc64

e results and send them to me, please. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite 3.31.1 crashes in SVN on OpenBSD/sparc64

>zSql.) Then do: set p->db->flags = p->db->flags | ((0x060)<<32) That will turn on bytecode listing and tracing, and might provide further clues. Please record and send in the trace. -- D. Richard Hipp d...@sqlite.org ___ s

Re: [sqlite] Is this an SQL parsing / ambiguity bug ?

ably want "ON CONFLICT > IGNORE". I think Vlad is trying to do an upsert, which does have a DO NOTHING syntax that I copied from postgres. The parsing ambiguity that Vlad is complaining about (if I understand him correctly) is documented at the bottom of the upsert page: https://www.s

Re: [sqlite] sqlite3: .width counts bytes, not characters

hese issues may have been fixed in the last couple of > years. I think the enhancement is here: https://sqlite.org/src/timeline?c=ed0842c156ab1a78 That would correspond to version 3.20.0. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sq

Re: [sqlite] Custom VFSes and PENDING_BYTE position

ing. Depending on your circumstances, I suppose you would also have to do something similar with xTruncate() and xFileSize(). -- 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] Bug in SQLite version 3.31.1 and 3.32?

On 3/6/20 9:54 PM, Keith Medcalf wrote: On Friday, 6 March, 2020 19:25, Richard Damon wrote: It is sort of like NaN, where a Nan is neither less than, greater than or equal to any value, including itself. NULL (as in SQL NULL) means "missing value" or "unknown". NULL

Re: [sqlite] Bug in SQLite version 3.31.1 and 3.32?

ce you can have NULL values, you have to know the rules very well when you apply logic. Other values make sense, but NULL is not logical. It is sort of like NaN, where a Nan is neither less than, greater than or equal to any value, including itself. -- Richard Damon

Re: [sqlite] Bug in SQLite version 3.31.1 and 3.32?

ssion "t1.textid=null" is always NULL. (2) The expression "NULL IS NOT FALSE" is always true. (3) The WHERE clause expression "... OR true" is always true. Hence, the query above simplifies to just "SELECT * FROM t, i;". That query should return 4 rows, just a

[sqlite] Updates to althttpd.c for LetsEncrypt compatibility

althttpd.c source file and recompile. You will almost certainly need to do this before you get your next cert from LetsEncrypt. And you might need to do that before tomorrow. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Report bug found in SQLite version 3.31.1

On 3/2/20, Keith Medcalf wrote: > > Perhaps this is the same constant propagation bug that was fixed recently? > So it seems. https://sqlite.org/src/timeline?bid=ya65c8d4e26n3bfa9cc97dn7d8dcfb95cy14d14eb537y109ee07433nabfb043ebbne0c6b8bdb7yc9a8defcef -- D. Richard Hipp d...@s

Re: [sqlite] VFS xFullPathname cannot access URI parameters

the argument passed into xFullPathname. But it has done so historically, and (apparently) some software has come to depend on that accidental behavior. So I have implemented changes on trunk, and on branch-3.31 to make it work again. -- D. Richard Hipp d..

Re: [sqlite] Trigger name missing

ction of those are unmaintained. And some additional fraction of those will break, probably to never work again, whenever we add a keyword, except for the keyword fallback mechanism. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@

Re: [sqlite] Trigger name missing

an "insert" trigger returns the correct value, the > equivalent expression "select from T where Id = new.Id" always > returns null (column "Id" is the PK of table "T"). Similarly, "update T > set = where Id = new.Id" (si

Re: [sqlite] sqliteDefaultBusyCallback and HAVE_USLEEP

t sounds like you are asking why SQLite does not try to sleep for sub-second intervals on systems that do not support usleep()? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sql

Re: [sqlite] Performance Issue on Large Table

On 2/23/20 3:06 PM, R.Smith wrote: On 2020/02/23 21:23, Richard Damon wrote: On 2/23/20 8:31 AM, Olaf Schmidt wrote: An amount of 140 tables in such a "BibleVersions.db" is not uncommon and can be managed by SQLite in a good performance. I'm not sure that form of division wou

Re: [sqlite] Performance Issue on Large Table

data from be taken from a field you get in a query. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] more efficient JSON encoding: idle musing

that is more space efficient and/or faster, please share it with us. -- 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] Is randomblob(16) a good guid generation across multiple computers?

plication, then fix it by compiling with -DSQLITE_WIN32_USE_UUID=1 and linking against RPCRT4.LIB. -- 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] Is randomblob(16) a good guid generation across multiple computers?

can use the uuid.c extension: https://www.sqlite.org/src/artifact/5bb2264c1b64d163 -- 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] Is randomblob(16) a good guid generation across multiple computers?

on between two randomblob(16) calls to practically zero. So, I think randomblob(16) is a fine way to generate a UUID. Though, I tend to use randomblob(20), and I often run it through hex() too, so that it is human-readable. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Does VACUUM imply REINDEX?

ACUUM is independent of ANALYZE. The information computed by ANALYZE is the same before and after VACUUM. There is no benefit to running ANALYZE after running VACUUM if the ANALYZE data (the content of the sqlite_stat1 table) is still up-to-date. --

Re: [sqlite] last_insert_rowid() returns every growing list

_insert_rowid() from TCL, it is faster to use the "db last_insert_rowid" TCL 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] Is it possible to dump a sqlite db that has an associated -wal file?

osed). > > Why the database can not be read by another sqlite3 session when the > corresponding -wal file exists? Thanks. Because Firefox uses "PRAGMA locking_mode=EXCLUSIVE;" -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mai

Re: [sqlite] WITHOUT ROWID tables

e some hidden cookie or value > I can use that I have overlooked? > There are no magic cookies that change with the schema but not with VACUUM. Perhaps you could store a strong hash of the sqlite_master.sql column for each table with your C++ objects, then compare the hash upon recon

Re: [sqlite] Incorrect join result with duplicate WHERE clause constraint (again)

On 2/13/20, Jim Bosch wrote: > https://gist.github.com/TallJimbo/d819876a77cfd79312ad48508cfdd8a2 Thanks for the very succinct bug report. The problem is now fixed on trunk. https://www.sqlite.org/src/timeline?c=c9a8defcef35a1fe -- D. Richard Hipp d...@sqlite.

Re: [sqlite] Compiling SQLite Encryption Extension for ARM processor

t work for 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] O_NOFOLLOW issue with /dev/null on Solaris

s that there is something wrong with your application. Thanks for the suggested improvements to SQLite. A patch for this will appear in the next release. Or you can use the latest trunk check-in. https://www.sqlite.org/src/timeline?c=0c683c43a62fe25c -- D. Ric

Re: [sqlite] JSON_EACH + recursive query = unexpected performance degradation

messages containing attachments. I think this depends on the size and mimetype of the attachments. In this case, I was asked and I approved. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite

Re: [sqlite] Please increase the default for SQLITE_MAX_VARIABLE_NUMBER

On 2/11/20, J. King wrote: > SQLite also has a 1M byte statement > length limit ... The statement length limit is yet another defense against mischief caused by SQL injections. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Please increase the default for SQLITE_MAX_VARIABLE_NUMBER

On 2/10/20, Digital Dog wrote: > Maybe they should be treated as a > dictionary/hashtable/linked list or similar? > Parameter look-ups are on the critical path. How much performance are you willing to give up in order to have parameters with larger numbers? -- D. Richard Hipp d...@s

Re: [sqlite] Please increase the default for SQLITE_MAX_VARIABLE_NUMBER

statements with ?32767 in them. The allocated array lives for the life of the prepared statement. -- 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 group this?

On 2/9/20 11:44 PM, Rowan Worth wrote: On Mon, 10 Feb 2020 at 11:12, Richard Damon wrote: On 2/9/20 7:24 PM, Bart Smissaert wrote: ID ENTRY_DATE TERM NUMERIC_VALUE ROWID 1308 15/Mar/2013 Systolic 127 701559 1308 15/Mar/2013

Re: [sqlite] How to group this?

(and at least throw out an error when it sees that). -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] loading extension csv.c

dard) which it appears not to be (as that shouldn't cause a problem with the shown code). -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] loading extension csv.c

provides > some info (macOS High Sierra version 10.13.6) > That command works fine for me on my iMac. I have no idea why it is failing for you. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@m

Re: [sqlite] loading extension csv.c

Within the SQLite command-line shell, do: .load ./csv I suspect that the -I. is the option that you need, so that the build will pick up a proper sqlite3ext.h file, and not whatever sqlite3ext.h file that Apple has installed. But that is just my gu

Re: [sqlite] Double return Issue in sqlite3_filename_database

. Thanks for pointing it out. -- 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] Check constrain execution timing change? (Now a bug)

On 2/3/20, Dominique Devienne wrote: > On Sun, Feb 2, 2020 at 12:50 AM Richard Hipp wrote: > >> On 2/1/20, Thomas Kurz wrote: >> > >> > create table x (x integer check (typeof(x) == 'integer')); >> > insert into x values ('1'); >> > >&g

Re: [sqlite] Check constrain execution timing change? (Now a bug)

On 2/2/20, Thomas Kurz wrote: > And are there any consequences for something like > >> create table x (x text check (typeof(x) == 'text')); >> insert into x values ('1'); > Not that I know of. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Check constrain execution timing change? (Now a bug)

?? I think that is what it means. yes. -- 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] Check constrain execution timing change? (Now a bug)

On 1/31/20, Keith Medcalf wrote: > > That would elevate this to the status of a bug since it should be impossible > to do this. > It is also not something that is fixable, so the solution will likely be to simply document it. -- D. Richard Hipp d..

Re: [sqlite] Check constrain execution timing change?

a that would have created valid data if the checks weren't there. > > Graham > > > ___ > 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] Check constrain execution timing change?

he other two) for every version of SQLite I checked from trunk going back to 3.1.0 (2005-01-21). Hence, for backwards compatibility, even it is documented to do something differently, I should probably change the documentation rather than the behavior. -- D. Richard Hipp d..

Re: [sqlite] Generated columns and COLLATE in the AS parens

there is never an occasion to inherit the data type from the AS expression. Furthermore, SQLite expressions do not have data types, so even if a generated column were said to omit the data type, there would be no way of capturing it from the AS expression. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Generated columns and COLLATE in the AS parens

S clause should be carried through as the default collating sequence of the generated column itself", then I'll change it. :-) -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sql

Re: [sqlite] Behavior change around triggers between 3.19 and 3.30

ave been requesting enhanced ALTER TABLE support. In order to provide that, we had to change ALTER TABLE to do a full parse of the entire schema, so that it can find all of the bits and pieces that need altering. This means that ALTER TABLE now also finds latent syntax errors in the schema. -- D.

Re: [sqlite] Generated columns and COLLATE in the AS parens

the DEFAULT clause to change the collating sequence associated with column a? Why should a GENERATED ALWAYS AS constraint work differently from a DEFAULT constraint? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] IO Short Read Error when inserting a TEXT column

t is only generated by the VFS. That means it is your code that is likely generating the error. I suggest you set a breakpoint on the place in your custom VFS where the SQLITE_IOERR_SHORT_READ is being generated and try to figure out what is going on. -- D. Richard Hipp d...@s

Re: [sqlite] sqlite-3.31.0 segfaults on fuzzcheck on s390x architectures

Please retry using this check-in: https://www.sqlite.org/src/info/b20503aaf5b6595a On 1/28/20, Brüns, Stefan wrote: > On Dienstag, 28. Januar 2020 18:26:05 CET Brüns, Stefan wrote: >> On Dienstag, 28. Januar 2020 16:16:01 CET Richard Hipp wrote: >> > On 1/27/20, Ondrej Dubaj

Re: [sqlite] Is mutliple-execute-one-commit slower than multiple single-execute-single-commit?

, then multiple executes could exceed the memory cache, causing it to spill to the database, and then the commit needs to read that back and put it into the right place, while a commit after each execute keeps everything in memory until the commit writes it to the database. -- Richard Damon

Re: [sqlite] Bug report: Potential thread safety issues in sqlite3_initialize

e.org/src/artifact/bae36f8af32c22ad?ln=247 prevent that? Do you have a suggested patch to make it work? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listin

Re: [sqlite] New word to replace "serverless"

On 1/28/20, Jan Danielsson wrote: > On 2020-01-28 00:19, Richard Hipp wrote: >> daemon-less? > >This is my favorite, the only problem is that it is culturally more a > Unix-y term. Since suggesting daemon-less, someone else (I'll have to research who, exactly) suggested &q

Re: [sqlite] sqlite-3.31.0 segfaults on fuzzcheck on s390x architectures

63c4cd00cb Thanks for the temporary SSH login! -- 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] New word to replace "serverless"

oes not work that way. -- 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] New word to replace "serverless"

daemon-less? -- 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] New word to replace "serverless"

work itself, using the callers stack, then returns control to the caller. So what do I call this, if I can no longer use the word "serverless" without confusing people? "no-server"? "sans-server"? "stackless"? "non-client/server"? -- D. Richar

Re: [sqlite] sqlite-3.31.0 segfaults on fuzzcheck on s390x architectures

ers with a temporary ssh account into an s390 machine so that we can investigate and fix the problem? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] List of innocuous functions?

3.31.0 or later. -- 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] SSL: cannot connect to host www3.sqlite.org:443 (Connection refused)

On 1/25/20, Richard Hipp wrote: > On 1/25/20, Domingo Alvarez Duarte wrote: >> Hello Richard ! >> >> Since yesterday I'm getting this message when trying to use fossil for >> sqlite3. > > Yeah. That machine went completely bonkers and I had to rebuild it >

Re: [sqlite] CVE-2019-16168

to me that this is really a vulnerability. -- 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] 64 bits version missing

On 1/23/20, Evert van Dijken wrote: > The 64-bits DLL is missing from the download page, Which download page are you looking at? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org h

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

On 1/25/20, Domingo Alvarez Duarte wrote: > Hello Richard ! > > Since yesterday I'm getting this message when trying to use fossil for > sqlite3. Yeah. That machine went completely bonkers and I had to rebuild it from scratch, using a new IP address. And because it used a new I

Re: [sqlite] List of innocuous functions?

ists.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 3.31.0 breaks firefox and thunderbird

t; Any ideas? > > Best regards > bero > > ___ > 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 on zPath length

On 1/23/20, Ondrej Dubaj wrote: > I discovered an issue found by coverity scan. Thanks for the report. This was previously fixed here: https://www.sqlite.org/src/info/465a15c5c2077011 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing l

Re: [sqlite] GENERATE_SERIES is not available in the command-line shell

But it is the official SQL standard way of getting an ascending list of integers. -- 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] Reporting documentation issues/unclarity?

IRC, in this case, sqlite3_result_error() persists. The subsequent sqlite3_result_int() call merely changes the error message to the number 42. If you want to cancel a prior call to sqlite3_result_error(), you need to invoke sqlite3_result_error_code(context, SQLITE_OK). -- D. Richard Hipp d...@sqli

Re: [sqlite] 3.31.0 Request TRUSTED_SCHEMA and pragma's

On 1/21/20, Keith Medcalf wrote: > > Richard, > > The TRUSTED_SCHEMA setting works really well but I have noticed one problem > (there may be more, but I haven't run across any yet) with it that is > perhaps easy to address, though it needs to be done properly. That i

Re: [sqlite] Find schema of a table in a query

nd might change by any number of things. If the order that the SQL engine happens to choose to fetch the data does happen to be in the order specified by the ORDER BY, then a good engine will optimize it out, so it is free. -- Richard Damon ___ sq

Re: [sqlite] How can I detect rows with non-ASCII values?

, it may be very hard to distinguish that from an actual question mark in the data. -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite 3.31.0 enters pre-release testing

it the URL to change the "from" and "to" attributes to a check-in hash prefix, branch name, of tag. -- 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] Next Release? Visual release timeline?

e first element of each pair is the release name (ex: "3.30.0") and the second element is the time as a fractional year (ex: "2019.7775"). -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.or

Re: [sqlite] Feature request: more robust handling of invalid UTF-16 data

On 1/14/20, Richard Hipp wrote: > I'm having trouble reproducing this. I went back to version 3.30.1 and I was able to reproduce it. So I bisected and found the following: https://sqlite.org/src/timeline?c=51027f08c0478f1b -- D. Richard Hipp d...@sqlite.

Re: [sqlite] Feature request: more robust handling of invalid UTF-16 data

at behavior were you expecting? Is there something that I can be doing differently to make it misbehave? -- 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 Planner GROUP BY and HAVING clauses optimization ?

can't remember the first). > > Anyway, Richard may be able to help here. Maybe you are thinking of SQLITE_ENABLE_SORTER_REFERENCES. https://www.sqlite.org/compile.html#enable_sorter_references -- D. Richard Hipp d...@sqlite.org ___ sqlite-

Re: [sqlite] Bug fixes only branch.

s do things like that for paid support customers. But maintaining bug-fix branches of historical versions is time-consuming, so we do not do it routinely. It is also risky, as actual releases are better tested and more reliable than backported patches. -- D

Re: [sqlite] Unexplained table bloat

to their fundamental 21 bit value and that encoded into UTF-8. If the code doesn't validate the data well enough to catch that issue, then I suspect the character counting would count each half of the surrogate pairs as a code-point, -- Richard Damon

Re: [sqlite] Unexplained table bloat

values of that type (or NULL). -- Richard Damon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Test failures on GPFS

le gives all the clients shared memory. Dunno if GPFS does that or not, though. Maybe not. Or, maybe not reliably. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mail

Re: [sqlite] Unexplained table bloat

On 1/10/20 2:24 PM, Tim Streater wrote: On 10 Jan 2020, at 18:55, Keith Medcalf wrote: On Friday, 10 January, 2020 11:44, Tim Streater wrote: On 10 Jan 2020, at 18:03, Richard Hipp wrote: On 1/10/20, Dominique Devienne wrote: There's no way at all, to know the length of a text column

Re: [sqlite] Unexplained table bloat

On 1/10/20 1:43 PM, Tim Streater wrote: On 10 Jan 2020, at 18:03, Richard Hipp wrote: On 1/10/20, Dominique Devienne wrote: There's no way at all, to know the length of a text column with embedded NULLs? You can find the true length of a string in bytes from C-code using

Re: [sqlite] Unexplained table bloat

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

Re: [sqlite] Unexplained table bloat

in a string, which length() will not tell you about. -- 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] Unexplained table bloat

ems. Please run that utility on the database and perhaps post the output here. -- 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 pass -Dxxx compile option

QLITE_ENABLE_INTERNAL_FUNCTIONS' make -e Option 3: ./configure && make OPTS='-DSQLITE_ENABLE_INTERNAL_FUNCTIONS' -- 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] Magellan 2.0 Vulnerabilities

rketing organization will merely distract you from defending against actual threats. -- 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   >