Repository navigation
Unable to get property 'modifier' of undefined or null reference #635
Description
- Describe the problem:
--- I have multiple select statements strung together with EXCEPT or INTERSECT between them. To order by with multiple selects, you usually add ORDER BY at the end. When I do order by at the end, I get the error in the title of the issue. The error points to alasql.min.js at line 2, char 9585, code 0 - Provide code that replicates the problem:
--- "SELECT * FROM Persons INTERSECT SELECT * FROM Persons WHEREeventStartBETWEEN x AND x OReventEndBETWEEN x AND x ORDER BYeventStart"
x's are just unix timestamps, I left them out for clarity.
Reacted by Copilot
Activity
mathiasrw commentedon Mar 24, 2016
Have you tried putting
(...)around?mathiasrw commentedon Mar 24, 2016
Ok - some inputs
(...)idea does not work. The parser cant handle it.SELECT *part wont work.alasql('SELECT * FROM $0 INTERSECT SELECT * FROM $0',[[{eventStart:1},{eventStart:100},{eventStart:10}]])gives an empty result
alasql('SELECT eventStart FROM $0 INTERSECT SELECT eventStart FROM $0',[[{eventStart:1},{eventStart:100},{eventStart:10}]])will give 3 results as expected.
ORDER BYis not working (as you state) so in the last example the order will be 1,100,10alasql('SELECT * FROM (SELECT eventStart FROM $0 INTERSECT SELECT eventStart FROM $0) ORDER BY eventStart',[[{eventStart:1},{eventStart:100},{eventStart:10}]])Bonus input: I hope the query is only to illustrate the problem. It does not make much sense to intersect with the same table.
Respect ORDER BY in INTERSECT/EXCEPT queries to fix AlaSQL#635 (AlaSQ…
mathiasrw commentedon Dec 6, 2025
Fix released as part of v4.11.0