lua-users home
lua-l archive

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]




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.