Skip to content

sbroad fails to execute query with nested inner joins

sbroad.execute([[
select * from "t1" inner join (
      select "b2" from "t2" 
      inner join "t3" on "t2"."c2" = "t3"."a3") as q 
on q."b2" = "t1"."a"
]], {})

Gives:

---
- null
- 'Sbroad Error: Lua error (IR dispatch): LuaError(ExecutionError("Sbroad Error: Failed
  to execute the query: LuaError(ExecutionError(\"Field ''b2'' was not found in space
  ''Q'' format\"))"))'
...