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

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