Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv30764/src/test/BugTracker-2009/Tests
Added Files:
crash_on_complex_join.SF-2847106.sql
Log Message:
propagated changes of Thursday Sep 03 2009 - Friday Sep 04 2009
from the Aug2009 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/09/03 - nielsnes:
src/test/BugTracker-2009/Tests/crash_on_complex_join.SF-2847106.sql,1.1.2.1
added test for bugs
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: crash_on_complex_join.SF-2847106.sql ---
CREATE TABLE "sys"."way_nds" (
"way" int,
"idx" int,
"to_node" int
);
CREATE TABLE "sys"."nodes_legacy" (
"id" int NOT NULL,
"long" double,
"lat" double,
"uid" int,
"timestamp" TIMESTAMP WITH TIME ZONE,
"zcurve" bigint
);
select way_nds.way, zcurve from way_nds, nodes_legacy where to_node = id
and zcurve between (zcurve - 4096) and (zcurve + 4096);
drop table nodes_legacy;
drop table way_nds;
------------------------------------------------------------------------------
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
