Fix EXISTS Function for Subqueries (Issue #1904)

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

6.96k stars 651 forks source link

Fix EXISTS Function for Subqueries (Issue #1904) #1939

Closed Midwayne closed 1 day ago

Midwayne commented 1 week ago

Changes Made:

Updated yy.ExistsValue class in 41exists.js to correctly handle EXISTS function in subqueries.
Adjusted toJS method to return a boolean value based on the presence of data in the subquery result.

Testing:

All tests passed successfully when executed with yarn test.

Related Issue: This pull request addresses issue #1904.