Re: [sqlite] Differences in row removal methods between iOS SQLite and PC?

are often overwritten. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Differences in row removal methods between iOS SQLite and PC?

On Sat, Oct 12, 2013 at 10:15 PM, Richard Hipp d...@sqlite.org wrote: On Sat, Oct 12, 2013 at 10:06 PM, Paul L Daniels pldani...@pldaniels.comwrote: Intact record, before removal; 81 16 86 30 05 1D 47 81 65 52 45 4D 4F 56 45 4D ...0..G.eREMOVEM Removed using sqlite3 cli [ Ubuntu 13.04

Re: [sqlite] Segmentation Fault With Trigger

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

Re: [sqlite] Bug report.

/body /html As you can see country@printable has the type _name TEXT. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] sqlite3_blob_open issue

of the output of PRAGMA database_list; -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Segmentation Fault With Trigger

On Fri, Oct 11, 2013 at 10:06 AM, techi eth techi...@gmail.com wrote: Please provide some hint. Recompile with -O0 and -g and then post the stack trace after the segfault. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite

Re: [sqlite] Bug: analyze.c does not honor SQLITE_64BIT_STATS

. (See http://www.sqlite.org/src/artifact/da9119eb?ln=163) And the SQLite version assumes that %lld means 64-bit integer and %d means 32-bit integer. I think that http://www.sqlite.org/src/info/e97d7d3044 fixes this issue. Please correct me if I've missed something. -- D. Richard Hipp d

Re: [sqlite] Virtual Table: misuse error on sqlite3_declare_vtab()

is called to create the new virtual table. The xCreate method needs to tell the SQLite core what the schema for the virtual table is and it uses sqlite3_declare_vtab() to do so. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Virtual Table: misuse error on sqlite3_declare_vtab()

? Recompile with line-number information (-g is it?) so that you know exactly which line of code tried to jump to the NULL pointer. Then you'll know exactly which method you need to add. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite

Re: [sqlite] 3.8.1

On Fri, Oct 4, 2013 at 2:32 PM, Peter Haworth p...@lcsql.com wrote: I've seen emntion of version 3.8.1 of sqlite - is there a document somwhere that describes the changes? http://www.sqlite.org/draft/releaselog/current.html -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Write-ahead logging issue on Android

a temporary file so that a multi-row update can be backed out if a constraint fails, but you are out of temporary file space, or maybe you don't have access rights on the temporary file space. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Hints for the query planner

On Wed, Oct 2, 2013 at 1:40 AM, Nico Williams n...@cryptonector.com wrote: On Tuesday, September 10, 2013, Richard Hipp wrote: SURVEY QUESTION: The question for today is what to call this magic hint function: (1) unlikely(EXPR) (2) selective(EXPR) (3) seldom(EXPR) (4

Re: [sqlite] Implementing a new index

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

Re: [sqlite] Cost/viability of using layered views as filters?

) or is it worse? I'm guessing that sqlite3_step() runs at the same speed. sqlite3_prepare_v2() might take a couple extra microseconds, but not enough extra time that you could measure it. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite

[sqlite] Version 3.8.1 beta

SQLite version 3.8.1 will be published before too much longer, probably. You can find beta versions at http://www.sqlite.org/download.html Comments, criticisms, and third-party testing of this beta is appreciated. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Bug in sqlite3.exe?

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

Re: [sqlite] SQLite3 3.7.17 = using column names with character '@'.

breaking backwards compatibility. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite database created in PHP not readable in python

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

Re: [sqlite] Bug : Tcl interface + INSERT OR REPLACE statement

__**_ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**usershttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing

Re: [sqlite] Namespacing sqlite3

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

Re: [sqlite] racing with date('now') (was: Select with dates)

that commenting out the iCurrentTime reset in sqlite3_step() would cause the behavior you describe. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Regression: Query takes 10x longer when using version 3.8.x

have a little more time now. I'll try again. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Regression: Query takes 10x longer when using version 3.8.x

LIMIT 100; -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] COMMIT or ROLLBACK failure

sqlite3_close() the database connection if you want. Depending on the reason for the COMMIT failure, you might be able to try it again, after a delay. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] SELECT statement performance in 3.8.0.2

0 ORDER BY product.product_id ASC LIMIT 100; ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Using pragma user_version when doing updates

name=KeyLock; I've tried using CASE..WHEN..ELSE but it doesn't seem to like the pragma statement in there. You can access the user version using PRAGMA user_version. Unfortunately, you cannot combine a pragma with a larger query. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] racing with date('now') (was: Select with dates)

'now' to mean exactly the same time for an entire SQL statement would break such applications. As a compromise, the current SQLite trunk causes 'now' to be exactly the same for all date and time functions within a single sqlite3_step() call. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] racing with date('now') (was: Select with dates)

: SELECT (SELECT timestamp('now')), * FROM tab; This issue is sufficiently obscure that it is not worth adding (and testing and documenting and supporting forever) yet another pragma. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite

Re: [sqlite] racing with date('now') (was: Select with dates)

. I call it obscure because the date and time functions have worked the way they do for a least 10 years and last week was the first time I have heard any complaints. Surely if the behavior were causing any significant problems for anyone I would have heard about it long before. -- D. Richard

Re: [sqlite] WAL Checkpointing question

the database file or the WAL file is unreadable due to hardware problems, then that could lead to corruption. But as long as the files are readable, recovery should always be possible. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite

Re: [sqlite] Clarification of overloading built-in funcs

! -- - stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] virtual table end of insert

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

Re: [sqlite] Regression: Query takes 10x longer when using version 3.8.x

IS NULL WHERE R.parent = (SELECT parent FROM Relationships WHERE rowid = 2) ORDER BY sort ASC LIMIT 100; ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d

[sqlite] Hints for the query planner

is small, but if the second argument is close to 1.0, then those names seem backwards. I don't know if this matters. The optional second argument is not guaranteed to make it into an actually release. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

Re: [sqlite] Out of memory error

BY terms, then SQLite has to do a sort, and that sort will occur in memory and require sufficient memory to hold the entire 1.5-million-row table. Can you try setting PRAGMA temp_store=FILE and see if that doesn't solve your OOM problem? -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] UNSIGNED BIG INT in SQLite 3.7.11.

2013-08-29 17:35:01 Enter .help for instructions Enter SQL statements terminated with a ; sqlite select 1024*1024*1024*1024*1024; 1125899906842624 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] UPDATE question

really have to go out of your way to do that. If a constraint error happens, the entire UPDATE statement is rolled back (except if OR FAIL is specified - see the docs). Yes, I know this is not relational. No, I do not intend to fix it. - D. Richard Hipp d...@sqlite.org

Re: [sqlite] How to use aux_data effectively?

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

[sqlite] Collating sequences. Was: Query problems

matches the collating sequence of the query and the index can be used. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] about Khmer unicode with sqlite

, then that is a fault in the shell program, not of SQLite. So what shell program are you using? D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Performance question related to multiple processes using sqlite

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

Re: [sqlite] Collating sequences. Was: Query problems

On Thu, Sep 5, 2013 at 9:31 AM, Igor Tandetnik i...@tandetnik.org wrote: On 9/5/2013 7:31 AM, Richard Hipp wrote: There seems to be some misinformation circulating in this thread. Please let me try to clear up a few points. While we are at it, an interesting question was raised upthread

Re: [sqlite] Collating sequences. Was: Query problems

: the first SELECT statement of the query that has an explicitly defined collating sequence. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL insert performance on Windows Mobile 6.5

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

Re: [sqlite] SQLite - potential bug with multiple leftjoin/groupby/count

On Tue, Sep 3, 2013 at 10:41 AM, Harry Beezhold ha...@beezhold.com wrote: The attached database (view.db) has 3 tables The sqlite-users@sqlite.org mailing list strips off attachments. Can you send a link instead? -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Table name length in sqlite affects performance. Why?

On Tue, Sep 3, 2013 at 8:43 PM, Jared Albers jalb...@mymail.mines.eduwrote: Attached is a code example that reproduces the problem. The sqlite-users@sqlite.org mailing list strips off attachments. Can you send a link to your code? -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] [CRASH] Segmentation fault since 3.8.0

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

Re: [sqlite] [CRASH] Segmentation fault since 3.8.0

the cursor, it dereferences a NULL pointer and segfaults. You can disable the optimization in the shell using: .testctrl optimizations 0x400 Or from C code: sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS, db, 0x400); We should have a proper fix before too long. -- D. Richard Hipp d

Re: [sqlite] [CRASH] Segmentation fault since 3.8.0

On Tue, Sep 3, 2013 at 9:09 AM, Richard Hipp d...@sqlite.org wrote: We should have a proper fix before too long. That fix can now be seen at http://www.sqlite.org/src/info/0303d6bc71 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Is SQLite a DBMS?

in school is not always true. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Inefficient covering index used for Subversion with SQLite 3.8.0

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

Re: [sqlite] Inefficient covering index used for Subversion with SQLite 3.8.0

source tree so that people who build from sources do not have to download (a particular version of) sqlite. Mozilla works this way, as does Fossil. I think Chromium does too, though I'd need to check to be sure. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Inefficient covering index used for Subversion with SQLite 3.8.0

or not this will be a worthwhile tradeoff. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Strange assert when running with authorizer

9b67c633d932f3e5 3 BAD 2012-02-11 23:55:15 98efac9630ca96ba 1 BAD 2010-12-07 20:14:09 a586a4deeb253300 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What am I missing when recovering a hot journal?

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

Re: [sqlite] Inefficient covering index used for Subversion with SQLite 3.8.0

it might make things easier for developers. Please try this out (by downloading sources from http://www.sqlite.org/src/info/d8daaba7da or by applying the simple patch shown there to any 3.7.x or 3.8.x version of SQLite) and let me know what you think. Your feedback is appreciated. -- D. Richard Hipp

Re: [sqlite] help needed for major SQLite problem

is doing when the error comes back. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] help needed for major SQLite problem

, Richard Hipp d...@sqlite.org wrote: On Sun, Sep 1, 2013 at 1:12 PM, C M cmpyt...@gmail.com wrote: I have a Python application that uses SQLite, and I randomly get this error: SQL logic error or missing database I have no idea how to figure out what's wrong, A good

Re: [sqlite] to encrypt sqlite db

algorithm, whatever it is, needs to be resistant to a known-plaintext attack. SEE uses a random IV or nonce on each page. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] Why latest places.sqlite from firefox can't be opened by some older versions of sqlite

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

Re: [sqlite] to encrypt sqlite db

known. That's what salt is for, no? nonce, IV, salt - call it whatever you want. Yes. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] recommended extension entry point name

or sqlite3_extension_name_init? Thanks, Pepijn ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] curious: Why no shared library or DLL?

DLL installed on their system. All such grief is easily avoided by statically linking. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Changed behavior from 3.7.17 to 3.8.0.

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

Re: [sqlite] recommended extension entry point name

On Fri, Aug 30, 2013 at 9:42 AM, Pepijn Van Eeckhoudt pep...@vaneeckhoudt.net wrote: So for new development sqlite3_X_init is preferred over sqlite3_extension_init? That's my preference. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing

Re: [sqlite] Inefficient covering index used for Subversion with SQLite 3.8.0

. An adjustment to the query planner so that it works better for your test case has been checked in here: http://www.sqlite.org/src/info/79e458ef7a -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

Re: [sqlite] Inefficient covering index used for Subversion with SQLite 3.8.0

key. But the query planner has know way of knowing that wc_id is always the same value, unless you run ANALYZE. Can you do that, please: Run ANALYZE, then send in the content of the resulting sqlite_stat1 table. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Inefficient covering index used for Subversion with SQLite 3.8.0

On Fri, Aug 30, 2013 at 3:31 PM, Bert Huijben rhuij...@apache.org wrote: The analyze on the very small database (which I used for the comparison between 3.7 and 3.8) is: Thanks for the data. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users

Re: [sqlite] segmentation fault with 3.8.0

/9f2eb3abac The fix is here: http://www.sqlite.org/src/info/c1152bdcbb A patch release 3.8.0.1 that includes this fix and fixes for two other equally obscure corner cases is currently in test and is expected to go out later today. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] segmentation fault with 3.8.0

On Thu, Aug 29, 2013 at 11:38 AM, Richard Hipp d...@sqlite.org wrote: A patch release 3.8.0.1 that includes this fix and fixes for two other equally obscure corner cases is currently in test and is expected to go out later today. Complete set of diffs for the proposed patch release: http

Re: [sqlite] segmentation fault with 3.8.0

omit the whereShortCut() routine entirely and SQLite would still give the correct answer. The only downside is that sqlite3_prepare_v2() would run slightly slower in the common case. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite

Re: [sqlite] v3.8 .import misbehaves

inside a string. The leading quote should not be considered an escaped quote. The ,, pattern is very common for denoting empty field. Unable to reproduce the problem. CSV import works according to RFC4180 when I try it. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] CREATE INDEX and column order

as a set. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] v3.8 .import misbehaves

.sep , .import data tab gives error(s). Unable to reproduce the problem. The example above works correctly for me using SQLite 3.8.0 on Linux and on Windows8. Please verify that you are using 3.8.0 (where this problem has been fixed) and not SQLite version 3.7.17 or earlier. -- D. Richard

Re: [sqlite] v3.8 .import misbehaves

http://www.sqlite.org/src/info/b5617e4fda -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Different result from experimental query

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

Re: [sqlite] Different result from experimental query

Problem fixed here: http://www.sqlite.org/src/info/caab361ebe -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Path Length Limit on Windows

windows VFS module called win32-longpath which accepts the full-length 32KB pathnames. Add the string win32-longpath as the 4th argument to sqlite3_open_v2() (on windows only, of course) and everything should just work after that. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] 3.8.0 Update

On Tue, Aug 27, 2013 at 10:15 AM, James Pearson jnp...@gmail.com wrote: I've just updated to SQLite 3.8.0 and seem to have lost the ability to use the up arrow key to cycle through my command line history. Which OS? -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Collation advice

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

Re: [sqlite] Compiling spellfix for sqlite3

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

Re: [sqlite] Path Length Limit on Windows

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

Re: [sqlite] BETWEEN and explicit collation assignment

. If neither X nor Y have collations, then the default collation (BINARY) is used. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sylinks to db files?

#alias for the explanation of why this leads to database corruption. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Bug] sqlite3_finalize() *DOES NOT* return most recent evaluation error code

, though* *column x is not unique* Somebody please confirm this... -- Dmitry Pashkevich ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Bind Parameters Documentation

On Tue, Aug 20, 2013 at 9:24 AM, Filipe Oliveira filipeolive...@gmail.comwrote: From my point of view the documentation isn't according to the implementation. Can anyone clarify? Undocumented behavior is subject to change. You are advised to use only documented behavior. -- D. Richard

Re: [sqlite] sqlite3DbMallocRaw is crashing

an indication of heap corruption. Have you run your application using valgrind? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Concurrent inserts - DB corruption in travisci vm with sqlite 3.7.9

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

Re: [sqlite] warning: ‘_popen’ redeclared without dllimport attribute

Attachments are omitted on this mailing list. -- D. Richard Hipp Sent from phone - Excuse brevity On Aug 15, 2013 9:26 AM, Jan Nijtmans jan.nijtm...@gmail.com wrote: When compiling latest SQLite (actually: fossil) with mingw, I get the warnings below. Here is my suggested fix (attached

Re: [sqlite] Concurrent inserts - DB corruption in travisci vm with sqlite 3.7.9

, etc. that would help? What makes you believe this is an SQLite problem, and not a problem somewhere else in Travis-CI that SQLite just happens to be stumbling over? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Concurrent inserts - DB corruption in travisci vm with sqlite 3.7.9

advisory locks are sometimes broken on network filesystems. Is the database being stored on a network filesystem? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] name resolutionn in GROUP BY

in behaviour. This issue should now be resolved in the prerelease amalgamation snapshots available at http://www.sqlite.org/download.html and in the trunk of the source tree. The changes will appears in the next official release (3.8.0). Thanks for the bug report. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Database locking without locking database file

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

Re: [sqlite] name resolutionn in GROUP BY

symbol in the GROUP BY clause refer to the original column name in the TEST table, or should it refer to the result column called name. SQLite version 3.7.15 picks the TEST table column. Version 3.7.17 picks the result column. Anybody know which is correct? -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] name resolutionn in GROUP BY

INTO t1 VALUES('az'); INSERT INTO t1 VALUES('by'); INSERT INTO t1 VALUES('cx'); SELECT '1', substr(m,2) AS m FROM t1 ORDER BY m; SELECT '2', substr(m,2) AS m FROM t1 ORDER BY lower(m); -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing

Re: [sqlite] name resolution in GROUP BY

FROM t1 ORDER BY m COLLATE Latin1_General_CS_AS; -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] name resolutionn in GROUP BY

that can be within expressions. At least that's how we've chosen to read it. Our current behavior is a compromise that tries to support both editions of the spec. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users

Re: [sqlite] name resolutionn in GROUP BY

3.7.17 work the other. I think I'm going to revert SQLite to working as does PostgreSQL. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] name resolutionn in GROUP BY

://www.sqlite.org/src/info/f617ea3125 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] name resolutionn in GROUP BY

) issues: http://www.sqlite.org/src/info/1c69be2daf http://www.sqlite.org/src/info/f617ea3125 Oracle is the outlier on the second of the two. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http

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