Skip to content

join fails with right scan without alias

    local r, err = api:call("sbroad.execute", { [[
    select * from "testing_space" inner join
    (select "id" as "i", "string_col" from "arithmetic_space")
    on "id" = "i"
]], {} })

 expected: nil, actual: Sbroad Error: Lua error (dispatch IR): LuaError(ExecutionError("Sbroad Error: Failed to execute the query: LuaError(ExecutionError(\"Unequal number of entries in row expression: left side has 1, but right side - 2\"))"))

storage-2-1 | SELECT "testing_space"."id", "testing_space"."name", "testing_space"."product_units", "i", "string_col" FROM (SELECT "testing_space"."id", "testing_space"."name", "testing_space"."product_units" FROM "testing_space") as "testing_space" INNER JOIN (SELECT "i","string_col" FROM "TMP_0b027456656145f49c1db80d781eb9e0_42") ON ("testing_space"."id") = (SELECT "i","string_col" FROM "TMP_0b027456656145f49c1db80d781eb9e0_42")

with alias query works

Edited by Arseniy Volynets