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

instructions 13 and 14 and omits the abs() function. The abs() function is now computed on instructions 7 and 8, but those instructions only run one time due to the "Once" opcode on instruction 6. -- D. Richard Hipp d...@sqlite.org ___ sq

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?

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] 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] 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] 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)

P address, I have to wait 24 hours for the new DNS information to propagate before LetsEncrypt will give me a new cert. The 24 hours have now passed, but I have to be out of the office on some other business. I'll get the new cert installed and running as soon as I a get a chance. Patience, -- D.

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

t you need to use pragma virtual tables inside of triggers and views, consider putting them inside TEMP triggers and views. TEMP triggers and views, because they must originate in the application itself, are always trusted. -- D. Richard Hipp d...@sqlite.org _

[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] 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

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

Re: [sqlite] TO

On 1/8/20, R Smith wrote: > > Anyone have an idea where the word TO is used in SQL in SQLite? > alter table t1 rename TO t2; rollback TO savepoint1; -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.s

Re: [sqlite] NOTNULL

pt in reference to the above list. > > 1. What is it for? > > 2. Does it have/need any documentation? NOTNULL is a postgresql-ism. It is equivalent to IS NOT NULL. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@m

Re: [sqlite] shell.c: exec_prepared_stmt no return value

gt; Hannes > > ___ > 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] Cascaded delete unexpectedly triggered by upsert

mation about REPLACE and https://www.sqlite.org/lang_UPSERT.html for information about UPSERT. REPLACE works by first DELETE-ing any rows that would cause a conflict and then doing the INSERT. UPDATE works by converting the INSERT into an UPDATE. -- D. Richard Hipp d..

Re: [sqlite] RTree function information

On 1/7/20, R Smith wrote: > On 2020/01/07 3:46 PM, Richard Hipp wrote: >> On 1/7/20, R Smith wrote: >>> I cannot find any mention of the other two. >> Those other routines are for testing and debugging use only. They >> will (likely) be made inaccessi

Re: [sqlite] RTree function information

two. Those other routines are for testing and debugging use only. They will (likely) be made inaccessible to normal application code in the next release. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://

Re: [sqlite] A hang in Sqlite

_ > 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] Performance regression since 3.19.0

: > Is there any more information I could provide? Run "ANALYZE;" on a database that contains actual data, then send us the output of ".fullschema" -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@maili

Re: [sqlite] Bug? SQLite command-line result is different from Perl DBI::Sqlite result

On 1/5/20, Richard Hipp wrote: > > Note that both MySQL and SQLite do allow you to use parentheses, as > shown in my examples, to define the order of evaluation. PostgreSQL > does not, sadly. > Apparently, in PostgreSQL you have to say: SELECT * FROM (SELECT * FROM a, b) AS

Re: [sqlite] Bug? SQLite command-line result is different from Perl DBI::Sqlite result

) JOIN c USING (id); I don't know which is correct. Perhaps the result is undefined. Note that both MySQL and SQLite do allow you to use parentheses, as shown in my examples, to define the order of evaluation. PostgreSQL does not, sadly. MS-SQL does not (as far as I can tell) support the USING syn

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

On 1/3/20, sky5w...@gmail.com wrote: > Is there a query function for these and other config settings? > I see no sqlite3_config_get() in sqlite3.h. There is no query function for the SQLITE_CONFIG_MEMSTATUS setting. -- D. Richard Hipp d...@sqli

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

lock() by putting each task in a separate process? -- 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 SQL functions available for testing only.

compile-time option that can be set to provide > internal functions by default? -DSQLITE_ENABLE_INTERNAL_FUNCTIONS NB: Do NOT enable this on a production build. The -DSQLITE_ENABLE_INTERNAL_FUNCTIONS compile-time option is for testing purposes only. -- D. Richard Hipp

[sqlite] New SQL functions available for testing only.

weaknesses that may turn up in these SQL functions. Fuzzer authors: I recommend that you enable these functions in your fuzzers. Doing so might help your fuzzersto find bugs that would otherwise be difficult to reach. Happy hunting. -- D. Richard Hipp d...@

  1   2   3   4   5   6   7   8   9   10   >