Re: [sqlite] [PHP5-FPM] Sqlite3 or pdo_sqlite?

nd certainly a slight advantage to PDO. PDO_sqlite3 also does have the advantage of being available by default since PHP 5.0.0, whereas sqlite3 is only available by default since PHP 5.3.0. I'm aware of no other advantages to using PDO, and from what I've read it's on the slow side. -- J. King

Re: [sqlite] which tool do they use to generate the SQL Syntax diagrams?

On Mon, 20 Apr 2009 06:53:37 -0400, D. Richard Hipp <d...@hwaci.com> wrote: > http://wiki.tcl.tk/21708 It's a shame: I far preferred the BNF: more compact, not to mention you could copy and paste as well as search the text of the syntax itself. --

Re: [sqlite] which tool do they use to generate the SQL Syntax diagrams?

y now sufficiently familiar with SQLite's syntax that the diagrams suffice when I need a refresher. :) -- J. King ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] setting a date in a BEFORE INSERT trigger

values you want, then does SELECT > RAISE(IGNORE); to suppress inserting the original record (one that > caused the trigger to run in the first place). Could he not also use an INSTEAD OF trigger, negating the need for RAISE(IGNORE)? -- J. King ___ sqli

Re: [sqlite] Syntax to set the conflict resolution of a transaction

or an entire transaction? Such a thing is not possible. You may specify a conflict resolution on a given statement (eg. 'INSERT OR ROLLBACK') or on a table (on PRIMARY KEY, NOT NULL and UNIQUE constraints), but not on a transaction. -- J. King ___ sqlite-u

Re: [sqlite] "Bad CPU type in executable"?

bottom, and that's a shame. I just roll with it, though, and I would suggest you do the same: it's really not worth the aggravation. -- J. King ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] MySQL makes me wish for SQLite

erface doesn't allow for some things like loading extensions (and it's apparently slower, but I haven't taken the time to compare), but there's always <http://ca2.php.net/manual/en/book.sqlite3.php> if you have PHP 5.3 on hand and your existing code works with it. -- J. King

Re: [sqlite] WASP

dded within PHP since 5.0.0. The SQLite library is typically not up to date, unfortunately, but it is nevertheless there. The PDO interface lacks most of SQLite's more advanced features, but the SQLite3 extension (included by default since PHP 5.3) is, I believe, feature-complet

Re: [sqlite] Is it possible for SQLite to notify an application connected to it of database changes?

On Mon, 23 Nov 2009 23:12:12 -0500, Erin Drummond <erin@gmail.com> wrote: > Is it possible for an application to be notified when a trigger inside > the database is fired? I imagine you could make the trigger call a user function which notifies the application...

Re: [sqlite] Implementing Regular Expression Support...?

The means by which one defines a user function depends on the language. See, for instance, [1] for Ruby. For a 'regexp' function you would specify two arguments, pattern and string to match against. [1] <http://sqlite-ruby.rubyforge.org/sqlite3/classes/

Re: [sqlite] sqlite, php, and Mac OS X 10.6.1

; http://php.net/manual/en/book.sqlite.php For clarity, that's the old SQLite 2 interface---which I suspect you didn't intend to recommend, Simon. The modern non-PDO SQLite 3 interface is documented here: <http://www.php.net/manual/en/book.sqlite3.php> It is, however, only av

Re: [sqlite] Accessing SQLite from PHP5?

ion of SQLite more up-to-date than that exposed by PDO. Whereas PDO is an abstracted interface, though, SQLite3 appears to be a slightly more direct mapping of the SQLite API, exposing more SQLite-specific features. -- J. King ___ sqlite-users maili

Re: [sqlite] Errors opening WAL-based databases with SQLITE_OPEN_READONLY

read-only WAL databases. The opening process must have write privileges for "-shm" wal-index shared memory file associated with the database, if that file exists, or else write access on the directory containing the database file if the "-shm" file does not exist. -- J. Ki

[sqlite] Typo in documentation

The first paragraph in Section 2 of <http://sqlite.org/compile.html> states in part: ... And the SQLITE_OMIT_PROGESS_CALLBACK option is only usable by applications... Note the missing R in PROGRESS. -- J. King ___ sqlite-users mailing list

Re: [sqlite] Security vulnerabilities prevalent in web tutorials for PHP, javascript, etc..

out using prepared statements; I'd love it if we could all get the basics right so that articles warning about less straightforward problems would stand out more. Hopefully that article will reach some of those who need it. Thanks, Simon. -- J. King _

Re: [sqlite] Producing SQLITE_MISMATCH

On 2017-03-09 09:35:00, "Dan Kennedy" <danielk1...@gmail.com> wrote: On 03/09/2017 09:23 PM, J. King wrote: I'm trying to write a minimal test case to produce an SQLITE_MISMATCH response. The documentation suggests the following should be sufficient: CREATE TABLE test(id

Re: [sqlite] Producing SQLITE_MISMATCH

On 2017-03-09 09:59:25, "Dan Kennedy" <danielk1...@gmail.com> wrote: On 03/09/2017 09:39 PM, J. King wrote: Out of curiosity, can you provide some insight as to why it does not produce a mismatch for a WITHOUT ROWID table? The main b-tree in which data for a "row

[sqlite] Producing SQLITE_MISMATCH

. Is there some trick to it that's not obvious? -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to use parameterized queries in SQLite.Net

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

[sqlite] Cut off paragraph in pointer documentation

The fifth paragraph of <https://sqlite.org/bindptr.html#destructor_functions> ends after two words, "Note that". -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/

Re: [sqlite] FOREING KEY constraint

The sqlite_master table should have this information. SELECT count() FROM sqlite_master WHERE name IS your_constraint_name AND tbl_name IS your_table_name; On July 3, 2017 9:37:04 AM EDT, Igor Korot wrote: >Hi, Keith et al, > >On Mon, Jul 3, 2017 at 7:13 AM, Keith Medcalf

Re: [sqlite] What is the exact syntax for SELECT MAX in PHP?

Simon, why would you recommend not using PDO? Does the SQLite3 extension perform better, or does it boil down to personal preference? On August 5, 2017 1:35:43 PM EDT, Simon Slavin wrote: > > >On 5 Aug 2017, at 10:53am, Edmondo Borasio >wrote: >

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

Indeed. Technically-minded Windows users do exist (Hi, Microsoft, I'm right here!), and I have neither the time nor the inclination to learn PowerShell when the Windows terminal is already adequate---with a set of ports of GNU tools, anyway. :) On June 20, 2017 9:24:12 AM EDT, R Smith

Re: [sqlite] Regarding Sqlite DB Index

te-users The "sql" field contains the statement executed to create the table/index/trigger/etc. Automatic indexes are a side-effect of table creation, and so have no associated statements. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] auntondex with unique and integer primary key

an/listinfo/sqlite-users A primary key is by definition unique, so the unique constraint is needless duplication. Note, too, that the primary key is only an alias for the rowid when using the formulation "integer primary key" exactly. -- J. King __

Re: [sqlite] Generalized SQLite stored procedure style pivot table exhibit.

ry view as one must not be tempted to keep it >(and miss new fruits). >Thanks, E. Pasma > >___ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users The eva

Re: [sqlite] SELECT WHERE with RTREE and second condition slow

you should always use INTEGER PRIMARY KEY if the column is whole numbers, regardless of size. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] JOIN vs. INTERSECT vs. WHERE IN (...) - speed and efficiency differences

There's an extra word in the first paragraph of Section 4 of that document, by the way: " The error logger callback has also proven useful in catching errors occasional errors that the application misses..." On September 11, 2017 11:22:50 AM EDT, Dan Kennedy wrote: >On

Re: [sqlite] JOIN vs. INTERSECT vs. WHERE IN (...) - speed and efficiency differences

Doh. I meant the linked document on the error log. Silly me. <http://sqlite.org/errlog.html> On September 11, 2017 9:41:39 PM EDT, "J. King" <jk...@jkingweb.ca> wrote: >There's an extra word in the first paragraph of Section 4 of that >document, by the way: > &

Re: [sqlite] How does SQLite handle \r and \n in values?

More details would help. How are you inserting the data? Are you using a bound parameter (you should be), or quoted text? Are you using something other than the C interface to interact with the database? Which error did you receive? Can you provide a minimal example of the code you used? On

Re: [sqlite] How to handle such situation

, it wouldn't even require changes to the logic of your application. On October 4, 2017 10:20:01 PM EDT, Igor Korot <ikoro...@gmail.com> wrote: >Hi, > >On Wed, Oct 4, 2017 at 6:19 PM, J. King <jk...@jkingweb.ca> wrote: >> See also: >> <http://sqlite.org/lang_co

[sqlite] The IS operator

want to use = rather than IS that I'm not aware of? Thanks. :) -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Data types for date and time functions

ual stored dates end up as simply '-MM-DD HH:NN:SS' or even just '-MM-DD' if not interested in the time. It's worth noting that the CURRENT_TIMESTAMP keyword uses "-MM-DD HH:MM:SS" format, and implied UTC. -- J. King ___ sqlite

Re: [sqlite] How to handle such situation

See also: On October 4, 2017 6:15:55 PM EDT, Jens Alfke wrote: > > >> On Oct 4, 2017, at 2:20 PM, Igor Korot wrote: >> >> If I start transaction, all queries were successful, but issuing >"COMMIT" fails. >> On such

Re: [sqlite] The IS operator

Thank you, Richard. After some digging I see, too, that MySQL uses <=> for that same functionality, Microsoft has a toggle for =, and Oracle nothing. I had clearly been mistaken about IS's portability. On October 6, 2017 7:53:27 PM EDT, Richard Hipp <d...@sqlite.org> wrote: &g

Re: [sqlite] Does journal_mode=DELETE writes uncommitted queries into DB?

Thanks for the thorough explanation, Rowan. I must say I learned something, myself! On November 23, 2017 11:23:11 PM EST, Rowan Worth <row...@dug.com> wrote: >On 24 November 2017 at 10:27, J. King <jk...@jkingweb.ca> wrote: > >> The rollback journal is used to return the

Re: [sqlite] Does journal_mode=DELETE writes uncommitted queries into DB?

The rollback journal is used to return the database to its previous state in the case of a partial write, not complete writes which are interrupted. As you didn't commit the transaction, no write occurred, never mind a partial one, so the database remained in its initial state. Deleting a

Re: [sqlite] "BIGINT" doesn't act like INTEGER on table creation [Bug]

Version 1 UUIDs only use a random number (16 bits) in the case of an uninitialized clock sequence (a case which, ideally, should only occur the first time a device generates a UUID). Version 1 UUIDs especially avoid using random numbers; they are also not a shortening of longer input. In

Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

Please forgive the off-topicedness of this message, but I would like to second that this mailing list is incredibly edifying, and I would also like thank everyone who has both answered and asked questions in the time I've been subscribed. I've stumbled across answers here that I never thought

Re: [sqlite] "BIGINT" doesn't act like INTEGER on table creation [Bug]

Peter (that is, the other Peter) is being more than a little flippant, yes, and at least a little obscure (I don't get the joke, either), but the substance appears quite serious. His prior message suggested using what I can only assume would be a trivial extension to SQLite to do what you

Re: [sqlite] Web issue

It seems to be fixed now. It's working for me now in the same environment in which it was not working earlier. On November 23, 2017 4:54:56 PM EST, Simon Slavin wrote: > > >On 23 Nov 2017, at 9:14pm, R Smith wrote: > >> In searching the sqlite.org

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

Someone please correct me if I'm wrong, but I believe it's mandated by the SQL standard that integer division is used when both operands are integers. Your synthetic example doesn't use a fixed table, but if it did the easiest solution for you would probably be to define any columns where you

Re: [sqlite] Can a trigger recursively update a table?

CTEs cannot be used inside triggers for UPDATE statements. See near the bottom of: On December 12, 2017 6:44:35 PM EST, Shane Dev wrote: >Hi, > >I have a hierarchical table - > >sqlite> .sch hierarchy >CREATE TABLE hierarchy(id

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

I greatly prefer e-mail, too. It's a shame mailing lists run afoul of SPF and usually DKIM, and doubly so that ARC is unlikely to be of much help. I abhor Discourse, so it's depressing for me that it's so popular. Alas... On November 21, 2017 10:16:24 AM EST, Stephen Chrzanowski

Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

gt; >___ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users SQLite also creates temp files in various circumstances: <https://sqlite.org/tempfiles.html&

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

e-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> >___ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlit

Re: [sqlite] Issue with node-sqlite3

u'd probably have more luck asking in a forum for those technologies first. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

ally sad to see this discussion list move to Discourse (as was suggested and apparently explored earlier this week), as I find that software very unresponsive and difficult to use on Firefox for Android, and I do much of my reading of this list on the go (like right now). -- J. King __

Re: [sqlite] Size of the SQLite library

standard build when distributing to others. A more powerful default configuration would be very beneficial, and a less powerful one possibly crippling. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] INSERT OR REPLACE statement and triggers

The documentation states that in cases of replacement the DELETE trigger only fires if recursive triggers are enabled. Recursive triggers are currently off by default. On December 23, 2017

Re: [sqlite] Move to Github!!?

SQLite source is managed in a Fossil (not Git) repository, which is software itself designed by Dr. Hipp and based on SQLite. GitHub would be an entirely inappropriate venue. SQLite is also not open source software in the conventional sense. SQLite is written by a small team of people, and

[sqlite] Documentation typo

In <http://sqlite.org/howtocorrupt.html#cfgerr> the following passage contains a typo ("crass" -> "crash"): Setting PRAGMA synchronous=OFF can cause the database to go corrupt if there is an operating-system crass or

Re: [sqlite] UTF8 and NUL

/M-80), the filesystem meta data did not include the actual _length_ of the data for a text data file. Since DOS wasn't an OS, then CP/M certainly wasn't. Do you have a point in making either statement? If you do, I'm really not seeing it. -- J. King

Re: [sqlite] Vetting SQLite

I believe it's only since Windows 8. On February 5, 2018 7:51:39 PM EST, Stephen Chrzanowski wrote: >I was surprised to see that statement, so, checking my system, this >isn't >true. Win7Pro-x64. Not with that filename anyways. Searching my >system >with the

Re: [sqlite] Vetting SQLite

I'm not aware of a statement or guarantee, but the Web site provides lots of evidence here: In particular, SQLite being used as part of aircraft software by Airbus should tell you something. On February 5, 2018 12:21:53 PM EST, "Drago, William @ CSG -

Re: [sqlite] Move to Github!!?

I use Git, but I'm not attached to it. I run my own publicly-accessible remote (using Gitea), but that would be completely replaceable with Fossil (which I am very impressed by). What's not so easy to replace is the Git integration in my editor (Visual Studio Code) which allows me to easily

Re: [sqlite] Very, very slow commits

ther >areas of the code are now significantly slower, whereas before they >were >quick. > >Where were you going with that question? > Might ANALYZE help? -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] Blob and Text columns: what's the difference?

send some binary data to a Text column? I don't know all the ins and outs, but text columnns are convertible between UTF-8 and UTF-16 upon request, whereas blobs are just byte strings. -- J. King ___ sqlite-users mailing list sq

Re: [sqlite] Minor JSON output bug (infinity)

RFC 8259 states: > Numeric values that cannot be represented in the grammar below (such as > Infinity and NaN) are not permitted. This is one of the cases that expose the fallacy of the "JS" part of "JSON". While SQLite should not be producing Inf as a bare word, it should not be producing

Re: [sqlite] A couple of questions about prepared statements

not affect the database itself and it's only when the prepared statement is actually executed that the database is touched and might generate an SQLITE_BUSY response? When the transaction is committed. If you've not explicitly begun a transaction, then

Re: [sqlite] [EXTERNAL] found a glitch in ALTER TABLE RENAME (3.25.x)

te a new modified table under the old name, insert the old table's data into the new, and then drop the old table. If foreign keys were, for lack of a better term, partially enforced, this process would yield new and backwards-incompatible results: when the old t

Re: [sqlite] Segmentation Fault When Using Window Function

quot;. As the ticket UUID is not deleted (it is invalid) I would have expected a 404 response with an appropriate message. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] minor nit pick of "When To Use"

sts.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users he.net is Hurricane Electric, an Internet backbone. Not exactly the authority on manpages, I'll grant, but given what they do it's not likely to go down, so it's a stable reference for the manual. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] JOINning two tables provides no data

On January 18, 2019 12:54:32 PM EST, Jose Isaias Cabrera wrote: > >sqlite> select a.a, a.b, a.c, b.d, b.e as q from a join b on a.a=b.a >where a.a = 1; >sqlite> > >This provides no result. I expected to get, > >1|2|3|| You appear to seek the resu

[sqlite] Detecting erroneous multi-row subqueries

. In my application the actual query was erroneous and would potentially return data belonging to a user other than the one making the request, which concerns me quite a bit. Is it possible to make SQLite fail like PostgreSQL does? -- J. King ___ sqlite

Re: [sqlite] Detecting erroneous multi-row subqueries

dn't recall it when it was actually important. Once again, thanks. :) -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Detecting erroneous multi-row subqueries

On 2018-11-29 20:56:13, "Richard Hipp" wrote: On 11/29/18, J. King wrote: Is it possible to make SQLite fail like PostgreSQL does? That is possible in theory, but how many of the millions of existing applications would that break? I was wondering more if it's -currently- po

[sqlite] Omitted features documentation slightly out of date

The documentation page at <https://sqlite.org/omitted.html> under ALTER TABLE mentions that RENAME TABLE and ADD COLUMN are supported, but does not mention the new RENAME COLUMN. -- J. King ___ sqlite-users mailing list sqlite

Re: [sqlite] SQLite 3.24.0 regression from enhanced "ALTER TABLE true/false DEFAULT" on TEXT field

5 00 - Fax : + 32 2 724 35 04 >www.mcl-collection.com<http://www.mcl-collection.com/> > >_______ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users The default should

Re: [sqlite] WITHOUT ROWID tables with a ROWID

uot;, or "_rowid_" in place of a column name. If a table contains a user defined column named "rowid", "oid" or "_rowid_", then that name always refers the explicitly declared column and cannot be used to retrieve the integer rowid value. -- J. King ___

[sqlite] Typo in FTS5 documentation

<https://www.sqlite.org/fts5.html#fts5_phrases> states: > the following three queries all specify the same phrase: Four queries are then listed. Presumably it should read: > the following four queries all specify the same phrase:

Re: [sqlite] Retrieve tables accessed by query

/sqlite-users Authorizer callbacks could be (ab)used for this purpose, I would think. <https://sqlite.org/c3ref/set_authorizer.html> I'm not very familiar with SQLite's C interface, though, so I may be dead wrong. -- J. King ___ sqlite-users

Re: [sqlite] Was there an announcement of 3.27?

e, but the source does indicate that 1 is "simple" and 2 "complex". It's not entirely clear, but it seems like " complex" is able to handle multiple diacritics on one base character and "simple" cannot? -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] inconsistent behavior when creating INTEGER NOT NULL column without DEFAULT?

implementation. Columns can only be added with a default value of NULL, therefore NOT NULL columns are forbidden. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] inconsistent behavior when creating INTEGER NOT NULL column without DEFAULT?

NT_TIMESTAMP with a general one. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with clause "where X in (...)"

; http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> >___ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users You can remove yourself by following the URL at the bottom of every message. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] MySQL Dumps into SQLite

;thing) >___ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users For what it's worth it's not possible to ignore anything after the closing bracket: SQLite itself use

Re: [sqlite] Can I assign negative value to the INTEGER PRIMARY KEY column?

_ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users Rowids are signed integers and can be negative. The documentation does advise (somewhere...) against using negative rowids because

Re: [sqlite] Why Error: ambiguous column name: ProjID

> >using SQLite version 3.26.0 2018-12-01 12:34:55. > >___ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users "...WHERE ProjID IN..." Which

Re: [sqlite] Mixing main and temp databases in foreign keys is not supported

c to a given connection while the main one is not. Creating foreign relations to the temp database would corrupt another connection's view of the same database -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sq

[sqlite] Bug in table_info pragma

table_info('t') where name = 'a'; '' /* comment */ I would expect it to print only the string delimiters. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug in table_info pragma

On 2019-05-17 07:08:27, "Warren Young" wrote: On May 17, 2019, at 4:55 AM, J. King wrote: SQLite version 3.28.0 2019-04-16 19:49:53 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent d

Re: [sqlite] Bug in table_info pragma

On 2019-05-17 06:59:58, "Simon Slavin" wrote: On 17 May 2019, at 11:55am, J. King wrote: I would expect it to print only the string delimiters. I might expect it to print only the thing inside the delimiters, i.e. nothing. Then there would be no differentiatin

Re: [sqlite] Bugs in foreign_key_list pragma

On May 24, 2019 2:22:46 p.m. EDT, "J. King" wrote: >First, a documentation bug: > ><https://sqlite.org/pragma.html#pragma_foreign_key_list> does not >indicate that a schema may in fact be prepended to the pragma the same >as its siblings. > >Second, t

[sqlite] Identifying rowid aliases

5. If the table has all three concrete columns, examine the table's SQL as a last resort to confirm it is a rowid table -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Bugs in foreign_key_list pragma

r|a|a|NO ACTION|NO ACTION|NONE Surely it should not be printing anything? -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

clude are necessarily beyond reproach or discussion. Derogatory references to "SQLbloat" really don't further the cause of honest discussion. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What could happen if an app crashes while calling sqlite3_rekey_v2()?

It's part of the encryption extension. The function signature is referenced publicly here: <https://www.sqlite.org/see/doc/release/www/readme.wiki> -- J. King On 2019-05-03 12:04:32, "David Raymond" wrote: Random question from a non-C person: What is sqlite3_rekey_v2()? I

Re: [sqlite] Bug when creating a table via select?

On July 15, 2019 12:01:00 a.m. EDT, "J. King" wrote: >On July 14, 2019 11:56:15 p.m. EDT, Donald Shepherd > wrote: >>Somewhat bizarrely only "BLOB" affinity doesn't make it from the >>original >>table to the new table when using the "selec

Re: [sqlite] Bug when creating a table via select?

|y|y|3|CREATE TABLE y( > a INT, > b TEXT, > c REAL, > d, > e TEXT, > f NUM >) >___ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users Bl

Re: [sqlite] Determining column collating functions

es list the collation sequence of index columns. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] a bug, date() cannot handle dates in range -1000-0000 (1000BC-0BC)

t behaviour for negative dates is undefined: > These functions only work for dates between -01-01 00:00:00 and > -12-31 23:59:59 (julian day numbers 1721059.5 through 5373484.5). For > dates outside that range, the results of these functions are undefined. <ht

Re: [sqlite] I can insert multiple rows with the same primary key when one of the value of the PK is NULL ...

E instruction ? Is this a normal behaviour ? It is indeed normal behaviour. See <https://sqlite.org/rowidtable.html> for an explanation. If you want a true primary key, use a without rowid table: CREATE TABLE "sales" ( "client" TEXT,

Re: [sqlite] Fossil Public Accounts

te-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users <http://chiselapp.com/> -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailin

Re: [sqlite] The LIKE operator and Swift

_ characters in your input before fencing with %, unless your input is itself a LIKE pattern. <https://sqlite.org/lang_expr.html#like> -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.o

Re: [sqlite] Why "UTF-8" and not 'UTF-8' ?

noting, too, that barring changed compile-time settings, the default encoding is UTF-8 to begin with. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Multiple files for a single SQLite database

lable. It's also worth noting that in WAL mode transactions are not atomic across database files (they are atomic in the default rollback-journal mode, however). -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sql

Re: [sqlite] Result set column names

gi-bin/mailman/listinfo/sqlite-users It's stated here, at least: <https://www.sqlite.org/c3ref/column_name.html> -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Roadmap?

ite, despite there being demand for it, for want of good tooling to perform schema alterations. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Possible bug in storing text values in numeric columns

sider the input as the number itself, not as a specific representation of that number. -- J. King ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

  1   2   >