1--connection master_1 2SELECT spider_direct_sql('ALTER SESSION SET NLS_DATE_FORMAT=\'YYYY-MM-DD HH24:MI:SS\'', '', 'srv "s_2_1"'); 3SELECT spider_direct_sql('ALTER SESSION SET NLS_TIME_FORMAT=\'HH24:MI:SSXFF\'', '', 'srv "s_2_1"'); 4SELECT spider_direct_sql('ALTER SESSION SET NLS_TIMESTAMP_FORMAT=\'YYYY-MM-DD HH24:MI:SSXFF\'', '', 'srv "s_2_1"'); 5let $CHILD2_1_DROP_TABLES= 6 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "ta_r"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 7let $CHILD2_1_CREATE_TABLES= 8 SELECT spider_direct_sql('CREATE TABLE "ta_r" ( 9 "a" INT DEFAULT 10, 10 "b" CHAR(1) DEFAULT \'c\', 11 "c" DATE DEFAULT TO_DATE(\'1999-10-10 10:10:10\', \'YYYY-MM-DD HH24:MI:SS\'), 12 CONSTRAINT "pk_s_2_1_ta_r" PRIMARY KEY("a") 13 )', '', 'srv "s_2_1"') 14 $STR_SEMICOLON 15 SELECT spider_direct_sql('CREATE INDEX "idx1" ON "ta_r"("b")', '', 'srv "s_2_1"'); 16let $CHILD2_1_SELECT_TABLES= 17 SELECT spider_direct_sql('SELECT "a", "b", TO_CHAR("c", \'YYYY-MM-DD HH24:MI:SS\') FROM "ta_r" ORDER BY "a"', '', 'srv "s_2_1"'); 18let $CHILD2_1_DROP_TABLES2= 19 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "ta_r2"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 20let $CHILD2_1_CREATE_TABLES2= 21 SELECT spider_direct_sql('CREATE TABLE "ta_r2" ( 22 "a" INT DEFAULT 10, 23 "b" CHAR(1) DEFAULT \'c\', 24 "c" DATE DEFAULT TO_DATE(\'1999-10-10 10:10:10\', \'YYYY-MM-DD HH24:MI:SS\'), 25 CONSTRAINT "pk_s_2_1_ta_r2" PRIMARY KEY("a") 26 )', '', 'srv "s_2_1"'); 27let $CHILD2_1_SELECT_TABLES2= 28 SELECT spider_direct_sql('SELECT "a", "b", TO_CHAR("c", \'YYYY-MM-DD HH24:MI:SS\') FROM "ta_r2" ORDER BY "a"', '', 'srv "s_2_1"'); 29let $CHILD2_1_DROP_TABLES3= 30 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "ta_r_no_idx"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 31let $CHILD2_1_CREATE_TABLES3= 32 SELECT spider_direct_sql('CREATE TABLE "ta_r_no_idx" ( 33 "a" INT DEFAULT 10, 34 "b" CHAR(1) DEFAULT \'c\', 35 "c" DATE DEFAULT TO_DATE(\'1999-10-10 10:10:10\', \'YYYY-MM-DD HH24:MI:SS\') 36 )', '', 'srv "s_2_1"'); 37let $CHILD2_1_SELECT_TABLES3= 38 SELECT spider_direct_sql('SELECT "a", "b", TO_CHAR("c", \'YYYY-MM-DD HH24:MI:SS\') FROM "ta_r_no_idx" ORDER BY "a"', '', 'srv "s_2_1"'); 39let $CHILD2_1_DROP_TABLES4= 40 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "ta_r_auto_inc"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 41let $CHILD2_1_CREATE_TABLES4= 42 SELECT spider_direct_sql('CREATE TABLE "ta_r_auto_inc" ( 43 "a" INT DEFAULT 10, 44 "b" CHAR(1) DEFAULT \'c\', 45 "c" DATE DEFAULT TO_DATE(\'1999-10-10 10:10:10\', \'YYYY-MM-DD HH24:MI:SS\'), 46 CONSTRAINT "pk_s_2_1_ta_r_auto_inc" PRIMARY KEY("a") 47 )', '', 'srv "s_2_1"'); 48let $CHILD2_1_SELECT_TABLES4= 49 SELECT spider_direct_sql('SELECT "a", "b", TO_CHAR("c", \'YYYY-MM-DD HH24:MI:SS\') FROM "ta_r_auto_inc" 50 ORDER BY "a"', '', 'srv "s_2_1"'); 51let $CHILD2_1_DROP_TABLES5= 52 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "s_2_1_ta_r_int"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 53let $CHILD2_1_CREATE_TABLES5= 54 SELECT spider_direct_sql('CREATE TABLE "s_2_1_ta_r_int" ( 55 "a" INT DEFAULT 3, 56 "b" INT DEFAULT 10, 57 "c" INT DEFAULT 11, 58 CONSTRAINT "pk_s_2_1_ta_r_int" PRIMARY KEY("a") 59 )', '', 'srv "s_2_1"') 60 $STR_SEMICOLON 61 SELECT spider_direct_sql('CREATE INDEX "idx1_s_2_1_ta_r_int" ON "s_2_1_ta_r_int"("b")', '', 'srv "s_2_1"') 62 $STR_SEMICOLON 63 SELECT spider_direct_sql('CREATE INDEX "idx2_s_2_1_ta_r_int" ON "s_2_1_ta_r_int"("c")', '', 'srv "s_2_1"'); 64let $CHILD2_1_SELECT_TABLES5= 65 SELECT spider_direct_sql('SELECT "a", "b", "c" FROM "s_2_1_ta_r_int" ORDER BY "a"', '', 'srv "s_2_1"'); 66let $CHILD2_1_DROP_TABLES6= 67 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "ta_r_3"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 68let $CHILD2_1_CREATE_TABLES6= 69 SELECT spider_direct_sql('CREATE TABLE "ta_r_3" ( 70 "a" INT DEFAULT 10, 71 "b" CHAR(1) DEFAULT \'c\', 72 "c" DATE DEFAULT TO_DATE(\'1999-10-10 10:10:10\', \'YYYY-MM-DD HH24:MI:SS\') 73 )', '', 'srv "s_2_1"'); 74let $CHILD2_1_SELECT_TABLES6= 75 SELECT spider_direct_sql('SELECT "a", "b", TO_CHAR("c", \'YYYY-MM-DD HH24:MI:SS\') FROM "ta_r_3" ORDER BY "a"', '', 'srv "s_2_1"'); 76let $CHILD2_1_DROP_FT_TABLES= 77 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "ft_r"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 78let $CHILD2_1_CREATE_FT_TABLES= 79 SELECT spider_direct_sql('CREATE TABLE "ft_r" ( 80 "a" INT DEFAULT 0, 81 "b" TEXT, 82 "c" TEXT, 83 "d" TEXT, 84 CONSTRAINT "pk_s_2_1_ft_r" PRIMARY KEY("a"), 85 FULLTEXT INDEX "ft_idx1"("b"), 86 FULLTEXT INDEX "ft_idx2"("c") 87 )', '', 'srv "s_2_1"'); 88let $CHILD2_1_SELECT_FT_TABLES= 89 SELECT spider_direct_sql('SELECT "a", "b", "c", "d" FROM "ft_r" ORDER BY "a"', '', 'srv "s_2_1"'); 90let $CHILD2_1_DROP_FT_TABLES2= 91 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "ft_r2"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 92let $CHILD2_1_CREATE_FT_TABLES2= 93 SELECT spider_direct_sql('CREATE TABLE "ft_r2" ( 94 "a" INT DEFAULT 0, 95 "b" TEXT, 96 "c" TEXT, 97 "d" TEXT, 98 CONSTRAINT "pk_s_2_1_ft_r2" PRIMARY KEY("a"), 99 FULLTEXT INDEX "ft_idx1"("b"), 100 FULLTEXT INDEX "ft_idx2"("c") 101 )', '', 'srv "s_2_1"'); 102let $CHILD2_1_SELECT_FT_TABLES2= 103 SELECT spider_direct_sql('SELECT "a", "b", "c", "d" FROM "ft_r2" ORDER BY "a"', '', 'srv "s_2_1"'); 104let $CHILD2_1_DROP_GM_TABLES= 105 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "gm_r"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 106let $CHILD2_1_CREATE_GM_TABLES= 107 SELECT spider_direct_sql('CREATE TABLE "gm_r" ( 108 "a" INT DEFAULT 0, 109 "b" GEOMETRY NOT NULL, 110 "c" GEOMETRY NOT NULL, 111 CONSTRAINT "pk_s_2_1_gm_r" PRIMARY KEY("a"), 112 SPATIAL INDEX "sp_idx1"("b"), 113 SPATIAL INDEX "sp_idx2"("c") 114 )', '', 'srv "s_2_1"'); 115let $CHILD2_1_SELECT_GM_TABLES= 116 SELECT spider_direct_sql('SELECT "a", "b", "c" FROM "gm_r" ORDER BY "a"', '', 'srv "s_2_1"'); 117let $CHILD2_1_DROP_GM_TABLES2= 118 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "gm_r2"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 119let $CHILD2_1_CREATE_GM_TABLES2= 120 SELECT spider_direct_sql('CREATE TABLE "gm_r2" ( 121 "a" INT DEFAULT 0, 122 "b" GEOMETRY NOT NULL, 123 "c" GEOMETRY NOT NULL, 124 CONSTRAINT "pk_s_2_1_gm_r2" PRIMARY KEY("a"), 125 SPATIAL INDEX "sp_idx1"("b"), 126 SPATIAL INDEX "sp_idx2"("c") 127 )', '', 'srv "s_2_1"'); 128let $CHILD2_1_SELECT_GM_TABLES2= 129 SELECT spider_direct_sql('SELECT "a", "b", "c" FROM "gm_r2" ORDER BY "a"', '', 'srv "s_2_1"'); 130let $CHILD2_1_DROP_LOCK_TABLES1= 131 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "t1_1"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 132let $CHILD2_1_CREATE_LOCK_TABLES1= 133 SELECT spider_direct_sql('CREATE TABLE "t1_1" ( 134 "id" INT NOT NULL, 135 CONSTRAINT "pk_s_2_1_t1_1" PRIMARY KEY ("id") 136 )', '', 'srv "s_2_1"'); 137let $CHILD2_1_DROP_LOCK_TABLES2= 138 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "t2_2"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 139let $CHILD2_1_CREATE_LOCK_TABLES2= 140 SELECT spider_direct_sql('CREATE TABLE "t2_2" ( 141 "id" INT NOT NULL, 142 CONSTRAINT "pk_s_2_1_t2_2" PRIMARY KEY ("id") 143 )', '', 'srv "s_2_1"'); 144let $CHILD2_1_DROP_INCREMENT_TABLES1= 145 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "t1_1"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 146let $CHILD2_1_CREATE_INCREMENT_TABLES1= 147 SELECT spider_direct_sql('CREATE TABLE "t1_1" ( 148 "id" INT NOT NULL, 149 CONSTRAINT "pk_s_2_1_t1_1" PRIMARY KEY ("id") 150 )', '', 'srv "s_2_1"'); 151let $CHILD2_1_SELECT_INCREMENT_TABLES1= 152 SELECT spider_direct_sql('SELECT "id" FROM "t1_1" ORDER BY "id"', '', 'srv "s_2_1"'); 153let $CHILD2_1_DROP_TEXT_PK_TABLES1= 154 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "t1"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 155let $CHILD2_1_CREATE_TEXT_PK_TABLES1= 156 SELECT spider_direct_sql('CREATE TABLE "t1" ( 157 "a" VARCHAR(255), 158 CONSTRAINT "pk_s_2_1_t1" PRIMARY KEY ("a") 159 )', '', 'srv "s_2_1"'); 160let $CHILD2_1_SELECT_TEXT_PK_TABLES1= 161 SELECT spider_direct_sql('SELECT "a" FROM "t1" ORDER BY "a"', '', 'srv "s_2_1"'); 162let $CHILD2_1_DROP_TEXT_KEY_TABLES1= 163 SELECT spider_direct_sql('begin execute immediate \'DROP TABLE "t1"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"'); 164let $CHILD2_1_CREATE_TEXT_KEY_TABLES1= 165 SELECT spider_direct_sql('CREATE TABLE "t1" ( 166 "a" VARCHAR(255), 167 "b" VARCHAR(255), 168 "c" VARCHAR(255), 169 CONSTRAINT "pk_s_2_1_t1" PRIMARY KEY ("c") 170 )', '', 'srv "s_2_1"') 171 $STR_SEMICOLON 172 SELECT spider_direct_sql('CREATE INDEX "idx1_t1" ON "t1"("a","b")', '', 'srv "s_2_1"') 173 $STR_SEMICOLON 174 SELECT spider_direct_sql('CREATE INDEX "idx2_t1" ON "t1"("b")', '', 'srv "s_2_1"'); 175let $CHILD2_1_SELECT_TEXT_KEY_TABLES1= 176 SELECT spider_direct_sql('SELECT "a", "b", "c" FROM "t1" ORDER BY "c"', '', 'srv "s_2_1"'); 177let $CHILD2_1_AUTO_INCREMENT_INCREMENT1= 178 SELECT spider_direct_sql('begin execute immediate \'DROP SEQUENCE "seq_t1_1"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"') 179 $STR_SEMICOLON 180 SELECT spider_direct_sql('CREATE SEQUENCE "seq_t1_1" START WITH 1 INCREMENT BY 1', '', 'srv "s_2_1"'); 181let $CHILD2_1_AUTO_INCREMENT_INCREMENT2= 182 SELECT spider_direct_sql('begin execute immediate \'DROP SEQUENCE "seq_t1_1"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"') 183 $STR_SEMICOLON 184 SELECT spider_direct_sql('CREATE SEQUENCE "seq_t1_1" START WITH 2 INCREMENT BY 4', '', 'srv "s_2_1"'); 185let $CHILD2_1_AUTO_INCREMENT_OFFSET1= 186 SELECT spider_direct_sql('begin execute immediate \'DROP SEQUENCE "seq_t1_1"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"') 187 $STR_SEMICOLON 188 SELECT spider_direct_sql('CREATE SEQUENCE "seq_t1_1" START WITH 1 INCREMENT BY 1', '', 'srv "s_2_1"'); 189let $CHILD2_1_AUTO_INCREMENT_OFFSET2= 190 SELECT spider_direct_sql('begin execute immediate \'DROP SEQUENCE "seq_t1_1"\'$STR_SEMICOLON exception when others then null$STR_SEMICOLON end$STR_SEMICOLON', '', 'srv "s_2_1"') 191 $STR_SEMICOLON 192 SELECT spider_direct_sql('CREATE SEQUENCE "seq_t1_1" START WITH 2 INCREMENT BY 4', '', 'srv "s_2_1"'); 193