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

> Regards > Sebastian > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] Regarding CoC

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

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

POLY from the "PRAGMA compile_options" command. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Regarding CoC

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

Re: [sqlite] Regarding CoC

ues in a way that modern twitter-ites can better understand, so do not hesitate to speak up if you have a plan. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Regarding CoC

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

Re: [sqlite] R*Tree performance

work on it? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] help, sqlite3_get_table return 21，

n that breakpoint is hit. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_ENABLE_DBSTAT_VTAB

o changes in processor cache behavior, but that differences is way, way down in the noise. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] geopoly data input options

to me... Where can I find information about WKB? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] geopoly data input options

ry format is smaller and faster. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Regarding CoC

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

Re: [sqlite] How to round to an Integer

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

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

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

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

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

Re: [sqlite] Query performance slower in 3.25

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

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

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

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

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

Re: [sqlite] Query performance slower in 3.25

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

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

> version 3.12.1. Maybe we can learn from it to fix this problem. > > Best, > > Kelvin > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

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

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

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

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

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

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

_ > 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] dbhash collision

rg/src/file/ext/misc/shathree.c The ".sha3sum" command in the command-line shell[1] uses shathree.c. That hasher does include a length on both text and blob fields. See the description at https://www.sqlite.org/src/artifact/9e960ba5048?ln=552-575 [1] https://www.sqlite.org/cli.html

[sqlite] Version 3.25.1 coming soon....

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

Re: [sqlite] The "natural" order of the query results.

ECT a, b, sum(c) FROM t1 GROUP BY a, b ORDER BY a, b; -- 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 touches unchanged expression indexes on update

cement on the latest trunk version of SQLite. You'll need to grab a tarball (or clone the Fossil repository) and compile it yourself. If you can, please do this and try out the code and let me know whether or not it works, that will be appreciated. -- D. Richard Hipp d...@sqli

Re: [sqlite] geopoly_contains_point

y, I don't remember writing a test case for that. (Probably, I should go back and add a few.) Please try it and see what happens :-) Do you have specific plans to use geopoly? Is this new extension meeting a specific need that you have? Or are you just curiou

Re: [sqlite] Draft Documentation small fixes

detect changes that happen either > internally or externally*,* on a single database. > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >

Re: [sqlite] Draft: Window Functions

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

Re: [sqlite] SQLITE touches unchanged expression indexes on update

would be. I found this comment: https://www.sqlite.org/src/artifact/345ce35eb133?ln=306 So apparently this has come up before :-) That comment was inserted on 2015-09-04. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite

[sqlite] SQLite version 3.25.0 enters release testing

/325/index When the checklist above goes all green, we will cut the release. If you have any issues or concerns with the forthcoming 3.25.0 release, please bring them to my attention quickly. Thank you. -- D. Richard Hipp d...@sqlite.org ___ sqlite

Re: [sqlite] sqlite3_column_type returns NOT SQLITE_NULL and the following sqlite3_column_text returns with nullptr

hing is: the prior called sqlite3_column_type do not return > with SQLITE_NULL. That can happen when SQLite needs to do a type conversion (INTEGER to TEXT, or UTF-16 to UTF-8, for example) and it is unable to allocate sufficient memory to carry out the conversion. How big is your text string?

Re: [sqlite] Some queries with ORDER BY and LIMIT lock DB

c/tktview/9936b2fa443fec03ff25f9b822528c20a2200a49 -- 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] Some queries with ORDER BY and LIMIT lock DB

On 9/7/18, Stephen Chrzanowski wrote: > I can reproduce this issue with the SQLite3.exe under Win7. It depends on compile-time options. I have a repro case now. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-us

Re: [sqlite] Some queries with ORDER BY and LIMIT lock DB

d. -- 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] Incorrect result when using WHERE with with correlated sub-select query

hy you should never perform equality comparisons of floating point numbers. -- 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] Incorrect result when using WHERE with with correlated sub-select query

te-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] sqlite3_column_* with error handling

> 3. Is it possible for every single one of the sqlite3_column_* functions > to fail in this manner? I think only the routines that returns TEXT and BLOB use malloc() in the current implementation. That might change in the future though. -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] How to get all SQL statement syntax images?

On 9/1/18, Rocky Ji wrote: > Hi everyone, > > (Mailing list newbie here). Where can I get a corpus of all the > -stmt.gif that are shown in the online docs e.g. > https://sqlite.org/images/syntax/insert-stmt.gif ? https://www.sqlite.org/syntaxdiagrams.html -- D. Richard Hipp

Re: [sqlite] Lemon Parser vs bubble-generator.tcl

that would not have been possible had we been dependent on an outside tool. -- 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] Strategies to reduce page-loads?

go much faster if you do the inserts in ROWID or INTEGER PRIMARY KEY order, then do a "CREATE UNIQUE INDEX" on the osm-id after all inserts have completed. But it will work in either case. -- D. Richard Hipp d...@sqlite.org ___ sqli

Re: [sqlite] Strategies to reduce page-loads?

s stored. Or if you create a WITHOUT ROWID table, then the PRIMARY KEY is the value that determines (approximately) on which page the content is stored. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http:/

Re: [sqlite] sqlidiff --schema question

CREATE TABLE t (foo text); > > $ sqldiff --schema /tmp/f1.db /tmp/f2.db > $ Correct. sqldiff appears to only look at the column names, not constraints. I think it will pick up if you add an extra UNIQUE index. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] beginners question

On 8/30/18, Jürgen Palm wrote: > > > Richard Hipp wrote: >> On 8/30/18, Klaus Maas wrote: >>> Same issues on Xubuntu 16.04 and 18.04 >>> >>> US international keyboard layout >>> >>> Actually 2 questions: >>> >>>

Re: [sqlite] beginners question

you don't have libz on your system, probably you don't have readline or editline either. Again, what Linux distro is this? -- 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] Strategies to reduce page-loads?

On 8/30/18, t...@qvgps.com wrote: > Will change to INT PRIMARY KEY now. It must be INTEGER PRIMARY KEY - spelled out. INT PRIMARY KEY won't work. This is a quirk of SQLite. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sql

Re: [sqlite] Strategies to reduce page-loads?

l cause features that are close together geographically to tend to be close together within the file. There is are two extension functions in the https://www.sqlite.org/src/artifact/b0ff58fa643afa1d file of the SQLite source tree that might help you with

Re: [sqlite] Pragma Use for TCL scripts

Lite Encryption Extension? -- 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 name/identifier length limit?

X_SQL_LENGTH (default: 1,000,000). -- 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 find records in a table which are not in a second table?

able A with nam > values, which are not present in the nam values of table B? I suppose: SELECT * FROM A WHERE nam NOT IN (SELECT nam FROM B); -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglis

Re: [sqlite] Blob and Text columns: what's the difference?

e engines might also have this limitation too. But not SQLite. SQLite allows any column to be indexed, including BLOB colums. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.or

Re: [sqlite] Next release

On 8/25/18, R Smith wrote: > A quick dev question: Any idea on the eta for the next release? My best guess at the moment is 4 or 5 weeks. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org h

Re: [sqlite] minor documentation flaw

> > > > Wolfgang > > ___ > 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 mailin

Re: [sqlite] RBU conflicts with SQLITE_UNTESTABLE

we did for a single client. Are you finding it useful for something? -- 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 optimisation

lease (3.20, I think). Opcodes and their meanings can change from one release to the next. -- 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] Variable value vs Static inside the Sqlite datetime function.

On 8/21/18, Fim Wästberg wrote: > Will I works even If the date is 2018-12-18 ? How hard is it to try and see for yourself? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org h

Re: [sqlite] After upgrade from sqlite3 3.8.7.4 to anything after 3.14.1, I get "Error: destination database is in use"

O it looks to me like the > 'exclusive' command just needs to be removed ... the threadsafe option that > sqlite3 was built with looks like it is internally handling the locking. That would be my guess too. -- D. Richard Hipp d...@sqli

Re: [sqlite] FTS - IF NOT EXISTS missing from sqlite_master

und to be true before the text is inserted into the sqlite_master table, so why keep it around? -- 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] Variable value vs Static inside the Sqlite datetime function.

09-18 > > I want to replace the ( “+1” ….. months) with a dynamic value from my table > field named “Months_Later” (integer datatype) to give the date after the > number of months in that field. SELECT date('now',printf('%+d months',tab.Months_Later)) FROM ta

Re: [sqlite] Pragma notnull for integer primary keys?

ordinary columns that are marked NOT NULL, the answer will be "yes" according to both meanings. But for an INTEGER PRIMARY KEY, the answer according to the second meaning is "no". -- D. Richard Hipp d...@sqlite.org ___ sqlit

Re: [sqlite] BUG REPORT

fficially-supported "sqlite3.exe" command-line tool available from (https://www.sqlite.org/download.html)? The "DB Browser for SQLite" is a third-party tool, about which I know very little. -- D. Richard Hipp d...@sqlite.org ___ sqlite-us

Re: [sqlite] Querying an indexed JSON expression with parameter binding

mpiled? I'm guessing it will not, since the subroutine in the query planner that checks to see if an expression in the WHERE clause matches an expression in the index does not know that $key is equal to '$.name'. For the time being, you should hard-code the field name. -- D. Richard Hipp d..

Re: [sqlite] UPSERT on constraint name instead of conflict target

_ > 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] UPSERT fails for unique partial index

On 8/14/18, Richard Hipp wrote: > I will strive to bring the behavior of SQLite into > alignment with PostgreSQL. Now fixed on trunk -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.or

Re: [sqlite] UPSERT fails for unique partial index

T NULL, "status" > integer NOT NULL, "metadata" text, "secret_key" blob, "created_at" > datetime, "updated_at" datetime) > > CREATE UNIQUE INDEX "index_alarms_on_device_id_and_alarm_type" ON "alarms" > ("device_

Re: [sqlite] Using Chinook

n just the one directory that has a space in its name: sqlite3 "e:\VB Resources\SQLite\chinook.db" But your original command worked fine for me on Win10. So I don't know what the problem is. -- D. Richard Hipp d...@sqlite.org ___ sqlite-us

Re: [sqlite] SQLITE Porting on FreeRTOS with STM32

sts.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] vtab stat*

irtual table implement might implement its own internal indexes, and indeed most of them do, but those indexes are not visible as indexes to the rest of the system.) Since STAT4 only provides information about indexes, it cannot provide any information about virtual tables. -- D. Richard

Re: [sqlite] Save text file content in db: lines or whole file?

k you should store your files as a single big blob and parse out the individual lines using C++ code when you need that. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite

Re: [sqlite] Common index for multiple databases

le tables? -- 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] Add Column with "If Not Exists"

] to quickly check for the existance of tables and/or columns. This happens a lot in Fossil, which has an evolving schema but still needs to work with older repositories. [1] https://www.sqlite.org/c3ref/table_column_metadata.html -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Known reasons why sqlite3_open_v2 can take over 60s on windows?

notorious for causing problems on Windows machines. That might also be a 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] Database locked problem on Windows 7

t on Win7. SQLite should work the same on both. -- 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] Issue using SEE

use any 16 digit code. Please see section 5.0 of the document here: https://www.sqlite.org/see/doc/trunk/www/readme.wiki -- 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: Problem with sqlite3_prepare_v2

lf at the first sqlite3_step() on 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] Possible memory leak in shell.c

sis tools to get them to stop complaining. -- 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: Problem with sqlite3_prepare_v2

n_count() bases its answer on whatever schema was current during last transaction for that connection. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/

Re: [sqlite] Backup and integrity check questions

opy the file externally). -- 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] Create VIEW passing despite invalid column name specified

be corrected by subsequent DDL statements prior to using the view. -- 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 know which database is corrupted

ften dispatched from way down inside the I/O routines which have no knowledge of which database connection they are servicing. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite

Re: [sqlite] Immediate mode transaction gets error 5, SQLITE_BUSY when attempting commit

On 7/24/18, Andy Dickson wrote: > > Using sqlite version 3.7.17 (which I know is old but I in my little cube > have no power to change that). > Recent versions of SQLite consume substantially fewer CPU resources than 3.7.17. See the graph at https://www.sqlite.org/cpu.html -- D. Ri

Re: [sqlite] Web draft problem

On 7/20/18, R Smith wrote: > The Web-site seems to have a bit of an error on the draft pages Thanks for the report. It is a missing chown in the script that syncs from development. Fixed now. -- D. Richard Hipp d...@sqlite.org ___ sqlite-us

Re: [sqlite] Any ideas on how long it takes to drop a large table...rather an important question now...

ate database files to your main database. Then, to drop those tables, you can DETACH them, and then unlink() the corresponding database file. That should go much faster. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Huge RAM usage when sqlite is started from another thread

ver you want. -- 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] Huge RAM usage when sqlite is started from another thread

{ if(argc > 1){ poll(NULL); }else{ cout << "Starting of sqlite DB threaded mode ..." << endl; pthread_t p; if(pthread_create(, NULL, poll, NULL)){ cerr << "Error creating thread" << endl; } if(pthread_join(p, NULL)){ cerr << "Cannot join thread" << endl; } } } -- 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-tripping SQLite back and forth between text representation.

from two different versions of SQLite. -- 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] Network share & disk I/O error

org/pragma.html#pragma_locking_mode -- 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-tripping SQLite back and forth between text representation.

. At some point, tools become sufficiently ubiquitous and common-place that they cease to be specialized. The SQLite command-line shell may have reached that threshold. If not, it is certainly close. SQLite is certainly not obscure or esoteric. It comes installed by default on just about eve

Re: [sqlite] CHECK IGNORE?

be real hard to make it so for column ... CHECK(...) > ON CONFLICT... too? > We follow the lead of PostgreSQL. If you can convince the PostgreSQL devs to support upsert on check constraints, we will consider it. -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] CHECK IGNORE?

ly discards the ON CONFLICT clause. I think this has always been the case. -- 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 IGNORE?

On 7/9/18, Thomas Kurz wrote: > is there a way to have Sqlite ignore check violations? > https://www.sqlite.org/pragma.html#pragma_ignore_check_constraints -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite

Re: [sqlite] Segfault when authorizer denies some steps of creating a WITHOUT ROWID table

argv[1],0,0); > sqlite3_set_authorizer(db,xAuth,0); > printf("%d\n",sqlite3_exec(db,argv[2],0,0,0)); > return 0; > } > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailm

Re: [sqlite] Fwd: ON CONFLICT parser bug?

) parser (parsers with more lookahead also run slower) and by the need to provide full backwards compatibility with older versions of SQLite. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://ma

Re: [sqlite] SQLite truncating long records for text-type fields.

ou set ".mode quote" or ".mode line" in order to see the full text of ever column. -- 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 truncating long records for text-type fields.

,8,8,8,8,8,8,8,8,16,16,16,16,16,16,16,16,28,28,28,28,28,28,28,28]]} > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@

Re: [sqlite] 3.24 database table is locked

han from cursors on the rtree. This approach ensures that there are no read cursors on rtree tables when they are written. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite

Re: [sqlite] column types and constraints

ty of stability problem caused by flexible typing? -- 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] order by column_name collate custom_collation, with virtual table index

implement. > So is there a way to tell SQLite that vindex is of a given custom collation, > to open the possibility of the index being used? The only way to avoid sorting the output of a virtual table is for the xBestIndex routine to set the sqlite3_index_info.orderByConsumed boolean. -- D. Richard

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