search

microsoft / ODBC-Specification

Microsoft ODBC Specification
Other
121 stars 40 forks source link

Elaborate on/integrate description of new SQLColumns/SQLStructuredTypeColumns 'path' feature #57

Open matthew-wozniczka opened 7 years ago

matthew-wozniczka commented 7 years ago

Section 3.10.1 (Schema Extensions for Structured Columns) describes a way to look at the columns of a nested structured type, while section 3.11.1.1 (Describing Collections using SQLColumns) mentions an analogous feature for collection types.

The former touches on escaping (if the path contains literal periods), there should be something similar for the latter about escaping literal braces, and maybe something to make it clear that both features are 'compatible' (can be used simultaneously in the creation of a 'path').

Maybe there should be a formal grammar? (There's some ambiguity now, for example, when quoting portions of the path, should '[]'s go inside or outside the quotes)

matthew-wozniczka commented 7 years ago

Are paths allowed to be patterns (i.e. contain % or _ when SQL_ATTR_METDATA_ID is SQL_FALSE)?

If so, how exactly does that work?