Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

They can subscribe to the forum too. :) On Thu, Mar 12, 2020, 2:40 PM Simon Slavin wrote: > Well, that'll annoy the nabble people. And I can live with that. > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org >

Re: [sqlite] Please increase the default for SQLITE_MAX_VARIABLE_NUMBER

On Tue, Feb 4, 2020, 5:23 PM J. King wrote > Not everyone has access to carrays and intarrays, either, such as PHP > users like myself. > But everyone has access to temp tables, and I think the idea of creating a temp table, inserting 1000 items in a loop, and using that temp table in the

Re: [sqlite] importing data to a table that has generated-columns

On Sun, Jan 26, 2020 at 11:01 AM chiahui chen wrote: > Hi, > > After creating a table (total 8 columns including 1 generated column) , I > tried to import data from a csv file (each record has values for 7 columns > that match the non-generated column names and data types, no headers ). > > The

Re: [sqlite] Coding standard

On Thu, Dec 12, 2019, 11:04 PM Valentin Davydov wrote: > On Thu, Dec 12, 2019 at 11:19:44AM -0500, Richard Hipp wrote: > > > > #define sqlite3Strlen30NN(C) (strlen(C)&0x3fff) > > > > The tool does not provide any details beyond "Use of strlen". > > So why not just #define

Re: [sqlite] last occurrence of /*

On Fri, Dec 6, 2019, 4:31 PM Bart Smissaert wrote: > I know I can do something like this: > > select replace(postcode, rtrim(postcode, replace(postcode, ' ', '')), '') > from addresses > > which will get the part of the postcode starting with the space. > Problem however is how to deal with the

Re: [sqlite] last occurrence of /*

On Fri, Dec 6, 2019, 4:00 PM Bart Smissaert wrote: > Have table with SQL statements and these statements may have comments, > starting with /* > How do I select the part of this statement starting with the last /* ? > So if the statement is: > select field1 /*comment 1 */ from table1 /*comment

Re: [sqlite] What is the C language standard to which sqlite conforms ?

On Mon, Nov 18, 2019 at 3:44 PM Dennis Clarke wrote: > > Same question as a few days ago. > > This may have been asked many times before but always seems to be a > valid question. On some machines with different compilers I get good > results using C99 strict compliance. On other machines, such

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

On Thu, Jun 13, 2019, 8:51 AM R Smith wrote: > On 2019/06/13 4:44 PM, Doug Currie wrote: > >> > >> Except by the rules of IEEE (as I understand them) > >> > >> -0.0 < 0.0 is FALSE, so -0.0 is NOT "definitely left of true zero" > >> > > Except that 0.0 is also an approximation to zero, not "true

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

On Wed, Jun 12, 2019, 10:02 AM James K. Lowden wrote: > On Wed, 12 Jun 2019 09:35:13 -0400 > Richard Hipp wrote: > > > Question: Should SQLite be enhanced to show -0.0 as "-0.0"? > > No. > > 1. Prior art. I can't think of a single programming language that > displays -0.0 without jumping

Re: [sqlite] Help with sqlite3_value_text

On Fri, Apr 12, 2019, 1:06 PM Keith Medcalf wrote: > > Actually you would have to convert the strings to UCS-4. UTF-16 is a > variable-length encoding. An actual "unicode character" is (at this > present moment in time, though perhaps not tomorrow) 4 bytes (64-bits). > That is some impressive

Re: [sqlite] Variable Declaration

On Sat, Jan 19, 2019, 6:53 AM Simon Slavin > On 19 Jan 2019, at 4:49am, Stephen Chrzanowski wrote: > > > I know about the bindings. I don't know about all languages supporting it. > > Bindings are part of the SQLite API. Any language which can make SQLite calls should be supporting binding. >

Re: [sqlite] Question about floating point

On Mon, Dec 17, 2018 at 2:50 PM Thomas Kurz wrote: > Ok, as there seem to be some experts about floating-point numbers here, > there is one aspect that I never understood: > > floats are stored as a fractional part, which is binary encoded, and an > integer-type exponent. The first leads to the

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Tue, Oct 9, 2018, 6:34 AM Will Parsons wrote: > On Sunday, 7 Oct 2018 5:25 PM -0400, Keith Medcalf wrote: > > > > Many people do not "do" web forums. I am one of them. If there is not > a mailing list then it does not exist. > > I completely agree. I read and post to the SQLite mailing

Re: [sqlite] Why sqlite fts5 Unicode61 Tokenizer does not support CJK(Chinese Japanese Krean)?

On Fri, Sep 21, 2018 at 12:39 AM 邱朗 wrote: > > >I think it could be made to work, or at least, I have experience > >making it work with CJK based on functionality exposed via ICU. I > >don't know if the unicode tokenizer uses ICU or if the functionality > >in ICU that I used is available in the

Re: [sqlite] Why sqlite fts5 Unicode61 Tokenizer does not support CJK(Chinese Japanese Krean)?

On Fri, Sep 21, 2018 at 12:02 AM 邱朗 wrote: > > https://www.sqlite.org/fts5.html said " The unicode tokenizer classifies all > unicode characters as either "separator" or "token" characters. By default > all space and punctuation characters, as defined by Unicode 6.1, are > considered

Re: [sqlite] Why sqlite fts5 Unicode61 Tokenizer does not support CJK(Chinese Japanese Krean)?

On Thu, Sep 20, 2018, 8:21 PM 邱朗 wrote: > Hi, > I had thought Unicode61 Tokenizer can support CJK -- Chinese Japanese > Korean I verify my sqlite supports fts5 > > {snipped} > > But to my surprise it can't find any CJK word at all. Why is that ? Based on my experience with such things, I

Re: [sqlite] foreign_keys = 0N with Entity Framework 6.2.0

oh][en]) is being written as 0N ([zero][en]) instead. Maybe that's just an email typo, but thought I'd point it out. -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

On Fri, Aug 31, 2018 at 2:59 PM Warren Young wrote: > > On Aug 31, 2018, at 1:55 PM, Scott Robison wrote: > > > > Is one generated from the other, or are they maintained separately? > > They’re separate. Here’s the Tcl source for the bubble diagrams: As I suspect

[sqlite] Lemon Parser vs bubble-generator.tcl

e diagrams, then realized "I should just use portions of the syntax diagram script directly", then started wondering about the parser vs the diagram script. -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailingl

Re: [sqlite] Best practices for forward conversion of database formats?

necessarily be as slow as the one I worked with was, but it was just the wrong tool for the job in that particular case. -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Strange Corruption Issue

On Mon, Jun 18, 2018 at 9:15 PM, Patrick Herbst wrote: > I'm using sqlite in an embedded application, running on SSD. > > journal_mode=persist > so that it is more resilient to loss of power. > > I'm seeing corruption. I'm using sqlite to log events on the system, > and the corruption is well in

Re: [sqlite] Idea: defining table-valued functions directly in SQL

t columns but also output > columns that have been named using AS, but we don't have this feature. SELECT *, (computation on Y) AS X FROM ( SELECT *, (some computation) AS Y FROM sometable) It is a little annoying having to nest them, but it works. -- Scott Robison __

Re: [sqlite] sqlite.org website is now HTTPS-only

On Fri, Jun 8, 2018, 12:19 AM Ron Yorston wrote: > Dennis Clarke wrote: > >On 6/7/18 9:59 PM, Richard Hipp wrote: > >> On 6/7/18, Scott Doctor wrote: > >>> Just out of curiosity, is the sqlite website using nginx or > >>> apache as the server? > >> > >> None of the above. > >> > >> The web

Re: [sqlite] [EXTERNAL] Feature suggestion / requesst

On Fri, Jun 8, 2018, 12:11 AM Hick Gunter wrote: > > > > > >I've encountered a feature that I think would be awesome: > >https://www.postgresql.org/docs/9.3/static/dml-returning.html > > > >Example: INSERT INTO blah (this, that, another) VALUES (x, y, z) > RETURNING id; > > > > What does this do

Re: [sqlite] Feature suggestion / requesst

On Thu, Jun 7, 2018, 9:25 PM Rowan Worth wrote: > On 3 June 2018 at 07:28, Scott Robison wrote: > > > I've encountered a feature that I think would be awesome: > > https://www.postgresql.org/docs/9.3/static/dml-returning.html > > > > Example: INSERT INTO blah (thi

Re: [sqlite] Filename encoding on Unix platforms

On Mon, Jun 4, 2018 at 10:56 PM, Christopher Head wrote: > Hello, > I have a question regarding text encoding of filenames on Unix > platforms. I’ve read the two related mailing list threads I could find > in the archive, >

[sqlite] Feature suggestion / requesst

s their argument, my thoughts are just that this could greatly simplify a lot of sql code that currently has to prepare and execute at least two statements to accomplish what is conceptually an atomic task. Thank you for your time. -- Scott Robison ___

Re: [sqlite] This is driving me nuts

Sqlite will use different strategies for ASC and desc ordering and result set sizes. Perhaps one is creating a temp btree to order the results. I think explain query plan might help show exactly what sqlite is contributing to the memory consumption without the need for as much speculation. Not

Re: [sqlite] SQLite is a LoC Preferred Format for datasets

mment in your data dump, I'm thinking your example came from MySQL, not SQLite. Even if you try to insert quoted strings into SQLite with the given column definitions, SQLite converts them to the given type affinity before storing them, and uses that type affinity when dumping the database. -- Sco

Re: [sqlite] Always call a value-quoting routine

On Sun, May 6, 2018 at 11:34 PM, Rowan Worth wrote: > Amusing -- but without the leading single-quote it would take intentional > effort for a programmer to detonate this payload. > > Its omission is interesting though. Does it indicate an incompetent > attacker, or is

Re: [sqlite] Always call a value-quoting routine

Thanks for sharing that. It will undoubtedly be useful to me in a computer security class I'm taking this semester. On Sat, May 5, 2018, 4:57 PM Simon Slavin wrote: > This is a genuine company registered under the UK Companies Act: > >

Re: [sqlite] Fossil Feature Request

On Fri, Mar 30, 2018 at 1:32 PM, J Decker wrote: > Sqlite's Fossile browser can't link line numbers... > > > Add ability to link to lines of source... > > > was trying to share this as another reference for getting UTF8 characters > from strings > > #define READ_UTF8(zIn,

Re: [sqlite] .dump command and user_version

On Thu, Mar 29, 2018, 8:18 AM Richard Hipp <d...@sqlite.org> wrote: > On 3/29/18, Scott Robison <sc...@casaderobison.com> wrote: > > It seems a > > reasonable to suggestion to add it. > > Version 3.23.0 is in bug-fix-only mode. It'll have to wait.

Re: [sqlite] .dump command and user_version

On Thu, Mar 29, 2018 at 6:56 AM, Simon Slavin wrote: > > > On 29 Mar 2018, at 1:47pm, Wout Mertens wrote: > >> I noticed that `.dump` does not output the user_version pragma. It seems to >> me that that is part of the database data? >> >> I don't

Re: [sqlite] How many AUTOINCREMENT tables are in your schema?

0 On Mar 16, 2018 9:37 AM, "Richard Hipp" wrote: > This is a survey, the results of which will help us to make SQLite faster. > > How many tables in your schema(s) use AUTOINCREMENT? > > I just need a single integer, the count of uses of the AUTOINCREMENT > in your overall

Re: [sqlite] difference between 'ID IS NULL' and 'ID = NULL'

Integer primary key is by definition not null, so looking for a null value on an index can't work. I guess there exists an optimization opportunity to just return an emotional set, though it seems easier to not specify an impossible condition. As to why it does a table scan, the primary key isn't

Re: [sqlite] GROUP_CONCAT with DISTINCT bug

On Tue, Jan 2, 2018 at 5:46 PM, petern wrote: > Hi Scott. > >>Are there other aggregate functions that take multiple arguments? > > Absolutely. I've got a few in my code which deserialize table rows into > runtime objects. Fortunately, the DISTINCT filter makes no

Re: [sqlite] GROUP_CONCAT with DISTINCT bug

On Tue, Jan 2, 2018 at 4:15 PM, petern wrote: > Hi Tony. Good. Yes, simpler test case is always better when posting > possible bugs. > > Unfortunately, as Cezary points out, this error is by design (from > select.c): > >if( pFunc->iDistinct>=0 ){ > Expr *pE

Re: [sqlite] GROUP_CONCAT with DISTINCT bug

On Tue, Jan 2, 2018 at 1:36 PM, Tony Papadimitriou wrote: > create table t(s); > insert into t values ('A'),('A'),('B'); > > select group_concat(s,', ') from t group by null; -- OK > select group_concat(distinct s) from t group by null; -- OK > select

Re: [sqlite] INSERT OR IGNORE ignores constraints. Bug ?

On Dec 21, 2017 10:50 AM, "Simon Slavin" wrote: On 21 Dec 2017, at 3:46pm, David Raymond wrote: > The only potential problem with "insert or ignore into" is that it will ignore any constraint violation for that record insert Wait. What ?

Re: [sqlite] StepSqlite: SuperPowers for SQLite and BerkeleyDB

They'll be able to renew the certificate after some payments are made after the free 6 month trial had lapsed. :) On Dec 5, 2017 5:15 PM, "Keith Medcalf" wrote: > > Uses an expired SSL certificate ... > > > --- > The fact that there's a Highway to Hell but only a Stairway

Re: [sqlite] Sqlite and docker performance question

Perhaps the file sync performed by SQLite is more expensive in the docker environment than in the host. That would make sense to me. On Nov 30, 2017 7:07 AM, "Sebastien HEITZMANN" <2...@2le.net> wrote: > In my last mail i have multiple table creation and index. It seam that the > overtime is for

Re: [sqlite] Please remove multiple warnings from compiler about optimisation, variable conversion, signed overflow and many more potential errors.

On Fri, Sep 29, 2017 at 1:20 PM, Bob Friesenhahn <bfrie...@simple.dallas.tx.us> wrote: > On Fri, 29 Sep 2017, Scott Robison wrote: >> >> >> The problem is that there is no one best practice for resolving all >> such warnings in a way that makes all compilers ha

Re: [sqlite] Please remove multiple warnings from compiler about optimisation, variable conversion, signed overflow and many more potential errors.

On Fri, Sep 29, 2017 at 11:14 AM, Denis V. Razumovsky wrote: > I would like to draw attention to the document: "The Power of 10: Rules > for Developing Safety-Critical Code" from NASA/JPL Laboratory. >

Re: [sqlite] bug: failure to write journal reported as "disk I/O error"

ge or include file!) > > And, yes, there needs to be *some* way to get the underlying problem reported > to somebody in a position to do something about it - where "the underlying > problem" includes "what did the OS say?" as much as it includes "what SQLite

Re: [sqlite] Support for named foreign keys?

to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Scott Robison > >Sent: Sunday, 24 September, 2017 16:47

Re: [sqlite] Support for named foreign keys?

I think he's asking for FK constraint names to be reported in conflict messages which has been requested in the past, but not included up until now because of the approach taken. On Sep 24, 2017 4:16 PM, "Keith Medcalf" wrote: > > Why do you think this? > > The syntax

Re: [sqlite] What's the level of B+-Tree ?

My understanding is that SQLite doesn't use the traditional definition of b-tree because it doesn't use fixed size records/keys. It will cram as few or as many as possible. I'm not in a position to confirm that, but it was something I read a few years ago I think. On Aug 11, 2017 9:16 AM, "james

Re: [sqlite] 3.18.0 SELECT..WHERE x & ? != 0; doesn't use an index

ing". The bitwise and operator is asking the question "where at least one bit from a set is not zero". Let's say you have 100 rows with different values of y. If you ask for rows "where y & 2 != 0", you should get all the even numbers. The only way to get that

Re: [sqlite] VALUES clause quirk or bug?

ming the columns. So, should SQLite be pickier in the syntax it supports? Probably. Can it be changed retroactively and break a bunch of existing code? Probably not (though it's not my position to say one way or the other). Are there other syntactic constructs that give you the ability to

Re: [sqlite] INSERT ... VALUES / want to "skip" default values

On Jun 28, 2017 6:51 AM, "Simon Slavin" wrote: On 28 Jun 2017, at 9:45am, Clemens Ladisch wrote: > An explicit NULL works only for the autoincrement column, but not for default values. Really ? In that case I withdraw my previous answer. I thought

Re: [sqlite] UTF8-BOM not disregarded in CSV import

qlite> pragma writable_schema = 0; sqlite> vacuum; sqlite> .schema CREATE TABLE temp( "a" TEXT, "b" TEXT, "c" TEXT, "d" TEXT ); CREATE TABLE utf8( "a" TEXT, "b" TEXT, "c" TEXT, "d" TEXT ); Still,

Re: [sqlite] [OT] UTF8-BOM and text encoding detection (was: UTF8-BOM not disregarded in CSV import)

On Jun 27, 2017 12:13 AM, "Rowan Worth" wrote: I'm sure I've simplified things with this description - have I missed something crucial? Is the BOM argument about future proofing? Are we worried about EBCDIC? Is my perspective too anglo-centric? The original issue was two of the

Re: [sqlite] UTF8-BOM not disregarded in CSV import

On Jun 26, 2017 9:02 AM, "Simon Slavin" wrote: There is no convention for "This software understands both UTF-16BE and UTF-16LE but nothing else.". If it handles any BOMs, it should handle all five. However, it can handle them by identifying, for example, UTF-32BE and

Re: [sqlite] UTF8-BOM not disregarded in CSV import

On Jun 26, 2017 4:05 AM, "Rowan Worth" <row...@dug.com> wrote: On 26 June 2017 at 16:55, Scott Robison <sc...@casaderobison.com> wrote: > Byte Order Mark isn't perfectly descriptive when used with UTF-8. Neither > is dialing a cell phone. Language evol

Re: [sqlite] UTF8-BOM not disregarded in CSV import

On Jun 25, 2017 1:16 PM, "Cezary H. Noweta" wrote: Certainly, there are no objections to extend an import's functionality in such a way that it ignores the initial 0xFEFF. However, an import should allow ZWNBSP as the first character, in its basic form, to be conforming to

Re: [sqlite] UTF8-BOM not disregarded in CSV import

On Jun 26, 2017 1:47 AM, "Rowan Worth" wrote: On 26 June 2017 at 15:09, Eric Grange wrote: > Alas, there is no end in sight to the pain for the Unicode decision to not > make the BOM compulsory for UTF-8. > UTF-8 is byte oriented. The very concept of byte

Re: [sqlite] How to search for fields with accents in UTF-8 data?

On Tue, Jun 20, 2017 at 8:17 AM, Olivier Mascia wrote: >> Le 20 juin 2017 à 15:24, R Smith a écrit : >> >> As an aside - I never understood the reasons for that. I get that Windows >> has a less "techy" clientèle than Linux for instance, and that the

Re: [sqlite] unusual but trivially reproducible bug

Not a bug. Instead of a keyword, you've defined an alias for the table named "limit1". On Jun 19, 2017 4:00 AM, "Robert Cousins" wrote: > Summary: > Leaving out the space after the word 'limit' causes the limit > clause to be ignored. > I've reproduced it on version

Re: [sqlite] INTEGER PRIMARY KEY

On Jun 12, 2017 8:26 PM, "Keith Medcalf" wrote: Additionally, declaring NOT NULL or NULL is ignored. CHECK constraints are honoured. DEFAULT values are ignored. so CREATE TABLE x(id INTEGER NULL PRIMARY KEY CHECK (id>1000) DEFAULT (-1)); & CREATE TABLE x(id INTEGER NULL

Re: [sqlite] INTEGER PRIMARY KEY

On Jun 12, 2017 5:43 PM, "Richard Hipp" <d...@sqlite.org> wrote: On 6/13/17, Scott Robison <sc...@casaderobison.com> wrote: > > Is it fair to say that the rowid aliasing behavior does not require > (by design) the incantation "INTEGER PRIMARY KEY" (all

Re: [sqlite] INTEGER PRIMARY KEY

On Mon, Jun 12, 2017 at 4:20 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 12 Jun 2017, at 11:01pm, Scott Robison <sc...@casaderobison.com> wrote: > >> Is it fair to say that the rowid aliasing behavior does not require >> (by design) the incantat

[sqlite] INTEGER PRIMARY KEY

mn's constraint list? -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Fwd: SELECT Max(IndexedField) doesn't use partial index

On May 9, 2017 9:07 PM, "jose isaias cabrera" <jic...@barrioinvi.net> wrote: Scott Robison wrote... On Mon, May 8, 2017 at 11:40 AM, Paul van Helden <p...@planetgis.co.za> wrote: > Hi, >> >> I use a lot of indexes on fields that typically contain lots of NU

Re: [sqlite] Fwd: SELECT Max(IndexedField) doesn't use partial index

; sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .DUMP displays floats differently from SELECT

On May 3, 2017 8:07 AM, "Tony Papadimitriou" wrote: While trying to search/replace some text from an SQLite3 dump I noticed that, unfortunately, .DUMP does not produce the exact same numbers as a plain SELECT on the same values. I know all about expected floating point

Re: [sqlite] Incompatibility into configure.ac

On Apr 5, 2017 7:28 AM, "Bob Friesenhahn" wrote: On Wed, 5 Apr 2017, Richard Hipp wrote: > > The deeper issue is that I do not have access to a machine that lacks > bash on which to test the modifications > Specify the shell that configure will use like

Re: [sqlite] Incompatibility into configure.ac

gt; sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] core using sqlite 3.17.0 on solaris

On Thu, Mar 30, 2017 at 11:22 AM, Richard Hipp <d...@sqlite.org> wrote: > On 3/30/17, Scott Robison <sc...@casaderobison.com> wrote: >>> >> Also, isn't the new code potentially allocating a smaller buffer in >> zSpace? If sizeof(yyParser) is 15, the removed

Re: [sqlite] core using sqlite 3.17.0 on solaris

code potentially allocating a smaller buffer in zSpace? If sizeof(yyParser) is 15, the removed line would allocate a 15 element array of unsigned char objects for a total of 15 bytes. The added line would allocate a 15/8 = 1 element array of sqlite3_uint64 objects for a total of 8 bytes. -- Scott Robison

Re: [sqlite] Possibly pointless assert

On Thu, Mar 23, 2017 at 11:05 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 03/23/2017 11:46 PM, Scott Robison wrote: >> >> Note: I'm on Windows 10 and reproduced this with the amalgamation >> downloaded today from >> http://sqlite.com/2017/sqlite-amalgamatio

Re: [sqlite] Possibly pointless assert

On Thu, Mar 23, 2017 at 10:17 AM, Scott Robison <sc...@casaderobison.com> wrote: > On Thu, Mar 23, 2017 at 9:21 AM, Dan Kennedy <danielk1...@gmail.com> wrote: >> How did you trip the assert()? i.e. what is the database schema and query >> that cause it to fail? > &g

Re: [sqlite] Possibly pointless assert

On Thu, Mar 23, 2017 at 9:21 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 03/23/2017 04:45 AM, Scott Robison wrote: >> >> Take a look at >> http://www.sqlite.org/cgi/src/artifact/3ed64afc49c0a222?ln=2214,2233 >> (especially the assert within). >>

[sqlite] Possibly pointless assert

and that is a useful assertion, I'd like to understand the reason why. Otherwise, the if statement at 2232 does everything the assert at 2230 does, making the assert fire when the code is working correctly. -- Scott Robison ___ sqlite-users mailing list

Re: [sqlite] SQLite3.dll for x64

files. > As you've already discovered (based on the posted answer), you just needed an extra command line option passed to the lib tool. -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/c

Re: [sqlite] [BUG REPORT] Open blob is invalidated by the update to unrelated fields in the same row

s the separate blob table (which I think I read you've already tried). -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] thousand separator for printing large numbers

On Feb 11, 2017 7:15 PM, "James K. Lowden" wrote: On Fri, 10 Feb 2017 10:46:24 +0100 Dominique Devienne wrote: > PS: In this context, I don't want to use a host-program provided UDF. > This is data meant to be viewed with any SQLite client, so

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

function before the first "executable" statement. I > believe that was a C language restriction back in the early 70's. > The declaration of variables have to be at the top of a scope as per ANSI C. C99 relaxed that. -- Scott Robison ___ sqlite-

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

On Jan 31, 2017 6:25 PM, "James K. Lowden" wrote: On Tue, 31 Jan 2017 15:50:08 -0800 Nathan Bossett wrote: > Since this is the sqlite users list and not the dev's list, can I ask > what your use case is that writing a thin wrapper around SQLITE >

Re: [sqlite] Bitten by lack of isolation between SELECT and UPDATE on the same connection

On Tue, Jan 31, 2017 at 12:15 PM, Jens Alfke wrote: > > > On Jan 31, 2017, at 9:39 AM, James K. Lowden > wrote: > > > > According the SQL standard, every SQL statement is atomic. SELECT has > > no beginning and no end: the results it returns

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

On Tue, Jan 31, 2017 at 9:48 AM, James K. Lowden <jklow...@schemamania.org> wrote: > On Mon, 30 Jan 2017 13:32:46 -0700 > Scott Robison <sc...@casaderobison.com> wrote: > > > Basing source on "ANSI C" (as much as possible) just gives you the > > bi

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

find a compiler for your PPC machine, and I bet if need be we can > port pcc to whatever you're running. (ISTM enlisting pcc would add to > SQLite's portability, btw.) > > --jkl > > > _______ > sqlite-users mailing list > sqlite-

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

On Jan 29, 2017 5:49 PM, "Simon Slavin" <slav...@bigfraud.org> wrote: On 30 Jan 2017, at 12:06am, Scott Robison <sc...@casaderobison.com> wrote: > I'm not sure how big the market is, but there are older computers in use in > areas that might be running older OS b

Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuInit

I'm not sure how big the market is, but there are older computers in use in areas that might be running older OS because anything newer is too bloated. If maintaining ANSI C compatibility truly becomes a burden, sure. If it isn't then why not? On Jan 29, 2017 4:36 PM, "James K. Lowden"

Re: [sqlite] How to circumvent UNIQUE constraint

This might be helpful. Maybe not. It's not an answer to the exact question, but ... What if you were to set all the IDs to their negative, then update them as desired? UPDATE TABLEA SET ID = -ID; UPDATE TABLEA SET ID = -ID + 1; Or something like that. It is not as efficient as would be

Re: [sqlite] Changing ID's to UUID

dom number generator for non cryptographic purposes. -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] deprecated windows OS calls

catch is that it will (apparently) forever report it is an older version of the OS than it really is. -- Scott Robison ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] A small technical question about SQLite

s. > > —Jens > > > On Oct 24, 2016, at 7:20 PM, Scott Robison <sc...@casaderobison.com> > wrote: > > > > Don't everyone dial at once! > > > > On Mon, Oct 24, 2016 at 2:36 PM, LIAT SEAGAL-DERY < > liat.seagald...@gmail.com > >> wrote: > &

Re: [sqlite] A small technical question about SQLite

> > Thank you, > Liat > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Scott Robison _

Re: [sqlite] Problem with rename table

On Sep 10, 2016 2:54 AM, "John McMahon" wrote: > > On 08/09/2016 10:09, Bob McFarlane wrote: >> >> Please reply if you sent this. Thanks. >> > > Hmm, looks like a fishing exercise to me. Same message in several threads. > > This reply only to mailing list. It's an

Re: [sqlite] schema_version and Vacuum or Backup API

Darn. Oh well. On Sep 8, 2016 9:34 AM, "Stephen Chrzanowski" wrote: > Apparently, no. Error is "cannot create trigger on system table". > > On Thu, Sep 8, 2016 at 11:19 AM, Stephen Chrzanowski > wrote: > > > Interesting idea. I'll try that on a

Re: [sqlite] schema_version and Vacuum or Backup API

On Sep 8, 2016 8:16 AM, "Richard Hipp" wrote: > > On 9/8/16, Stephen Chrzanowski wrote: > > > > However, the rabbit I was hoping to pull out of the hat was that the change > > in version numbers be done automatically when I make a change in the 3rd > > party

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

I saw no page content below "Documents By Category". If I rotated it to landscape the content was there, but it didn't render. I'll be able to go more in depth later, not at home with the tablet at the moment. On Sep 6, 2016 12:37 PM, "Richard Hipp" <d...@sqlite.org>

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

Lamding page looks fine on my Galaxy Note 4 phone and cheap Amazon Fire tablet, both landscape and portrait. Documents by category doesn't like portrait mode on my tablet (at least). On Sep 6, 2016 8:38 AM, "Eric Kestler" wrote: > Looks quite good and is very readable on my

Re: [sqlite] client app crashes frequently and points sqlite DLL

In looking at the changelog for 2.7.12, I see multiple SQLite related Python fixes that addressed coredump bugs. On Sep 1, 2016 9:22 AM, "Scott Robison" <sc...@casaderobison.com> wrote: > It appears 2.7.12 is available. Perhaps it is worth trying. > > On Sep 1, 2016

Re: [sqlite] client app crashes frequently and points sqlite DLL

; > > Thanks, > > Frantz. > > > On 01/09/2016 17:00, Scott Robison wrote: > >> Specifically, what version / distribution of Python 2 is in use? Python's >> own release, ActiveState, other? >> >> On Sep 1, 2016 8:27 AM, "Frantz FISCHER" <ffi

Re: [sqlite] client app crashes frequently and points sqlite DLL

Specifically, what version / distribution of Python 2 is in use? Python's own release, ActiveState, other? On Sep 1, 2016 8:27 AM, "Frantz FISCHER" wrote: > Hello Richard, > > > Thank you for your answer! > > Could you please tell me which details you would require? > > I

Re: [sqlite] Why MMAP return ENOMEM in SQLite?

On Aug 31, 2016 5:29 AM, "sanhua.zh" wrote: > > BTW, what do you think if I mapseparatly instead of the whole db file, ... I suspect that it wouldn't really help you much, if any. One, there is overhead in making that many system calls to map a bunch of 4 MiB buffers.

Re: [sqlite] sqlite importing csv

On Aug 24, 2016 10:25 PM, "Alan" wrote: > > forgot to reply to one of the questions. > > I am using version 3.13.0.0 and it is 64 bit > > I am running Windows 10 Pro > > computer is intel I3 3.5Ghz with 8Gb RAM. > > As my friend has no problem loading the same csv file with

Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

On Aug 24, 2016 5:35 AM, "Simon Slavin" wrote: > > > On 24 Aug 2016, at 12:33pm, Drago, William @ CSG - NARDA-MITEQ wrote: > > > This is also the list for System.Data.SQLite. System.Data.SQLite supports design time components for VS2015, so this

  1   2   3   4   >