Bug when a variable is assigned from a query

[pabloBelt]

Hi,

There is a bug when a variable takes a value from a query.

DECLARE @x NUMBER = (SELECT MAX(population) FROM cities) `

http://jsfiddle.net/wa5hz8nd/1/

It can also be reproduced with the latest 3.0.0 version:

Bests,
Pablo

[joan8ruth]

Hello @pabloBelt ,
I see that the declare could be split into two steps:

declare @v NUMBER;
SET @v = (Select MAX(X) from T);

and is working fine this way (maybe it works only this way? because I believe this is what I usually do when writing queries), but I would like to know if the single line declaration you have mentioned was working in the previous version.

Regards,
Joanna

[abhishek-kumar-91]

I want to work on this issue, please assign me.

[mathiasrw]

Fix Released as part of v4.0.6