Related Issue: https://github.com/apache/arrow-java/issues/1134
Related PR: https://github.com/apache/arrow-java/pull/1139

I have an open PR on arrow-java that changes FlightSql.proto, hence
starting a dicussion here.  Specifically, COLUMN_DEF is being added to
table_schema on the 4 Commands that have that field.

COLUMN_DEF (String) relates to default values, see getColumns() of
DatabaseMetaData
<https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html>.
The getProcedureColumns method has more specifics on the format of
COLUMN_DEF - it's unclear to me if that convention is followed everywhere.

The Related PR above is currently extracting the COLUMN_DEF as is; it
assumes the server-side will handle any parsing.  Alternatives exist here.
The PR enables DB clients to display default values when viewing column
metadata.

Does anyone have thoughts, concerns, or suggestions regarding this topic?

Reply via email to