tenants: internal error when selecting from crdb_internal.node_runtime_info

[andy-kimball]

Repro Steps:

1. Create a tenant cluster.
2. Run the following SQL in the tenant cluster:

SELECT * FROM crdb_internal.node_runtime_info

EXPECTED: Empty results?
ACTUAL: Internal error

ERROR: internal error: column node_runtime_info.node_id not nullable, but found NULL value
SQLSTATE: XX000
DETAIL: stack trace:
/go/src/github.com/cockroachdb/cockroach/pkg/sql/virtual_schema.go:427: validateRow()
/go/src/github.com/cockroachdb/cockroach/pkg/sql/virtual_schema.go:493: 1()
/go/src/github.com/cockroachdb/cockroach/pkg/sql/crdb_internal.go:210: func45()
/go/src/github.com/cockroachdb/cockroach/pkg/sql/virtual_schema.go:492: 1()
/go/src/github.com/cockroachdb/cockroach/pkg/sql/virtual_table.go:115: func2()
/usr/local/go/src/runtime/asm_amd64.s:1357: goexit()

[blathers-crl]

Hi @andy-kimball, please add a C-ategory label to your issue. Check out the label system docs.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}

[andy-kimball]

@asubiotto, @nvanbenschoten, @tbg, I'm not quite sure who this issue should be assigned to. My thinking is one of the SQL teams, since it falls within SQL code? But which SQL Team owns internal functions like this? Execution?

[andy-kimball]

I think there are a number of internal tables that give internal errors. For example, crdb_internal.leases does.