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] Can I search all tables and columns of SQLite database for a specific text string?

a combination of SQL statements and looping arrays. Thanks for your help guys! Scott ValleryEcclesiastes 4:9-10 On Thursday, February 13, 2020, 09:35:54 AM EST, Simon Slavin wrote: On 13 Feb 2020, at 2:01pm, Scott wrote: > Can I search all tables and columns of SQLite datab

[sqlite] Can I search all tables and columns of SQLite database for a specific text string?

. Thanks, Scott ValleryEcclesiastes 4:9-10 ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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] Please increase the default for SQLITE_MAX_VARIABLE_NUMBER

ht to be using carray or intarray but not everyone knows they exist :) Scott ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[sqlite] Problem building DLL on Windows - no exported symbols

ideas? Thanks, Scott ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] DEF CON (wasL A license plate of NULL)

ined with Check Point Research's recent publication (search for "SELECT code_execution FROM * USING SQLite;"), which explains how to gain control of a process from a database file by replacing all of its tables with views containing malicious queries. Scott _

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] SEE encryption password

Here is a suggestion. You can select between decimal and hexadecimal output. https://nousrandom.net/randominteger/index.html - Scott Doctor sc...@scottdoctor.com - On 5/6/2019 13:20, Jens Alfke wrote: On May 5, 2019, at 11:04 PM

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] Backing up a SQLite database without the CLI

(and wal, if appropriate) files directly. Scott On Mar 18, 2019, at 08:21, Jonathan Moules wrote: > > Hi Simon, > > Thanks for your thoughts. Sorry, I should have been clearer: I have no way of > knowing if there are other open connections to the file - there may be a

Re: [sqlite] Corruption of database when renaming a table

/lang_altertable.html Scott > On Mar 15, 2019, at 06:29, tjerzyko wrote: > > I'm having corruption problem with a certain database file. You can download > it here: > https://drive.google.com/file/d/1RCPoPgoLdc2VgF2uX2zPFrkheFi9z3b_/view?usp=sharing > It was created with SQLite 3.8.7 or older

Re: [sqlite] Am I understanding how to use ROLLBACK - SAVEPOINT correctly?

Andy, David, Tim!!! Thanks for the help and advice... I think I will name mine "theKraken"... ;) LOL! Scott ValleryEcclesiastes 4:9-10 On Wednesday, February 13, 2019, 10:34:51 AM EST, Tim Streater wrote: On 13 Feb 2019, at 15:23, David Raymond wrote: > On a humor

[sqlite] Am I understanding how to use ROLLBACK - SAVEPOINT correctly?

DB connection Thanks for your time! Scott ValleryEcclesiastes 4:9-10 ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] My TimeStamp field keeps populating though I don't write anything to it

Last reply... I figured out the cause. I had a Regex to validate but there was a second validation I forgot about with a DateTime object check causing the issue - so blank was defaulting. I removed it and no issue. Thanks! Scott ValleryEcclesiastes 4:9-10 On Tuesday, February 5, 2019, 12

Re: [sqlite] My TimeStamp field keeps populating though I don't write anything to it

Hi Simon... Thanks, I do have my  moments! LOL! I have a Regex on the GUI limiting the user to hh:mm:ss format or simply blank. Somehow that must be getting translated into a full date and time as default when blank. Scott ValleryEcclesiastes 4:9-10 On Tuesday, February 5, 2019, 11:55:47

Re: [sqlite] My TimeStamp field keeps populating though I don't write anything to it

Hi David! I think I know what direction I need to go and this helps and makes sense. I may simply need to figure out what is sending the "Thu Jan 01 00:00:00 EST 1970" and handle it from there. Thanks! Scott ValleryEcclesiastes 4:9-10 On Tuesday, February 5, 2019, 11:11:56 AM

Re: [sqlite] My TimeStamp field keeps populating though I don't write anything to it

probably need to be apart of that forum for this question. Thanks for the help! I appreciate the patience until my thick head could be penetrated :) 16 (17) Data Types:https://github.com/pawelsalawa/sqlitestudio/wiki/User_Manual#value-editor-dialog Scott ValleryEcclesiastes 4:9-10 On Tuesday

Re: [sqlite] My TimeStamp field keeps populating though I don't write anything to it

olumn Data Type SizeCommentID INTEGER PKSummary VARCHAR 120Comment BLOBPage VARCHAR 10TimeStamp TIME 8Hyperlink BLOB Scott Vallery Ecclesiastes 4:9-10 On Tuesday, February 5, 2019, 8:23:53 AM EST, Tim Streater wrote: On 05 Feb 2019, at 13:08, Sco

[sqlite] My TimeStamp field keeps populating though I don't write anything to it

());stmt.setString(2,this.tbxComment.getText());stmt.setString(3,this.tbxPages.getText());stmt.setString(4,this.tbxTimeStamp.getText());stmt.setString(5, this.tbxHyperlink.getText());stmt.execute() Scott ValleryEcclesiastes 4:9-10 ___ sqlite-users maili

Re: [sqlite] How to do I get an 'AND' condition to work in an SQLite query?

Figured it out! I had set the column Deleted to "CHAR" but all the fields without 'X' were null. If I replaced null with a valid character it worked. Thanks for your time. Scott ValleryEcclesiastes 4:9-10 On Thursday, January 31, 2019, 12:46:34 PM EST, Scott wrote: I

[sqlite] How to do I get an 'AND' condition to work in an SQLite query?

tried and even with INNER JOIN: (WHERE t.Topic = 'Manuscript Copies') AND n.Deleted <> 'X')WHERE (t.Topic = 'Manuscript Copies') AND (n.Deleted <> 'X') WHERE t.Topic = 'Manuscript Copies' AND n.Deleted <> 'X' Thanks, Scott ValleryEcclesiastes 4:9-10

Re: [sqlite] SEE Temp Files

der which it may write an idle application's memory to disk. Scott ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] -wal and -shm files left behind by libsqlite3.dylib

files. If you need, you can still override this behaviour using the SQLITE_FCNTL_PERSIST_WAL opcode to the sqlite3_file_control() interface. Scott On Jan 28, 2019, at 10:32, Carsten Müncheberg wrote: > > When loading and using /usr/lib/libsqlite3.dylib (3.19.3) which is shipped > w

Re: [sqlite] CoreData - when database gets closed

cks. > Using NSFileProtectionCompleteUnlessOpen or NSFileProtectionComplete should > do a good job of keeping your data secure. I'd recommend using NSFileProtectionComplete over NSFileProtectionCompleteUnlessOpen. The former is simpler and self-securing (the filesystem will return an error if Core Data attempts to

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] Database locking problems

this in VB and C# but I think you stated below you using Linux and C, which I have no clue... but I found a video here:  https://www.youtube.com/watch?v=rvbGbmXJ0f0 Scott ValleryEcclesiastes 4:9-10 On Saturday, January 19, 2019, 7:11:57 AM EST, andrew.g...@l3t.com wrote: I am having

[sqlite] Ideas or Guide on SQLite Search Engine for a relational database?

nything linked back to a source. However, the source will be associated to many of each of those. Thanks, Scott       ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mai

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

. - Scott Doctor sc...@scottdoctor.com - On 12/21/2018 13:02, Larry Brasfield wrote: Zydeholic wrote: ➢ I compile and get one error: Severity    Code    Description    Project    File    Line    Suppression State Error    LNK2001    unresolved

Re: [sqlite] Need setup code for VC++ 2017 that will ACTUALLY COMPILE

Click the link. https://sqlite.org/download.html Download the amalgamation zip file. Unzip to your files directory. Should be two files. sqlite.c and sqlite.h Add #include "sqlite.h" to your file. Compile. - Scott Doctor sc...@scott

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] Mac: Users receive "database disk image is malformed" errors after restoring database from Time Machine backup

the update for a long time without any reports of this issue. I might > be doing something wrong or have changed anything else, but I don’t know > what; if you have any ideas, let me know. > > Any suggestions on what could be the culprit or what else I could try besides > downgrading al

Re: [sqlite] SQLite iOS timestamp type mapping settings must be set to float to get correct data

On Nov 26, 2018, at 14:16, Simon Slavin wrote: > > On 26 Nov 2018, at 9:09pm, Scott Perry wrote: > >> For Bill's purposes—investigating a copied, non-corrupt database—it would >> probably be easiest to just convert from the Cocoa epoch to the Unix epoch >>

Re: [sqlite] SQLite iOS timestamp type mapping settings must be set to float to get correct data

hing like: UPDATE ZTIMEENTRY SET ZDATE = ZDATE + 978307200; Scott ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Regarding CoC

for such documents. Scott On Oct 19, 2018, at 7:11 AM, Richard Hipp wrote: > > On 10/19/18, Mantas Gridinas wrote: >> >> I found code of conduct in documentation and I was wondering if it were >> true. Checking the version history it appears to have been added on >

Re: [sqlite] Using SQLite in C# without System.Data.SQLite

Why not just add the amalgmation to your source then do C function calss. I do not get why you would use a dll when you can just link in the amalgamtion into your program and have full access to the latest version. - Scott Doctor sc...@scottdoctor.com

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

[sqlite] Shouldn't have to specify primary key explicitly

SQLite is supposed to autoincrement by default when a column is defined as "INTEGER PRIMARY KEY" according to everything I've read. But I've only gotten this to work if I let SQLite create its own PK column. If I have an explicit PK column, I am expected to specify an ID myself. What am I missing?

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] Strange Corruption Issue

SSD's have a limited number of write cycles. You may have a failing SSD. Those are still, IMO, another 5-10 years before they solve the write lifetime reliabilty issue. - Scott Doctor sc...@scottdoctor.com - On 6/18/2018 20:15, Patrick Herbst

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? >

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] sqlite.org website is now HTTPS-only

Just out of curiosity, is the sqlite website using nginx or apache as the server? - Scott Doctor sc...@scottdoctor.com - ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

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 <peter.nichvolo...@gmail.com> 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

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] Move to Github!!?

What fossil needs is for the UI to perform ALL normal common functions (new, commit, clone,...) WITHOUT having to open a command line window. That is imo the main limitation. - Scott Doctor sc...@scottdoctor.com

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] random value get re-generated too often in SQLite

Is it possible that the first call to random is cached and the cached value is being returned in subsequent calls? - Scott Doctor sc...@scottdoctor.com - On 12/8/2017 12:09, John McKown wrote: On Fri, Dec 8, 2017 at 12:54 PM, John Mount <

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] Problem with mailing list

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

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

  1   2   3   4   5   6   7   8   9   10   >