Update of /cvsroot/monetdb/sql/src/common
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv13213/src/common
Modified Files:
sql_types.mx
Log Message:
propagated changes of Wednesday Feb 11 2009 - Thursday Feb 12 2009
from the Feb2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/02/11 - nielsnes: src/common/sql_types.mx,1.121.2.1
disabled mitosis (not ready for production/release)
fixed bugs
2585592 Serial with order by is not working properly
First order then project, added check for project with order)
2582389 subtraction between two columns
Disabled pushing sort down, this causes problems when the sorted
column is used in other selection/projection results)
2581617 cardinality of expression is wrong
When optimizing we sometimes have to fixup the cardinality of
expressions
2523442 IS NULL handled wrong in searched CASE
The case condition column needs its null's removed.
2513620 subquery returns a table crash
Properly detect unexpected table results in the selection
2499537 SQL: time to implement BINOP
Done
Optimizer now also pushes select under cross-product
fixed bug in alter add index
fixed bug in "OR" handling, with views. These require a distinct over
their "%TID%" columns. These TID columns are usualy not include in a
view, but when used now they are re-introduced.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: sql_types.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/common/sql_types.mx,v
retrieving revision 1.121
retrieving revision 1.122
diff -u -d -r1.121 -r1.122
--- sql_types.mx 27 Jan 2009 16:14:23 -0000 1.121
+++ sql_types.mx 12 Feb 2009 15:48:52 -0000 1.122
@@ -633,7 +633,7 @@
if (strcmp(f->base.name, name) == 0) {
if (list_length(f->ops) == nrargs) {
int scale = 0;
- sql_subfunc *fres = NEW(sql_subfunc);
+ sql_subfunc *fres = ZNEW(sql_subfunc);
sql_ref_init(&(fres->ref));
fres->func = f;
@@ -702,7 +702,7 @@
/* member functions should not match binary
operators */
if (nrargs == 2 && subtype_cmp( &((sql_arg *)
f->ops->h->data)->type, &((sql_arg *) f->ops->h->next->data)->type) == 0)
continue;
- fres = NEW(sql_subfunc);
+ fres = ZNEW(sql_subfunc);
sql_ref_init(&(fres->ref));
fres->func = f;
@@ -773,7 +773,7 @@
if (strcmp(f->base.name, sqlfname) == 0) {
if (list_cmp(f->ops, ops, (fcmp) &arg_subtype_cmp) ==
0) {
unsigned int scale = 0;
- sql_subfunc *fres = NEW(sql_subfunc);
+ sql_subfunc *fres = ZNEW(sql_subfunc);
sql_ref_init(&(fres->ref));
fres->func = f;
@@ -817,7 +817,7 @@
if (strcmp(f->base.name, sqlfname) == 0) {
if (list_cmp(f->ops, ops, (fcmp)
&arg_subtype_cmp) == 0) {
unsigned int scale = 0;
- sql_subfunc *fres = NEW(sql_subfunc);
+ sql_subfunc *fres = ZNEW(sql_subfunc);
sql_ref_init(&(fres->ref));
fres->func = f;
@@ -889,7 +889,7 @@
continue;
if (strcmp(f->base.name, sqlfname) == 0 && (is_subtype(&f->res,
res) || f->res.type->eclass == EC_ANY) && list_cmp(f->ops, ops, (fcmp)
&arg_subtype_cmp) == 0) {
unsigned int scale = 0;
- sql_subfunc *fres = NEW(sql_subfunc);
+ sql_subfunc *fres = ZNEW(sql_subfunc);
sql_ref_init(&(fres->ref));
fres->func = f;
@@ -935,7 +935,7 @@
if (f->res.type)
continue;
if (strcmp(f->base.name, sqlfname) == 0 && list_cmp(f->ops,
ops, (fcmp) &arg_subtype_cmp) == 0) {
- sql_subfunc *fres = NEW(sql_subfunc);
+ sql_subfunc *fres = ZNEW(sql_subfunc);
sql_ref_init(&(fres->ref));
fres->func = f;
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
