Update of /cvsroot/monetdb/sql/src/test/BugTracker-2010/Tests
In directory
sfp-cvsdas-4.v30.ch3.sourceforge.com:/tmp/cvs-serv15809/src/test/BugTracker-2010/Tests
Added Files:
heap_combine_crash.SF-2947763.sql
Log Message:
propagated changes of Wednesday Apr 14 2010
from the Feb2010 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/04/14 - sjoerd:
src/test/BugTracker-2010/Tests/heap_combine_crash.SF-2947763.sql,1.1.2.1
Test for SF bug 2947763.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: heap_combine_crash.SF-2947763.sql ---
START TRANSACTION;
CREATE TABLE "temp_27_TERM" (
"termid" int NOT NULL,
"term" varchar(1000),
"prob" double,
CONSTRAINT "temp_27_TERM_termid_pkey" PRIMARY KEY ("termid")
);
COPY 2222 RECORDS INTO "temp_27_TERM" FROM stdin USING DELIMITERS '\t','\n','"';
0 "#STOPWORD#" 1
1 "a" 1
2 "about" 1
3 "above" 1
4 "across" 1
5 "after" 1
6 "again" 1
7 "against" 1
8 "all" 1
9 "almost" 1
10 "alone" 1
[...7313 lines suppressed...]
951 "articl" 1
952 "objet" 1
953 "céramiqu" 1
954 "sa" 1
955 "fabric" 1
COMMIT;
START TRANSACTION;
CREATE TEMP TABLE termDict_1 (idstr VARCHAR(1000));;
INSERT INTO termDict_1 SELECT a.term as idstr FROM "temp_27_TERM" as a LEFT
JOIN termDict_1 as b ON a.term=b.idstr WHERE isnull(b.idstr);;
INSERT INTO termDict_1 SELECT a.term as idstr FROM "temp_20_TERM" as a LEFT
JOIN termDict_1 as b ON a.term=b.idstr WHERE isnull(b.idstr);;
INSERT INTO termDict_1 SELECT a.term as idstr FROM "temp_26_TERM" as a LEFT
JOIN termDict_1 as b ON a.term=b.idstr WHERE isnull(b.idstr);;
INSERT INTO termDict_1 SELECT a.term as idstr FROM "temp_24_TERM" as a LEFT
JOIN termDict_1 as b ON a.term=b.idstr WHERE isnull(b.idstr);;
COMMIT;
DROP TABLE termDict_1;
DROP TABLE "temp_24_TERM";
DROP TABLE "temp_26_TERM";
DROP TABLE "temp_20_TERM";
DROP TABLE "temp_27_TERM";
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
