SQL++ Query Join with alias returns incorrect result

 - Steps to Reproduce:  Create a test accordingly to API doc 8.11.5 with query string: 

SELECT f.name, c.color FROM test.flowers as f JOIN test.colors as c ON f.cid = c.cid ORDER BY f.name

 - Actual Result: Result has one item {"color":"blue", "name":"hydrangea"}
 - Expected Result:

{"color":"red","name":"rose"}

• Link to java test: https://github.com/couchbase/couchbase-lite-java-common/blob/d80068835f6370347b5e84ec29cfd024daca0651/common/test/java/com/couchbase/lite/QueryTest.java#L3361-L3406