Update of /cvsroot/monetdb/sql/src/server
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv28777/src/server
Modified Files:
sql_mvc.mx
Log Message:
propagated changes of Friday Nov 20 2009 - Saturday Nov 28 2009
from the Nov2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/11/20 - nielsnes: src/server/sql_mvc.mx,1.226.2.3
new optimizer to fix (performance) bug. We should always start grouping with
a sorted column (if its part of a group by list).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: sql_mvc.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/server/sql_mvc.mx,v
retrieving revision 1.228
retrieving revision 1.229
diff -u -d -r1.228 -r1.229
--- sql_mvc.mx 9 Oct 2009 08:57:07 -0000 1.228
+++ sql_mvc.mx 28 Nov 2009 19:57:19 -0000 1.229
@@ -192,6 +192,7 @@
extern sql_column *mvc_null(mvc *c, sql_column *col, int flag);
extern sql_column *mvc_default(mvc *c, sql_column *col, char *val);
extern sql_column *mvc_drop_default(mvc *c, sql_column *col);
+extern int mvc_is_sorted(mvc *c, sql_column *col);
extern sql_key *mvc_create_ukey(mvc *m, sql_table *t, char *kname, key_type
kt);
extern sql_key *mvc_create_ukey_done(mvc *m, sql_key *k);
@@ -1415,6 +1416,15 @@
return sql_trans_alter_default(m->session->tr, col, NULL);
}
+int
+mvc_is_sorted(mvc *m, sql_column *col)
+{
+ if (mvc_debug)
+ fprintf(stderr, "mvc_is_sorted %s\n", col->base.name);
+
+ return sql_trans_is_sorted(m->session->tr, col);
+}
+
/* variable management */
void
stack_push_var(mvc *sql, char *name, stmt *var, sql_subtype *type)
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
