Hello,
I'm going to take your comments one at a time (because I have the first
one all prepared and want to get it out). The response is below.
On Sat, 2006-11-04 at 00:00 +0900, 荒川則泰 wrote:
> Folks,
>
> I have tow problems with SQL::Translator(0.07).
> 1) SQLite schema with 'CREATE TRIGGER';
>
> As test cases goes, no semicolon(';') allowed after
> 'create trigger' statements.
> However is is mandatory according to SQLite syntax.
>
> 'SQL-Translator-0.07/t/data/sqlite/create.sql'
> -----------------------------------------
> 19 );
> 20
> 21 create trigger after insert on pet
> 22 begin
> 23 update name=name;
> 24 end
> 25
> 26 create view person_pet as
> -----------------------------------------
You are right about the required semicolon. I just tested this on my
machine and it doesn't work without the ";". Also, the "update
name=name" didn't work.
I propose changing it to:
create trigger pet_trig after insert on pet
begin
update pet set name=name;
end
;
I can also modified the parser to include a "SEMICOLON" at the end of
the trigger. (We could make that optional if I'm mistaken and a
semicolon isn't required.)
Does anyone have any thoughts?
Ben
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
--
sqlfairy-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
