fantastisch! 2010/2/5 Niels Nes :

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 Monetdb-sql-checkins@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins