test / some complex query (it fails with analyzer enabled)

[den-crane]

Changelog category (leave one):

• Not for changelog (changelog entry is not required)

[alexey-milovidov]

LGTM. This test will help us when we are going to enable Analyzer.

[novikd]

I'm not sure if it makes sense to support such queries. The exception says:

using identifier 'account_id' cannot be resolved from left table expression.

The JOIN expression is: srv_account_parts LEFT JOIN (SELECT ...). The table actually doesn't contain account_id column, it has account_ids Array(Int64) which can be used by an alias arrayJoin(account_ids) AS account_id defined in the SELECT.

This is a very strange behavior that it worked in the old infrastructure. In my opinion, we should not support it. @kitaisreal what do you think?