"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/t/683310.test" (6 May 2012, 13572 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 # Test concurrency operation on create table
    2 
    3 # This is here so that something appears in the log, otherwise test-run
    4 # complains.
    5 SELECT 1;
    6 
    7 CREATE SCHEMA drizzleslap;
    8 
    9 USE drizzleslap;
   10 
   11 CREATE TABLE bench1 (field_search SERIAL, field1 int DEFAULT 1, field2 int DEFAULT 1, field3 int DEFAULT 1, field4 int DEFAULT 1, field5 int DEFAULT 1);
   12 INSERT INTO bench1 (field1, field2, field3, field4, field5) SELECT value, value, value, value, value from data_dictionary.random_number LIMIT 255;
   13 
   14 UPDATE bench1 SET field5=1 WHERE field_search=1;
   15 UPDATE bench1 SET field5=1 WHERE field_search=2;
   16 UPDATE bench1 SET field5=1 WHERE field_search=3;
   17 UPDATE bench1 SET field5=1 WHERE field_search=4;
   18 UPDATE bench1 SET field5=1 WHERE field_search=5;
   19 UPDATE bench1 SET field5=1 WHERE field_search=6;
   20 UPDATE bench1 SET field5=1 WHERE field_search=7;
   21 UPDATE bench1 SET field5=1 WHERE field_search=8;
   22 UPDATE bench1 SET field5=1 WHERE field_search=9;
   23 UPDATE bench1 SET field5=1 WHERE field_search=10;
   24 UPDATE bench1 SET field5=1 WHERE field_search=11;
   25 UPDATE bench1 SET field5=1 WHERE field_search=12;
   26 UPDATE bench1 SET field5=1 WHERE field_search=13;
   27 UPDATE bench1 SET field5=1 WHERE field_search=14;
   28 UPDATE bench1 SET field5=1 WHERE field_search=15;
   29 UPDATE bench1 SET field5=1 WHERE field_search=16;
   30 UPDATE bench1 SET field5=1 WHERE field_search=17;
   31 UPDATE bench1 SET field5=1 WHERE field_search=18;
   32 UPDATE bench1 SET field5=1 WHERE field_search=19;
   33 UPDATE bench1 SET field5=1 WHERE field_search=20;
   34 UPDATE bench1 SET field5=1 WHERE field_search=21;
   35 UPDATE bench1 SET field5=1 WHERE field_search=22;
   36 UPDATE bench1 SET field5=1 WHERE field_search=23;
   37 UPDATE bench1 SET field5=1 WHERE field_search=24;
   38 UPDATE bench1 SET field5=1 WHERE field_search=25;
   39 UPDATE bench1 SET field5=1 WHERE field_search=26;
   40 UPDATE bench1 SET field5=1 WHERE field_search=27;
   41 UPDATE bench1 SET field5=1 WHERE field_search=28;
   42 UPDATE bench1 SET field5=1 WHERE field_search=29;
   43 UPDATE bench1 SET field5=1 WHERE field_search=30;
   44 UPDATE bench1 SET field5=1 WHERE field_search=31;
   45 UPDATE bench1 SET field5=1 WHERE field_search=32;
   46 UPDATE bench1 SET field5=1 WHERE field_search=33;
   47 UPDATE bench1 SET field5=1 WHERE field_search=34;
   48 UPDATE bench1 SET field5=1 WHERE field_search=35;
   49 UPDATE bench1 SET field5=1 WHERE field_search=36;
   50 UPDATE bench1 SET field5=1 WHERE field_search=37;
   51 UPDATE bench1 SET field5=1 WHERE field_search=38;
   52 UPDATE bench1 SET field5=1 WHERE field_search=39;
   53 UPDATE bench1 SET field5=1 WHERE field_search=40;
   54 UPDATE bench1 SET field5=1 WHERE field_search=41;
   55 UPDATE bench1 SET field5=1 WHERE field_search=42;
   56 UPDATE bench1 SET field5=1 WHERE field_search=43;
   57 UPDATE bench1 SET field5=1 WHERE field_search=44;
   58 UPDATE bench1 SET field5=1 WHERE field_search=45;
   59 UPDATE bench1 SET field5=1 WHERE field_search=46;
   60 UPDATE bench1 SET field5=1 WHERE field_search=47;
   61 UPDATE bench1 SET field5=1 WHERE field_search=48;
   62 UPDATE bench1 SET field5=1 WHERE field_search=49;
   63 UPDATE bench1 SET field5=1 WHERE field_search=50;
   64 UPDATE bench1 SET field5=1 WHERE field_search=51;
   65 UPDATE bench1 SET field5=1 WHERE field_search=52;
   66 UPDATE bench1 SET field5=1 WHERE field_search=53;
   67 UPDATE bench1 SET field5=1 WHERE field_search=54;
   68 UPDATE bench1 SET field5=1 WHERE field_search=55;
   69 UPDATE bench1 SET field5=1 WHERE field_search=56;
   70 UPDATE bench1 SET field5=1 WHERE field_search=57;
   71 UPDATE bench1 SET field5=1 WHERE field_search=58;
   72 UPDATE bench1 SET field5=1 WHERE field_search=59;
   73 UPDATE bench1 SET field5=1 WHERE field_search=60;
   74 UPDATE bench1 SET field5=1 WHERE field_search=61;
   75 UPDATE bench1 SET field5=1 WHERE field_search=62;
   76 UPDATE bench1 SET field5=1 WHERE field_search=63;
   77 UPDATE bench1 SET field5=1 WHERE field_search=64;
   78 UPDATE bench1 SET field5=1 WHERE field_search=65;
   79 UPDATE bench1 SET field5=1 WHERE field_search=66;
   80 UPDATE bench1 SET field5=1 WHERE field_search=67;
   81 UPDATE bench1 SET field5=1 WHERE field_search=68;
   82 UPDATE bench1 SET field5=1 WHERE field_search=69;
   83 UPDATE bench1 SET field5=1 WHERE field_search=70;
   84 UPDATE bench1 SET field5=1 WHERE field_search=71;
   85 UPDATE bench1 SET field5=1 WHERE field_search=72;
   86 UPDATE bench1 SET field5=1 WHERE field_search=73;
   87 UPDATE bench1 SET field5=1 WHERE field_search=74;
   88 UPDATE bench1 SET field5=1 WHERE field_search=75;
   89 UPDATE bench1 SET field5=1 WHERE field_search=76;
   90 UPDATE bench1 SET field5=1 WHERE field_search=77;
   91 UPDATE bench1 SET field5=1 WHERE field_search=78;
   92 UPDATE bench1 SET field5=1 WHERE field_search=79;
   93 UPDATE bench1 SET field5=1 WHERE field_search=80;
   94 UPDATE bench1 SET field5=1 WHERE field_search=81;
   95 UPDATE bench1 SET field5=1 WHERE field_search=82;
   96 UPDATE bench1 SET field5=1 WHERE field_search=83;
   97 UPDATE bench1 SET field5=1 WHERE field_search=84;
   98 UPDATE bench1 SET field5=1 WHERE field_search=85;
   99 UPDATE bench1 SET field5=1 WHERE field_search=86;
  100 UPDATE bench1 SET field5=1 WHERE field_search=87;
  101 UPDATE bench1 SET field5=1 WHERE field_search=88;
  102 UPDATE bench1 SET field5=1 WHERE field_search=89;
  103 UPDATE bench1 SET field5=1 WHERE field_search=90;
  104 UPDATE bench1 SET field5=1 WHERE field_search=91;
  105 UPDATE bench1 SET field5=1 WHERE field_search=92;
  106 UPDATE bench1 SET field5=1 WHERE field_search=93;
  107 UPDATE bench1 SET field5=1 WHERE field_search=94;
  108 UPDATE bench1 SET field5=1 WHERE field_search=95;
  109 UPDATE bench1 SET field5=1 WHERE field_search=96;
  110 UPDATE bench1 SET field5=1 WHERE field_search=97;
  111 UPDATE bench1 SET field5=1 WHERE field_search=98;
  112 UPDATE bench1 SET field5=1 WHERE field_search=99;
  113 UPDATE bench1 SET field5=1 WHERE field_search=100;
  114 UPDATE bench1 SET field5=1 WHERE field_search=101;
  115 UPDATE bench1 SET field5=1 WHERE field_search=102;
  116 UPDATE bench1 SET field5=1 WHERE field_search=103;
  117 UPDATE bench1 SET field5=1 WHERE field_search=104;
  118 UPDATE bench1 SET field5=1 WHERE field_search=105;
  119 UPDATE bench1 SET field5=1 WHERE field_search=106;
  120 UPDATE bench1 SET field5=1 WHERE field_search=107;
  121 UPDATE bench1 SET field5=1 WHERE field_search=108;
  122 UPDATE bench1 SET field5=1 WHERE field_search=109;
  123 UPDATE bench1 SET field5=1 WHERE field_search=110;
  124 UPDATE bench1 SET field5=1 WHERE field_search=111;
  125 UPDATE bench1 SET field5=1 WHERE field_search=112;
  126 UPDATE bench1 SET field5=1 WHERE field_search=113;
  127 UPDATE bench1 SET field5=1 WHERE field_search=114;
  128 UPDATE bench1 SET field5=1 WHERE field_search=115;
  129 UPDATE bench1 SET field5=1 WHERE field_search=116;
  130 UPDATE bench1 SET field5=1 WHERE field_search=117;
  131 UPDATE bench1 SET field5=1 WHERE field_search=118;
  132 UPDATE bench1 SET field5=1 WHERE field_search=119;
  133 UPDATE bench1 SET field5=1 WHERE field_search=120;
  134 UPDATE bench1 SET field5=1 WHERE field_search=121;
  135 UPDATE bench1 SET field5=1 WHERE field_search=122;
  136 UPDATE bench1 SET field5=1 WHERE field_search=123;
  137 UPDATE bench1 SET field5=1 WHERE field_search=124;
  138 UPDATE bench1 SET field5=1 WHERE field_search=125;
  139 UPDATE bench1 SET field5=1 WHERE field_search=126;
  140 UPDATE bench1 SET field5=1 WHERE field_search=127;
  141 UPDATE bench1 SET field5=1 WHERE field_search=128;
  142 UPDATE bench1 SET field5=1 WHERE field_search=129;
  143 UPDATE bench1 SET field5=1 WHERE field_search=130;
  144 UPDATE bench1 SET field5=1 WHERE field_search=131;
  145 UPDATE bench1 SET field5=1 WHERE field_search=132;
  146 UPDATE bench1 SET field5=1 WHERE field_search=133;
  147 UPDATE bench1 SET field5=1 WHERE field_search=134;
  148 UPDATE bench1 SET field5=1 WHERE field_search=135;
  149 UPDATE bench1 SET field5=1 WHERE field_search=136;
  150 UPDATE bench1 SET field5=1 WHERE field_search=137;
  151 UPDATE bench1 SET field5=1 WHERE field_search=138;
  152 UPDATE bench1 SET field5=1 WHERE field_search=139;
  153 UPDATE bench1 SET field5=1 WHERE field_search=140;
  154 UPDATE bench1 SET field5=1 WHERE field_search=141;
  155 UPDATE bench1 SET field5=1 WHERE field_search=142;
  156 UPDATE bench1 SET field5=1 WHERE field_search=143;
  157 UPDATE bench1 SET field5=1 WHERE field_search=144;
  158 UPDATE bench1 SET field5=1 WHERE field_search=145;
  159 UPDATE bench1 SET field5=1 WHERE field_search=146;
  160 UPDATE bench1 SET field5=1 WHERE field_search=147;
  161 UPDATE bench1 SET field5=1 WHERE field_search=148;
  162 UPDATE bench1 SET field5=1 WHERE field_search=149;
  163 UPDATE bench1 SET field5=1 WHERE field_search=150;
  164 UPDATE bench1 SET field5=1 WHERE field_search=151;
  165 UPDATE bench1 SET field5=1 WHERE field_search=152;
  166 UPDATE bench1 SET field5=1 WHERE field_search=153;
  167 UPDATE bench1 SET field5=1 WHERE field_search=154;
  168 UPDATE bench1 SET field5=1 WHERE field_search=155;
  169 UPDATE bench1 SET field5=1 WHERE field_search=156;
  170 UPDATE bench1 SET field5=1 WHERE field_search=157;
  171 UPDATE bench1 SET field5=1 WHERE field_search=158;
  172 UPDATE bench1 SET field5=1 WHERE field_search=159;
  173 UPDATE bench1 SET field5=1 WHERE field_search=160;
  174 UPDATE bench1 SET field5=1 WHERE field_search=161;
  175 UPDATE bench1 SET field5=1 WHERE field_search=162;
  176 UPDATE bench1 SET field5=1 WHERE field_search=163;
  177 UPDATE bench1 SET field5=1 WHERE field_search=164;
  178 UPDATE bench1 SET field5=1 WHERE field_search=165;
  179 UPDATE bench1 SET field5=1 WHERE field_search=166;
  180 UPDATE bench1 SET field5=1 WHERE field_search=167;
  181 UPDATE bench1 SET field5=1 WHERE field_search=168;
  182 UPDATE bench1 SET field5=1 WHERE field_search=169;
  183 UPDATE bench1 SET field5=1 WHERE field_search=170;
  184 UPDATE bench1 SET field5=1 WHERE field_search=171;
  185 UPDATE bench1 SET field5=1 WHERE field_search=172;
  186 UPDATE bench1 SET field5=1 WHERE field_search=173;
  187 UPDATE bench1 SET field5=1 WHERE field_search=174;
  188 UPDATE bench1 SET field5=1 WHERE field_search=175;
  189 UPDATE bench1 SET field5=1 WHERE field_search=176;
  190 UPDATE bench1 SET field5=1 WHERE field_search=177;
  191 UPDATE bench1 SET field5=1 WHERE field_search=178;
  192 UPDATE bench1 SET field5=1 WHERE field_search=179;
  193 UPDATE bench1 SET field5=1 WHERE field_search=180;
  194 UPDATE bench1 SET field5=1 WHERE field_search=181;
  195 UPDATE bench1 SET field5=1 WHERE field_search=182;
  196 UPDATE bench1 SET field5=1 WHERE field_search=183;
  197 UPDATE bench1 SET field5=1 WHERE field_search=184;
  198 UPDATE bench1 SET field5=1 WHERE field_search=185;
  199 UPDATE bench1 SET field5=1 WHERE field_search=186;
  200 UPDATE bench1 SET field5=1 WHERE field_search=187;
  201 UPDATE bench1 SET field5=1 WHERE field_search=188;
  202 UPDATE bench1 SET field5=1 WHERE field_search=189;
  203 UPDATE bench1 SET field5=1 WHERE field_search=190;
  204 UPDATE bench1 SET field5=1 WHERE field_search=191;
  205 UPDATE bench1 SET field5=1 WHERE field_search=192;
  206 UPDATE bench1 SET field5=1 WHERE field_search=193;
  207 UPDATE bench1 SET field5=1 WHERE field_search=194;
  208 UPDATE bench1 SET field5=1 WHERE field_search=195;
  209 UPDATE bench1 SET field5=1 WHERE field_search=196;
  210 UPDATE bench1 SET field5=1 WHERE field_search=197;
  211 UPDATE bench1 SET field5=1 WHERE field_search=198;
  212 UPDATE bench1 SET field5=1 WHERE field_search=199;
  213 UPDATE bench1 SET field5=1 WHERE field_search=200;
  214 UPDATE bench1 SET field5=1 WHERE field_search=201;
  215 UPDATE bench1 SET field5=1 WHERE field_search=202;
  216 UPDATE bench1 SET field5=1 WHERE field_search=203;
  217 UPDATE bench1 SET field5=1 WHERE field_search=204;
  218 UPDATE bench1 SET field5=1 WHERE field_search=205;
  219 UPDATE bench1 SET field5=1 WHERE field_search=206;
  220 UPDATE bench1 SET field5=1 WHERE field_search=207;
  221 UPDATE bench1 SET field5=1 WHERE field_search=208;
  222 UPDATE bench1 SET field5=1 WHERE field_search=209;
  223 UPDATE bench1 SET field5=1 WHERE field_search=210;
  224 UPDATE bench1 SET field5=1 WHERE field_search=211;
  225 UPDATE bench1 SET field5=1 WHERE field_search=212;
  226 UPDATE bench1 SET field5=1 WHERE field_search=213;
  227 UPDATE bench1 SET field5=1 WHERE field_search=214;
  228 UPDATE bench1 SET field5=1 WHERE field_search=215;
  229 UPDATE bench1 SET field5=1 WHERE field_search=216;
  230 UPDATE bench1 SET field5=1 WHERE field_search=217;
  231 UPDATE bench1 SET field5=1 WHERE field_search=218;
  232 UPDATE bench1 SET field5=1 WHERE field_search=219;
  233 UPDATE bench1 SET field5=1 WHERE field_search=220;
  234 UPDATE bench1 SET field5=1 WHERE field_search=221;
  235 UPDATE bench1 SET field5=1 WHERE field_search=222;
  236 UPDATE bench1 SET field5=1 WHERE field_search=223;
  237 UPDATE bench1 SET field5=1 WHERE field_search=224;
  238 UPDATE bench1 SET field5=1 WHERE field_search=225;
  239 UPDATE bench1 SET field5=1 WHERE field_search=226;
  240 UPDATE bench1 SET field5=1 WHERE field_search=227;
  241 UPDATE bench1 SET field5=1 WHERE field_search=228;
  242 UPDATE bench1 SET field5=1 WHERE field_search=229;
  243 UPDATE bench1 SET field5=1 WHERE field_search=230;
  244 UPDATE bench1 SET field5=1 WHERE field_search=231;
  245 UPDATE bench1 SET field5=1 WHERE field_search=232;
  246 UPDATE bench1 SET field5=1 WHERE field_search=233;
  247 UPDATE bench1 SET field5=1 WHERE field_search=234;
  248 UPDATE bench1 SET field5=1 WHERE field_search=235;
  249 UPDATE bench1 SET field5=1 WHERE field_search=236;
  250 UPDATE bench1 SET field5=1 WHERE field_search=237;
  251 UPDATE bench1 SET field5=1 WHERE field_search=238;
  252 UPDATE bench1 SET field5=1 WHERE field_search=239;
  253 UPDATE bench1 SET field5=1 WHERE field_search=240;
  254 UPDATE bench1 SET field5=1 WHERE field_search=241;
  255 UPDATE bench1 SET field5=1 WHERE field_search=242;
  256 UPDATE bench1 SET field5=1 WHERE field_search=243;
  257 UPDATE bench1 SET field5=1 WHERE field_search=244;
  258 UPDATE bench1 SET field5=1 WHERE field_search=245;
  259 UPDATE bench1 SET field5=1 WHERE field_search=246;
  260 UPDATE bench1 SET field5=1 WHERE field_search=247;
  261 UPDATE bench1 SET field5=1 WHERE field_search=248;
  262 UPDATE bench1 SET field5=1 WHERE field_search=249;
  263 UPDATE bench1 SET field5=1 WHERE field_search=250;
  264 UPDATE bench1 SET field5=1 WHERE field_search=251;
  265 UPDATE bench1 SET field5=1 WHERE field_search=252;
  266 UPDATE bench1 SET field5=1 WHERE field_search=253;
  267 UPDATE bench1 SET field5=1 WHERE field_search=254;
  268 UPDATE bench1 SET field5=1 WHERE field_search=255;
  269 
  270 # We want to know that atleast one insert happened
  271 SELECT if((count(field_search) = 255), "YES", "NO") from drizzleslap.bench1;
  272 
  273 drop table drizzleslap.bench1;
  274 drop schema drizzleslap;