Changeset: 0c093c40a229 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0c093c40a229
Modified Files:
        sql/server/rel_schema.c
Branch: Mar2018
Log Message:

Don't allow creation of indexes on merge or remote tables


diffs (15 lines):

diff --git a/sql/server/rel_schema.c b/sql/server/rel_schema.c
--- a/sql/server/rel_schema.c
+++ b/sql/server/rel_schema.c
@@ -1939,8 +1939,9 @@ rel_create_index(mvc *sql, char *iname, 
        t = mvc_bind_table(sql, s, tname);
        if (!t) {
                return sql_error(sql, 02, SQLSTATE(42S02) "CREATE INDEX: no 
such table '%s'", tname);
-       } else if (isView(t)) {
-               return sql_error(sql, 02, SQLSTATE(42S02) "CREATE INDEX: cannot 
create index on view '%s'", tname);
+       } else if (isView(t) || isMergeTable(t) || isRemote(t)) {
+               return sql_error(sql, 02, SQLSTATE(42S02) "CREATE INDEX: cannot 
create index on %s '%s'", isView(t)?"VIEW":
+                                               isMergeTable(t)?"MERGE 
TABLE":"REMOTE TABLE", tname);
        }
        sname = get_schema_name( sql, sname, tname);
        nt = dup_sql_table(sql->sa, t);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to