On Tue, Jun 5, 2018 at 10:08 AM, Sam Putman
<atmanistan@gmail.com> wrote:
Also, SQL values get translated to language values, and casting SQL null to Java null
is a mistake, C NULL would of course be a disaster.
Perhaps the most important: SQL cannot specify an evaluation order, to give
the query planner flexibility in execution.
This makes a short circuiting left-to-right logic impossible.
Because SQL is declarative, this doesn't have to be eager. Lua would have no alternative,
and likes to choose the sensible thing, such as left-to-right evaluation of parameters, and
getting out of logical chains just as soon as it's able.