Assignment operator not working

[sumitsum]

The following sql statement fails :

SELECT @amount := 10;

Error seen:
java.lang.IllegalStateException: Parameter at position 0 is not set

[rusher]

right, https://jira.mariadb.org/browse/R2DBC-79 created to handle that

[Stenerson]

@rusher, I've used := for quite some time on complex update and select statements in MariaDB. It's also in their KB: https://mariadb.com/kb/en/assignment-operator/

Is there somewhere that points to this being invalid syntax in MariaDB?

[sumitsum]

@rusher MariaDB GitHub page claims that it can support MySQL as well, so I have been using it for MySQL DB as well. On MySQL DB the assignment operator works fine when run via console but fails when run via the driver which tells me that the problem is with the driver.

[rusher]

yes, sorry, this is clearly a parser error that will be corrected soon. (I've initially mentionned that it was a wrong syntax and immediatly removed that part)

[sumitsum]

Thanks a lot @rusher . Will be waiting for the fix :)

[Stenerson]

Thanks @rusher! Your edit was too fast for me! 😉