support for the TRUNCATE statement
Issue #1474
resolved
it'd be nice to support TRUNCATE on those dbms that support it, for example when table.delete() is called without any filters. it's standard sql, and more efficient than a normal .delete(), so why not? :)
Comments (4)
-
repo owner -
repo owner oh if you mean, issue TRUNCATE when one says
delete()
, definitely never. wow talk about surprise behavior. -
repo owner as you can see here http://en.wikipedia.org/wiki/Truncate_(SQL) , its behavior is anything but consistent. implicitly commits on oracle, for example.
-
repo owner - changed status to wontfix
- Log in to comment
usually because its easy enough to just say execute("truncate table"). its more "efficient" because it bypasses all integrity checks and triggers so its not a lever you should be pulling often - its more of an administration command.