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