AlaSQL/alasql

AUTOINCREMENT for INDEXEDDB does not seem to work 10 days ago

Help wanted Bug: Code provided to reproduced Good first issue

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Execution gives wrong result when field name starts from number 10 days ago

Help wanted Related to: Code quality Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

error callback is undefined 12 days ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

ESCAPE character issue 20 days ago

Help wanted Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

COALESCE isn`t work 21 days ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Foreign key via `REFERENCES` does not work with `FILESTORAGE` 3 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Using ? with limit causes "Expecting 'NUMBER', got 'QUESTION'" error 3 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Issue with correlated queries 3 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

alasql.js:19270 Uncaught TypeError: SQL.Database is not a constructor 3 months ago

Help wanted Related to: Code quality Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

BLOB not working with safari 4 months ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Promise.all error 4 months ago

Help wanted Related to: Code quality Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Enhance SQL function 4 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

sql exec error 4 months ago

Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

ALTER TABLE ADD COLUMN does not work 6 months ago

Help wanted Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

ORDER BY with CASE doesn't work on UNION 7 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Query result is wrong 8 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

UNION ALL does not work with sub query 8 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Wrong datatype after reading FROM CSV 8 months ago

Help wanted Related to: SQL compliance Bug: Code not provided to reproduce Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

GROUP_CONCAT is treating null as "null" 8 months ago

Help wanted Related to: SQL compliance Bug: Code not provided to reproduce Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

transactions does not seem to work with indexeddb 8 months ago

Help wanted Related to: Code quality Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Data extraction issue: Query does not return the expected result. 8 months ago

Help wanted Related to: Code quality Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

It seems like Scalar Subquery is not available in AlaSQL. 8 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Trying to implement CORR() using custom function logic, but it is not working 8 months ago

Help wanted ! Question

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Foreign key not detected in tables object 8 months ago

Help wanted ! Question Related to: Documentation Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

LIKE pattern is usually case-sensitive 8 months ago

AI Summary: This GitHub issue highlights that AlaSQL's `LIKE` operator is currently case-insensitive, which deviates from the typical case-sensitive behavior found in most standard SQL implementations. The user is questioning the rationale behind this design choice in AlaSQL. The issue implies a need for either an explanation of the current behavior or a potential adjustment to align with common SQL standards.

Complexity: 3/5

Help wanted Related to: SQL compliance Good first issue Breaking change

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Default values are ignored in FILESTORAGE and LOCALSTORAGE 8 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

SELECT field on joined tables gives unexpected undefined 8 months ago

AI Summary: The `alasql` library exhibits a bug where explicitly selecting fields after a `JOIN` operation results in some fields from the joined table being `undefined`. While `SELECT *` correctly returns all data, a `SELECT UserName, Text` query, for example, incorrectly shows `Text` as `undefined` despite it being present in the `SELECT *` output.

Complexity: 3/5

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

sqllogictest 2: FROM (tab1 CROSS JOIN tab2) construction 8 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Comprison on NULL differes from SQL 8 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Problem catching errors using the simple notation 8 months ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

UNION (ALL) only gives data from table 1 8 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

joinstar option not working 8 months ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

SELECT null [not] IN () 8 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Duplicate record inserted regardless of PK constraint 8 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

REGEXP not working as expected 8 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Add WITH ROLLUP/WITH CUBE syntax to ROLLUP()/CUBE() 8 months ago

! Feature request Help wanted Related to: SQL compliance

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Add OUTPUT clause for INSERT/DELETE/UPDATE/MERGE 8 months ago

! Feature request Help wanted Related to: SQL compliance

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

sqllogictest3: Unambigous syntax in FROM 8 months ago

! Feature request Help wanted Related to: SQL compliance Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

GROUP BY returns 1 invalid result if no rows meet condition 8 months ago

Help wanted Related to: Code quality Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Sorting does not occur for field names in Latin or in quotation marks! 8 months ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

primary key not working. Adds duplicate values. 8 months ago

Help wanted Related to: Code quality Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Timezone challenge for test408.js 9 months ago

Help wanted Related to: Code quality Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Records in table are always insert empty in the table 9 months ago

Help wanted Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Performance issues at AlaSQL database queries - response time of several minutes 9 months ago

Help wanted Related to: Performance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Implement per group row numbers rather than per result set row numbers 9 months ago

! Feature request Help wanted Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Import xlsx with multiple sheets 9 months ago

! Feature request Help wanted Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Error in exception message for foreign key violation error 9 months ago

! Feature request Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Inserting pre-defined serial type gets overwritten 9 months ago

! Feature request Help wanted Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

UNIQUE JSON property 9 months ago

Help wanted Bug: Code provided to reproduced

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Fix SEARCH DISTINCT function and SELECT DISTINCT functions 9 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Add RIGHT() and LEFT() SQL string functions 9 months ago

! Feature request Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

DELETE not working without WHERE xxx 9 months ago

! Feature request Help wanted Related to: SQL compliance Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

ORDER BY clause on three or more UNIONS 9 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Nested SubQueries do not work as expected 9 months ago

Help wanted Related to: SQL compliance Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Alasql cli docker / pipe issues 9 months ago

Help wanted ! Question Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

localstorage: creating view succeeds but selecting from it fails 9 months ago

Help wanted Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

alasql not checking schema on insertion 9 months ago

Help wanted Bug: Code provided to reproduced Good first issue

AlaSQL/alasql

7.3K

AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

JavaScript

Open Issues Need Help