Ok. I am a fossil newbie. My effort to build from that did not work. The
amalgamation from configure+make seemed incomplete and other files like
json1.c were missing.
I am on trunk and fossil timeline showed Dr Hipp's fix. I'll educate
myself a bit more on Fossil to see where I went wrong.
Howeve
ge-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp
>Sent: Friday, 2 November, 2018 11:39
>To: SQLite mailing list
>Subject: Re: [sqlite] json_each() in a table trigger for an
>'attached' db causes an error
>
8:12
>To: General Discussion of SQLite Database
>Subject: Re: [sqlite] json_each() in a table trigger for an
>'attached' db causes an error
>
>Hi,
>
>Sorry. I have had no luck with this.
>
>I followed the instructions here
>https://www.sqlite.org/getthecode.ht
Hi,
Sorry. I have had no luck with this.
I followed the instructions here
https://www.sqlite.org/getthecode.html#clone
then built from source following the directions in README.md.
mkdir bld;# Build will occur in a sibling directory
cd bld ;# Change to the
P.S.
Here are the first few lines of 'fossil timeline' on my local that I am
building.
=== 2018-11-02 ===
17:38:39 [1fa74930ab] Enhance triggers so that they can use
table-valued-functions that exist in schemas outside of the schema in which
the trigger is defined. (user: drh)
=== 2018-10-31 ===
Please try your test script on the latest trunk check-in and let us
know whether or not it is working for you.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/m
Thanks!
As a further note, I also tried building the shell with JSON1 enabled and
building and loading the json1 extension separately, with the same results.
SQLite version 3.25.2 2018-09-25 19:08:10
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME"
On 11/2/18, Lindsay Lawrence wrote:
> Has anyone else run into this issue?
I can confirm that it is an issue and that we are working on it.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mai
Has anyone else run into this issue?
I have the following tables and trigger
- Data table
CREATE TABLE people (
id INTEGER PRIMARY KEY,
created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
name TEXT,
age INTEGER
);
-- Change log table
CREATE TABLE change_log (
id INTEGER PRIMARY
9 matches
Mail list logo
