SQLite Forum

I've accidentally forgot to specify the name of a trigger:

  CREATE TRIGGER AFTER UPDATE OF Proda_Page BEGIN [...] END;

There did not popup any error message, and when I was testing, the trigger worked.
But then I wanted to change the behavior of the trigger, and realized that the
name was missing.

To figure out the name of the trigger, I issued:

  SELECT name FROM sqlite_master WHERE type='trigger'

The result: 'AFTER'

To me it looks like there is something wrong with the parser.