Re: [sqlite] Is it possible to create the Stored Procedure (SP) in Sqlite?

2017-04-15 Thread Simon Slavin
On 15 Apr 2017, at 9:14pm, petern wrote: > Yes, please include it in the FAQ It’s not a FAQ. Not on this list, at least. I would argue against it. I do agree that DRH’s explanation of why it’s not as important in SQLite as in client/server engines is well

Re: [sqlite] Is it possible to create the Stored Procedure (SP) in Sqlite?

2017-04-15 Thread petern
Yes, please include it in the FAQ along with a description of the SQLite stored procedure pattern syntax which is never disclosed in these replies: CREATE TRIGGER my_sproc INSTEAD OF INSERT on my_sproc_caller_view BEGIN --My procedural code to be prepared and stored in the database. END;

Re: [sqlite] Threadsafe and _config() question

2017-04-15 Thread Simon Slavin
On 15 Apr 2017, at 8:10pm, Richard Hipp wrote: > On 4/15/17, Simon Slavin wrote: >> Suppose I compile a copy of SQLite3 with SQLITE_THREADSAFE = 0. >> >> Then suppose I execute >> >> sqlite3_config(SQLITE_CONFIG_SERIALIZED) >> >> Would I get an

Re: [sqlite] Threadsafe and _config() question

2017-04-15 Thread Richard Hipp
On 4/15/17, Simon Slavin wrote: > Suppose I compile a copy of SQLite3 with SQLITE_THREADSAFE = 0. > > Then suppose I execute > > sqlite3_config(SQLITE_CONFIG_SERIALIZED) > > Would I get an error back ? Yes. Did you try it? -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Is it possible to create the Stored Procedure (SP) in Sqlite?

2017-04-15 Thread Christian Werner
On 04/15/2017 06:18 PM, Richard Hipp wrote: On 4/15/17, Manoj Sengottuvel wrote: Hi Richard, Is it possible to create the Stored Procedure (SP) in Sqlite? if not , is there any alternate way for SP? Short answer: No. Longer answer: With SQLite, your application is

Re: [sqlite] Malformed databases and multithreading

2017-04-15 Thread Simon Slavin
On 14 Apr 2017, at 11:37pm, Simon Slavin wrote: > Have each program using SQLite execute > > sqlite3_config(SQLITE_CONFIG_MULTITHREAD) That should have been Have each program using SQLite execute sqlite3_config(SQLITE_CONFIG_MULTITHREAD) Apologies.

[sqlite] Threadsafe and _config() question

2017-04-15 Thread Simon Slavin
Suppose I compile a copy of SQLite3 with SQLITE_THREADSAFE = 0. Then suppose I execute sqlite3_config(SQLITE_CONFIG_SERIALIZED) Would I get an error back ? If not, can this be considered a bug and fixed ? If not, can the problem be documented ? Simon.

Re: [sqlite] Malformed databases and multithreading

2017-04-15 Thread Jens Alfke
> On Apr 14, 2017, at 2:53 PM, Paul Egli wrote: > > On the "how to corrupt" page ( http://sqlite.org/howtocorrupt.html > ) i > do not see any mention of using SQLite in an incorrect way with > respect to thread safety. Huh, you’re

Re: [sqlite] Is it possible to create the Stored Procedure (SP) in Sqlite?

2017-04-15 Thread Richard Hipp
On 4/15/17, Manoj Sengottuvel wrote: > Hi Richard, > > Is it possible to create the Stored Procedure (SP) in Sqlite? > > if not , is there any alternate way for SP? Short answer: No. Longer answer: With SQLite, your application is the stored procedure. In a traditional

[sqlite] Is it possible to create the Stored Procedure (SP) in Sqlite?

2017-04-15 Thread Manoj Sengottuvel
Hi Richard, Is it possible to create the Stored Procedure (SP) in Sqlite? if not , is there any alternate way for SP? regards Manoj ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Is this a foreign key bug ?

2017-04-15 Thread Domingo Alvarez Duarte
Hello Dan ! Thank you for the reply ! It was my fault of knowledge here, thanks ! On 15/04/17 10:11, Dan Kennedy wrote: On 04/15/2017 07:16 PM, Domingo Alvarez Duarte wrote: Hello ! I'm getting an error that seems to be a bug in sqlite3 or a change of behavior. === CREATE TABLE a(

Re: [sqlite] Is this a foreign key bug ?

2017-04-15 Thread Dan Kennedy
On 04/15/2017 07:16 PM, Domingo Alvarez Duarte wrote: Hello ! I'm getting an error that seems to be a bug in sqlite3 or a change of behavior. === CREATE TABLE a( keyval varchar(25) NOT NULL, testid integer NOT NULL, PRIMARY KEY ("keyval","testid") ); CREATE TABLE b(

[sqlite] Is this a foreign key bug ?

2017-04-15 Thread Domingo Alvarez Duarte
Hello ! I'm getting an error that seems to be a bug in sqlite3 or a change of behavior. === CREATE TABLE a( keyval varchar(25) NOT NULL, testid integer NOT NULL, PRIMARY KEY ("keyval","testid") ); CREATE TABLE b( sampleid integer NOT NULL, prodspeckey varchar(25) NOT

[sqlite] strange behaviour on sqlite shell output…

2017-04-15 Thread aotto
Hi…i have written a VTAB extension and using SHELL to view the results… + valgrind --leak-check=full --quiet gen/cltdb -column -echo -header gen/.my1 'select Reporter, Partner, Year, PartnerCode from [EXEC-BtH0] where Reporter = '\''AGO'\'' and select Reporter, Partner, Year, PartnerCode from