Re: [sqlite] c program which performs the same function as the SQLite shell command ".import"

features as is the shell. You might be able to get cvs.c to work simply by changing a single instance of a ',' literal into '\t'. Probably a little more work than that will be involved, but not too much more. -- D. Richard Hipp d...@sqlite.org ___ sqlite-user

Re: [sqlite] c program which performs the same function as the SQLite shell command ".import"

ow to specify a separator other than > ","? The "C" in CSV stands for "Comma". That is the only separator supported. But, you can probably edit the source code to do something different. -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] Crash when querying a unique index containing 12 columns using sub-selects

that allegedly do not work. I think it is now back to Matthew to come up with a new test case that actually demonstrates his 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] About sql parametrized queries

lopers whom want to test my > software. Test means clients whom want to use it. > > I am a newbie on the programming world. > > Thanks > ___ > sqlite-users mailing list > sqlite-users@mailinglists.

Re: [sqlite] Crash when querying a unique index containing 12 columns using sub-selects

etAbundanceId2 INTEGER))", ^ x2.cpp:7:2: error: in C++98 ‘query_texts’ must be initialized by constructor, not by ‘{...}’ x2.cpp:7:2: error: could not convert ‘{}’ from ‘’ to ‘const std::vector<std::__cxx11::basic_string >’ x2.cpp:7:2: error: expected ‘,’ or ‘;’ before

Re: [sqlite] Can I create a stealth index?

be the name of the table that 'newindex' is indexing. You will need to either close and reopen the database connection, or else run "ANALYZE sqlite_master;" after making the changes above in order for the changes to go into effect. -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Can an SQL script be built from within sqlite?

mpile a command-line application (like "sqlite3" or "kvtest"), download that application to the phone, then run it from the terminal app. If I am underestimating the capabilities of the terminal app, please correct me. -- D. Richard Hipp d...@sqlite.org _

Re: [sqlite] Infinite loop when updating indexed with case and where clause

sus comparing a target condition > to a source constant, as in "(wctrlFlags & WHERE_ONEPASS_MULTIROW)!=0"? Without actually checking, I'm guessing that both forms generating identical machine code. The difference is purely a stylistic thing. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Infinite loop when updating indexed with case and where clause

te.org/src/info/feb2c2b6f66b0f45 to whatever prior version of SQLite that you happen to be using. -- 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] Infinite loop when updating indexed with case and where clause

t on OpenBSD 6.2 with SQLite version 3.20.1 2017-08-24 > 16:21:36, > on MacOSX 10.10.5 with SQLite version 3.21.0 2017-10-24 18:55:49 > and on ArchLinux 4.14.12-1-ARCH with SQLite version 3.21.0 2017-10-24 > 18:55:49 > (all x86_64). > The p

Re: [sqlite] Can an SQL script be built from within sqlite?

derstand correctly, iOS does not allow fork() as a security measure. The previous paragraph is not authoritative. It is merely my recollection. I have not researched the issue. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing

Re: [sqlite] Can an SQL script be built from within sqlite?

y compile and run all of the SQLite command-line tools for Android. There are simple instructions at the bottom of the https://www.sqlite.org/fasterthanfs.html document. The engineers at Apple tell me this is not possible on iOS. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] Output/CSV

quot; file is? Can you explain? Perhaps you are concerned that the CSV output uses \r\n line terminators instead of the more succinct \n favored by unix. That is intentional, and it is because that is what RFC4180 (https://www.ietf.org/rfc/rfc4180.txt) says should happen. --

Re: [sqlite] pcache1FetchStage2 CRASH

equently about0.1percent. Do you still have the problem with the latest version 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] os_unix.c:36136: (2)

either because that file does not exist or because you do not have appropriate permissions to open that file. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin

Re: [sqlite] SQLite 3.22.0 coming soon

ate with one argument and a scalar with two or more arguments? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is foreign key support disabled within triggers with raise functions?

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

Re: [sqlite] Is foreign key support disabled within triggers with raise functions?

to temporarily disable > foreign >...> support'); >...> end; > sqlite> insert into vtrig select 5; > Error: this statement seems to temporarily disable foreign > support > sqlite> select * from deptab; > id ref > 1 2 > > > On 12 Janu

Re: [sqlite] Is foreign key support disabled within triggers with raise functions?

it was doing and leave the database in whatever half-way completed state it was in at the moment. That's what raise(FAIL) is suppose to do. Did you mean to do "raise(ABORT)" instead, which should do what I think you are trying to accomplish. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Crash when querying a unique index containing 12 columns using sub-selects

On 1/11/18, Matthew Towler <tow...@ccdc.cam.ac.uk> wrote: > for the > volumes of data I have sqlite hangs Is it hanging, or is it crashing? Your statement of the problem is unclear on this point. -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] sqlite3_column_decltype and max and min

s fast and has all the latest features. -- 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] Can error messages be concatenated in the raise function?

be a fixed string. -- 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] SQLite 3.22.0 coming soon

appreciated. Please continue the good work! -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 3.22.0 coming soon

n your old PowerPC system. Thanks! This is the kind of thing is very important. We SQLite developers can test as much as we want to, but we will never find strange interactions with old compilers that we don't own. This is exactly the kind of thing we need your help with. Thanks for all your testing! -

Re: [sqlite] SQLite 3.22.0 coming soon

reproducible test case that I can work from? -- 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] SQLite 3.22.0 coming soon

-ins since the last release: https://www.sqlite.org/src/timeline?from=release=trunk -- 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] Tip of Trunk does not compile under 64-bit MingW compiler

Please try again with the latest trunk of SQLite (https://www.sqlite.org/src/timeline?c=2018-01-07+21:58:17 or later) and let me know whether or not your a still having problems. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite

Re: [sqlite] Tip of Trunk does not compile under 64-bit MingW compiler

sing, and what steps are you taking to build? -- 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] The performance of indexed select

n the b-tree pages when I first designed the current b-tree format for SQLite. back in 2003. -- 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] Preventing a slow, determinstic function from running twice

gt; > > > > -- > Sent from: http://sqlite.1065341.n5.nabble.com/ > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard H

Re: [sqlite] LEFT JOIN + WHERE / OR optimisation

These are hard questions with no easy answers. -- 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 optimizer and recursive common table expressions

to the queue without considering > that the subsequent SELECT only needs the first 3 of them. No, it is continuing to search for rows for which x<=3. The query planner does not know enough algebra to figure out that that will never happen again after the first three ro

Re: [sqlite] Loadable extension with shared state

gt; global context. > > The question is: how do I turn this into a thread-safe extension? > > Should I use SQLite3 mutex functions to guarantee exclusive access to > shared state? Or should I define my own locks? Either approach will work. Which is easiest for you? --

Re: [sqlite] pragma table_info return column delimiters?

> would get eg: [column1] [column2] etc. if indeed the column names were > delimited like that. No. SQLite does not retain that information in its internal symbol tables. You'll have to parse out the original CREATE TABLE statements to figure that out. -- D. Richard

Re: [sqlite] Capturing groups for regexp.c Check-in [3d6fba62] ?

t capability. -- 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] fsync on -wal still happening

internal operating-system buffers out to persistent storage on your disk drive, where it will survive and OS reset or power loss. The WAL is written on every transaction, in the sense that the content is moved into the operating system. But it is only synced to persistent storage on a checkpoin

Re: [sqlite] sqlite3AtoF()

/src/timeline?c=fd2e0e7a) and confirm that the modifications work for you. Thanks for the suggested algorithm improvement. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/

Re: [sqlite] Move to Github!!?

self-host and thus frees you of any dependencies on third-party companies, the question becomes: Why aren't you moving all of your GitHub projects over to Fossil! -- 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] .load fails

On 12/23/17, Richard Hipp <d...@sqlite.org> wrote: > On 12/23/17, Joop! <bur...@xs4all.nl> wrote: >> sqlite> *.load /usr/lib/sqlite3/pcre.so* >> *Error: /usr/lib/sqlite3/pcre.so.so: cannot open shared object file: No >> such file or directory* >> >

Re: [sqlite] .load fails

On 12/23/17, Joop! <bur...@xs4all.nl> wrote: > sqlite> *.load /usr/lib/sqlite3/pcre.so* > *Error: /usr/lib/sqlite3/pcre.so.so: cannot open shared object file: No > such file or directory* > What error message do you get if you omit the ".so" at the end of the shar

Re: [sqlite] sqlite3 related crash (SIGSEGV) in GNOME tracker-store

be a version of SQLite that has been customized by Debian. Where can we get a copy of Debian's customized code? -- 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] Changed behaviour or bug using field alias in 3.21.0

Your trouble ticket is here: https://sqlite.org/src/tktview/3b4450072511 -- 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] Changed behaviour or bug using field alias in 3.21.0

ECT does. > > SELECT give name d > > CREATE TABLE AS SELECT > create table with name a instead of d. Can you provide a simple test case for this behavior? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing l

Re: [sqlite] Changed behaviour or bug using field alias in 3.21.0

On 12/22/17, Radovan Antloga <radovan.antl...@siol.net> wrote: > In my example I have AS clause so rule 1. You did not understand my question. I think what you are asking for is that we should enhance rule 1 so that it applies even if the AS clause is contained within a subquery. -- D

Re: [sqlite] Changed behaviour or bug using field alias in 3.21.0

as it appears in the original CREATE TABLE statement for the table. (3) Otherwise, name the result-set column using the SQL text in the SELECT statement. What set of rules are you proposing that we should use instead? -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Btree page corruption

tabase? Are you sure that you have the database set in a thread-safe 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] Compile fails with '-Wall -Werror'

On 12/21/17, Richard Hipp <d...@sqlite.org> wrote: > > If you are unwilling to work-around this problem > by omitting -Werror, then you might try upgrading to GCC 5.4. > You can also apply this patch: https://www.sqlite.org/src/info/64487d658cb3b6c8 -- D. Richard Hi

Re: [sqlite] Compile fails with '-Wall -Werror'

not possible for either pLeft or eOp2 to be used uninitialized - it is just that GCC 4.8 is unable to construct a proof of that fact. If you are unwilling to work-around this problem by omitting -Werror, then you might try upgrading to GCC 5.4. -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Minor bug reports during build.

On 12/21/17, Michael Tiernan <michael.tier...@gmail.com> wrote: > Is there a route for reporting an error for an average user without > creating an account and all the overhead of the ticket system? Send an email to this mailing list, or directly to me. -- D. Richard Hipp d..

Re: [sqlite] Compiling / building SQLite to include regex

ite.org/download.html>. > Is there a simple recipe for "make REGEX work after installation"? There is a loadable REGEXP extension here: https://www.sqlite.org/src/artifact/a68d25c659bd2d89 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Changed behaviour or bug using field alias in 3.21.0

') as U, ifnull(H,'') as H, ZZ >from SOPP1 >); > > You will see that first column name is VP instead of P. > In previous versions name was P not VP. > > Best Regards > Radovan Antloga > ___ > sqlite-users mailing list &

Re: [sqlite] create index implies analyze?

stat1" utility on the "est_count_pragma" branch: https://www.sqlite.org/src/timeline?r=est_count_pragma -- 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] Macro expansion of B0 on Linux PPC system

ad a tarball of the latest trunk checkin from https://sqlite.org/src/tarball/sqlite.tar.gz?r=trunk We are dependent on you to run this test since we do not have access to a Linux PPC system. --- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list

Re: [sqlite] Macro expansion of B0 on Linux PPC system

ot;B0" is a reserved word on Power 8 and Power 9 systems, and can never be used as a local variable name? -- 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] Atomic DELETE index optimisation?

eans valid SQL semantics; in all RDBBMS I've worked with, > structure changes' relation to a transaction is undefined at best. DROP, CREATE, and ALTER are transactional in SQLite, just like DELETE, INSERT, and UPDATE. This has always been the case, and always sha

Re: [sqlite] Atomic DELETE index optimisation?

On 12/17/17, Dinu <dinumar...@gmail.com> wrote: > > We have ~32M records out of which we are deleting about ~24M. Can you try this: (1) BEGIN TRANSACTION (2) DROP all indexes from the table (3) Do the DELETE operation (4) CREATE all indexes again (5) COMMIT -- D. Richard Hipp d..

Re: [sqlite] Possibly uninitialized variables...compile time error

Hence, I have now added extra (unnecessary) local variable initializations in the relevant RTree indexing routines so that these warnings should now be suppressed. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mail

Re: [sqlite] Macro expansion of B0 on Linux PPC system

fixed on the highlighted check-in here: https://www.sqlite.org/src/timeline?y=ci=b9a58daca=9 That fix should have appeared in SQLite version 3.19.0. Version 3.21.0 is the latest. Are you still having issues? -- D. Richard Hipp d...@sqlite.org ___ sqlite-u

Re: [sqlite] What happens if an in memory database runs out of memory

On 12/15/17, x <tam118...@hotmail.com> wrote: > > Is there any easy way of creating a table that will use mem for speed but > revert to disc for backup if memory runs out? > Make the database filename be an empty string. -- D. Richard Hi

Re: [sqlite] What happens if an in memory database runs out of memory

happens. sqlite3 --heap 5MB The --heap option causes the shell to do a single 5MB memory allocation and then divy up that one allocation for all its memory needs. When the 5MB is gone, SQLite is out of memory and will start reporting SQLITE_NOMEM errors. --

Re: [sqlite] Is this a bug with expression evaluation?

integer arithmetic on integer values. This is probably the reason that MySQL has the separate "DIV" operator for integer division, whereas everybody else makes due with the standard "/" operator. -- D. Richard Hipp d...@sqlite.org __

Re: [sqlite] Does sqlite have official development testing tool?

to run to start all TCL tests? > make test -- 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] the timing to truncate WAL file to journal_size_limit

> > Which means WAL file may still consume a large amount of space after > checkpoints, unless a new transaction commits. Is that right? Correct. The reset happens on the next transaction commit. There is also "PRAGMA wal_checkpoint(TRUNCATE);" -- D. Richard Hipp d...@sqlite.

Re: [sqlite] How to index data based on custom comparisons?

y close. Given these routines, you could then index your IEEE754-decimal columns by doing an index on an expression using the new iee754bin() function. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http:

Re: [sqlite] How to index data based on custom comparisons?

te always uses memcmp() to compare BLOBs. You can add a collating function for strings, but not for BLOBs. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/ma

Re: [sqlite] 2D query

ES("Jane","F"); > INSERT INTO people VALUES("John","M"); > > How to construct a query which returns coalesced sex but individual names, > such as "F: Alex, Jane. M: Alex, John."? SELECT sex || ': ' || group_concat(name, ", ")

Re: [sqlite] Does sqlite have official development testing tool?

? > > I have found sqlspeedtest1,8 and sqlthreadtest3,4. Is there any other > testing I should make? https://www.sqlite.org/testing.html -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://

Re: [sqlite] values ?

> Probably obvious to the right people but what am I missing? It probably means you are using an older version of SQLite. The syntax you describe as introduced in version 3.8.3 (2014-02-03). -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mail

Re: [sqlite] Enabling MMAP in Android

games with mmap(). -- 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] Enabling MMAP in Android

uch less likely, as SQLite would probably detect the situation before the COMMIT completes, thus leaving the database intact. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/

Re: [sqlite] UPDATE SET using column-name-list Syntax error

T (a, b) = (SELECT "vala", "valb") ; > Error: near "(": syntax error > > What am I doing wrong ? or is this syntax really supported ? It is supported beginning with SQLite 3.15.0 (2016-10-14). What version of SQLite are you running? -- D. Richard Hipp d...@

Re: [sqlite] Timing issue with min, max and count

quire checking all values of ID rather than obtaining the result from > first and last entries in primary key. > > Tom > > > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.or

Re: [sqlite] getting error "string or blob too big" for 500 MB data insertion

inglists.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] Errors in "julianday" function in SqLite

anything about Julian calendar dates. SQLite does not have the capability of converting Julian calendar dates into other systems such as the Gregorian calendar or the julian-day number. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-u

Re: [sqlite] Cross-compiling fails.

te-for-byte identical on all host platforms. We test for that. And we publish the SHA3 hash of the generated sqlite3.c file in our release notes. If you find a pair of host platforms that build different "sqlite3.c" files from the same sources, then that is a bug. Please repo

Re: [sqlite] Cross-compiling fails.

sc sqlite3.c depending on whether your host system is unix or windows. Then manually compile the resulting sqlite3.c for your target platform. What are the host and target systems for the build you are trying to do? -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] [EXTERNAL] Re: Possible User Defined Function (UDF) Bug?

s at the moment. -- 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] Assert failure line 72132, function: valueFromExpr

On 11/27/17, no...@null.net <no...@null.net> wrote: > > assertion "0" failed: file "sqlite3.c", line 72132, function: > valueFromExpr > This should be fixed in the latest Pre-release Snapshot, uploaded moments ago

Re: [sqlite] Assert failure line 72132, function: valueFromExpr

On 11/27/17, Richard Hipp <d...@sqlite.org> wrote: > I am unable to reproduce the problem. Dan suggested that I needed to enable foreign keys, and that did indeed enable me to repro the problem. -- D. Richard Hipp d...@sqlite.org ___ sql

Re: [sqlite] Assert failure line 72132, function: valueFromExpr

> valueFromExpr > I am unable to reproduce the problem. The database and INSERT statement you sent via private email work fine for me. No errors or warnings. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists

Re: [sqlite] Assert failure line 72132, function: valueFromExpr

00 > 127 OpenRead 3 1530 00 root=153 iDb=0 > 128 NotExists30 41 00 intkey=r[41] > 129 Goto 0 -140 00 > 130 FkCounter110 00 fkctr[1]+=1 >

[sqlite] Wrong mailing list..... Was: More timeline changes.

Please ignore. This post was intended for fossil-us...@lists.fossli-scm.org, not for the SQLite users mailing list. My appologies.. On 11/25/17, Richard Hipp <d...@sqlite.org> wrote: > In the latest code on https://www.fossil-scm.org/fossil/timeline and > at https://sqlite.org/s

[sqlite] More timeline changes.

(3) above, how can I make the ellipsis or icon to "show more detail" configurable using CSS? What's the best way to handle that so that people can customize the look for various skins? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing li

[sqlite] SQLite website A/B comparison

responding to the mailing list. Or, join the discussion of this question over on the fossil-us...@lists.fossil-scm.org mailing list. Further suggestions for the improvement of the timeline display (or anything else on the website) are welcomed. -- D. Richard Hipp d...@

Re: [sqlite] Exit value of "PRAGMA integrity_check" in command line

running "PRAGMA integrity_chck". -- 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] Exit value of "PRAGMA integrity_check" in command line

d with release 3.21.0. It should now always return error message text and an SQLITE_OK return code. See item 9 on the relase notes: https://www.sqlite.org/releaselog/3_21_0.html -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@ma

Re: [sqlite] SELECT result different after ANALYZE

On 11/21/17, Richard Hipp <d...@sqlite.org> wrote: > > To work around this problem, please DROP all indexes on the INTEGER > PRIMARY KEY columns. Except, you don't have any indexes on INTEGER PRIMARY KEY columns. I misread the schema. I'll be working on some other solution

Re: [sqlite] Many ML emails going to GMail's SPAM

e are seeing is the beginning of the end of email as a viable communication medium. I really need to come up with an alternative to the mailing list. Perhaps some kind of forum system. Suggestions are welcomed. -- D. Richard Hipp d...@sqlite.org ___ sqlite-u

Re: [sqlite] SELECT result different after ANALYZE

ing the query planner. This problem will be corrected in the next release. -- 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] View is not flattened when inside an IN sub-query

On 11/18/17, E.Pasma <pasm...@concepts.nl> wrote: > I found that in the > SQLite3 timeline Thanks for watching the timeline! -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sql

Re: [sqlite] Update the SQLite package in Tcl

er of these. (I suggest the Pre-release Snapshot so that you can help us beta test!) Untar, and cd into the "tea" subdirectory. Then type: "./configure; make install". That is suppose to install the latest SQLite for TCL. "TEA" is t

Re: [sqlite] Starting with TCL

ea ... > } > > This latter case works because the query is surrounded by {} so Tcl won’t > substitute the variable, it will be seen and securely inserted into the > query by SQLite. FWIW, this is the reason that SQLite, uniquely among all modern SQL database engines, understands $n

Re: [sqlite] Starting with TCL

On 11/16/17, Cecil Westerhof <cldwester...@gmail.com> wrote: > ​Is it possible to get the library version before connecting to a database? puts [sqlite -version] -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sql

Re: [sqlite] Starting with TCL

arguments. Since everything is a function, everything follows exactly the same quoting rules. This is an important feature of Tcl that programmers whose prior experience has been exclusively using Algol-derived languages such as C, Java, Javas

Re: [sqlite] SQLite Bytecode

extra logic to defend the bytecode against such problems would slow down SQLite for everybody, which we are not willing to do. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite

Re: [sqlite] SQLite Bytecode

sers 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] Best way to develop a GUI front-end

ut people I trust tell me that it is good. -- 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] 1TB limit on encrypted database

rger like 8192. -- 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] 1TB limit on encrypted database

s not changed. Do I need > the updated encryption extension first? The PRAGMA only changes the one database connection in which it runs. To make the setting persistent, recompile with -DSQLITE_MAX_PAGE_COUNT=20 -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] 1TB limit on encrypted database

as some of the older versions had issues. Also, note that the VACUUM will take some time and will require a couple TB of temporary disk space while it is running. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailing

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