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. FWIW.