Update of /cvsroot/monetdb/sql/src/storage
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv8090/src/storage
Modified Files:
Tag: Nov2009
sql_storage.h store.mx
Log Message:
new optimizer to fix (performance) bug. We should always start grouping with
a sorted column (if its part of a group by list).
Index: store.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/storage/store.mx,v
retrieving revision 1.38.2.1
retrieving revision 1.38.2.2
diff -u -d -r1.38.2.1 -r1.38.2.2
--- store.mx 8 Oct 2009 13:26:24 -0000 1.38.2.1
+++ store.mx 20 Nov 2009 13:06:36 -0000 1.38.2.2
@@ -3617,6 +3617,14 @@
return col;
}
+int
+sql_trans_is_sorted( sql_trans *tr, sql_column *col )
+{
+ if (col && store_funcs.sorted_col(tr, col))
+ return 1;
+ return 0;
+}
+
sql_key *
sql_trans_create_ukey(sql_trans *tr, sql_table *t, char *name, key_type kt)
{
Index: sql_storage.h
===================================================================
RCS file: /cvsroot/monetdb/sql/src/storage/sql_storage.h,v
retrieving revision 1.60.2.1
retrieving revision 1.60.2.2
diff -u -d -r1.60.2.1 -r1.60.2.2
--- sql_storage.h 9 Oct 2009 08:52:26 -0000 1.60.2.1
+++ sql_storage.h 20 Nov 2009 13:06:36 -0000 1.60.2.2
@@ -322,6 +322,7 @@
extern void sql_trans_drop_column(sql_trans *tr, sql_table *t, int id, int
drop_action);
extern sql_column *sql_trans_alter_null(sql_trans *tr, sql_column *col, int
isnull);
extern sql_column *sql_trans_alter_default(sql_trans *tr, sql_column *col,
char *val);
+extern int sql_trans_is_sorted(sql_trans *tr, sql_column *col);
extern sql_key *sql_trans_create_ukey(sql_trans *tr, sql_table *t, char *name,
key_type kt);
extern sql_key * sql_trans_key_done(sql_trans *tr, sql_key *k);
------------------------------------------------------------------------------
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
