Subqueries return incorrect data when there are more than one

SQL++
1

You can repro the issue with a query like this:

select
  (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)
Linux

2

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

3

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

4

Hi @vibelifeinc, you should upgrade.