Subqueries return incorrect data when there are more than one

You can repro the issue with a query like this:

  (select "couchbase", "mongo") NoSQL
  ,(select "mariadb") RDBMS
from vibelifedata p
limit 1;

Run that a few times and the results of the subqueries will randomly be assigned to the wrong field, or one of the result sets will be returned for both fields.

Version: 4.0.0-4051 Community Edition (build-4051)

Hello, this should be fixed in 4.1 and later. I just tried it out on 4.5, and it works fine.

Hi geraldss - will it be fixed in 4.0, or do we have to upgrade our database now?

Hi @vibelifeinc, you should upgrade.