search

AlaSQL / alasql

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.
http://alasql.org
MIT License
7.02k stars 654 forks source link

group_concat function doesn't work in lower case #1898

Closed kdabir closed 6 months ago

kdabir commented 6 months ago

when used as GROUP_CONCAT in query it works but when used group_concat it throws the following:

TypeError: alasql.fn["group_concat"] is not a function. (In 'alasql.fn["group_concat"](g['fieldName'])', 'alasql.fn["group_concat"]' is undefined)

this is not the case with other aggregation functions like count for example.

vishal6557 commented 6 months ago

Can you assign to me, @mathiasrw Thanks!

Dedsec0098 commented 6 months ago

Hi I already have experience in fixing these issues. Can you please assign it to me?

mathiasrw commented 6 months ago

Fix released as part of v4.3.1