Update of /cvsroot/monetdb/sql/src/server
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv25790/src/server
Modified Files:
Tag: Feb2010
rel_schema.mx
Log Message:
fixed bug in handeling topn in create table as select with data.
Index: rel_schema.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/server/rel_schema.mx,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -u -d -r1.2 -r1.2.2.1
--- rel_schema.mx 11 Jan 2010 10:29:17 -0000 1.2
+++ rel_schema.mx 5 Feb 2010 10:18:16 -0000 1.2.2.1
@@ -127,9 +127,14 @@
static char *
as_subquery( mvc *sql, sql_table *t, sql_rel *sq, dlist *column_spec )
{
+ sql_rel *r = sq;
+
+ if (is_topn(r->op))
+ r = sq->l;
+
if (column_spec) {
dnode *n = column_spec->h;
- node *m = sq->exps->h;
+ node *m = r->exps->h;
for (; n; n = n->next, m = m->next) {
char *cname = n->data.sval;
@@ -143,7 +148,7 @@
} else {
node *m;
- for (m = sq->exps->h; m; m = m->next) {
+ for (m = r->exps->h; m; m = m->next) {
sql_exp *e = m->data;
char *cname = exp_name(e);
sql_subtype *tp = exp_subtype(e);
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
