Issues

Benchmark: temp XLSX files are never deleted, and --fail-above passes when nothing was measured

AlaSQL/alasql#2888 · opened

on Oct 23, 2026

Types: Op.right became ExpressionNode | string, and compile() callbacks are typed (err, data) but called with (data, err)

AlaSQL/alasql#2887 · opened

on Oct 23, 2026

astCache and the LIKE pattern cache grow without a limit

AlaSQL/alasql#2886 · opened

on Oct 23, 2026

A schema change in one database compiles the cached statements of every database again

AlaSQL/alasql#2885 · opened

on Oct 23, 2026

A trigger with SET @x = f() calls f with the row and does not set the variable

AlaSQL/alasql#2884 · opened

on Oct 23, 2026

A foreign key to a primary key with a prefix length compares only the prefix

AlaSQL/alasql#2883 · opened

on Oct 23, 2026

DATEDIFF and DATEADD throw Unknown date part for the T-SQL short forms: dd, mm, yy

AlaSQL/alasql#2882 · opened

on Oct 23, 2026

Recursive CTE with UNION: BigInt throws, and NaN and NULL, or a Date and its ISO string, count as one row

AlaSQL/alasql#2881 · opened

on Oct 23, 2026

Inline INDEX in CREATE TABLE makes INSERT about 6 times slower, and DELETE and UPDATE leave the index stale

AlaSQL/alasql#2880 · opened

on Oct 23, 2026

A JOIN subquery with its own subquery, next to a subquery in the SELECT list, returns wrong values

AlaSQL/alasql#2879 · opened

on Oct 23, 2026

A HAVING alias replaces a source column of the same name when the source is a subquery or FROM ?

AlaSQL/alasql#2878 · opened

on Oct 23, 2026

UPDATE t SET a = DEFAULT writes undefined instead of the column default

AlaSQL/alasql#2877 · opened

on Oct 23, 2026

UNIQUE (ROUND(a)) makes every INSERT throw: alasql is not defined

AlaSQL/alasql#2876 · opened

on Oct 23, 2026

After one error through a callback or promise(), a compiled statement is parsed and compiled again on every run

AlaSQL/alasql#2875 · opened

on Oct 23, 2026

IN and NOT IN ignore list items that are not plain literals: a IN (-1, 5) misses -1

AlaSQL/alasql#2874 · opened

on Oct 23, 2026

In a join, an unqualified column that is NULL in the first source takes the value of the second source

AlaSQL/alasql#2873 · opened

on Oct 23, 2026

Bit-value literals are a parse error: b'101'

AlaSQL/alasql#2872 · opened

on Oct 22, 2026

· v5.x Focus

LATERAL derived tables are a parse error

AlaSQL/alasql#2871 · opened

on Oct 22, 2026

· v5.x Focus

CREATE and DROP PROCEDURE, CREATE and DROP FUNCTION with an SQL body, and CALL are parse errors

AlaSQL/alasql#2870 · opened

on Oct 22, 2026

· v5.x Focus

Multi-table UPDATE and DELETE are parse errors: UPDATE t1, t2 SET ..., DELETE t1 FROM t1 JOIN t2

AlaSQL/alasql#2869 · opened

on Oct 22, 2026

· v5.x Focus

CREATE TABLE new LIKE old is a parse error

AlaSQL/alasql#2868 · opened

on Oct 22, 2026

· v5.x Focus

CREATE TABLE: KEY and INDEX in the column list, INT(11) UNSIGNED, COMMENT, SET, BINARY, COLLATE and CHARSET without = are parse errors

AlaSQL/alasql#2867 · opened

on Oct 22, 2026

· v5.x Focus

Joins in brackets and STRAIGHT_JOIN are parse errors: t1 LEFT JOIN (t2 JOIN t3 ON ...) ON ...

AlaSQL/alasql#2866 · opened

on Oct 22, 2026

· v5.x Focus

SHOW WARNINGS, SHOW ERRORS, SHOW STATUS, SHOW VARIABLES and SHOW CREATE VIEW are parse errors

AlaSQL/alasql#2865 · opened

on Oct 22, 2026

· v5.x Focus

ANALYZE, OPTIMIZE, CHECK and REPAIR TABLE, FLUSH, and LOCK and UNLOCK TABLES are parse errors

AlaSQL/alasql#2864 · opened

on Oct 22, 2026

· v5.x Focus

Navigation Menu

Repository navigation

Issues

Benchmark: temp XLSX files are never deleted, and --fail-above passes when nothing was measured

Types: Op.right became ExpressionNode | string, and compile() callbacks are typed (err, data) but called with (data, err)

astCache and the LIKE pattern cache grow without a limit

A schema change in one database compiles the cached statements of every database again

A trigger with SET @x = f() calls f with the row and does not set the variable

A foreign key to a primary key with a prefix length compares only the prefix

DATEDIFF and DATEADD throw Unknown date part for the T-SQL short forms: dd, mm, yy

Recursive CTE with UNION: BigInt throws, and NaN and NULL, or a Date and its ISO string, count as one row

Inline INDEX in CREATE TABLE makes INSERT about 6 times slower, and DELETE and UPDATE leave the index stale

A JOIN subquery with its own subquery, next to a subquery in the SELECT list, returns wrong values

A HAVING alias replaces a source column of the same name when the source is a subquery or FROM ?

UPDATE t SET a = DEFAULT writes undefined instead of the column default

UNIQUE (ROUND(a)) makes every INSERT throw: alasql is not defined

After one error through a callback or promise(), a compiled statement is parsed and compiled again on every run

IN and NOT IN ignore list items that are not plain literals: a IN (-1, 5) misses -1

In a join, an unqualified column that is NULL in the first source takes the value of the second source

Bit-value literals are a parse error: b'101'

LATERAL derived tables are a parse error

CREATE and DROP PROCEDURE, CREATE and DROP FUNCTION with an SQL body, and CALL are parse errors

Multi-table UPDATE and DELETE are parse errors: UPDATE t1, t2 SET ..., DELETE t1 FROM t1 JOIN t2

CREATE TABLE new LIKE old is a parse error

CREATE TABLE: KEY and INDEX in the column list, INT(11) UNSIGNED, COMMENT, SET, BINARY, COLLATE and CHARSET without = are parse errors

Joins in brackets and STRAIGHT_JOIN are parse errors: t1 LEFT JOIN (t2 JOIN t3 ON ...) ON ...

SHOW WARNINGS, SHOW ERRORS, SHOW STATUS, SHOW VARIABLES and SHOW CREATE VIEW are parse errors

ANALYZE, OPTIMIZE, CHECK and REPAIR TABLE, FLUSH, and LOCK and UNLOCK TABLES are parse errors