(Looks like Mantis doesn't allow commenting closed tickets, so I'll post to the list)
(DELETE .. WHERE TRUE ) is OK in general, it's only problem is that it is completely non-obvious. I think dropping a note in a compiler's error message will be a good help here. ---------- Forwarded message ---------- From: Mantis Bug Tracker <[email protected]> Date: 2014-08-24 18:52 GMT+04:00 Subject: [Ur/Web 0000181]: No support for dml DELETE FROM without WHERE clause To: [email protected] The following issue has been CLOSED ====================================================================== http://www.impredicative.com/mantis/view.php?id=181 ====================================================================== Reported By: grwlf Assigned To: ====================================================================== Project: Ur/Web Issue ID: 181 Category: Reproducibility: always Severity: tweak Priority: low Status: closed Resolution: open Fixed in Version: ====================================================================== Date Submitted: 2014-08-23 13:47 EDT Last Modified: 2014-08-24 10:52 EDT ====================================================================== Summary: No support for dml DELETE FROM without WHERE clause Description: For example, the following code would result in an error table channels : {Channel: channel int} task initialize = fn _ => dml( DELETE FROM channels ) Please, consider adding support for such syntax. ====================================================================== ---------------------------------------------------------------------- (0000334) adamc (administrator) - 2014-08-24 10:52 http://www.impredicative.com/mantis/view.php?id=181#c334 ---------------------------------------------------------------------- While Ur/Web's SQL interface in general was designed to expose the underlying language faithfully, I decided to make an improvement in this case. :) In particular, it scares me that the default of 'DELETE' is to nuke all your data. I prefer to be forced to write 'WHERE TRUE' if I really want to delete everything. It's possible I could be convinced to add the scary default back in, but for now I'll mark this issue as closed. Issue History Date Modified Username Field Change ====================================================================== 2014-08-23 13:47 grwlf New Issue 2014-08-24 10:52 adamc Note Added: 0000334 2014-08-24 10:52 adamc Status new => closed ====================================================================== _______________________________________________ Ur mailing list [email protected] http://www.impredicative.com/cgi-bin/mailman/listinfo/ur
