[CALCITE-5964] Add test case checking that connection.getMetaData().getTables() handles responses with different signature shapes.

[olivrlee]

Also adding in Type.CLASS to ConnectionProperty.java and the associated getters.