Update of
/cvsroot/monetdb/sql/src/test/BugTracker-2010/alter-table-restart-crash.SF-2975018/Tests
In directory
sfp-cvsdas-4.v30.ch3.sourceforge.com:/tmp/cvs-serv5340/src/test/BugTracker-2010/alter-table-restart-crash.SF-2975018/Tests
Added Files:
alter-table-restart-crash.SF-2975018-1.sql
Log Message:
propagated changes of Thursday Apr 15 2010
from the Feb2010 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/04/15 - sjoerd:
src/test/BugTracker-2010/alter-table-restart-crash.SF-2975018/Tests/alter-table-restart-crash.SF-2975018-1.sql,1.1.2.1
Added test for bug 2975022. It fails as reported.
Also moved test for bug 2975018 to a separate directory so that it doesn't
interfere with other tests.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: alter-table-restart-crash.SF-2975018-1.sql ---
--
-- Setup two test tables, one that references the other.
--
CREATE TABLE "sf2975018t1" (
"id" int NOT NULL,
CONSTRAINT "sf2975018t1_id_pkey" PRIMARY KEY ("id")
);
CREATE TABLE "sf2975018t2" (
"id" int NOT NULL,
"sf2975018t1_id" int NOT NULL,
CONSTRAINT "sf2975018t2_id_pkey" PRIMARY KEY ("id"),
CONSTRAINT "sf2975018t2_sf2975018t1_id_fkey" FOREIGN KEY ("sf2975018t1_id")
REFERENCES "sf2975018t1" ("id")
);
CREATE INDEX "sf2975018t2_sf2975018t1_id" ON "sf2975018t2" ("sf2975018t1_id");
--
-- Drop fkey constraint and index
--
DROP INDEX "sf2975018t2_sf2975018t1_id";
ALTER TABLE "sf2975018t2" DROP CONSTRAINT sf2975018t2_sf2975018t1_id_fkey;
--
-- Drop fkey column that links tables.
--
ALTER TABLE "sf2975018t2" DROP COLUMN sf2975018t1_id;
------------------------------------------------------------------------------
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
