I even tried with 1.39, and the problem exists.

The OP didn't do anything strange, that syntax he used is in DBI document.

"limit the number of rows"

This has nothing to do with number of rows, but number of columns. I tried: $sth->fetchall_arrayref([0]), it fails in the same way.

This is a bug.