Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.08 » View Incident Report |
Serious |
Reported By: Terry Swiers Reported On: 4/11/2012 For: Version 2.08 Build 3 |
Table: CREATE TABLE "test" ( "Entry" INTEGER, "Sequence" INTEGER ) INSERT INTO "test" VALUES (1,4) INSERT INTO "test" VALUES (2,3) INSERT INTO "test" VALUES (3,2) INSERT INTO "test" VALUES (4,1) Script: SCRIPT BEGIN EXECUTE IMMEDIATE 'CREATE TEMPORARY TABLE MyTempTable as (select * from test) WITH DATA'; EXECUTE IMMEDIATE 'ALTER TABLE MyTempTable ADD CONSTRAINT "MyUnique" UNIQUE ("Entry")'; EXECUTE IMMEDIATE 'CREATE INDEX "MyIndex" ON "MyTempTable" (Sequence, Entry)'; EXECUTE IMMEDIATE 'DROP TABLE MyTempTable'; END
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |