search

microsoft / ODBC-Specification

Microsoft ODBC Specification
Other
121 stars 40 forks source link

How does a client know if a structured column with no backing type is open? #115

Closed golamo closed 7 years ago

golamo commented 7 years ago

So far I understand

Structured Column Type DATA_TYPE SQL_DATA_TYPE
Typed SQL_UDT ?
Unnamed SQL_ROW ?
UnTyped SQL_ROW SQL_ROW

However it is not clear what will be in SQL_DATA_TYPE for a Unnamed Structured Column?

mikepizzo commented 7 years ago

Should clarify in the spec that SQL_DATA_TYPE and DATA_TYPE are both SQL_ROW, SQL_UDT, SQL_MULTISET, and SQL_COLUMNS.

We should remove the concept of "untyped" from section 3.10.1. Untyped is a special case of an unnamed type that has no defined columns.

We should replace the last paragraph of 3.10.1 with a statement like "a structured type with no members returns an empty result set. The members of such a type are treated as dynamic columns by the client."

mikepizzo commented 7 years ago

Updated spec, but need to determine how the client knows if a structured column with no backing type allows dynamic properties.

mikepizzo commented 7 years ago

Perhaps assume any structured column with no backing is open?

mikepizzo commented 7 years ago

Added: Clients must assume that instances of structured columns with no backing type may include undeclared (dynamic) columns.