SQLite

In the following test case, the integer overflow error is unexpected:

CREATE TABLE t0 (c0);
INSERT INTO t0(c0) VALUES (-9223372036854775808);
SELECT FALSE AND ABS(t0.c0) FROM t0; -- unexpected: integer overflow

I would expect that short-circuit evaluation is applied, which is the case when using the expression in the WHERE clause:

SELECT * FROM t0 WHERE FALSE AND ABS(t0.c0); -- expected: no error

Neither SQL nor SQLite require nor disallow short-circuit evaluation. The query planner is free to choose short-circuit evaluation or not, as it sees fit.