release/src/router/mysql/mysql-test/suite/engines/funcs/r/rpl_loadfile.result

   1 stop slave;
   2 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
   3 reset master;
   4 reset slave;
   5 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
   6 start slave;
   7 DROP PROCEDURE IF EXISTS test.p1;
   8 DROP TABLE IF EXISTS test.t1;
   9 CREATE TABLE test.t1 (a INT, blob_column LONGBLOB, PRIMARY KEY(a));
  10 INSERT INTO test.t1  VALUES(1,'test');
  11 UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=1;
  12 create procedure test.p1()
  13 begin
  14 INSERT INTO test.t1  VALUES(2,'test');
  15 UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=2;
  16 end|
  17 CALL test.p1();
  18 SELECT * FROM test.t1 ORDER BY blob_column;
  19 a       blob_column
  20 1       abase
  21 abased
  22 abasement
  23 abasements
  24 abases
  25 abash
  26 abashed
  27 abashes
  28 abashing
  29 abasing
  30 abate
  31 abated
  32 abatement
  33 abatements
  34 abater
  35 abates
  36 abating
  37 Abba
  38 abbe
  39 abbey
  40 abbeys
  41 abbot
  42 abbots
  43 Abbott
  44 abbreviate
  45 abbreviated
  46 abbreviates
  47 abbreviating
  48 abbreviation
  49 abbreviations
  50 Abby
  51 abdomen
  52 abdomens
  53 abdominal
  54 abduct
  55 abducted
  56 abduction
  57 abductions
  58 abductor
  59 abductors
  60 abducts
  61 Abe
  62 abed
  63 Abel
  64 Abelian
  65 Abelson
  66 Aberdeen
  67 Abernathy
  68 aberrant
  69 aberration
  70
  71 2       abase
  72 abased
  73 abasement
  74 abasements
  75 abases
  76 abash
  77 abashed
  78 abashes
  79 abashing
  80 abasing
  81 abate
  82 abated
  83 abatement
  84 abatements
  85 abater
  86 abates
  87 abating
  88 Abba
  89 abbe
  90 abbey
  91 abbeys
  92 abbot
  93 abbots
  94 Abbott
  95 abbreviate
  96 abbreviated
  97 abbreviates
  98 abbreviating
  99 abbreviation
 100 abbreviations
 101 Abby
 102 abdomen
 103 abdomens
 104 abdominal
 105 abduct
 106 abducted
 107 abduction
 108 abductions
 109 abductor
 110 abductors
 111 abducts
 112 Abe
 113 abed
 114 Abel
 115 Abelian
 116 Abelson
 117 Aberdeen
 118 Abernathy
 119 aberrant
 120 aberration
 121
 122 SELECT * FROM test.t1 ORDER BY blob_column;
 123 a       blob_column
 124 1       abase
 125 abased
 126 abasement
 127 abasements
 128 abases
 129 abash
 130 abashed
 131 abashes
 132 abashing
 133 abasing
 134 abate
 135 abated
 136 abatement
 137 abatements
 138 abater
 139 abates
 140 abating
 141 Abba
 142 abbe
 143 abbey
 144 abbeys
 145 abbot
 146 abbots
 147 Abbott
 148 abbreviate
 149 abbreviated
 150 abbreviates
 151 abbreviating
 152 abbreviation
 153 abbreviations
 154 Abby
 155 abdomen
 156 abdomens
 157 abdominal
 158 abduct
 159 abducted
 160 abduction
 161 abductions
 162 abductor
 163 abductors
 164 abducts
 165 Abe
 166 abed
 167 Abel
 168 Abelian
 169 Abelson
 170 Aberdeen
 171 Abernathy
 172 aberrant
 173 aberration
 174
 175 2       abase
 176 abased
 177 abasement
 178 abasements
 179 abases
 180 abash
 181 abashed
 182 abashes
 183 abashing
 184 abasing
 185 abate
 186 abated
 187 abatement
 188 abatements
 189 abater
 190 abates
 191 abating
 192 Abba
 193 abbe
 194 abbey
 195 abbeys
 196 abbot
 197 abbots
 198 Abbott
 199 abbreviate
 200 abbreviated
 201 abbreviates
 202 abbreviating
 203 abbreviation
 204 abbreviations
 205 Abby
 206 abdomen
 207 abdomens
 208 abdominal
 209 abduct
 210 abducted
 211 abduction
 212 abductions
 213 abductor
 214 abductors
 215 abducts
 216 Abe
 217 abed
 218 Abel
 219 Abelian
 220 Abelson
 221 Aberdeen
 222 Abernathy
 223 aberrant
 224 aberration
 225
 226 DROP PROCEDURE IF EXISTS test.p1;
 227 DROP TABLE test.t1;