Hi User-List,

I am experiencing very strange behavior:

CREATE TRIGGER marketdata.calc_sdate BEFORE INSERT ON marketdata.quotes FOR EACH ROW

BEGIN ATOMIC

-- select * from marketdata.quotes limit 1;

END;

ERROR: syntax error, unexpected '.', expecting WHILE in: "create trigger marketdata.calc_sdate before insert on

marketdata."

When I am creating trigger on table without schema it works fine. CREATE TRIGGER marketdata.calc_sdate BEFORE INSERT ON t1 ...

Assuming t1 created without schema.

All combination of " around schema and table, schema only, table only didn't help.

Am I doing something wrong or this is the bug?

Thanks,

John