v4.x Focus

Issues

• Let UPDATE, INSERT and DELETE work on data passed in parameter.

  ! Feature requestHelp wanted
  AlaSQL/alasql#348 · Filter by author pasapsi opened on Jul 2, 2015 · v4.x Focus
  37

• A column named value reads as the VALUE keyword in expressions: WHERE value = 3 finds no rows

  AlaSQL/alasql#2670 · Filter by author mathiasrw opened on Oct 20, 2026 · v4.x Focus
  1

• Review #2339 for code improvements: an unknown column takes its value from a different table per row

  Theme: Code quality
  AlaSQL/alasql#2680 · Filter by author mathiasrw opened on Oct 20, 2026 · v4.x Focus

• Window aggregates read the output row: SUM(v) OVER (PARTITION BY g) gives 0 when v is not selected

  AlaSQL/alasql#2689 · Filter by author mathiasrw opened on Oct 20, 2026 · v4.x Focus

• A subquery before IN (SELECT ...) is evaluated as the wrong subquery

  Dialect: SQLite
  AlaSQL/alasql#2707 · Filter by author mathiasrw opened on Oct 20, 2026 · v4.x Focus
  1

• (SELECT ... LIMIT 1) UNION ALL SELECT ... applies the LIMIT to the whole result

  AlaSQL/alasql#2711 · Filter by author mathiasrw opened on Oct 20, 2026 · v4.x Focus
  1

• After assigning table.data directly, INSERT stores duplicate keys and DELETE throws

  AlaSQL/alasql#2715 · Filter by author mathiasrw opened on Oct 20, 2026 · v4.x Focus

• SELECT (a+1) ... GROUP BY a+1 drops the column

  Dialect: Postgres
  AlaSQL/alasql#2721 · Filter by author mathiasrw opened on Oct 20, 2026 · v4.x Focus
  1

• INSERT INTO t SELECT gives empty rows when no selected column name is a column of the table

  Dialect: SQLiteTheme: SQL compliance
  AlaSQL/alasql#2760 · Filter by author mathiasrw opened on Oct 21, 2026 · v4.x Focus

• AVG over text joins the strings: AVG of '12' and '3' gives 61.5

  Dialect: SQLiteTheme: SQL compliance
  AlaSQL/alasql#2763 · Filter by author mathiasrw opened on Oct 21, 2026 · v4.x Focus

• COUNT(DISTINCT *) is accepted and returns 1 for any number of rows

  Dialect: SQLiteTheme: SQL compliance
  AlaSQL/alasql#2758 · Filter by author mathiasrw opened on Oct 21, 2026 · v4.x Focus

• A constant IN list returns the answer of an earlier list with the same text: 1 IN (1) is false after '1' IN ('1')

  Dialect: SQLiteTheme: SQL compliance
  AlaSQL/alasql#2753 · Filter by author mathiasrw opened on Oct 21, 2026 · v4.x Focus

• INDEXED BY and NOT INDEXED after a table name are parse errors

  Dialect: SQLiteTheme: SQL compliance
  AlaSQL/alasql#2762 · Filter by author mathiasrw opened on Oct 21, 2026 · v4.x Focus

• An aggregate inside CAST throws g is not defined: SELECT CAST(COUNT(*) AS INTEGER)

  Dialect: SQLiteTheme: SQL compliance
  AlaSQL/alasql#2764 · Filter by author mathiasrw opened on Oct 21, 2026 · v4.x Focus
  1

• MATRIX repeats or drops a value when two result columns have the same name: SELECT 0 AS c, 27 AS c gives [27, 27]

  Dialect: SQLiteTheme: SQL compliance
  AlaSQL/alasql#2765 · Filter by author mathiasrw opened on Oct 21, 2026 · v4.x Focus
  1

• CREATE INDEX IF NOT EXISTS, DROP INDEX IF EXISTS, CREATE TRIGGER IF NOT EXISTS and DROP TRIGGER IF EXISTS are parse errors

  Dialect: SQLiteTheme: SQL compliance
  AlaSQL/alasql#2775 · Filter by author mathiasrw opened on Oct 21, 2026 · v4.x Focus

• MATRIX puts a column named by a number first when the query has an aggregate: SELECT COUNT(*), 17 gives [17, 1]

  Dialect: SQLiteTheme: SQL compliance
  AlaSQL/alasql#2766 · Filter by author mathiasrw opened on Oct 21, 2026 · v4.x Focus

• NOT binds tighter than IN and BETWEEN: WHERE NOT x IN (32) finds no rows

  Dialect: SQLiteTheme: SQL compliance
  AlaSQL/alasql#2768 · Filter by author mathiasrw opened on Oct 21, 2026 · v4.x Focus
  1

• HAVING with an alias for an expression finds no rows: SELECT g * 10 AS z ... HAVING z > 15

  Dialect: SQLiteTheme: SQL compliance
  AlaSQL/alasql#2769 · Filter by author mathiasrw opened on Oct 21, 2026 · v4.x Focus
  1

• GROUP BY with a column selected twice adds keys c0:1, c0:2 to the result rows

  Dialect: SQLiteTheme: SQL compliance
  AlaSQL/alasql#2770 · Filter by author mathiasrw opened on Oct 21, 2026 · v4.x Focus

• An expression inside an IN list never matches: WHERE c IN (7 * 2) or IN (1, b) (a regression)

  Dialect: SQLiteTheme: SQL compliance
  AlaSQL/alasql#2771 · Filter by author mathiasrw opened on Oct 21, 2026 · v4.x Focus
  1

• With options.modifier MATRIX, views and FROM subqueries give NULLs or throw: Data source number 0 in undefined

  Dialect: SQLiteTheme: SQL compliance
  AlaSQL/alasql#2772 · Filter by author mathiasrw opened on Oct 21, 2026 · v4.x Focus

• Expressions: identity by text and column lookup while generating code

  Theme: Code quality
  AlaSQL/alasql#2723 · Filter by author mathiasrw opened on Oct 20, 2026 · v4.x Focus

• Query runs: state of one run kept on the cached statement, and separate sync and async paths

  Theme: Code quality
  AlaSQL/alasql#2724 · Filter by author mathiasrw opened on Oct 20, 2026 · v4.x Focus

• Subqueries: give each SELECT its own subqueries, one compiled form and a run context

  Theme: Code quality
  AlaSQL/alasql#2717 · Filter by author mathiasrw opened on Oct 20, 2026 · v4.x Focus