Changeset: 510b082149f5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=510b082149f5
Modified Files:
clients/odbc/driver/SQLGetInfo.c
Branch: Apr2019
Log Message:
We do not support REVOKE options CASCADE or RESTRICT.
We do not support string functions TRANSLATE and BIT_LENGTH.
Added a comment to clarify why we currently have N for SQL_INTEGRITY.
diffs (94 lines):
diff --git a/clients/odbc/driver/SQLGetInfo.c b/clients/odbc/driver/SQLGetInfo.c
--- a/clients/odbc/driver/SQLGetInfo.c
+++ b/clients/odbc/driver/SQLGetInfo.c
@@ -610,6 +610,7 @@ MNDBGetInfo(ODBCDbc *dbc,
SQL_IS_SELECT_INTO;
break;
case SQL_INTEGRITY:
+ /* N because we currently do not supprt CHECK constraints (see
bug 3568) nor deferrable FK constraints. */
sValue = "N"; /* "Y" */
break;
case SQL_KEYSET_CURSOR_ATTRIBUTES1:
@@ -793,7 +794,7 @@ MNDBGetInfo(ODBCDbc *dbc,
SQL_FN_NUM_SIN |
SQL_FN_NUM_SQRT |
SQL_FN_NUM_TAN |
- SQL_FN_NUM_TRUNCATE;
+ SQL_FN_NUM_TRUNCATE; /* is mapped to ms_trunc() */
break;
case SQL_ODBC_INTERFACE_CONFORMANCE:
nValue = SQL_OIC_CORE;
@@ -867,13 +868,13 @@ MNDBGetInfo(ODBCDbc *dbc,
SQL_SDF_CURRENT_TIME |
SQL_SDF_CURRENT_TIMESTAMP;
break;
- case SQL_SQL92_FOREIGN_KEY_DELETE_RULE: /* ? */
+ case SQL_SQL92_FOREIGN_KEY_DELETE_RULE:
nValue = SQL_SFKD_CASCADE |
SQL_SFKD_NO_ACTION |
SQL_SFKD_SET_DEFAULT |
SQL_SFKD_SET_NULL;
break;
- case SQL_SQL92_FOREIGN_KEY_UPDATE_RULE: /* ? */
+ case SQL_SQL92_FOREIGN_KEY_UPDATE_RULE:
nValue = SQL_SFKU_CASCADE |
SQL_SFKU_NO_ACTION |
SQL_SFKU_SET_DEFAULT |
@@ -931,18 +932,18 @@ MNDBGetInfo(ODBCDbc *dbc,
SQL_SRJO_UNION_JOIN;
break;
case SQL_SQL92_REVOKE:
- nValue = SQL_SR_CASCADE |
- SQL_SR_DELETE_TABLE |
+ nValue = SQL_SR_DELETE_TABLE |
SQL_SR_GRANT_OPTION_FOR |
SQL_SR_INSERT_COLUMN |
SQL_SR_INSERT_TABLE |
SQL_SR_REFERENCES_COLUMN |
SQL_SR_REFERENCES_TABLE |
- SQL_SR_RESTRICT |
SQL_SR_SELECT_TABLE |
SQL_SR_UPDATE_COLUMN |
SQL_SR_UPDATE_TABLE;
- /* SQL_SR_USAGE_ON_DOMAIN |
+ /* SQL_SR_CASCADE |
+ * SQL_SR_RESTRICT |
+ * SQL_SR_USAGE_ON_DOMAIN |
* SQL_SR_USAGE_ON_CHARACTER_SET |
* SQL_SR_USAGE_ON_COLLATION |
* SQL_SR_USAGE_ON_TRANSLATION */
@@ -953,16 +954,16 @@ MNDBGetInfo(ODBCDbc *dbc,
SQL_SRVC_DEFAULT |
SQL_SRVC_ROW_SUBQUERY;
break;
- case SQL_SQL92_STRING_FUNCTIONS: /* ? */
+ case SQL_SQL92_STRING_FUNCTIONS:
nValue = SQL_SSF_CONVERT |
SQL_SSF_LOWER |
SQL_SSF_UPPER |
SQL_SSF_SUBSTRING |
- SQL_SSF_TRANSLATE |
SQL_SSF_TRIM_BOTH |
SQL_SSF_TRIM_LEADING |
SQL_SSF_TRIM_TRAILING;
break;
+ /* SQL_SSF_TRANSLATE */
case SQL_SQL92_VALUE_EXPRESSIONS:
nValue = SQL_SVE_CASE |
SQL_SVE_CAST |
@@ -1014,7 +1015,6 @@ MNDBGetInfo(ODBCDbc *dbc,
break;
case SQL_STRING_FUNCTIONS:
nValue = SQL_FN_STR_ASCII |
- SQL_FN_STR_BIT_LENGTH |
SQL_FN_STR_CHAR |
SQL_FN_STR_CHARACTER_LENGTH |
SQL_FN_STR_CHAR_LENGTH |
@@ -1037,6 +1037,7 @@ MNDBGetInfo(ODBCDbc *dbc,
SQL_FN_STR_SPACE |
SQL_FN_STR_SUBSTRING |
SQL_FN_STR_UCASE;
+ /* SQL_FN_STR_BIT_LENGTH */
break;
case SQL_SUBQUERIES:
nValue = SQL_SQ_CORRELATED_SUBQUERIES |
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
