Issues

WITH t(a) AS (SELECT ...) throws ReferenceError: renameColumns is not defined

AlaSQL/alasql#2841 · opened

on Oct 21, 2026

Common PostgreSQL functions are missing: GENERATE_SERIES, LPAD, DATE_TRUNC, MOD, STRING_AGG and more

AlaSQL/alasql#2831 · opened

on Oct 21, 2026

|| binds tighter than +: 'four: ' || 2 + 2 is 'four: 22', PostgreSQL gives 'four: 4'

AlaSQL/alasql#2830 · opened

on Oct 21, 2026

^ is bitwise XOR, PostgreSQL uses it for exponentiation: 2 ^ 3 is 1

AlaSQL/alasql#2829 · opened

on Oct 21, 2026

Aggregate FILTER (WHERE ...) is a parse error

AlaSQL/alasql#2828 · opened

on Oct 21, 2026

SIMILAR TO is a parse error

AlaSQL/alasql#2827 · opened

on Oct 21, 2026

RETURNING in INSERT, UPDATE and DELETE is a parse error

AlaSQL/alasql#2826 · opened

on Oct 21, 2026

SET name TO value, RESET and SHOW are parse errors

AlaSQL/alasql#2825 · opened

on Oct 21, 2026

CREATE TABLE AS SELECT is a parse error, and SELECT INTO a new table throws a TypeError

AlaSQL/alasql#2824 · opened

on Oct 21, 2026

VALUES as a query is a parse error: VALUES (1, 2) and FROM (VALUES ...) AS v

AlaSQL/alasql#2823 · opened

on Oct 21, 2026

Typed literals are parse errors or read as a column with an alias: int4 '12', bool 't'

AlaSQL/alasql#2822 · opened

on Oct 21, 2026

GROUPING SETS with a CUBE or ROLLUP inside throws a TypeError

AlaSQL/alasql#2821 · opened

on Oct 21, 2026

Hexadecimal, octal and binary integer literals throw a TypeError: SELECT 0x1F

AlaSQL/alasql#2820 · opened

on Oct 21, 2026

CURRENT_TIME, LOCALTIME and LOCALTIMESTAMP are not supported

AlaSQL/alasql#2819 · opened

on Oct 21, 2026

SUM() OVER (ORDER BY a) gives the partition total instead of a running total, and window frames are parse errors

AlaSQL/alasql#2818 · opened

on Oct 21, 2026

· Breaking change (for v5.0.0)

ORDER BY LOWER(c) in a query grouped by LOWER(c) does not sort

AlaSQL/alasql#2817 · opened

on Oct 21, 2026

Text stays text in INTEGER, BIGINT, REAL and DOUBLE PRECISION columns and in casts to int4 or float8: '456' + 1 is '4561'

AlaSQL/alasql#2816 · opened

on Oct 21, 2026

· Breaking change (for v5.0.0)

A PRIMARY KEY column accepts NULL

AlaSQL/alasql#2815 · opened

on Oct 21, 2026

UPDATE with a table-qualified column throws a TypeError: UPDATE t SET u = t.u + 1

AlaSQL/alasql#2814 · opened

on Oct 21, 2026

An option for warnings, so statements that are accepted and ignored can tell the developer

AlaSQL/alasql#2813 · opened

on Oct 21, 2026

ORDER BY on a column of numbers and text gives an order that depends on the runtime and on earlier statements

AlaSQL/alasql#2812 · opened

on Oct 21, 2026

'a' || NULL gives 'a', SQL gives NULL

AlaSQL/alasql#2811 · opened

on Oct 21, 2026

· Breaking change (for v5.0.0)

A comma join throws a TypeError when WHERE compares a bare column with a qualified one

AlaSQL/alasql#2810 · opened

on Oct 21, 2026

Division by zero, a subquery with several rows and an invalid CAST give a value, SQL-92 requires an error

AlaSQL/alasql#2809 · opened

on Oct 21, 2026

1

CHAR(n) and VARCHAR(n) columns store longer text without an error

AlaSQL/alasql#2808 · opened

on Oct 21, 2026

Navigation Menu

Repository navigation

Issues

WITH t(a) AS (SELECT ...) throws ReferenceError: renameColumns is not defined

Common PostgreSQL functions are missing: GENERATE_SERIES, LPAD, DATE_TRUNC, MOD, STRING_AGG and more

|| binds tighter than +: 'four: ' || 2 + 2 is 'four: 22', PostgreSQL gives 'four: 4'

^ is bitwise XOR, PostgreSQL uses it for exponentiation: 2 ^ 3 is 1

Aggregate FILTER (WHERE ...) is a parse error

SIMILAR TO is a parse error

RETURNING in INSERT, UPDATE and DELETE is a parse error

SET name TO value, RESET and SHOW are parse errors

CREATE TABLE AS SELECT is a parse error, and SELECT INTO a new table throws a TypeError

VALUES as a query is a parse error: VALUES (1, 2) and FROM (VALUES ...) AS v

Typed literals are parse errors or read as a column with an alias: int4 '12', bool 't'

GROUPING SETS with a CUBE or ROLLUP inside throws a TypeError

Hexadecimal, octal and binary integer literals throw a TypeError: SELECT 0x1F

CURRENT_TIME, LOCALTIME and LOCALTIMESTAMP are not supported

SUM() OVER (ORDER BY a) gives the partition total instead of a running total, and window frames are parse errors

ORDER BY LOWER(c) in a query grouped by LOWER(c) does not sort

Text stays text in INTEGER, BIGINT, REAL and DOUBLE PRECISION columns and in casts to int4 or float8: '456' + 1 is '4561'

A PRIMARY KEY column accepts NULL

UPDATE with a table-qualified column throws a TypeError: UPDATE t SET u = t.u + 1

An option for warnings, so statements that are accepted and ignored can tell the developer

ORDER BY on a column of numbers and text gives an order that depends on the runtime and on earlier statements

'a' || NULL gives 'a', SQL gives NULL

A comma join throws a TypeError when WHERE compares a bare column with a qualified one

Division by zero, a subquery with several rows and an invalid CAST give a value, SQL-92 requires an error

CHAR(n) and VARCHAR(n) columns store longer text without an error