Re: false and nil

[Sam Putman <atmanistan@...>]

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.