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 > http://mailinglists

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 query,

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 s

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 sqlite3Strlen30N

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 f

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 2

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 z

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 thro

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 f

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 vi

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 un

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 separators

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 suspec

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

ON ([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 suspected havi

[sqlite] Lemon Parser vs bubble-generator.tcl

from some of the 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

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

#x27;t think all ORMs would 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

input 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 Robi

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 serve

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

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

have ways to do this 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 inte

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

; INSERT INTO mySinkDBTable VALUES(1,8,'51'); COMMIT; Given the comment 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

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 companieshouse.gov.uk using

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: > > > > Th

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, zTerm, c) > https://

Re: [sqlite] .dump command and user_version

On Thu, Mar 29, 2018, 8:18 AM Richard Hipp wrote: > On 3/29/18, Scott Robison 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. > Of course. I wasn't suggesting that it should be

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 actually use it, but it might be interesting to ad

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 schema. You might com

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 sense in that > use case, so I

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 = pFunc->pExpr; > asser

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 group_concat(distinct s,', ')

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 ? SQLite version 3.19.3 2017-06-27 16:48:08 Enter ".he

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 to Heaven says > a lot

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 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 happy. It is possible >> to fix

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. > https://en.wikipedia.org/wiki/The_Power_of_10:_Rules_for_Developing_Safety-Critical_Code The p

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

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 > operation got the error?

Re: [sqlite] Support for named foreign keys?

y 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 diagrams are quite clear th

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

sking 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 i

Re: [sqlite] VALUES clause quirk or bug?

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

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 that NULLs were converted to the default v

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

#x27;utf8'; sqlite> 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&

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 largest companie

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 returning an error indicat

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

On Jun 26, 2017 4:05 AM, "Rowan Worth" wrote: On 26 June 2017 at 16:55, Scott Robison wrote: > Byte Order Mark isn't perfectly descriptive when used with UTF-8. Neither > is dialing a cell phone. Language evolves. > It's not descriptive in the slightest

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 the standard. If we'

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 order is nonsense in this context as t

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 backwards >> compatibility is paramount, and

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 3.19.2 2017-05-25 1

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 PRIMARY KEY CHECK (id

Re: [sqlite] INTEGER PRIMARY KEY

On Jun 12, 2017 5:43 PM, "Richard Hipp" wrote: On 6/13/17, Scott Robison wrote: > > Is it fair to say that the rowid aliasing behavior does not require > (by design) the incantation "INTEGER PRIMARY KEY" (all three words in > that order as the "type&quo

Re: [sqlite] INTEGER PRIMARY KEY

On Mon, Jun 12, 2017 at 4:20 PM, Simon Slavin wrote: > > > On 12 Jun 2017, at 11:01pm, Scott Robison wrote: > >> Is it fair to say that the rowid aliasing behavior does not require >> (by design) the incantation "INTEGER PRIMARY KEY" (all three words in >&

[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" wrote: Scott Robison wrote... On Mon, May 8, 2017 at 11:40 AM, Paul van Helden wrote: > Hi, >> >> I use a lot of indexes on fields that typically contain lots of NULLs, so >> the WHERE NOT NULL partial indexing s

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

ts.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 inaccuracies, but I don’t

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 CONFIG_SHELL=/bin/dash ./configure

Re: [sqlite] Incompatibility into configure.ac

27;t a standard location for bash on systems where it is not the default shell. Does sh not provide the necessary functionality with some other syntax? > > —Jens > ___ > sqlite-users mailing list > sqlite-users@m

Re: [sqlite] core using sqlite 3.17.0 on solaris

On Thu, Mar 30, 2017 at 11:22 AM, Richard Hipp wrote: > On 3/30/17, Scott Robison wrote: >>> >> Also, isn't the new code potentially allocating a smaller buffer in >> zSpace? If sizeof(yyParser) is 15, the removed line would allocate a >> 15 element array of u

Re: [sqlite] core using sqlite 3.17.0 on solaris

ting 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 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-amalgamation-317.zip >> &

Re: [sqlite] Possibly pointless assert

On Thu, Mar 23, 2017 at 10:17 AM, Scott Robison wrote: > On Thu, Mar 23, 2017 at 9:21 AM, Dan Kennedy wrote: >> How did you trip the assert()? i.e. what is the database schema and query >> that cause it to fail? > > In trying to track down issues recently, a team member d

Re: [sqlite] Possibly pointless assert

On Thu, Mar 23, 2017 at 9:21 AM, Dan Kennedy 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). >> >> I may not be underst

[sqlite] Possibly pointless assert

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

Re: [sqlite] SQLite3.dll for x64

eady 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/cgi-bin/mailman/listinfo/sqlite-users

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

ers are not encoded as fixed sized fields. Depending on the magnitude of the integer that is being written, it could change sizes from 0 to 9 bytes. Thus the offset of the blob in the row may change. Once the fix for the "any table same rowid" problem is available to you, your best bet

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 kind of > "report". https://github.com/jklowden/sq

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

irst "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-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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 > doesn't solve your problem? I've encountered no

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 reflect the state of > > the database as of the momen

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

On Tue, Jan 31, 2017 at 9:48 AM, James K. Lowden wrote: > On Mon, 30 Jan 2017 13:32:46 -0700 > Scott Robison wrote: > > > Basing source on "ANSI C" (as much as possible) just gives you the > > biggest possible distribution / compatibility. > > Yes, but i

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

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-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-

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

On Jan 29, 2017 5:49 PM, "Simon Slavin" wrote: On 30 Jan 2017, at 12:06am, Scott Robison 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 because anything newer is too bloated. The emphasis is

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" wrote: >

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 preferred

Re: [sqlite] Changing ID's to UUID

ng it for anything, except > when needed for compatibility with legacy formats/protocols. > Completely depends on your needs. If your needs are not cryptographic, then there is no problem. Just like there is no problem using a pseudo random number generator for non cry

Re: [sqlite] deprecated windows OS calls

is something I should be concerned about with deployment on Windows > 8/10 boxes? > As long as SQLite isn't using APIs introduced with Windows 8 or later, it shouldn't make a difference. Microsoft might call GetVersionEx "deprecated" but it's still there and suppor

Re: [sqlite] A small technical question about SQLite

; On Oct 24, 2016, at 7:20 PM, Scott Robison > wrote: > > > > Don't everyone dial at once! > > > > On Mon, Oct 24, 2016 at 2:36 PM, LIAT SEAGAL-DERY < > liat.seagald...@gmail.com > >> wrote: > > > >> Hi, > >> > >> I am

Re: [sqlite] A small technical question about SQLite

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

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 anti-spam measure. Most spam wil

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 scratch DB when I get the > > chance. (Spen

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 DB management tool. I don't know if t

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" wrote: >

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 iPhone 6s and iPad Mi

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" wrote: > It appears 2.7.12 is available. Perhaps it is worth trying. > > On Sep 1, 2016 9:19 AM, "Frantz FIS

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

It appears 2.7.12 is available. Perhaps it is worth trying. On Sep 1, 2016 9:19 AM, "Frantz FISCHER" wrote: > Hello, > > > 2.7.10 python own release. > > Got another crash mentioning the _pylite3.pyd module as you suspected > before. > > > Thanks, >

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 managed to get a window

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. Two, once you've mapped th

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 his Windows7 computer

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 may be the correct list for questions regarding iss

  1   2   3   4   >