Issues

• Reject an ambiguous bare column inside a built-in function and in the SELECT list

  Breaking changeTheme: SQL compliance
  AlaSQL/alasql#2928 · Filter by author mathiasrw opened on Oct 29, 2026

• A subquery in HAVING cannot refer to a grouped column of the outer query

  Bug: Code provided to reproduced
  AlaSQL/alasql#2925 · Filter by author mathiasrw opened on Oct 29, 2026

• Remove unused optimizeWhereJoin

  Theme: Code quality
  AlaSQL/alasql#2924 · Filter by author mathiasrw opened on Oct 29, 2026

• Test 815 is flaky because its cleanup is not awaited

  Theme: Testing
  AlaSQL/alasql#2923 · Filter by author mathiasrw opened on Oct 29, 2026

• A cached join index ignores a parameter in the join condition

  Bug: Code provided to reproduced
  AlaSQL/alasql#2922 · Filter by author mathiasrw opened on Oct 29, 2026

• A cached join index survives UPDATE and reassigned data on a table that was never marked dirty

  Bug: Code provided to reproduced
  AlaSQL/alasql#2919 · Filter by author mathiasrw opened on Oct 29, 2026

• A bare column inside a function in a query over several tables reads the first table of FROM

  AlaSQL/alasql#2917 · Filter by author mathiasrw opened on Oct 29, 2026

• Comma join is slow when a table is filtered by IN or OR

  Bug: Code provided to reproducedTheme: Performance
  AlaSQL/alasql#2916 · Filter by author mathiasrw opened on Oct 29, 2026

• Harden internal object copying

  AlaSQL/alasql#2909 · Filter by author mathiasrw opened on Oct 27, 2026
  

• Types: alasql() and Database.exec() callbacks are typed (err, data) but called with (data, err)

  Theme: Code quality
  AlaSQL/alasql#2908 · Filter by author mathiasrw opened on Oct 27, 2026
  1

• Remove FROM TABLETOP

  Breaking change
  AlaSQL/alasql#2897 · Filter by author mathiasrw opened on Oct 24, 2026 · v5.0.0

• Drop react-native-fs from optionalDependencies and stop using react-native-fetch-blob

  Breaking change
  AlaSQL/alasql#2896 · Filter by author mathiasrw opened on Oct 24, 2026 · v5.0.0

• Require Node 18 or later and drop cross-fetch

  Breaking change
  AlaSQL/alasql#2894 · Filter by author mathiasrw opened on Oct 24, 2026 · v5.0.0

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

  Theme: PerformanceTheme: Testing
  AlaSQL/alasql#2888 · Filter by author mathiasrw opened on Oct 23, 2026
  1

• astCache and the LIKE pattern cache grow without a limit

  Theme: Performance
  AlaSQL/alasql#2886 · Filter by author mathiasrw opened on Oct 23, 2026

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

  Theme: Performance
  AlaSQL/alasql#2885 · Filter by author mathiasrw opened on Oct 23, 2026

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

  Bug: Code provided to reproduced
  AlaSQL/alasql#2883 · Filter by author mathiasrw 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

  Bug: Code provided to reproducedWas previously working
  AlaSQL/alasql#2881 · Filter by author mathiasrw opened on Oct 23, 2026

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

  Bug: Code provided to reproducedTheme: Performance
  AlaSQL/alasql#2880 · Filter by author mathiasrw opened on Oct 23, 2026

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

  Bug: Code provided to reproduced
  AlaSQL/alasql#2879 · Filter by author mathiasrw opened on Oct 23, 2026

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

  Bug: Code provided to reproduced
  AlaSQL/alasql#2878 · Filter by author mathiasrw opened on Oct 23, 2026

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

  Bug: Code provided to reproducedTheme: PerformanceWas previously working
  AlaSQL/alasql#2875 · Filter by author mathiasrw opened on Oct 23, 2026

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

  Bug: Code provided to reproduced
  AlaSQL/alasql#2874 · Filter by author mathiasrw opened on Oct 23, 2026 · v4.x Focus

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

  Dialect: MySQLTheme: SQL compliance
  AlaSQL/alasql#2872 · Filter by author mathiasrw opened on Oct 22, 2026 · v5.0.0

• LATERAL derived tables are a parse error

  Dialect: MySQLTheme: SQL compliance
  AlaSQL/alasql#2871 · Filter by author mathiasrw opened on Oct 22, 2026 · v5.0.0