SQLite Forum

Create a trigger without a name, BUG?
There was a similar thread recently, I believe.

The short answer is that there's no *bug*. SQLite, for historical  
reasons often, and sometimes by-design (i.e. no accident), is very  
*lax* in what it allows, and unfortunately often silently ignores  
pieces of SQL that some would hope it'd error-out on.

Things have gotten better recently, e.g. with warnings for using double-quotes  
with string literals (generated *tons* of warnings in our logs recently,  
when we upgraded, because of course when something is wrong yet allowed  
it quickly permeates everywhere...), but some things cannot be fixed  
w/o breaking backward compatibility, like I suspect in this case.