Changeset: 7e58098c0f27 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/7e58098c0f27
Added Files:
sql/test/BugTracker-2025/Tests/7732-table-exp-issue.test
Modified Files:
sql/server/rel_select.c
sql/test/BugTracker-2025/Tests/All
Branch: Mar2025
Log Message:
add fix for issue #7732
diffs (35 lines):
diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c
--- a/sql/server/rel_select.c
+++ b/sql/server/rel_select.c
@@ -5426,9 +5426,11 @@ rel_table_exp(sql_query *query, sql_rel
tname = column_e->data.lval->h->data.sval;
} else if (column_e->token == SQL_COLUMN &&
column_e->data.lval->h->type == type_symbol) {
symbol *sym = column_e->data.lval->h->data.sym;
- if (sym->token == SQL_COLUMN)
+ if (sym->token == SQL_COLUMN) {
tname = sym->data.lval->h->data.sval;
- else
+ if (dlist_length(sym->data.lval) > 1 &&
sym->data.lval->t->data.sval)
+ return NULL;
+ } else
return NULL;
} else {
return NULL;
diff --git a/sql/test/BugTracker-2025/Tests/7732-table-exp-issue.test
b/sql/test/BugTracker-2025/Tests/7732-table-exp-issue.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2025/Tests/7732-table-exp-issue.test
@@ -0,0 +1,5 @@
+statement ok
+create table test (id integer primary key, value string)
+
+statement error 42S22!SELECT: no such column
'test.some_column_that_does_not_exist'
+select id, test."some_column_that_does_not_exist" from test order by id
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
@@ -41,3 +41,4 @@ 7694-anti-join-and-filters
7699-create-user
7702-stmt_convert_cands
7706-set-user
+7732-table-exp-issue
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
