SOQL query results table doesn't include columns for fields with all null values

If I run the query:

SELECT Name, AccountNumber
FROM Account
ORDER BY AccountNumber NULLS FIRST
LIMIT 2

I get the following:

Name                       AccountNumber
sForce
Pyramid Construction Inc.  CC213425

but if I change that query to:

SELECT Name, AccountNumber
FROM Account
ORDER BY AccountNumber NULLS FIRST
LIMIT 1

I get the following:

Name
sForce

A column should be shown for each queried field/relationship even if all values are null.

Comments (4)