“LIMIT N” now can be used in additional places.

Was found a problem that in a stored procedure the assignment statement do not accept SELECT with LIMIT. This problem is fixed now. So you can have

procname
BEGIN
var = SELECT f1 FROM T WHERE … LIMIT 1
END

Published by

Ruslan Zasukhin

VP Engineering and New Technology Paradigma Software, Inc