Subtable error: subResults is not defined

Wappler Version : 4.9.1
Operating System : mac
Server Model: node
Database Type: maria
Hosting Type:

Expected behavior

I should be able to add a subtable

Actual behavior

In this particular query, adding this subtable generates an error:

{"status":"500","message":"subResults is not defined","stack":"ReferenceError: subResults is not defined\n    at App.select (/Users/pauka/WapplerProjects/tbd/lib/modules/dbconnector.js:61:69)\n    at processTicksAndRejections (node:internal/process/task_queues:96:5)\n    at async App._exec (/Users/pauka/WapplerProjects/tbd/lib/core/app.js:491:30)\n    at async App._exec (/Users/pauka/WapplerProjects/tbd/lib/core/app.js:458:17)\n    at async App.exec (/Users/pauka/WapplerProjects/tbd/lib/core/app.js:427:9)\n    at async App.exec (/Users/pauka/WapplerProjects/tbd/lib/modules/core.js:228:13)\n    at async App._exec (/Users/pauka/WapplerProjects/tbd/lib/core/app.js:491:30)\n    at async App.exec (/Users/pauka/WapplerProjects/tbd/lib/core/app.js:427:9)\n    at async App.define (/Users/pauka/WapplerProjects/tbd/lib/core/app.js:417:9)"}

How to reproduce

When selecting the media subtable, it is added and displays:

Screen Shot 2022-06-17 at 9.43.19 AM2104×272 68 KB

However if I click okay to save the query, and immediately re-open it displays like this:

Screen Shot 2022-06-17 at 9.43.41 AM1682×234 47.4 KB

And if run the api, the error noted above is thrown.

The joins on the table are:

Screen Shot 2022-06-17 at 9.49.59 AM588×506 48.8 KB