Unexpected result executing: SELECT COUNT(*) as c FROM commits limit 10;

[ajnavarro]

Executing the query without alias, the result is as expected:

!> SELECT COUNT(*) FROM commits;

--> Executing query: SELECT COUNT(*) FROM commits;

+----------+
| COUNT(*) |
+----------+
|    48279 |
+----------+

But if we add an alias:

!> SELECT COUNT(*) as c FROM commits limit 10;

--> Executing query: SELECT COUNT(*) as c FROM commits limit 10;

+------------------------------------------+
|                    C                     |
+------------------------------------------+
| 6fa4b393c01a84c9adf2e2435fba6de13227eabf |
| f6fe463165824f26efe6aaabaa352032f6f93886 |
| 2ba79c4f8ad74b87ef44dd692d46706adbb9e8d0 |
| d07b93103dc7e8bcba010541efa5b0a2394ea6a7 |
| 054bc50dde1a194bbd9a69a72004c2e18b19852f |
| deaab788af9a4f1ed8ed8193b20e3cffb1555b20 |
| 2cfc70f0de7c8902791d3b23a92d6462b9e11d72 |
| fc8af32b8ddaeddf12542cc233631b3dccf4724a |
| 27d5987585e08376915ca02ebb53cfc0a40a39f0 |
| bc01db39ce5bf4d227bc5ef6d9b95bb5f5390f5c |
+------------------------------------------+