OK, downloaded and built from this and the problem went away, including the 
more 
complex case the submitted case was cut down from.  We'll run our autotests 
again and see if anything else pops up.  Thanks for all the hard work!

Peter

----- Original Message ----
> From: Richard Hipp <d...@sqlite.org>
> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
> Sent: Sat, March 9, 2013 7:58:27 AM
> Subject: Re: [sqlite] Changed behavior in SQLite 3.7.16 beta
> 
> Please try again with the latest 3.7.16 beta.  You can download an
> amalgamation snapshot from http://www.sqlite.org/test/download.html
> 
> The testing checklist (http://www.sqlite.org/checklists/3071600) has been
> restarted once again on account of this issue.
> 
> On Thu, Mar 7, 2013 at 7:07 PM, Peter Aronson <pbaron...@att.net> wrote:
> 
> > I've encountered the following changed behavior (which I believe is a
> > bug).  The
> > following script works at 3.7.15.2 but fails at 3.6.16 beta:
> >
> > create table qa_data_edit (str_col text,int_col integer,rowidcol integer);
> > insert into qa_data_edit values ('this',1000,1);
> > insert into qa_data_edit values ('that',3000,2);
> > create view qa_data_edit_evw as select str_col,int_col,rowidcol from
> > qa_data_edit;
> >
> > create trigger qa_data_edit_view_update instead of update on
> > qa_data_edit_evw
> > BEGIN
> >  update or replace qa_data_edit
> >  set str_col = new.str_col,
> >      int_col = new.int_col
> >  where rowidcol = old.rowidcol;
> > END;
> > select * from qa_data_edit;
> > update main.qa_data_edit_evw
> > set str_col = 'fred',
> >    int_col = 5000
> > where main.qa_data_edit_evw.rowidcol = 1;
> > select * from qa_data_edit;
> >
> > Output:
> >
> > SQLite version 3.7.16 2013-03-06 01:55:27
> > Enter ".help" for instructions
> > Enter SQL statements terminated with a ";"
> > sqlite> .read test.sql
> > this|1000|1
> > that|3000|2
> > Error: near line 17: no such column: main.qa_data_edit_evw.rowidcol
> > this|1000|1
> > that|3000|2
> >
> > SQLite version 3.7.15.2 2013-01-09 11:53:05
> > Enter ".help" for instructions
> > Enter SQL statements terminated with a ";"
> > sqlite> .read test.sql
> > this|1000|1
> > that|3000|2
> > fred|5000|1
> > that|3000|2
> >
> > Using an unqualified ROWIDCOL in the update causes the error to go away.
> > However, database.table.column is a legal expression element according the
> > the
> > syntax diagrams.
> >
> > Tested on Windows XP and Solaris 9.
> >
> > Peter
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> 
> 
> 
> -- 
> D. Richard Hipp
> d...@sqlite.org
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to