Short test:
SET @TEST = ENCODE('test', 'mykey$'); SELECT @TEST; SELECT DECODE(@TEST, 'mykey$');
Outputs: 0xA0227630 0x74657374
So, second one must be actually a 'test' string again, but its returns 0x74657374 (?)
The same code on MySQL server works properly.
Is a bug or i doing something wrong?