Issues

A dialect that keeps today's behaviour, as the way back from each breaking change

AlaSQL/alasql#2851 · opened

on Oct 22, 2026

· Breaking change (for v5.0.0)

The postgres dialect: answers that differ from the default

AlaSQL/alasql#2850 · opened

on Oct 22, 2026

· v5.x Focus

FILESTORAGE: ATTACH DATABASE throws TypeError: error is not a function, and createTable's message reads an undefined fsdbid

AlaSQL/alasql#2846 · opened

on Oct 22, 2026

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

AlaSQL/alasql#2841 · opened

on Oct 21, 2026

· v4.x Focus

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

AlaSQL/alasql#2831 · opened

on Oct 21, 2026

· v5.x Focus

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

AlaSQL/alasql#2830 · opened

on Oct 21, 2026

· v5.x Focus

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

AlaSQL/alasql#2829 · opened

on Oct 21, 2026

· v5.x Focus

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

AlaSQL/alasql#2828 · opened

on Oct 21, 2026

· v5.x Focus

SIMILAR TO is a parse error

AlaSQL/alasql#2827 · opened

on Oct 21, 2026

· v5.x Focus

RETURNING in INSERT, UPDATE and DELETE is a parse error

AlaSQL/alasql#2826 · opened

on Oct 21, 2026

· v5.x Focus

SET name TO value, RESET and SHOW are parse errors

AlaSQL/alasql#2825 · opened

on Oct 21, 2026

· v5.x Focus

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

· v5.x Focus

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

AlaSQL/alasql#2823 · opened

on Oct 21, 2026

· v5.x Focus

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

· v5.x Focus

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

· v5.x Focus

CURRENT_TIME, LOCALTIME and LOCALTIMESTAMP are not supported

AlaSQL/alasql#2819 · opened

on Oct 21, 2026

· v5.x Focus

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

· v5.x Focus

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)

Navigation Menu

Repository navigation

Issues

A dialect that keeps today's behaviour, as the way back from each breaking change

The postgres dialect: answers that differ from the default

FILESTORAGE: ATTACH DATABASE throws TypeError: error is not a function, and createTable's message reads an undefined fsdbid

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