X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Fdata%2Fsqlite%2Fcreate.sql;h=f5ee2f5eeead74d1ae89c7df0752eb7061695489;hb=2661d702977d22849f5fcc4f756c649d7170874b;hp=f46b7194d2f9d3009a1a37d2a7f3541683cdf8ba;hpb=b08b5416f45bfbe381637ee3091202524c78ecab;p=dbsrgits%2FSQL-Translator.git diff --git a/t/data/sqlite/create.sql b/t/data/sqlite/create.sql index f46b719..f5ee2f5 100644 --- a/t/data/sqlite/create.sql +++ b/t/data/sqlite/create.sql @@ -20,8 +20,9 @@ create table pet ( create trigger pet_trig after insert on pet begin - update name=name; + update pet set name=name; end +; create view person_pet as select pr.person_id, pr.name as person_name, pt.name as pet_name