"Fossies" - the Fresh Open Source Software Archive

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