[11.1.125 Pro] - BUG: Formatting operators (MariaDB)

[11.1.125 Pro] - BUG: Formatting operators (MariaDB)

When formatting code in MariaDB, the assignment operator := gets its parts separated, thus

	Code:
	SET `lv_reply_to_caller` := 111;

becomes

	Code:
	SET `lv_reply_to_caller` : = 111; -- surplus space between : and =

resulting in a syntax error.

I believe this has been fixed in version 11.2.x which is not yet released. I tested with a couple of very simple procedures and it formatted the code correctly without adding extra spaces within unary operators and assignments.

Great news! Can you provide an ETA for that version?

Version 11.2 is now available

Still happens in [11.2.246 Pro].

Still happens in [11.2.246 Pro].

I'm not able to reproduce it. Is there any specific context in which I need to try it?

No, nothing special. I've tried it with Operators Spacing set to Don't Modify, Compact, and Space Before and After Operator. None of those helped, there was always something wrong with them.

Check this short video here.

We have tried it on multiple test systems and still unable to reproduce it. The team says they cannot fix it as they don't know what's wrong with it, and unable to debug it, not being able to reproduce the same result with MariaDB. I'm now asking them to try with PostgreSQL and -> operators.