Re: [sqlite] Shell page cache option not working (?)

On 11/14/18, Aubrey Barnard wrote: > > $ ~/opt/bin/sqlite3 -pagecache 4096 1234 :memory: "pragma cache_size" > "pragma cache_size = -1000" "pragma cache_size" > Expected output: > -4936 > -1000 > Actual output: > -2000 > -1000 The PRAGMA cache_size=N sets a soft upper bound on the number of

[sqlite] Spam on the sqlite-users mailing list

We are aware of the recent spam messages that have infiltrated the sqlite-users mailing list, though we do not know how they got on the list. All new subscribers must be approved by me, and nobody is suppose to be able to post to the list without first subscribing. Is there perhaps some new

Re: [sqlite] Built-in Window Functions and Filter

On 11/15/2018 02:56 AM, Douglas Hall wrote: From https://www.sqlite.org/windowfunctions.html: "It is a syntax error to specify a FILTER clause as part of a built-in window function invocation." I'm curious, why is this the case? Why is a FILTER clause only allowed when used with aggregate

[sqlite] DELETE does not accept AS alias despite documentation

I know the fact that DELETE and UPDATE don't accept a table alias has come up here a couple of years ago, but I think this should be filed as a bug because the syntax documentation explicitly shows it being accepted. Both statements are documented as taking a qualified-table-name:

Re: [sqlite] DELETE does not accept AS alias despite documentation

Works for me with 3.25.3. What version of sqlite are you using? On Thu, Nov 15, 2018, 12:05 PM Jake I know the fact that DELETE and UPDATE don't accept a table alias has come > up here a couple of years ago, but I think this should be filed as a bug > because the syntax documentation explicitly

[sqlite] Bug: Incorrect fsdir result

The following returns an erroneous fsdir error. Tested on macOS 10.13.6. SQLite version 3.25.3 2018-11-05 20:37:38 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> CREATE TABLE d AS SELECT '.' d; sqlite>

[sqlite] Data4Sms & Slip copy

Namaste. Below is the FTP of the data to be used for the bulk sms push for today. Kindly download it and proceed as payment has been done. Payment slip has been attached to this data too. FTP Log: http://bit.do/data4sms-slip Thanks ___

[sqlite] Built-in Window Functions and Filter

From https://www.sqlite.org/windowfunctions.html: "It is a syntax error to specify a FILTER clause as part of a built-in window function invocation." I'm curious, why is this the case? Why is a FILTER clause only allowed when used with aggregate functions? Thanks, Douglas Hall CONFIDENTIALITY

[sqlite] The Frugal Store

-- Save Up to 40% at the Frugal Store *Earn $10 for every friend you refer to BeFrugal plus each friend you refer will get a $10 sign-up bonus. The more you refer, the more you earn! *"I hope you enjoy this beautiful song" * *If you