>
>
> You have something mucking about and "helping you" to be cutie-pie. If
> you turn that crap off, your problems will go away...
>
If it's on a mac, this terrible misfeature can be turned off in system
preferences - keyboard - text - smart quotes.
I lost a couple hours this way too, I
On 11/26/18, Ashish Goyal wrote:
> Bug Report
> ==
> SQlite version - 3.19.3
> Platform Linux 64 Bit.
>
> We are seeing crashes in our application which uses SQLite to store JOB
> information where JOB is Application specific activities. The crash always
> has following stack trace:
>
>
Bug Report
==
SQlite version - 3.19.3
Platform Linux 64 Bit.
We are seeing crashes in our application which uses SQLite to store JOB
information where JOB is Application specific activities. The crash always
has following stack trace:
#0 0x003c000325e5 in raise () from
On Monday, 26 November, 2018 12:19, Petite Abeille
wrote:
...
> Talking of which, the CLI doesn’t seem to handle the following
> statement very gracefully:
>
> sqlite> select DATE '1998-12-25’;
> ...>
> ...>
> …>
>Note how the CLI doesn’t recognize the semicolon marking the end-of-
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 by
> updating all the columns that currently store Cocoa timestamps. Something
> like:
>
>
On Nov 20, 2018, at 12:41 PM, Jens Alfke wrote:
> On Nov 20, 2018, at 11:44 AM, Bill Hashman
> wrote:
>
>> The timestamp from iOS systems is not compliant with ISO 8601/Unix or other
>> common timestamps. It appears apple has their start date offset 31 years.
>
> Yes, the ‘epoch’ in
> On Nov 26, 2018, at 21:16, Shawn Wagner wrote:
>
> It's waiting on a plain single quote to end the string. You have a Unicode
> smart quote character U+2019 (’) instead of a ' at the end before the
> semicolon, which doesn't count.
D’oh. Facepalm. Right you are. Long live Unicode! :)
It's waiting on a plain single quote to end the string. You have a Unicode
smart quote character U+2019 (’) instead of a ' at the end before the
semicolon, which doesn't count.
On Mon, Nov 26, 2018, 11:19 AM Petite Abeille
>
> > On Nov 26, 2018, at 20:11, Richard Hipp wrote:
> >
> > though
> On Nov 26, 2018, at 20:25, Richard Hipp wrote:
>
> Unable to repro:
Hmmm… ok… then… local problem of some type…
$ uname -a
Darwin 18.2.0 Darwin Kernel Version 18.2.0: Fri Oct 5 19:41:49 PDT 2018;
root:xnu-4903.221.2~2/RELEASE_X86_64 x86_64
$ brew info sqlite3
sqlite: stable 3.25.3
On 11/26/18, Petite Abeille wrote:
> the CLI doesn’t seem to handle the following statement
> very gracefully:
>
> sqlite> select DATE '1998-12-25’;
> ...>
> ...>
> …>
Unable to repro:
SQLite version 3.25.3 2018-11-05 20:37:38
Enter ".help" for usage hints.
Connected to a transient
> On Nov 26, 2018, at 20:11, Richard Hipp wrote:
>
> though there probably is not time to get warnings in to the forthcoming
> 3.26.0 release.
Talking of which, the CLI doesn’t seem to handle the following statement very
gracefully:
sqlite> select DATE '1998-12-25’;
...>
...>
…>
On 11/25/18, Balaji Ramanathan wrote:
> I expected the Alter Table command to find and replace all occurrences of
> that column name in my schema with the new name.
Here is simplified SQL that illustrates the problem:
CREATE TABLE t1(x);
CREATE VIEW v1 AS SELECT x FROM t1;
CREATE VIEW v2 AS
On Mon, Nov 26, 2018 at 1:19 PM Richard Hipp wrote:
> On 11/23/18, Digital Dog wrote:
> > I think these changes would not add a lot of code to sqlite and will make
> > life easier for users.
>
> SQLite remembers the database schema by storing the original CREATE
> TABLE text in the
Okay Richard. I will create a script to reproduce the error and will share it.
Regards,
Tanuj Sharma
From: drhsql...@gmail.com on behalf of Richard Hipp
Sent: Monday, November 26, 2018 8:48:21 PM
To: SQLite mailing list
Cc: Sharma, Tanuj [AUTOSOL/FMP/IN]
On 11/26/18, Sharma, Tanuj [AUTOSOL/FMP/IN] wrote:
> I want to know why auto_checkpoint is not working when there is no Primary
> Key in the table.
As far as I know, you are the only person who has ever seen this
problem. Nobody else is able to reproduce it, and nobody has any
ideas what might
Dear SQL Developers / Users,
I haven't found the solution for WAL file increase issue. Below is the summary
of my issue. The email thread is added for additional information as asked by
Simon.
I am using Sqlite3 in our project. My database has journal_mode set to WAL and
has one writer &
On 11/23/18, Digital Dog wrote:
> I think these changes would not add a lot of code to sqlite and will make
> life easier for users.
SQLite remembers the database schema by storing the original CREATE
TABLE text in the sqlite_master table. That means the CREATE TABLE is
reparsed whenever a new
Fixed now. Thanks.
On 11/24/18, Project Nayuki wrote:
> In the SQLite online documentation, there seems to be a problem in the
> wording of a sentence, which I highlighted in angle brackets.
>
> https://www.sqlite.org/wal.html
> Write-Ahead Logging
> 5. Read-Only Databases
>
> "Even though it
On Mon, Nov 26, 2018 at 2:52 AM Balaji Ramanathan <
balaji.ramanat...@gmail.com> wrote:
> SQLite> Alter Table Trip rename column StartGMTOffset to StartUTCOffset;
> Error: error in view CumulativeStatisticsByPlaceName after rename: no such
> column: StartGMTOffset
>
> I was able to reproduce this
19 matches
Mail list logo