Re: [sqlite] WITHOUT ROWID

2019-09-08 Thread Richard Hipp
On 9/8/19, t...@qvgps.com wrote: > > One option would be to create a new table with rowid, copy all records from > the old one, delete old one and rename new table. That is the quickest solution. -- D. Richard Hipp d...@sqlite.org ___ sql

Re: [sqlite] SQLITE_BUSY, database is locked in "PRAGMA journal_mode"

2019-09-04 Thread Richard Hipp
calling sqlite3_close()". -- 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] Tutorial on SQLite Internals - 2019-11-05 in Houston, TX

2019-09-02 Thread Richard Hipp
have questions, please ask and I will see if I can find answers. Or, some of the conference organizers are on this mailing list, so perhaps they will speak up. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] What is the zlib compression level used by sqlar?

2019-08-29 Thread Richard Hipp
me decoder works regardless of the compression level. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] database like file archive

2019-08-27 Thread Richard Hipp
ed recently to implement the best practices outlined in the first document above. The existing code is safe. But I'll get busy and add the extra layers of defense to make it even safer. -- D. Richard Hipp d...@sqlite.org ___ sqlite-us

Re: [sqlite] database like file archive

2019-08-27 Thread Richard Hipp
ttps://www.sqlite.org/sqlar.html#managing_an_sqlite_archive_from_the_command_line -- 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] Unexpected "out of memory" error in CLI edit() function

2019-08-23 Thread Richard Hipp
.S.: I am not subscribed to this mailing list, so please CC me > directly on any replies. > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Ric

Re: [sqlite] SQLite Encryption Extension For Use with With PHP 7.x Code

2019-08-20 Thread Richard Hipp
On 8/20/19, Mark Tomlin wrote: > I've looked at the PRAGMA statements and there doesn't appear to > be any public documentation on this interface. The PRAGMAs in question are part of the SEE documentation, as they are unique to SEE. -- D. Richard Hipp

Re: [sqlite] SQLite Encryption Extension For Use with With PHP 7.x Code

2019-08-20 Thread Richard Hipp
he PHP source code. You do not need to modify any C code, either in SQLite/SEE or in PHP. You can activate encryption and set the encryption key using a PRAGMA statement. > > Has anyone done this before? Yes. -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] Error response for automatic transaction rollback

2019-08-20 Thread Richard Hipp
On 8/20/19, Matt Zand wrote: > I wonder if version 3.29 does support error handling for sql transaction > rollbacks. Also, does it support bypassing errors by forcing unconditional > rollback yet. I don't understand what you are asking. -- D. Richard Hipp d

Re: [sqlite] crash at sqlite3DbMallocRawNN

2019-08-20 Thread Richard Hipp
_held(db->mutex) ); > 27023: assert( db->pnBytesFreed==0 ); > > > Thanks in advance! > > Tham > -- 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] Prepared Statement Consistency

2019-08-19 Thread Richard Hipp
ses? That depends, I suppose, one how the new CREATE differs from the prior table that you DROP-ed. -- 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: LSM1 lsm1BestIndex() always chooses table scan

2019-08-17 Thread Richard Hipp
I used as a template when throwing together the LSM1 vtab. The fix has now been checked into the SQLite source tree. -- 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] Schema updates across threads in WAL & multithread mode

2019-08-16 Thread Richard Hipp
le. If you are not deliberately holding a read transaction open, perhaps you are doing so accidentally by failing to sqlite3_reset() or sqlite3_finalize() a prepared statement. You can perhaps figure out which statement that is by running: SELECT sql FROM sqlite_stmt WHERE busy; --

Re: [sqlite] Getting a notification when a write lock is released.

2019-08-15 Thread Richard Hipp
ing a hung process. I am not aware of a way to do a blocking file lock with a timeout that is portable across operating systems. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Documentation update request

2019-08-15 Thread Richard Hipp
> > I didn't notice that, for some reason. Thanks for the correction. You didn't notice it because I only added it moments ago, in response to your documentation update request. -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Will rootpage number ever change?

2019-08-15 Thread Richard Hipp
e and each index is a separate b-tree. Each b-tree has a root page. All other pages of the b-tree are descended from the root page. The sqlite_master table identifies the page number of the root of each b-tree. The sqlite_master table itself is also a b-tree which is always rooted on page 1. --

Re: [sqlite] divide-by-zero bug in whereLoopAddBtreeIndex function

2019-08-15 Thread Richard Hipp
The mailing list strips attachments as an anti-spam measure. Please send the POC directly d...@sqlite.org. On 8/15/19, Xingwei Lin wrote: > Attach is the poc sql file. > I used the following command: -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] sqlite3_interrupt vs. SQLITE_CONFIG_SINGLETHREAD

2019-08-14 Thread Richard Hipp
sqlite3_interrupt() that compile-time options matter? -- 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] specify CHECK clause to date text field

2019-08-14 Thread Richard Hipp
"nm" (on many unix systems, or the equivalent on Mac or Windows) on a compiled sqlite3.o file, and seeing that "strftime" appears nowhere in the output, while library routines that SQLite does use like "open", "read", and "mall

Re: [sqlite] Programming methodology (was DEF CON (wasL A license plate of NULL))

2019-08-13 Thread Richard Hipp
On 8/13/19, Jose Isaias Cabrera wrote: > > I see all of you smart programmers using this > non-column matching behavior, and I ask myself why? Because that's the way Dennis Richie did it. :-) -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Correct use of sqlite3_vtab_nochange/sqlite3_value_nochange

2019-08-13 Thread Richard Hipp
load and decompess the complete content of that file as part of the UPDATE operation. sqlite3_vtab_nochange() facilitates such optimizations. But it never occurred to me that somebody might do this on the PRIMARY KEY. I don't see any reason why it wouldn't work, though. -- D. Richard Hipp

Re: [sqlite] SQLITE_BUSY (SQLITE_BUSY_SNAPSHOT) due to a simple SELECT query -- Documentation needed!

2019-08-12 Thread Richard Hipp
The documentation on transactions at https://www.sqlite.org/lang_transaction.html was written long, long ago, apparently long before WAL mode was available, and is in serious need of updating and improvement. I'm working on that now -- D. Richard Hipp d...@sqlit

Re: [sqlite] COMMIT, what locking behaviour when current lock is merely SHARED?

2019-08-09 Thread Richard Hipp
On 8/9/19, David Raymond wrote: > > I'm pretty sure you missed the bit where he said that there was only a read, > and no changes were made or requested. > You are correct - I missed that part. In that case, it just drops the SHARED lock. -- D. Richard Hip

Re: [sqlite] COMMIT, what locking behaviour when current lock is merely SHARED?

2019-08-09 Thread Richard Hipp
ry to make sure no other connections are simultaneously reading the database, because it would not work for the committer to change content out from under the other readers. After the COMMIT, it falls back to unlocked. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Is rootPage a reasonable estimate for index age?

2019-08-07 Thread Richard Hipp
pages it will add new > indexes to smaller pages than older indexes? It probably only works because your DB is vacuumed. Seems to me that the rowid of the sqlite_master table entry for your index would be a more reliable indicator. Larger rowids are newer

Re: [sqlite] Probable bug with SQLITE_DQS=0 regarding shell .schema command?

2019-08-06 Thread Richard Hipp
On 8/6/19, Olivier Mascia wrote: > Using 3.29.0 with SQLITE_DQS. Is this the problem that was fixed here: https://www.sqlite.org/src/timeline?c=fcd937d9786a82ef -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-us

Re: [sqlite] Avoiding resource exhaustion caused by executing untrusted SQL queries

2019-08-05 Thread Richard Hipp
Lite builds in its own optimal memory allocator that uses only memory from a single big allocation you provide it at start-time. So you give SQLite 30MB (or whatever you think is appropriate) to play with, and it uses that and only that memory, and never goes to malloc(). -- D

Re: [sqlite] Issue report: sqlite3_set_authorizer triggers error 4/516 (SQLITE_ABORT_ROLLBACK) during statement iteration

2019-08-02 Thread Richard Hipp
uthorizer, then you will be fine. But if you mess up, and accidentally use a prepared statement with an incorrect authorizer, and that statement leaks information or allows unauthorized changes to the database, then no tears. -- D. Richard Hipp d...@s

Re: [sqlite] Issue report: sqlite3_set_authorizer triggers error 4/516 (SQLITE_ABORT_ROLLBACK) during statement iteration

2019-08-01 Thread Richard Hipp
de shown below fixes the problem, and report back. https://www.sqlite.org/src/artifact/0fac710388?ln=81 -- 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] storing blobs in a separate table

2019-08-01 Thread Richard Hipp
p information. If it guesses correctly, it can avoid reading a page from disk. But it has to fallback to reading the page if it guesses incorrectly. See the 22 lines of code here: https://sqlite.org/src/artifact/58d002f71?ln=4626-4648 -- D. Richard Hi

Re: [sqlite] Explicit "read transaction" with journal_mode=WAL.

2019-07-31 Thread Richard Hipp
st and maintain for the next 31 years. So it has a high cost and low 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] [SPAM?] Re: Explicit "read transaction" with journal_mode=WAL.

2019-07-31 Thread Richard Hipp
ider the things you wanted to do and whether it's worth providing a > better way to do them. Just to confirm: Simon is exactly correct. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http:/

Re: [sqlite] [EXTERNAL] Help with sqlite3TreeViewSelect

2019-07-29 Thread Richard Hipp
the comments, or should we ever need to work on that particular aspect of the implementation. As with all of the internal representation, we might find a better way to accomplish the same thing tomorrow, and totally eliminate the IF_NULL_ROW operator from the code. So don't become too attach

Re: [sqlite] [EXTERNAL] Virtual Tables xConnect Called When?

2019-07-25 Thread Richard Hipp
; Urite mala mundi > Ardente veritate > Incendite tenebras mundi" > ___ > 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] Seg fault using json_each() subquery

2019-07-23 Thread Richard Hipp
> 0; > > sqlite> select sqlite_version(); > 3.18.2 > > Am I doing anything obviously wrong? Or is this a known problem/limitation? > Thanks! > Minollo > > _______ > sqlite-us

Re: [sqlite] [EXTERNAL] Determining valid statement placeholders.

2019-07-22 Thread Richard Hipp
t the first 99 are unused. -- 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] Boolean values in variable, tclsqlite3

2019-07-19 Thread Richard Hipp
On 7/19/19, Gilles Pérez wrote: > set tvalue true This statement sets the TCL variable "tvalue" to the four-character string "true", not to a boolean true. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users ma

Re: [sqlite] Unreachable Breaks with ICC on Windows

2019-07-17 Thread Richard Hipp
le "break" statements with "assert(0)". -- 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] strftime("%Y", "-1234-01-01") returns -123

2019-07-16 Thread Richard Hipp
een -01-01 00:00:00 and -12-31 23:59:59 (julian day numbers 1721059.5 through 5373484.5). For dates outside that range, the results of these functions are undefined." -- D. Richard Hipp d...@sqlite.org ___ sqlite-users ma

Re: [sqlite] Safe saving of in-memory db to disk file

2019-07-15 Thread Richard Hipp
On 7/15/19, Jens Alfke wrote: > > If you’re going to keep your data in memory, there’s no good reason to use > SQLite at all. Yeah there is. SQLite has a high-level query language (SQL) that can radically simplify application development. -- D. Richard Hipp d...@s

Re: [sqlite] Bug in all-bnf.html documentation?

2019-07-13 Thread Richard Hipp
f the language. The implementation is described by a LALR(1) grammar at https://sqlite.org/src/file/src/parse.y if that is of any help to you. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.s

Re: [sqlite] Bug in all-bnf.html documentation?

2019-07-13 Thread Richard Hipp
rs ago, but the generator script has not been keep up-to-date and no longer functions. The file has been removed from the trunk check-in and should no longer appear when you attempt to load it. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailin

Re: [sqlite] Grammar police

2019-07-11 Thread Richard Hipp
y, for sending them in. Please feel free to do so at any time. You can send them directly to me if you don't want to send them to the mailing list. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqli

Re: [sqlite] Grammar police

2019-07-11 Thread Richard Hipp
y, for sending them in. Please feel free to do so at any time. You can send them directly to me if you don't want to send them to the mailing list. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqli

[sqlite] Quirks of SQLite. Was: Version 3.29.0

2019-07-11 Thread Richard Hipp
EVERYONE: If you have personally experienced some unusual or unexpected feature of SQLite that you think should be added to "quirks.html", please follow-up to this thread, or send me private email, so that I can consider adding it. Thanks. -

Re: [sqlite] FW: [sqlite-announce] Version 3.29.0

2019-07-11 Thread Richard Hipp
On 7/11/19, David Raymond wrote: > I don't think I'd ever seen the quirks page > (https://sqlite.org/quirks.html) before. Is that new-ish? It's been around for a little more than a year. See https://www.sqlite.org/docsrc/finfo?ss=c&name=pages%2Fquirks.in -- D. Ric

Re: [sqlite] sqlite3 unable to open network db file in readwrite mode

2019-07-07 Thread Richard Hipp
der to write to the database file, so that SQLite can create a rollback journal for transaction control. -- 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] Preserve file descriptors for journal files

2019-07-07 Thread Richard Hipp
ication have exclusive access to the database file? If so, then consider: PRAGMA locking_mode=EXCLUSIVE; -- 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] json_group_array( json_object())

2019-07-05 Thread Richard Hipp
ook, > 'total_notes', total_notes >), ...etc > > results in: > > {"data":"[{\"type\":\"notebook\",\"id\":2,\"attributes\":{\"book\":\"brew\&

Re: [sqlite] modify table (again)

2019-07-02 Thread Richard Hipp
On 7/1/19, Thomas Kurz wrote: > > I really followed the 12-step ALTER TABLE schema and stumbled upon the > following problem: Step 3 and Step 8 need to be modified to also record the content of VIEWs in addition to INDEXes and TRIGGERs. I am working on the revised text now. -- D. Ric

Re: [sqlite] INSERT INTO ... ON CONFLICT(...) DO UPDATE ...

2019-06-14 Thread Richard Hipp
of type IMMEDIATE? 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] [SPAM?] Re: [EXTERNAL] Re: Should SQLite distinguish between +0.0 and -0.0 on output?

2019-06-13 Thread Richard Hipp
hen converts back to double upon retrieval. That round-trip > would change -0.0 into +0.0." I was wondering when this changed? You are right. I had forgotten about that point. This has not been changed even now, and so -0.0 does get truncated to +0.0 when it is stored in the database

Re: [sqlite] [SPAM?] Re: [EXTERNAL] Re: Should SQLite distinguish between +0.0 and -0.0 on output?

2019-06-13 Thread Richard Hipp
> move to a SQLite version with this improvement. SQLite version 3.0.0 from 2004-06-17. -- 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] endianess/signed issue on OpenBSD/sparc64 ?

2019-06-13 Thread Richard Hipp
get me a temporary login on such a system, however, I will debug it for you. Send private email to the address below. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bi

Re: [sqlite] Should SQLite distinguish between +0.0 and -0.0 on output?

2019-06-12 Thread Richard Hipp
On 6/12/19, James K. Lowden wrote: > what kind of computation > would lead to a value in memory representing -0,0? 0.0/-1.0 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.or

Re: [sqlite] Should SQLite distinguish between +0.0 and -0.0 on output?

2019-06-12 Thread Richard Hipp
isting database files obsolete. -- 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] Should SQLite distinguish between +0.0 and -0.0 on output?

2019-06-12 Thread Richard Hipp
ot;: PostgreSQL, MySQL, Oracle, SqlServer So in my tests, programming languages do distinguish between +0.0 and -0.0, but database engines do not. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] Should SQLite distinguish between +0.0 and -0.0 on output?

2019-06-12 Thread Richard Hipp
s only the binary-to-text conversion routine that is at question here. If you are reading back your database content using sqlite3_column_double(), you get back bit-for-bit exactly what you put in. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users m

Re: [sqlite] Should SQLite distinguish between +0.0 and -0.0 on output?

2019-06-12 Thread Richard Hipp
ted enhancements. -- 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] Should SQLite distinguish between +0.0 and -0.0 on output?

2019-06-12 Thread Richard Hipp
IEEE754 floating point numbers have separate representations for +0.0 and -0.0. As currently implemented, SQLite always display both quantities as just "0.0". Question: Should SQLite be enhanced to show -0.0 as "-0.0"? Or, would that create unnecessary confusion? -

Re: [sqlite] Unexpected parsing of an invalid CREATE TABLE statement

2019-06-10 Thread Richard Hipp
t; The parser in SQL is very forgiving. Does this cause some kind of 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] How to insert the BLOB in database?

2019-06-09 Thread Richard Hipp
On 6/9/19, Igor Korot wrote: > > Now I open this database in sqlite3 CLI binary and would like to insert some > png > file inside this BLOB field. INSERT INTO tab1(blob1) VALUES(readfile('some.png')); -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Compile time error when compiling extension shathree.c together with sqlite3.c for Android

2019-06-07 Thread Richard Hipp
On 6/7/19, Ulrich Telle wrote: > Would it be possible for the SQLite developers to adjust the variable names > used in the extension shathree.c to avoid this name clash with the macro in > termbits.h? https://www.sqlite.org/src/timeline?c=3ec73711 -- D. Richard Hipp d...@s

Re: [sqlite] upsert unique partial index

2019-06-05 Thread Richard Hipp
ARY KEY or UNIQUE > constraint > > ingo > _______ > 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] CVE-2019-5018, Resolved Which Version?

2019-06-04 Thread Richard Hipp
On 6/4/19, Mike Nicolino wrote: > > I am trying to determine which version CVE-2019-5018 is resolved in. It appears to be 3.28.0, as best as I can tell. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite

Re: [sqlite] Change delimiter with CSV extension?

2019-05-30 Thread Richard Hipp
ard-coded. -- 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: "View with UNION ALL and limit in subquery" (v 3.28.0)

2019-05-29 Thread Richard Hipp
he overall result set and not for the subquery. > > > In the hope that this might help others. > Thank you very much for your hard work! > > > Cheers, > Marco > > > _______ > sqlite-users mailing list > sqlite-users@mailinglists.sqlit

Re: [sqlite] bug in sqlite3??

2019-05-27 Thread Richard Hipp
also notice that your columns are named "column_one", "column_two", "column_three", and so forth. Is that deliberate, or have you post-processed the database to obfuscate these column names? If the latter, might the missing rows have been deleted by th

Re: [sqlite] SEE extension questions

2019-05-26 Thread Richard Hipp
abase? No, not that I can think of. -- 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] round function inconsistent

2019-05-24 Thread Richard Hipp
RIC),2) from t1 And the result is then: 1 3.26 2 3.26 -- 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] Unclear about some shell command differences

2019-05-24 Thread Richard Hipp
originally called ".repair". I do not recall why we created that command. There will be a new ".recover" command in the next release (currently available in the prerelease snapshot) which does a better job of recovering content from a c

Re: [sqlite] round function inconsistent

2019-05-24 Thread Richard Hipp
nce always round the same. I do not know what the underlying representation for floating point numbers is in Excel, but as your experiment shows, it is probably not IEEE754 double-precision binary. -- D. Richard Hipp d...@sqlite.org ___ sqlite-us

Re: [sqlite] round function inconsistent

2019-05-24 Thread Richard Hipp
tical inputs? How does it know which answer to give? -- 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] round function inconsistent

2019-05-24 Thread Richard Hipp
double-precision binary floating point number. So the system has to use an approximation. The closest approximation is 3.25489341858963598497211933135986328125 and that value rounds to 3.25. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users m

Re: [sqlite] Bug: CTE name leaking through views

2019-05-22 Thread Richard Hipp
Thanks for the test case. This problem should now be fixed on trunk. Please try it out and let us know if you encounter any additional probglems. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Bug: sqlite ARM endian problem

2019-05-22 Thread Richard Hipp
my mail. I've sent it again and will get back to > you then. I'll also try out aarch64 in qemu in the meantime. Thanks for verifying the fix for us! -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailingli

Re: [sqlite] CSV import does not handle fields with a comma surrounded by double

2019-05-21 Thread Richard Hipp
s: "Spaces are considered part of a field and should not be ignored." -- 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] CSV import does not handle fields with a comma surrounded by double

2019-05-21 Thread Richard Hipp
On 5/21/19, Faheem Mitha wrote: > The ".import" command does not parse CSV correctly. > somestuff, "some,stuff" This is not valid CSV. There is an extra space character after the comma and before the double-quote. -- D. Ri

Re: [sqlite] Bug: sqlite ARM endian problem

2019-05-20 Thread Richard Hipp
ify that it now works on OpenWrt armeb xscale devices and report back, as we have no way of verifying this ourselves. Thanks. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.

Re: [sqlite] Cell pointer array values

2019-05-18 Thread Richard Hipp
nk in terms of offsets within a single page. You should get the same answer in either case, but just know that you are looking at this from a different angle. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailin

Re: [sqlite] Cell pointer array values

2019-05-18 Thread Richard Hipp
s the offset to the start of the cell from the beginning of the page. -- 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] Series of statements results in a malformed database disk image

2019-05-09 Thread Richard Hipp
On 5/9/19, Manuel Rigger wrote: > > I discovered a sequence of statements that results in a malformed database > disk image: > Should be fixed now. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglist

Re: [sqlite] Series of statements results in a malformed database disk image

2019-05-09 Thread Richard Hipp
point value can be represented by an integer. That optimization works well when storing floating point values like 1.0 and 0.0, but might be running into round-off error problems when storing 9223372036854775807.0. Still looking. -- D. Richard Hipp

Re: [sqlite] Series of statements results in a malformed database disk image

2019-05-09 Thread Richard Hipp
UPDATE OR REPLACE t1 SET c1 = 1; > SELECT DISTINCT * FROM t1 WHERE (t1.c0 IS NULL); > > The last statement returns the following: > |1.0 > Error: near line 5: database disk image is malformed Ticket here: https://www.sqlite.org/src/tktview/6c1d3febc00b22d457

Re: [sqlite] Talos Security Advisory for Sqlite3 (TALOS-2019-0777)

2019-05-08 Thread Richard Hipp
On 5/8/19, Richard Hipp wrote: > On 5/8/19, Regina Wilson (regiwils) wrote: >> >> Here’s a copy of the report. > > > Thanks! Is the "poc" file available for our inspection too? If you want to keep the "poc" encrypted, you can log in at https://s

Re: [sqlite] Talos Security Advisory for Sqlite3 (TALOS-2019-0777)

2019-05-08 Thread Richard Hipp
On 5/8/19, Regina Wilson (regiwils) wrote: > > Here’s a copy of the report. Thanks! Is the "poc" file available for our inspection too? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists

Re: [sqlite] Talos Security Advisory for Sqlite3 (TALOS-2019-0777)

2019-05-08 Thread Richard Hipp
On 5/8/19, Regina Wilson (regiwils) wrote: > Hello D. Richard Hipp, > > To date, we have not received a response from point of contact handling > security issues. Can you assist with the issues reported via the bug report > site? We don't do PGP here. But you can se

Re: [sqlite] INSERT OR FAIL inserts row although it violates a table constraint

2019-05-07 Thread Richard Hipp
nts of an inserted or updated row to change datatypes, which causes the row to be constructed incorrectly. Fixed by check-in https://www.sqlite.org/src/info/3f1c8051648a341d -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sql

Re: [sqlite] INSERT OR FAIL inserts row although it violates a table constraint

2019-05-07 Thread Richard Hipp
1), > (0, 2); > REINDEX;; > SELECT * FROM t0; -- returns 0|1 > SELECT * FROM t0 WHERE c1=1; -- returns nothing > > Best, > Manuel > ___ > sqlite-users mailing list > sqlite-users@mailinglists.s

Re: [sqlite] Problem with REAL PRIMARY KEY

2019-05-04 Thread Richard Hipp
se <, <=, >, and >=. -- 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] Partial Index on "~" malfunctions when used with likely/unlikely

2019-05-04 Thread Richard Hipp
> Manuel >> > _______ > 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] Index on REAL malfunctions in combination with the LENGTH function

2019-05-03 Thread Richard Hipp
On 5/3/19, Manuel Rigger wrote: > I just tried the examples on the int-real branch, > and it seems that they do not cause any errors. > The int-real branch has now been fully tested and merged to trunk. -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] Query planner: Covering index not chosen over primary key

2019-05-03 Thread Richard Hipp
I have your request. -- 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 could happen if an app crashes while calling sqlite3_rekey_v2()?

2019-05-03 Thread Richard Hipp
UUM is *highly* recommended for security if you take an unencrypted database that has never before been encrypted and "rekey" it into an encrypted database. That is a totally separate issue. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mai

Re: [sqlite] SQLite windows function support

2019-05-03 Thread Richard Hipp
the "/draft" from the middle of the URL in order to get the officially released document. -- 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 REAL malfunctions in combination with the LENGTH function

2019-05-03 Thread Richard Hipp
SQLite regression tests. -- 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 REAL malfunctions in combination with the LENGTH function

2019-05-03 Thread Richard Hipp
right this moment. I will return to that branch, finish testing it, and perhaps merge it to trunk, when I get a chance. -- 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] TYPEOF index on REAL column malfunctions

2019-05-02 Thread Richard Hipp
On 5/2/19, Manuel Rigger wrote: > Hi everyone, > > I think that I found another issue related to type affinity on real columns: The typeof() function corner-case you identified has been fixed in check-in https://www.sqlite.org/src/timeline?c=48889530a9de22fe -- D. Richard Hipp d...@s

Re: [sqlite] UPSERT clause does not work with "NOT NULL" constraint

2019-05-02 Thread Richard Hipp
uot; Would it maybe be helpful to update the documentation to > explicitly state that UPSERT does not apply to NOT NULL constraints, and > that apart from this case DO NOTHING works in the same way as INSERT OR > IGNORE? > > Best, > Manuel > > On Thu, May 2, 2019 at 5:38 P

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