Changeset: 3ae6097da5c6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/3ae6097da5c6
Added Files:
sql/test/BugTracker-2025/Tests/7656_incorrect_error.test
Modified Files:
sql/backends/monet5/sql_cat.c
sql/test/BugTracker-2025/Tests/All
Branch: Mar2025
Log Message:
fixed error message for issue # 7656
ie error is about the foreign key, ie use the foreign keys names
diffs (48 lines):
diff --git a/sql/backends/monet5/sql_cat.c b/sql/backends/monet5/sql_cat.c
--- a/sql/backends/monet5/sql_cat.c
+++ b/sql/backends/monet5/sql_cat.c
@@ -699,7 +699,7 @@ drop_table(mvc *sql, char *sname, char *
/* make sure it is not a self
referencing key */
if (fk->t != t)
- throw(SQL,"sql.drop_table",
SQLSTATE(40000) "DROP TABLE: FOREIGN KEY %s.%s depends on %s", k->t->base.name,
k->base.name, tname);
+ throw(SQL,"sql.drop_table",
SQLSTATE(40000) "DROP TABLE: FOREIGN KEY %s.%s depends on %s",
fk->t->base.name, fk->base.name, tname);
}
}
}
diff --git a/sql/test/BugTracker-2025/Tests/7656_incorrect_error.test
b/sql/test/BugTracker-2025/Tests/7656_incorrect_error.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2025/Tests/7656_incorrect_error.test
@@ -0,0 +1,23 @@
+
+-- the primary key
+statement ok
+create table a(id int)
+
+statement ok
+insert into a values (1)
+
+statement ok
+alter table a add primary key(id)
+
+-- the foreign key
+statement ok
+create table b(i int)
+
+statement ok
+insert into b values (1)
+
+statement ok
+alter table b add foreign key(i) references a
+
+statement error 40000!DROP TABLE: FOREIGN KEY b.b_i_fkey depends on a
+drop table a
diff --git a/sql/test/BugTracker-2025/Tests/All
b/sql/test/BugTracker-2025/Tests/All
--- a/sql/test/BugTracker-2025/Tests/All
+++ b/sql/test/BugTracker-2025/Tests/All
@@ -15,3 +15,4 @@ 7643_select_0_optimizer_bug
7644_antijoin_crash
7646_leftjoin_crash
7654_non_monetdb_user_remote_table_exec
+7656_incorrect_error
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
