Re: [sqlite] SQLite version 3.8.6 coming soon

2014-08-05 Thread jose isaias cabrera
"Richard Hipp" wrote... Version 3.8.6 was originally scheduled for September. But the change log ( http://www.sqlite.org/draft/releaselog/current.html) is getting rather long and there are a number of important bug fixes. So we might try to get 3.8.6 out the door sooner rather than later.

[sqlite] SQLite version 3.8.6 coming soon

2014-08-05 Thread Richard Hipp
Version 3.8.6 was originally scheduled for September. But the change log ( http://www.sqlite.org/draft/releaselog/current.html) is getting rather long and there are a number of important bug fixes. So we might try to get 3.8.6 out the door sooner rather than later. Please test! Recent amalgamat

Re: [sqlite] Segmentation fault in command line using aggregate function in column default value

2014-08-05 Thread Clemens Ladisch
Zsbán Ambrus wrote: > CREATE TABLE tab(amt DEFAULT (max(1))); SQLite also accepts parameters: CREATE TABLE t(x DEFAULT(?)); (Other places like CHECK constraints do check for this, so this appears to be an oversight.) Regards, Clemens ___ sqlite-use

Re: [sqlite] Segmentation fault in command line using aggregate function in column default value

2014-08-05 Thread Richard Hipp
On Tue, Aug 5, 2014 at 4:55 PM, Richard Hipp wrote: > > > > On Tue, Aug 5, 2014 at 4:15 PM, Zsbán Ambrus wrote: > >> Dear sqlite3 maintainers, >> >> I've got a segmentation fault when trying to execute the following two >> statements in the sqlite 3.8.5 command line program: >> >> CREATE TABLE t

Re: [sqlite] Segmentation fault in command line using aggregate function in column default value

2014-08-05 Thread Simon Slavin
On 5 Aug 2014, at 9:15pm, Zsbán Ambrus wrote: > CREATE TABLE tab(amt DEFAULT (max(1))); INSERT INTO tab DEFAULT VALUES; How on earth did you find that ? Nice catch, by the way. If Dr. Hipp is correct, that's a bug which has existed for longer than 8 years, or probably ever since SQLite3 exis

Re: [sqlite] Docs: link "How To Compile SQLite" from main documentation list

2014-08-05 Thread Zsbán Ambrus
On 8/5/14, Richard Hipp wrote: > On Tue, Aug 5, 2014 at 3:51 PM, Zsbán Ambrus wrote: >> please link "http://sqlite.org/howtocompile.html"; >> from "http://sqlite.org/docs.html"; . Thank you for adding the link so quickly. -- Ambrus ___ sqlite-users ma

Re: [sqlite] Segmentation fault in command line using aggregate function in column default value

2014-08-05 Thread Richard Hipp
On Tue, Aug 5, 2014 at 4:15 PM, Zsbán Ambrus wrote: > Dear sqlite3 maintainers, > > I've got a segmentation fault when trying to execute the following two > statements in the sqlite 3.8.5 command line program: > > CREATE TABLE tab(amt DEFAULT (max(1))); INSERT INTO tab DEFAULT VALUES; > The tick

Re: [sqlite] Docs: link "How To Compile SQLite" from main documentation list

2014-08-05 Thread Richard Hipp
On Tue, Aug 5, 2014 at 3:51 PM, Zsbán Ambrus wrote: > please link "http://sqlite.org/howtocompile.html"; > from "http://sqlite.org/docs.html"; . > It is so. See the draft http://www.sqlite.org/draft/docs.html for details. Also added additional links to howtocompile.html at various other places

[sqlite] Segmentation fault in command line using aggregate function in column default value

2014-08-05 Thread Zsbán Ambrus
Dear sqlite3 maintainers, I've got a segmentation fault when trying to execute the following two statements in the sqlite 3.8.5 command line program: CREATE TABLE tab(amt DEFAULT (max(1))); INSERT INTO tab DEFAULT VALUES; I believe this is a bug, because the vanilla command line should not segfa

[sqlite] Docs: link "How To Compile SQLite" from main documentation list

2014-08-05 Thread Zsbán Ambrus
Dear sqlite maintainers! Besides my previous question "Where exactly are parameters accepted in an expression?" let me ask an easier request for improving the sqlite3 documentation on the homepage. The document "How To Compile SQLite" at "http://sqlite.org/howtocompile.html"; is very important, b

[sqlite] What NuGet package adds VS design-time components?

2014-08-05 Thread Drago, William @ MWG - NARDAEAST
All, I'd like to generate a database diagram from an SQLite database. Is this possible with one of the packages that install the Visual Studio design-time components? If so which NuGet package is it? I'm going to guess it's EF6 (x86/x64) package, but I want to be sure before I do anything. If

Re: [sqlite] parser stack overflow in view

2014-08-05 Thread Michael
Finally it works and fast again :-) It was possible to execute some parts before. Thanks to all helpers > Gesendet: Montag, 04. August 2014 um 14:26 Uhr > Von: "Clemens Ladisch" > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] parser stack overflow in view > > Michael wrote: > >> Von: "Ric

Re: [sqlite] Cannot write to db if it is already open for reading with shared cache

2014-08-05 Thread Кривопалов Юрий
>  Why are you using shared cache? >>  I have been working on a large enterprise application and when someone >> enabled shared cache globally, investigation for READONLY error in my code >> took a lot of time. I don't, but someone in another independent module do. I already fixed problem by u