View Issue

Hi, all

I created a view as

When I selects from this view, the error comes out.

ERROR: Failed to parse view statement: select * from (select * from test ) a left join (select * from test2 ) b on a.id = b.i

I checked the xsysviews table, the view statement missed some letters.

I corrected the view statement and selected from the view again, but I still got the same error.

I tried restart the server, then I got a new error.

ERROR: Node 3 has aborted execution, cause is: org.postgresql.util.PSQLException : ERROR: each UNION query must have the same number of columns
Position: 363
QUERY: SELECT "TMPTT3_3"."id" as "id", "TMPTT3_3"."name" as "name", "TMPTT3_3"."password" as "password", "TMPTT3_3"."rq" as "rq", "TMPTT3_3"."id" as "EXPRESSION1", "TMPTT3_3"."name" as "EXPRESSION2", "TMPTT3_3"."password" as "EXPRESSION3", "TMPTT3_3"."rq" as "EXPRESSION4" FROM "TMPTT3_3" INNER JOIN "TMPTT5_2" ON ("TMPTT3_3"."id" = "TMPTT5_2"."id") UNI...

Does the gridsql cache the view statement?

Does gridsql support full join now?

Thanks.

Regards,
David