Possible bug: rsumi + row_number()

[kodonnell]

Try this:

select r, rsumi(r) from (select row_number() as r from information_schema.tables) as t;

On my version, r increases by 2 for each row, and rsumi(r) at row n is equal to the expected rsumi(r) + n.

Note that:

select row_number(), rsumi(row_number()) from information_schema.tables;

seems to be fine, so it would appear to be something associated with nested queries.

[infusion]

On what OS have you tried this? I tried to reproduce your problem, but I get the same result for both queries.

[kodonnell]

Interesting. I'm on centos 7.1.1503, using mariadb 10.0.22.

[infusion]

Hm, I've never tried it with mariadb. Running on percona server here and also on MySQL it's just fine. Maybe it is a thing with MariaDB - I'll install it on a vm and test it there.

[kodonnell]

Thanks. I may be entirely wrong, but I believe (?) MariaDB is becoming the default install of "mysql" on Linux boxes, so it is probably worth considering.