| 1 |
include/master-slave.inc |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 5 |
[connection master] |
| 6 |
# Creating table t1 |
| 7 |
CREATE TABLE t1(c1 INT NOT NULL, c2 INT); |
| 8 |
################################################################### |
| 9 |
# Run plugin |
| 10 |
################################################################### |
| 11 |
INSTALL PLUGIN test_sql_replication SONAME 'TEST_SQL_REPLICATION'; |
| 12 |
################################################################### |
| 13 |
# Stop plugin |
| 14 |
################################################################### |
| 15 |
UNINSTALL PLUGIN test_sql_replication; |
| 16 |
################################################################### |
| 17 |
# Plugin log |
| 18 |
################################################################### |
| 19 |
======================================================================== |
| 20 |
Test in a server thread |
| 21 |
[srv_session_open] |
| 22 |
======================================================================== |
| 23 |
EXECUTING:[35][SELECT 'first complex command' as a] |
| 24 |
[CS_TEXT_REPRESENTATION] |
| 25 |
[meta] rows: 1 |
| 26 |
[meta] cols: 1 |
| 27 |
[meta] server status: 2 |
| 28 |
[meta] server status: AUTOCOMMIT |
| 29 |
[meta] warning count: 0 |
| 30 |
|
| 31 |
[meta][field] db name: |
| 32 |
[meta][field] table name: |
| 33 |
[meta][field] org table name: |
| 34 |
[meta][field] col name: a |
| 35 |
[meta][field] org col name: |
| 36 |
[meta][field] length: 63 |
| 37 |
[meta][field] charsetnr: 33 |
| 38 |
[meta][field] flags: 1 (NOT_NULL ) |
| 39 |
[meta][field] decimals: 31 |
| 40 |
[meta][field] type: VARCHAR (15) |
| 41 |
|
| 42 |
|
| 43 |
[meta][charset result] number: 33 |
| 44 |
[meta][charset result] name: utf8mb3 |
| 45 |
[meta][charset result] collation: utf8mb3_general_ci |
| 46 |
[meta][charset result] sort order: |
| 47 |
|
| 48 |
[data][.a][ 21][first complex command] |
| 49 |
|
| 50 |
[end] server status: 2 |
| 51 |
[end] server status: AUTOCOMMIT |
| 52 |
[end] warning count: 0 |
| 53 |
[end] affected rows: 0 |
| 54 |
[end] last insert id: 0 |
| 55 |
[end] message: |
| 56 |
[CS_BINARY_REPRESENTATION] |
| 57 |
[meta] rows: 1 |
| 58 |
[meta] cols: 1 |
| 59 |
[meta] server status: 2 |
| 60 |
[meta] server status: AUTOCOMMIT |
| 61 |
[meta] warning count: 0 |
| 62 |
|
| 63 |
[meta][field] db name: |
| 64 |
[meta][field] table name: |
| 65 |
[meta][field] org table name: |
| 66 |
[meta][field] col name: a |
| 67 |
[meta][field] org col name: |
| 68 |
[meta][field] length: 63 |
| 69 |
[meta][field] charsetnr: 33 |
| 70 |
[meta][field] flags: 1 (NOT_NULL ) |
| 71 |
[meta][field] decimals: 31 |
| 72 |
[meta][field] type: VARCHAR (15) |
| 73 |
|
| 74 |
|
| 75 |
[meta][charset result] number: 33 |
| 76 |
[meta][charset result] name: utf8mb3 |
| 77 |
[meta][charset result] collation: utf8mb3_general_ci |
| 78 |
[meta][charset result] sort order: |
| 79 |
|
| 80 |
[data][.a][ 21][first complex command] |
| 81 |
|
| 82 |
[end] server status: 2 |
| 83 |
[end] server status: AUTOCOMMIT |
| 84 |
[end] warning count: 0 |
| 85 |
[end] affected rows: 0 |
| 86 |
[end] last insert id: 0 |
| 87 |
[end] message: |
| 88 |
======================================================================== |
| 89 |
EXECUTING:[COM_INIT_DB][test] |
| 90 |
======================================================================== |
| 91 |
EXECUTING:[62][INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,1), (5,2), (6,3)] |
| 92 |
[CS_TEXT_REPRESENTATION] |
| 93 |
[meta] rows: 0 |
| 94 |
[meta] cols: 0 |
| 95 |
[meta] server status: 0 |
| 96 |
[meta] server status: |
| 97 |
[meta] warning count: 0 |
| 98 |
|
| 99 |
[meta] no columns |
| 100 |
|
| 101 |
[meta] no charset |
| 102 |
|
| 103 |
[data] no rows |
| 104 |
|
| 105 |
[end] server status: 2 |
| 106 |
[end] server status: AUTOCOMMIT |
| 107 |
[end] warning count: 0 |
| 108 |
[end] affected rows: 6 |
| 109 |
[end] last insert id: 0 |
| 110 |
[end] message: Records: 6 Duplicates: 0 Warnings: 0 |
| 111 |
======================================================================== |
| 112 |
EXECUTING:[COM_INIT_DB][test] |
| 113 |
======================================================================== |
| 114 |
EXECUTING:[16][SELECT * FROM t1] |
| 115 |
[CS_TEXT_REPRESENTATION] |
| 116 |
[meta] rows: 6 |
| 117 |
[meta] cols: 2 |
| 118 |
[meta] server status: 34 |
| 119 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 120 |
[meta] warning count: 0 |
| 121 |
|
| 122 |
[meta][field] db name: test |
| 123 |
[meta][field] table name: t1 |
| 124 |
[meta][field] org table name: t1 |
| 125 |
[meta][field] col name: c1 |
| 126 |
[meta][field] org col name: c1 |
| 127 |
[meta][field] length: 11 |
| 128 |
[meta][field] charsetnr: 8 |
| 129 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 130 |
[meta][field] decimals: 0 |
| 131 |
[meta][field] type: LONG (3) |
| 132 |
|
| 133 |
[meta][field] db name: test |
| 134 |
[meta][field] table name: t1 |
| 135 |
[meta][field] org table name: t1 |
| 136 |
[meta][field] col name: c2 |
| 137 |
[meta][field] org col name: c2 |
| 138 |
[meta][field] length: 11 |
| 139 |
[meta][field] charsetnr: 8 |
| 140 |
[meta][field] flags: 0 |
| 141 |
[meta][field] decimals: 0 |
| 142 |
[meta][field] type: LONG (3) |
| 143 |
|
| 144 |
|
| 145 |
[meta][charset result] number: 33 |
| 146 |
[meta][charset result] name: utf8mb3 |
| 147 |
[meta][charset result] collation: utf8mb3_general_ci |
| 148 |
[meta][charset result] sort order: |
| 149 |
|
| 150 |
[data][t1.c1][ 1][1] |
| 151 |
[data][t1.c2][ 1][1] |
| 152 |
|
| 153 |
[data][t1.c1][ 1][2] |
| 154 |
[data][t1.c2][ 1][2] |
| 155 |
|
| 156 |
[data][t1.c1][ 1][3] |
| 157 |
[data][t1.c2][ 1][3] |
| 158 |
|
| 159 |
[data][t1.c1][ 1][4] |
| 160 |
[data][t1.c2][ 1][1] |
| 161 |
|
| 162 |
[data][t1.c1][ 1][5] |
| 163 |
[data][t1.c2][ 1][2] |
| 164 |
|
| 165 |
[data][t1.c1][ 1][6] |
| 166 |
[data][t1.c2][ 1][3] |
| 167 |
|
| 168 |
[end] server status: 34 |
| 169 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 170 |
[end] warning count: 0 |
| 171 |
[end] affected rows: 0 |
| 172 |
[end] last insert id: 0 |
| 173 |
[end] message: |
| 174 |
[CS_BINARY_REPRESENTATION] |
| 175 |
[meta] rows: 6 |
| 176 |
[meta] cols: 2 |
| 177 |
[meta] server status: 34 |
| 178 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 179 |
[meta] warning count: 0 |
| 180 |
|
| 181 |
[meta][field] db name: test |
| 182 |
[meta][field] table name: t1 |
| 183 |
[meta][field] org table name: t1 |
| 184 |
[meta][field] col name: c1 |
| 185 |
[meta][field] org col name: c1 |
| 186 |
[meta][field] length: 11 |
| 187 |
[meta][field] charsetnr: 8 |
| 188 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 189 |
[meta][field] decimals: 0 |
| 190 |
[meta][field] type: LONG (3) |
| 191 |
|
| 192 |
[meta][field] db name: test |
| 193 |
[meta][field] table name: t1 |
| 194 |
[meta][field] org table name: t1 |
| 195 |
[meta][field] col name: c2 |
| 196 |
[meta][field] org col name: c2 |
| 197 |
[meta][field] length: 11 |
| 198 |
[meta][field] charsetnr: 8 |
| 199 |
[meta][field] flags: 0 |
| 200 |
[meta][field] decimals: 0 |
| 201 |
[meta][field] type: LONG (3) |
| 202 |
|
| 203 |
|
| 204 |
[meta][charset result] number: 33 |
| 205 |
[meta][charset result] name: utf8mb3 |
| 206 |
[meta][charset result] collation: utf8mb3_general_ci |
| 207 |
[meta][charset result] sort order: |
| 208 |
|
| 209 |
[data][t1.c1][ 1][1] |
| 210 |
[data][t1.c2][ 1][1] |
| 211 |
|
| 212 |
[data][t1.c1][ 1][2] |
| 213 |
[data][t1.c2][ 1][2] |
| 214 |
|
| 215 |
[data][t1.c1][ 1][3] |
| 216 |
[data][t1.c2][ 1][3] |
| 217 |
|
| 218 |
[data][t1.c1][ 1][4] |
| 219 |
[data][t1.c2][ 1][1] |
| 220 |
|
| 221 |
[data][t1.c1][ 1][5] |
| 222 |
[data][t1.c2][ 1][2] |
| 223 |
|
| 224 |
[data][t1.c1][ 1][6] |
| 225 |
[data][t1.c2][ 1][3] |
| 226 |
|
| 227 |
[end] server status: 34 |
| 228 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 229 |
[end] warning count: 0 |
| 230 |
[end] affected rows: 0 |
| 231 |
[end] last insert id: 0 |
| 232 |
[end] message: |
| 233 |
======================================================================== |
| 234 |
EXECUTING:[COM_INIT_DB][test] |
| 235 |
======================================================================== |
| 236 |
EXECUTING:[35][UPDATE t1 SET c1 = 100 WHERE c2 = 2] |
| 237 |
[CS_TEXT_REPRESENTATION] |
| 238 |
[meta] rows: 0 |
| 239 |
[meta] cols: 0 |
| 240 |
[meta] server status: 0 |
| 241 |
[meta] server status: |
| 242 |
[meta] warning count: 0 |
| 243 |
|
| 244 |
[meta] no columns |
| 245 |
|
| 246 |
[meta] no charset |
| 247 |
|
| 248 |
[data] no rows |
| 249 |
|
| 250 |
[end] server status: 34 |
| 251 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 252 |
[end] warning count: 0 |
| 253 |
[end] affected rows: 2 |
| 254 |
[end] last insert id: 0 |
| 255 |
[end] message: Rows matched: 2 Changed: 2 Warnings: 0 |
| 256 |
======================================================================== |
| 257 |
EXECUTING:[COM_INIT_DB][test] |
| 258 |
======================================================================== |
| 259 |
EXECUTING:[16][SELECT * FROM t1] |
| 260 |
[CS_TEXT_REPRESENTATION] |
| 261 |
[meta] rows: 6 |
| 262 |
[meta] cols: 2 |
| 263 |
[meta] server status: 34 |
| 264 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 265 |
[meta] warning count: 0 |
| 266 |
|
| 267 |
[meta][field] db name: test |
| 268 |
[meta][field] table name: t1 |
| 269 |
[meta][field] org table name: t1 |
| 270 |
[meta][field] col name: c1 |
| 271 |
[meta][field] org col name: c1 |
| 272 |
[meta][field] length: 11 |
| 273 |
[meta][field] charsetnr: 8 |
| 274 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 275 |
[meta][field] decimals: 0 |
| 276 |
[meta][field] type: LONG (3) |
| 277 |
|
| 278 |
[meta][field] db name: test |
| 279 |
[meta][field] table name: t1 |
| 280 |
[meta][field] org table name: t1 |
| 281 |
[meta][field] col name: c2 |
| 282 |
[meta][field] org col name: c2 |
| 283 |
[meta][field] length: 11 |
| 284 |
[meta][field] charsetnr: 8 |
| 285 |
[meta][field] flags: 0 |
| 286 |
[meta][field] decimals: 0 |
| 287 |
[meta][field] type: LONG (3) |
| 288 |
|
| 289 |
|
| 290 |
[meta][charset result] number: 33 |
| 291 |
[meta][charset result] name: utf8mb3 |
| 292 |
[meta][charset result] collation: utf8mb3_general_ci |
| 293 |
[meta][charset result] sort order: |
| 294 |
|
| 295 |
[data][t1.c1][ 1][1] |
| 296 |
[data][t1.c2][ 1][1] |
| 297 |
|
| 298 |
[data][t1.c1][ 3][100] |
| 299 |
[data][t1.c2][ 1][2] |
| 300 |
|
| 301 |
[data][t1.c1][ 1][3] |
| 302 |
[data][t1.c2][ 1][3] |
| 303 |
|
| 304 |
[data][t1.c1][ 1][4] |
| 305 |
[data][t1.c2][ 1][1] |
| 306 |
|
| 307 |
[data][t1.c1][ 3][100] |
| 308 |
[data][t1.c2][ 1][2] |
| 309 |
|
| 310 |
[data][t1.c1][ 1][6] |
| 311 |
[data][t1.c2][ 1][3] |
| 312 |
|
| 313 |
[end] server status: 34 |
| 314 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 315 |
[end] warning count: 0 |
| 316 |
[end] affected rows: 0 |
| 317 |
[end] last insert id: 0 |
| 318 |
[end] message: |
| 319 |
[CS_BINARY_REPRESENTATION] |
| 320 |
[meta] rows: 6 |
| 321 |
[meta] cols: 2 |
| 322 |
[meta] server status: 34 |
| 323 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 324 |
[meta] warning count: 0 |
| 325 |
|
| 326 |
[meta][field] db name: test |
| 327 |
[meta][field] table name: t1 |
| 328 |
[meta][field] org table name: t1 |
| 329 |
[meta][field] col name: c1 |
| 330 |
[meta][field] org col name: c1 |
| 331 |
[meta][field] length: 11 |
| 332 |
[meta][field] charsetnr: 8 |
| 333 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 334 |
[meta][field] decimals: 0 |
| 335 |
[meta][field] type: LONG (3) |
| 336 |
|
| 337 |
[meta][field] db name: test |
| 338 |
[meta][field] table name: t1 |
| 339 |
[meta][field] org table name: t1 |
| 340 |
[meta][field] col name: c2 |
| 341 |
[meta][field] org col name: c2 |
| 342 |
[meta][field] length: 11 |
| 343 |
[meta][field] charsetnr: 8 |
| 344 |
[meta][field] flags: 0 |
| 345 |
[meta][field] decimals: 0 |
| 346 |
[meta][field] type: LONG (3) |
| 347 |
|
| 348 |
|
| 349 |
[meta][charset result] number: 33 |
| 350 |
[meta][charset result] name: utf8mb3 |
| 351 |
[meta][charset result] collation: utf8mb3_general_ci |
| 352 |
[meta][charset result] sort order: |
| 353 |
|
| 354 |
[data][t1.c1][ 1][1] |
| 355 |
[data][t1.c2][ 1][1] |
| 356 |
|
| 357 |
[data][t1.c1][ 3][100] |
| 358 |
[data][t1.c2][ 1][2] |
| 359 |
|
| 360 |
[data][t1.c1][ 1][3] |
| 361 |
[data][t1.c2][ 1][3] |
| 362 |
|
| 363 |
[data][t1.c1][ 1][4] |
| 364 |
[data][t1.c2][ 1][1] |
| 365 |
|
| 366 |
[data][t1.c1][ 3][100] |
| 367 |
[data][t1.c2][ 1][2] |
| 368 |
|
| 369 |
[data][t1.c1][ 1][6] |
| 370 |
[data][t1.c2][ 1][3] |
| 371 |
|
| 372 |
[end] server status: 34 |
| 373 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 374 |
[end] warning count: 0 |
| 375 |
[end] affected rows: 0 |
| 376 |
[end] last insert id: 0 |
| 377 |
[end] message: |
| 378 |
======================================================================== |
| 379 |
[srv_session_close] |
| 380 |
Follows threaded run |
| 381 |
======================================================================== |
| 382 |
init thread |
| 383 |
[srv_session_open] |
| 384 |
======================================================================== |
| 385 |
EXECUTING:[35][SELECT 'first complex command' as a] |
| 386 |
[CS_TEXT_REPRESENTATION] |
| 387 |
[meta] rows: 1 |
| 388 |
[meta] cols: 1 |
| 389 |
[meta] server status: 2 |
| 390 |
[meta] server status: AUTOCOMMIT |
| 391 |
[meta] warning count: 0 |
| 392 |
|
| 393 |
[meta][field] db name: |
| 394 |
[meta][field] table name: |
| 395 |
[meta][field] org table name: |
| 396 |
[meta][field] col name: a |
| 397 |
[meta][field] org col name: |
| 398 |
[meta][field] length: 63 |
| 399 |
[meta][field] charsetnr: 33 |
| 400 |
[meta][field] flags: 1 (NOT_NULL ) |
| 401 |
[meta][field] decimals: 31 |
| 402 |
[meta][field] type: VARCHAR (15) |
| 403 |
|
| 404 |
|
| 405 |
[meta][charset result] number: 33 |
| 406 |
[meta][charset result] name: utf8mb3 |
| 407 |
[meta][charset result] collation: utf8mb3_general_ci |
| 408 |
[meta][charset result] sort order: |
| 409 |
|
| 410 |
[data][.a][ 21][first complex command] |
| 411 |
|
| 412 |
[end] server status: 2 |
| 413 |
[end] server status: AUTOCOMMIT |
| 414 |
[end] warning count: 0 |
| 415 |
[end] affected rows: 0 |
| 416 |
[end] last insert id: 0 |
| 417 |
[end] message: |
| 418 |
[CS_BINARY_REPRESENTATION] |
| 419 |
[meta] rows: 1 |
| 420 |
[meta] cols: 1 |
| 421 |
[meta] server status: 2 |
| 422 |
[meta] server status: AUTOCOMMIT |
| 423 |
[meta] warning count: 0 |
| 424 |
|
| 425 |
[meta][field] db name: |
| 426 |
[meta][field] table name: |
| 427 |
[meta][field] org table name: |
| 428 |
[meta][field] col name: a |
| 429 |
[meta][field] org col name: |
| 430 |
[meta][field] length: 63 |
| 431 |
[meta][field] charsetnr: 33 |
| 432 |
[meta][field] flags: 1 (NOT_NULL ) |
| 433 |
[meta][field] decimals: 31 |
| 434 |
[meta][field] type: VARCHAR (15) |
| 435 |
|
| 436 |
|
| 437 |
[meta][charset result] number: 33 |
| 438 |
[meta][charset result] name: utf8mb3 |
| 439 |
[meta][charset result] collation: utf8mb3_general_ci |
| 440 |
[meta][charset result] sort order: |
| 441 |
|
| 442 |
[data][.a][ 21][first complex command] |
| 443 |
|
| 444 |
[end] server status: 2 |
| 445 |
[end] server status: AUTOCOMMIT |
| 446 |
[end] warning count: 0 |
| 447 |
[end] affected rows: 0 |
| 448 |
[end] last insert id: 0 |
| 449 |
[end] message: |
| 450 |
======================================================================== |
| 451 |
EXECUTING:[COM_INIT_DB][test] |
| 452 |
======================================================================== |
| 453 |
EXECUTING:[62][INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,1), (5,2), (6,3)] |
| 454 |
[CS_TEXT_REPRESENTATION] |
| 455 |
[meta] rows: 0 |
| 456 |
[meta] cols: 0 |
| 457 |
[meta] server status: 0 |
| 458 |
[meta] server status: |
| 459 |
[meta] warning count: 0 |
| 460 |
|
| 461 |
[meta] no columns |
| 462 |
|
| 463 |
[meta] no charset |
| 464 |
|
| 465 |
[data] no rows |
| 466 |
|
| 467 |
[end] server status: 2 |
| 468 |
[end] server status: AUTOCOMMIT |
| 469 |
[end] warning count: 0 |
| 470 |
[end] affected rows: 6 |
| 471 |
[end] last insert id: 0 |
| 472 |
[end] message: Records: 6 Duplicates: 0 Warnings: 0 |
| 473 |
======================================================================== |
| 474 |
EXECUTING:[COM_INIT_DB][test] |
| 475 |
======================================================================== |
| 476 |
EXECUTING:[16][SELECT * FROM t1] |
| 477 |
[CS_TEXT_REPRESENTATION] |
| 478 |
[meta] rows: 12 |
| 479 |
[meta] cols: 2 |
| 480 |
[meta] server status: 34 |
| 481 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 482 |
[meta] warning count: 0 |
| 483 |
|
| 484 |
[meta][field] db name: test |
| 485 |
[meta][field] table name: t1 |
| 486 |
[meta][field] org table name: t1 |
| 487 |
[meta][field] col name: c1 |
| 488 |
[meta][field] org col name: c1 |
| 489 |
[meta][field] length: 11 |
| 490 |
[meta][field] charsetnr: 8 |
| 491 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 492 |
[meta][field] decimals: 0 |
| 493 |
[meta][field] type: LONG (3) |
| 494 |
|
| 495 |
[meta][field] db name: test |
| 496 |
[meta][field] table name: t1 |
| 497 |
[meta][field] org table name: t1 |
| 498 |
[meta][field] col name: c2 |
| 499 |
[meta][field] org col name: c2 |
| 500 |
[meta][field] length: 11 |
| 501 |
[meta][field] charsetnr: 8 |
| 502 |
[meta][field] flags: 0 |
| 503 |
[meta][field] decimals: 0 |
| 504 |
[meta][field] type: LONG (3) |
| 505 |
|
| 506 |
|
| 507 |
[meta][charset result] number: 33 |
| 508 |
[meta][charset result] name: utf8mb3 |
| 509 |
[meta][charset result] collation: utf8mb3_general_ci |
| 510 |
[meta][charset result] sort order: |
| 511 |
|
| 512 |
[data][t1.c1][ 1][1] |
| 513 |
[data][t1.c2][ 1][1] |
| 514 |
|
| 515 |
[data][t1.c1][ 3][100] |
| 516 |
[data][t1.c2][ 1][2] |
| 517 |
|
| 518 |
[data][t1.c1][ 1][3] |
| 519 |
[data][t1.c2][ 1][3] |
| 520 |
|
| 521 |
[data][t1.c1][ 1][4] |
| 522 |
[data][t1.c2][ 1][1] |
| 523 |
|
| 524 |
[data][t1.c1][ 3][100] |
| 525 |
[data][t1.c2][ 1][2] |
| 526 |
|
| 527 |
[data][t1.c1][ 1][6] |
| 528 |
[data][t1.c2][ 1][3] |
| 529 |
|
| 530 |
[data][t1.c1][ 1][1] |
| 531 |
[data][t1.c2][ 1][1] |
| 532 |
|
| 533 |
[data][t1.c1][ 1][2] |
| 534 |
[data][t1.c2][ 1][2] |
| 535 |
|
| 536 |
[data][t1.c1][ 1][3] |
| 537 |
[data][t1.c2][ 1][3] |
| 538 |
|
| 539 |
[data][t1.c1][ 1][4] |
| 540 |
[data][t1.c2][ 1][1] |
| 541 |
|
| 542 |
[data][t1.c1][ 1][5] |
| 543 |
[data][t1.c2][ 1][2] |
| 544 |
|
| 545 |
[data][t1.c1][ 1][6] |
| 546 |
[data][t1.c2][ 1][3] |
| 547 |
|
| 548 |
[end] server status: 34 |
| 549 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 550 |
[end] warning count: 0 |
| 551 |
[end] affected rows: 0 |
| 552 |
[end] last insert id: 0 |
| 553 |
[end] message: |
| 554 |
[CS_BINARY_REPRESENTATION] |
| 555 |
[meta] rows: 12 |
| 556 |
[meta] cols: 2 |
| 557 |
[meta] server status: 34 |
| 558 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 559 |
[meta] warning count: 0 |
| 560 |
|
| 561 |
[meta][field] db name: test |
| 562 |
[meta][field] table name: t1 |
| 563 |
[meta][field] org table name: t1 |
| 564 |
[meta][field] col name: c1 |
| 565 |
[meta][field] org col name: c1 |
| 566 |
[meta][field] length: 11 |
| 567 |
[meta][field] charsetnr: 8 |
| 568 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 569 |
[meta][field] decimals: 0 |
| 570 |
[meta][field] type: LONG (3) |
| 571 |
|
| 572 |
[meta][field] db name: test |
| 573 |
[meta][field] table name: t1 |
| 574 |
[meta][field] org table name: t1 |
| 575 |
[meta][field] col name: c2 |
| 576 |
[meta][field] org col name: c2 |
| 577 |
[meta][field] length: 11 |
| 578 |
[meta][field] charsetnr: 8 |
| 579 |
[meta][field] flags: 0 |
| 580 |
[meta][field] decimals: 0 |
| 581 |
[meta][field] type: LONG (3) |
| 582 |
|
| 583 |
|
| 584 |
[meta][charset result] number: 33 |
| 585 |
[meta][charset result] name: utf8mb3 |
| 586 |
[meta][charset result] collation: utf8mb3_general_ci |
| 587 |
[meta][charset result] sort order: |
| 588 |
|
| 589 |
[data][t1.c1][ 1][1] |
| 590 |
[data][t1.c2][ 1][1] |
| 591 |
|
| 592 |
[data][t1.c1][ 3][100] |
| 593 |
[data][t1.c2][ 1][2] |
| 594 |
|
| 595 |
[data][t1.c1][ 1][3] |
| 596 |
[data][t1.c2][ 1][3] |
| 597 |
|
| 598 |
[data][t1.c1][ 1][4] |
| 599 |
[data][t1.c2][ 1][1] |
| 600 |
|
| 601 |
[data][t1.c1][ 3][100] |
| 602 |
[data][t1.c2][ 1][2] |
| 603 |
|
| 604 |
[data][t1.c1][ 1][6] |
| 605 |
[data][t1.c2][ 1][3] |
| 606 |
|
| 607 |
[data][t1.c1][ 1][1] |
| 608 |
[data][t1.c2][ 1][1] |
| 609 |
|
| 610 |
[data][t1.c1][ 1][2] |
| 611 |
[data][t1.c2][ 1][2] |
| 612 |
|
| 613 |
[data][t1.c1][ 1][3] |
| 614 |
[data][t1.c2][ 1][3] |
| 615 |
|
| 616 |
[data][t1.c1][ 1][4] |
| 617 |
[data][t1.c2][ 1][1] |
| 618 |
|
| 619 |
[data][t1.c1][ 1][5] |
| 620 |
[data][t1.c2][ 1][2] |
| 621 |
|
| 622 |
[data][t1.c1][ 1][6] |
| 623 |
[data][t1.c2][ 1][3] |
| 624 |
|
| 625 |
[end] server status: 34 |
| 626 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 627 |
[end] warning count: 0 |
| 628 |
[end] affected rows: 0 |
| 629 |
[end] last insert id: 0 |
| 630 |
[end] message: |
| 631 |
======================================================================== |
| 632 |
EXECUTING:[COM_INIT_DB][test] |
| 633 |
======================================================================== |
| 634 |
EXECUTING:[35][UPDATE t1 SET c1 = 100 WHERE c2 = 2] |
| 635 |
[CS_TEXT_REPRESENTATION] |
| 636 |
[meta] rows: 0 |
| 637 |
[meta] cols: 0 |
| 638 |
[meta] server status: 0 |
| 639 |
[meta] server status: |
| 640 |
[meta] warning count: 0 |
| 641 |
|
| 642 |
[meta] no columns |
| 643 |
|
| 644 |
[meta] no charset |
| 645 |
|
| 646 |
[data] no rows |
| 647 |
|
| 648 |
[end] server status: 34 |
| 649 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 650 |
[end] warning count: 0 |
| 651 |
[end] affected rows: 2 |
| 652 |
[end] last insert id: 0 |
| 653 |
[end] message: Rows matched: 4 Changed: 2 Warnings: 0 |
| 654 |
======================================================================== |
| 655 |
EXECUTING:[COM_INIT_DB][test] |
| 656 |
======================================================================== |
| 657 |
EXECUTING:[16][SELECT * FROM t1] |
| 658 |
[CS_TEXT_REPRESENTATION] |
| 659 |
[meta] rows: 12 |
| 660 |
[meta] cols: 2 |
| 661 |
[meta] server status: 34 |
| 662 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 663 |
[meta] warning count: 0 |
| 664 |
|
| 665 |
[meta][field] db name: test |
| 666 |
[meta][field] table name: t1 |
| 667 |
[meta][field] org table name: t1 |
| 668 |
[meta][field] col name: c1 |
| 669 |
[meta][field] org col name: c1 |
| 670 |
[meta][field] length: 11 |
| 671 |
[meta][field] charsetnr: 8 |
| 672 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 673 |
[meta][field] decimals: 0 |
| 674 |
[meta][field] type: LONG (3) |
| 675 |
|
| 676 |
[meta][field] db name: test |
| 677 |
[meta][field] table name: t1 |
| 678 |
[meta][field] org table name: t1 |
| 679 |
[meta][field] col name: c2 |
| 680 |
[meta][field] org col name: c2 |
| 681 |
[meta][field] length: 11 |
| 682 |
[meta][field] charsetnr: 8 |
| 683 |
[meta][field] flags: 0 |
| 684 |
[meta][field] decimals: 0 |
| 685 |
[meta][field] type: LONG (3) |
| 686 |
|
| 687 |
|
| 688 |
[meta][charset result] number: 33 |
| 689 |
[meta][charset result] name: utf8mb3 |
| 690 |
[meta][charset result] collation: utf8mb3_general_ci |
| 691 |
[meta][charset result] sort order: |
| 692 |
|
| 693 |
[data][t1.c1][ 1][1] |
| 694 |
[data][t1.c2][ 1][1] |
| 695 |
|
| 696 |
[data][t1.c1][ 3][100] |
| 697 |
[data][t1.c2][ 1][2] |
| 698 |
|
| 699 |
[data][t1.c1][ 1][3] |
| 700 |
[data][t1.c2][ 1][3] |
| 701 |
|
| 702 |
[data][t1.c1][ 1][4] |
| 703 |
[data][t1.c2][ 1][1] |
| 704 |
|
| 705 |
[data][t1.c1][ 3][100] |
| 706 |
[data][t1.c2][ 1][2] |
| 707 |
|
| 708 |
[data][t1.c1][ 1][6] |
| 709 |
[data][t1.c2][ 1][3] |
| 710 |
|
| 711 |
[data][t1.c1][ 1][1] |
| 712 |
[data][t1.c2][ 1][1] |
| 713 |
|
| 714 |
[data][t1.c1][ 3][100] |
| 715 |
[data][t1.c2][ 1][2] |
| 716 |
|
| 717 |
[data][t1.c1][ 1][3] |
| 718 |
[data][t1.c2][ 1][3] |
| 719 |
|
| 720 |
[data][t1.c1][ 1][4] |
| 721 |
[data][t1.c2][ 1][1] |
| 722 |
|
| 723 |
[data][t1.c1][ 3][100] |
| 724 |
[data][t1.c2][ 1][2] |
| 725 |
|
| 726 |
[data][t1.c1][ 1][6] |
| 727 |
[data][t1.c2][ 1][3] |
| 728 |
|
| 729 |
[end] server status: 34 |
| 730 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 731 |
[end] warning count: 0 |
| 732 |
[end] affected rows: 0 |
| 733 |
[end] last insert id: 0 |
| 734 |
[end] message: |
| 735 |
[CS_BINARY_REPRESENTATION] |
| 736 |
[meta] rows: 12 |
| 737 |
[meta] cols: 2 |
| 738 |
[meta] server status: 34 |
| 739 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 740 |
[meta] warning count: 0 |
| 741 |
|
| 742 |
[meta][field] db name: test |
| 743 |
[meta][field] table name: t1 |
| 744 |
[meta][field] org table name: t1 |
| 745 |
[meta][field] col name: c1 |
| 746 |
[meta][field] org col name: c1 |
| 747 |
[meta][field] length: 11 |
| 748 |
[meta][field] charsetnr: 8 |
| 749 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 750 |
[meta][field] decimals: 0 |
| 751 |
[meta][field] type: LONG (3) |
| 752 |
|
| 753 |
[meta][field] db name: test |
| 754 |
[meta][field] table name: t1 |
| 755 |
[meta][field] org table name: t1 |
| 756 |
[meta][field] col name: c2 |
| 757 |
[meta][field] org col name: c2 |
| 758 |
[meta][field] length: 11 |
| 759 |
[meta][field] charsetnr: 8 |
| 760 |
[meta][field] flags: 0 |
| 761 |
[meta][field] decimals: 0 |
| 762 |
[meta][field] type: LONG (3) |
| 763 |
|
| 764 |
|
| 765 |
[meta][charset result] number: 33 |
| 766 |
[meta][charset result] name: utf8mb3 |
| 767 |
[meta][charset result] collation: utf8mb3_general_ci |
| 768 |
[meta][charset result] sort order: |
| 769 |
|
| 770 |
[data][t1.c1][ 1][1] |
| 771 |
[data][t1.c2][ 1][1] |
| 772 |
|
| 773 |
[data][t1.c1][ 3][100] |
| 774 |
[data][t1.c2][ 1][2] |
| 775 |
|
| 776 |
[data][t1.c1][ 1][3] |
| 777 |
[data][t1.c2][ 1][3] |
| 778 |
|
| 779 |
[data][t1.c1][ 1][4] |
| 780 |
[data][t1.c2][ 1][1] |
| 781 |
|
| 782 |
[data][t1.c1][ 3][100] |
| 783 |
[data][t1.c2][ 1][2] |
| 784 |
|
| 785 |
[data][t1.c1][ 1][6] |
| 786 |
[data][t1.c2][ 1][3] |
| 787 |
|
| 788 |
[data][t1.c1][ 1][1] |
| 789 |
[data][t1.c2][ 1][1] |
| 790 |
|
| 791 |
[data][t1.c1][ 3][100] |
| 792 |
[data][t1.c2][ 1][2] |
| 793 |
|
| 794 |
[data][t1.c1][ 1][3] |
| 795 |
[data][t1.c2][ 1][3] |
| 796 |
|
| 797 |
[data][t1.c1][ 1][4] |
| 798 |
[data][t1.c2][ 1][1] |
| 799 |
|
| 800 |
[data][t1.c1][ 3][100] |
| 801 |
[data][t1.c2][ 1][2] |
| 802 |
|
| 803 |
[data][t1.c1][ 1][6] |
| 804 |
[data][t1.c2][ 1][3] |
| 805 |
|
| 806 |
[end] server status: 34 |
| 807 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 808 |
[end] warning count: 0 |
| 809 |
[end] affected rows: 0 |
| 810 |
[end] last insert id: 0 |
| 811 |
[end] message: |
| 812 |
======================================================================== |
| 813 |
[srv_session_close] |
| 814 |
deinit thread |
| 815 |
SELECT * FROM t1; |
| 816 |
c1 c2 |
| 817 |
1 1 |
| 818 |
100 2 |
| 819 |
3 3 |
| 820 |
4 1 |
| 821 |
100 2 |
| 822 |
6 3 |
| 823 |
1 1 |
| 824 |
100 2 |
| 825 |
3 3 |
| 826 |
4 1 |
| 827 |
100 2 |
| 828 |
6 3 |
| 829 |
include/sync_slave_sql_with_master.inc |
| 830 |
[Connection Slave] |
| 831 |
SELECT * FROM t1; |
| 832 |
c1 c2 |
| 833 |
1 1 |
| 834 |
100 2 |
| 835 |
3 3 |
| 836 |
4 1 |
| 837 |
100 2 |
| 838 |
6 3 |
| 839 |
1 1 |
| 840 |
100 2 |
| 841 |
3 3 |
| 842 |
4 1 |
| 843 |
100 2 |
| 844 |
6 3 |
| 845 |
[Connection Master] |
| 846 |
################################################################### |
| 847 |
# Run plugin |
| 848 |
################################################################### |
| 849 |
INSTALL PLUGIN test_sql_replication SONAME 'TEST_SQL_REPLICATION'; |
| 850 |
################################################################### |
| 851 |
# Stop plugin |
| 852 |
################################################################### |
| 853 |
UNINSTALL PLUGIN test_sql_replication; |
| 854 |
################################################################### |
| 855 |
# Plugin log |
| 856 |
################################################################### |
| 857 |
======================================================================== |
| 858 |
Test in a server thread |
| 859 |
[srv_session_open] |
| 860 |
======================================================================== |
| 861 |
EXECUTING:[35][SELECT 'first complex command' as a] |
| 862 |
[CS_TEXT_REPRESENTATION] |
| 863 |
[meta] rows: 1 |
| 864 |
[meta] cols: 1 |
| 865 |
[meta] server status: 2 |
| 866 |
[meta] server status: AUTOCOMMIT |
| 867 |
[meta] warning count: 0 |
| 868 |
|
| 869 |
[meta][field] db name: |
| 870 |
[meta][field] table name: |
| 871 |
[meta][field] org table name: |
| 872 |
[meta][field] col name: a |
| 873 |
[meta][field] org col name: |
| 874 |
[meta][field] length: 63 |
| 875 |
[meta][field] charsetnr: 33 |
| 876 |
[meta][field] flags: 1 (NOT_NULL ) |
| 877 |
[meta][field] decimals: 31 |
| 878 |
[meta][field] type: VARCHAR (15) |
| 879 |
|
| 880 |
|
| 881 |
[meta][charset result] number: 33 |
| 882 |
[meta][charset result] name: utf8mb3 |
| 883 |
[meta][charset result] collation: utf8mb3_general_ci |
| 884 |
[meta][charset result] sort order: |
| 885 |
|
| 886 |
[data][.a][ 21][first complex command] |
| 887 |
|
| 888 |
[end] server status: 2 |
| 889 |
[end] server status: AUTOCOMMIT |
| 890 |
[end] warning count: 0 |
| 891 |
[end] affected rows: 0 |
| 892 |
[end] last insert id: 0 |
| 893 |
[end] message: |
| 894 |
[CS_BINARY_REPRESENTATION] |
| 895 |
[meta] rows: 1 |
| 896 |
[meta] cols: 1 |
| 897 |
[meta] server status: 2 |
| 898 |
[meta] server status: AUTOCOMMIT |
| 899 |
[meta] warning count: 0 |
| 900 |
|
| 901 |
[meta][field] db name: |
| 902 |
[meta][field] table name: |
| 903 |
[meta][field] org table name: |
| 904 |
[meta][field] col name: a |
| 905 |
[meta][field] org col name: |
| 906 |
[meta][field] length: 63 |
| 907 |
[meta][field] charsetnr: 33 |
| 908 |
[meta][field] flags: 1 (NOT_NULL ) |
| 909 |
[meta][field] decimals: 31 |
| 910 |
[meta][field] type: VARCHAR (15) |
| 911 |
|
| 912 |
|
| 913 |
[meta][charset result] number: 33 |
| 914 |
[meta][charset result] name: utf8mb3 |
| 915 |
[meta][charset result] collation: utf8mb3_general_ci |
| 916 |
[meta][charset result] sort order: |
| 917 |
|
| 918 |
[data][.a][ 21][first complex command] |
| 919 |
|
| 920 |
[end] server status: 2 |
| 921 |
[end] server status: AUTOCOMMIT |
| 922 |
[end] warning count: 0 |
| 923 |
[end] affected rows: 0 |
| 924 |
[end] last insert id: 0 |
| 925 |
[end] message: |
| 926 |
======================================================================== |
| 927 |
EXECUTING:[COM_INIT_DB][test] |
| 928 |
======================================================================== |
| 929 |
EXECUTING:[62][INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,1), (5,2), (6,3)] |
| 930 |
[CS_TEXT_REPRESENTATION] |
| 931 |
[meta] rows: 0 |
| 932 |
[meta] cols: 0 |
| 933 |
[meta] server status: 0 |
| 934 |
[meta] server status: |
| 935 |
[meta] warning count: 0 |
| 936 |
|
| 937 |
[meta] no columns |
| 938 |
|
| 939 |
[meta] no charset |
| 940 |
|
| 941 |
[data] no rows |
| 942 |
|
| 943 |
[end] server status: 2 |
| 944 |
[end] server status: AUTOCOMMIT |
| 945 |
[end] warning count: 0 |
| 946 |
[end] affected rows: 6 |
| 947 |
[end] last insert id: 0 |
| 948 |
[end] message: Records: 6 Duplicates: 0 Warnings: 0 |
| 949 |
======================================================================== |
| 950 |
EXECUTING:[COM_INIT_DB][test] |
| 951 |
======================================================================== |
| 952 |
EXECUTING:[16][SELECT * FROM t1] |
| 953 |
[CS_TEXT_REPRESENTATION] |
| 954 |
[meta] rows: 18 |
| 955 |
[meta] cols: 2 |
| 956 |
[meta] server status: 34 |
| 957 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 958 |
[meta] warning count: 0 |
| 959 |
|
| 960 |
[meta][field] db name: test |
| 961 |
[meta][field] table name: t1 |
| 962 |
[meta][field] org table name: t1 |
| 963 |
[meta][field] col name: c1 |
| 964 |
[meta][field] org col name: c1 |
| 965 |
[meta][field] length: 11 |
| 966 |
[meta][field] charsetnr: 8 |
| 967 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 968 |
[meta][field] decimals: 0 |
| 969 |
[meta][field] type: LONG (3) |
| 970 |
|
| 971 |
[meta][field] db name: test |
| 972 |
[meta][field] table name: t1 |
| 973 |
[meta][field] org table name: t1 |
| 974 |
[meta][field] col name: c2 |
| 975 |
[meta][field] org col name: c2 |
| 976 |
[meta][field] length: 11 |
| 977 |
[meta][field] charsetnr: 8 |
| 978 |
[meta][field] flags: 0 |
| 979 |
[meta][field] decimals: 0 |
| 980 |
[meta][field] type: LONG (3) |
| 981 |
|
| 982 |
|
| 983 |
[meta][charset result] number: 33 |
| 984 |
[meta][charset result] name: utf8mb3 |
| 985 |
[meta][charset result] collation: utf8mb3_general_ci |
| 986 |
[meta][charset result] sort order: |
| 987 |
|
| 988 |
[data][t1.c1][ 1][1] |
| 989 |
[data][t1.c2][ 1][1] |
| 990 |
|
| 991 |
[data][t1.c1][ 3][100] |
| 992 |
[data][t1.c2][ 1][2] |
| 993 |
|
| 994 |
[data][t1.c1][ 1][3] |
| 995 |
[data][t1.c2][ 1][3] |
| 996 |
|
| 997 |
[data][t1.c1][ 1][4] |
| 998 |
[data][t1.c2][ 1][1] |
| 999 |
|
| 1000 |
[data][t1.c1][ 3][100] |
| 1001 |
[data][t1.c2][ 1][2] |
| 1002 |
|
| 1003 |
[data][t1.c1][ 1][6] |
| 1004 |
[data][t1.c2][ 1][3] |
| 1005 |
|
| 1006 |
[data][t1.c1][ 1][1] |
| 1007 |
[data][t1.c2][ 1][1] |
| 1008 |
|
| 1009 |
[data][t1.c1][ 3][100] |
| 1010 |
[data][t1.c2][ 1][2] |
| 1011 |
|
| 1012 |
[data][t1.c1][ 1][3] |
| 1013 |
[data][t1.c2][ 1][3] |
| 1014 |
|
| 1015 |
[data][t1.c1][ 1][4] |
| 1016 |
[data][t1.c2][ 1][1] |
| 1017 |
|
| 1018 |
[data][t1.c1][ 3][100] |
| 1019 |
[data][t1.c2][ 1][2] |
| 1020 |
|
| 1021 |
[data][t1.c1][ 1][6] |
| 1022 |
[data][t1.c2][ 1][3] |
| 1023 |
|
| 1024 |
[data][t1.c1][ 1][1] |
| 1025 |
[data][t1.c2][ 1][1] |
| 1026 |
|
| 1027 |
[data][t1.c1][ 1][2] |
| 1028 |
[data][t1.c2][ 1][2] |
| 1029 |
|
| 1030 |
[data][t1.c1][ 1][3] |
| 1031 |
[data][t1.c2][ 1][3] |
| 1032 |
|
| 1033 |
[data][t1.c1][ 1][4] |
| 1034 |
[data][t1.c2][ 1][1] |
| 1035 |
|
| 1036 |
[data][t1.c1][ 1][5] |
| 1037 |
[data][t1.c2][ 1][2] |
| 1038 |
|
| 1039 |
[data][t1.c1][ 1][6] |
| 1040 |
[data][t1.c2][ 1][3] |
| 1041 |
|
| 1042 |
[end] server status: 34 |
| 1043 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1044 |
[end] warning count: 0 |
| 1045 |
[end] affected rows: 0 |
| 1046 |
[end] last insert id: 0 |
| 1047 |
[end] message: |
| 1048 |
[CS_BINARY_REPRESENTATION] |
| 1049 |
[meta] rows: 18 |
| 1050 |
[meta] cols: 2 |
| 1051 |
[meta] server status: 34 |
| 1052 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1053 |
[meta] warning count: 0 |
| 1054 |
|
| 1055 |
[meta][field] db name: test |
| 1056 |
[meta][field] table name: t1 |
| 1057 |
[meta][field] org table name: t1 |
| 1058 |
[meta][field] col name: c1 |
| 1059 |
[meta][field] org col name: c1 |
| 1060 |
[meta][field] length: 11 |
| 1061 |
[meta][field] charsetnr: 8 |
| 1062 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 1063 |
[meta][field] decimals: 0 |
| 1064 |
[meta][field] type: LONG (3) |
| 1065 |
|
| 1066 |
[meta][field] db name: test |
| 1067 |
[meta][field] table name: t1 |
| 1068 |
[meta][field] org table name: t1 |
| 1069 |
[meta][field] col name: c2 |
| 1070 |
[meta][field] org col name: c2 |
| 1071 |
[meta][field] length: 11 |
| 1072 |
[meta][field] charsetnr: 8 |
| 1073 |
[meta][field] flags: 0 |
| 1074 |
[meta][field] decimals: 0 |
| 1075 |
[meta][field] type: LONG (3) |
| 1076 |
|
| 1077 |
|
| 1078 |
[meta][charset result] number: 33 |
| 1079 |
[meta][charset result] name: utf8mb3 |
| 1080 |
[meta][charset result] collation: utf8mb3_general_ci |
| 1081 |
[meta][charset result] sort order: |
| 1082 |
|
| 1083 |
[data][t1.c1][ 1][1] |
| 1084 |
[data][t1.c2][ 1][1] |
| 1085 |
|
| 1086 |
[data][t1.c1][ 3][100] |
| 1087 |
[data][t1.c2][ 1][2] |
| 1088 |
|
| 1089 |
[data][t1.c1][ 1][3] |
| 1090 |
[data][t1.c2][ 1][3] |
| 1091 |
|
| 1092 |
[data][t1.c1][ 1][4] |
| 1093 |
[data][t1.c2][ 1][1] |
| 1094 |
|
| 1095 |
[data][t1.c1][ 3][100] |
| 1096 |
[data][t1.c2][ 1][2] |
| 1097 |
|
| 1098 |
[data][t1.c1][ 1][6] |
| 1099 |
[data][t1.c2][ 1][3] |
| 1100 |
|
| 1101 |
[data][t1.c1][ 1][1] |
| 1102 |
[data][t1.c2][ 1][1] |
| 1103 |
|
| 1104 |
[data][t1.c1][ 3][100] |
| 1105 |
[data][t1.c2][ 1][2] |
| 1106 |
|
| 1107 |
[data][t1.c1][ 1][3] |
| 1108 |
[data][t1.c2][ 1][3] |
| 1109 |
|
| 1110 |
[data][t1.c1][ 1][4] |
| 1111 |
[data][t1.c2][ 1][1] |
| 1112 |
|
| 1113 |
[data][t1.c1][ 3][100] |
| 1114 |
[data][t1.c2][ 1][2] |
| 1115 |
|
| 1116 |
[data][t1.c1][ 1][6] |
| 1117 |
[data][t1.c2][ 1][3] |
| 1118 |
|
| 1119 |
[data][t1.c1][ 1][1] |
| 1120 |
[data][t1.c2][ 1][1] |
| 1121 |
|
| 1122 |
[data][t1.c1][ 1][2] |
| 1123 |
[data][t1.c2][ 1][2] |
| 1124 |
|
| 1125 |
[data][t1.c1][ 1][3] |
| 1126 |
[data][t1.c2][ 1][3] |
| 1127 |
|
| 1128 |
[data][t1.c1][ 1][4] |
| 1129 |
[data][t1.c2][ 1][1] |
| 1130 |
|
| 1131 |
[data][t1.c1][ 1][5] |
| 1132 |
[data][t1.c2][ 1][2] |
| 1133 |
|
| 1134 |
[data][t1.c1][ 1][6] |
| 1135 |
[data][t1.c2][ 1][3] |
| 1136 |
|
| 1137 |
[end] server status: 34 |
| 1138 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1139 |
[end] warning count: 0 |
| 1140 |
[end] affected rows: 0 |
| 1141 |
[end] last insert id: 0 |
| 1142 |
[end] message: |
| 1143 |
======================================================================== |
| 1144 |
EXECUTING:[COM_INIT_DB][test] |
| 1145 |
======================================================================== |
| 1146 |
EXECUTING:[35][UPDATE t1 SET c1 = 100 WHERE c2 = 2] |
| 1147 |
[CS_TEXT_REPRESENTATION] |
| 1148 |
[meta] rows: 0 |
| 1149 |
[meta] cols: 0 |
| 1150 |
[meta] server status: 0 |
| 1151 |
[meta] server status: |
| 1152 |
[meta] warning count: 0 |
| 1153 |
|
| 1154 |
[meta] no columns |
| 1155 |
|
| 1156 |
[meta] no charset |
| 1157 |
|
| 1158 |
[data] no rows |
| 1159 |
|
| 1160 |
[end] server status: 34 |
| 1161 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1162 |
[end] warning count: 0 |
| 1163 |
[end] affected rows: 2 |
| 1164 |
[end] last insert id: 0 |
| 1165 |
[end] message: Rows matched: 6 Changed: 2 Warnings: 0 |
| 1166 |
======================================================================== |
| 1167 |
EXECUTING:[COM_INIT_DB][test] |
| 1168 |
======================================================================== |
| 1169 |
EXECUTING:[16][SELECT * FROM t1] |
| 1170 |
[CS_TEXT_REPRESENTATION] |
| 1171 |
[meta] rows: 18 |
| 1172 |
[meta] cols: 2 |
| 1173 |
[meta] server status: 34 |
| 1174 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1175 |
[meta] warning count: 0 |
| 1176 |
|
| 1177 |
[meta][field] db name: test |
| 1178 |
[meta][field] table name: t1 |
| 1179 |
[meta][field] org table name: t1 |
| 1180 |
[meta][field] col name: c1 |
| 1181 |
[meta][field] org col name: c1 |
| 1182 |
[meta][field] length: 11 |
| 1183 |
[meta][field] charsetnr: 8 |
| 1184 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 1185 |
[meta][field] decimals: 0 |
| 1186 |
[meta][field] type: LONG (3) |
| 1187 |
|
| 1188 |
[meta][field] db name: test |
| 1189 |
[meta][field] table name: t1 |
| 1190 |
[meta][field] org table name: t1 |
| 1191 |
[meta][field] col name: c2 |
| 1192 |
[meta][field] org col name: c2 |
| 1193 |
[meta][field] length: 11 |
| 1194 |
[meta][field] charsetnr: 8 |
| 1195 |
[meta][field] flags: 0 |
| 1196 |
[meta][field] decimals: 0 |
| 1197 |
[meta][field] type: LONG (3) |
| 1198 |
|
| 1199 |
|
| 1200 |
[meta][charset result] number: 33 |
| 1201 |
[meta][charset result] name: utf8mb3 |
| 1202 |
[meta][charset result] collation: utf8mb3_general_ci |
| 1203 |
[meta][charset result] sort order: |
| 1204 |
|
| 1205 |
[data][t1.c1][ 1][1] |
| 1206 |
[data][t1.c2][ 1][1] |
| 1207 |
|
| 1208 |
[data][t1.c1][ 3][100] |
| 1209 |
[data][t1.c2][ 1][2] |
| 1210 |
|
| 1211 |
[data][t1.c1][ 1][3] |
| 1212 |
[data][t1.c2][ 1][3] |
| 1213 |
|
| 1214 |
[data][t1.c1][ 1][4] |
| 1215 |
[data][t1.c2][ 1][1] |
| 1216 |
|
| 1217 |
[data][t1.c1][ 3][100] |
| 1218 |
[data][t1.c2][ 1][2] |
| 1219 |
|
| 1220 |
[data][t1.c1][ 1][6] |
| 1221 |
[data][t1.c2][ 1][3] |
| 1222 |
|
| 1223 |
[data][t1.c1][ 1][1] |
| 1224 |
[data][t1.c2][ 1][1] |
| 1225 |
|
| 1226 |
[data][t1.c1][ 3][100] |
| 1227 |
[data][t1.c2][ 1][2] |
| 1228 |
|
| 1229 |
[data][t1.c1][ 1][3] |
| 1230 |
[data][t1.c2][ 1][3] |
| 1231 |
|
| 1232 |
[data][t1.c1][ 1][4] |
| 1233 |
[data][t1.c2][ 1][1] |
| 1234 |
|
| 1235 |
[data][t1.c1][ 3][100] |
| 1236 |
[data][t1.c2][ 1][2] |
| 1237 |
|
| 1238 |
[data][t1.c1][ 1][6] |
| 1239 |
[data][t1.c2][ 1][3] |
| 1240 |
|
| 1241 |
[data][t1.c1][ 1][1] |
| 1242 |
[data][t1.c2][ 1][1] |
| 1243 |
|
| 1244 |
[data][t1.c1][ 3][100] |
| 1245 |
[data][t1.c2][ 1][2] |
| 1246 |
|
| 1247 |
[data][t1.c1][ 1][3] |
| 1248 |
[data][t1.c2][ 1][3] |
| 1249 |
|
| 1250 |
[data][t1.c1][ 1][4] |
| 1251 |
[data][t1.c2][ 1][1] |
| 1252 |
|
| 1253 |
[data][t1.c1][ 3][100] |
| 1254 |
[data][t1.c2][ 1][2] |
| 1255 |
|
| 1256 |
[data][t1.c1][ 1][6] |
| 1257 |
[data][t1.c2][ 1][3] |
| 1258 |
|
| 1259 |
[end] server status: 34 |
| 1260 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1261 |
[end] warning count: 0 |
| 1262 |
[end] affected rows: 0 |
| 1263 |
[end] last insert id: 0 |
| 1264 |
[end] message: |
| 1265 |
[CS_BINARY_REPRESENTATION] |
| 1266 |
[meta] rows: 18 |
| 1267 |
[meta] cols: 2 |
| 1268 |
[meta] server status: 34 |
| 1269 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1270 |
[meta] warning count: 0 |
| 1271 |
|
| 1272 |
[meta][field] db name: test |
| 1273 |
[meta][field] table name: t1 |
| 1274 |
[meta][field] org table name: t1 |
| 1275 |
[meta][field] col name: c1 |
| 1276 |
[meta][field] org col name: c1 |
| 1277 |
[meta][field] length: 11 |
| 1278 |
[meta][field] charsetnr: 8 |
| 1279 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 1280 |
[meta][field] decimals: 0 |
| 1281 |
[meta][field] type: LONG (3) |
| 1282 |
|
| 1283 |
[meta][field] db name: test |
| 1284 |
[meta][field] table name: t1 |
| 1285 |
[meta][field] org table name: t1 |
| 1286 |
[meta][field] col name: c2 |
| 1287 |
[meta][field] org col name: c2 |
| 1288 |
[meta][field] length: 11 |
| 1289 |
[meta][field] charsetnr: 8 |
| 1290 |
[meta][field] flags: 0 |
| 1291 |
[meta][field] decimals: 0 |
| 1292 |
[meta][field] type: LONG (3) |
| 1293 |
|
| 1294 |
|
| 1295 |
[meta][charset result] number: 33 |
| 1296 |
[meta][charset result] name: utf8mb3 |
| 1297 |
[meta][charset result] collation: utf8mb3_general_ci |
| 1298 |
[meta][charset result] sort order: |
| 1299 |
|
| 1300 |
[data][t1.c1][ 1][1] |
| 1301 |
[data][t1.c2][ 1][1] |
| 1302 |
|
| 1303 |
[data][t1.c1][ 3][100] |
| 1304 |
[data][t1.c2][ 1][2] |
| 1305 |
|
| 1306 |
[data][t1.c1][ 1][3] |
| 1307 |
[data][t1.c2][ 1][3] |
| 1308 |
|
| 1309 |
[data][t1.c1][ 1][4] |
| 1310 |
[data][t1.c2][ 1][1] |
| 1311 |
|
| 1312 |
[data][t1.c1][ 3][100] |
| 1313 |
[data][t1.c2][ 1][2] |
| 1314 |
|
| 1315 |
[data][t1.c1][ 1][6] |
| 1316 |
[data][t1.c2][ 1][3] |
| 1317 |
|
| 1318 |
[data][t1.c1][ 1][1] |
| 1319 |
[data][t1.c2][ 1][1] |
| 1320 |
|
| 1321 |
[data][t1.c1][ 3][100] |
| 1322 |
[data][t1.c2][ 1][2] |
| 1323 |
|
| 1324 |
[data][t1.c1][ 1][3] |
| 1325 |
[data][t1.c2][ 1][3] |
| 1326 |
|
| 1327 |
[data][t1.c1][ 1][4] |
| 1328 |
[data][t1.c2][ 1][1] |
| 1329 |
|
| 1330 |
[data][t1.c1][ 3][100] |
| 1331 |
[data][t1.c2][ 1][2] |
| 1332 |
|
| 1333 |
[data][t1.c1][ 1][6] |
| 1334 |
[data][t1.c2][ 1][3] |
| 1335 |
|
| 1336 |
[data][t1.c1][ 1][1] |
| 1337 |
[data][t1.c2][ 1][1] |
| 1338 |
|
| 1339 |
[data][t1.c1][ 3][100] |
| 1340 |
[data][t1.c2][ 1][2] |
| 1341 |
|
| 1342 |
[data][t1.c1][ 1][3] |
| 1343 |
[data][t1.c2][ 1][3] |
| 1344 |
|
| 1345 |
[data][t1.c1][ 1][4] |
| 1346 |
[data][t1.c2][ 1][1] |
| 1347 |
|
| 1348 |
[data][t1.c1][ 3][100] |
| 1349 |
[data][t1.c2][ 1][2] |
| 1350 |
|
| 1351 |
[data][t1.c1][ 1][6] |
| 1352 |
[data][t1.c2][ 1][3] |
| 1353 |
|
| 1354 |
[end] server status: 34 |
| 1355 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1356 |
[end] warning count: 0 |
| 1357 |
[end] affected rows: 0 |
| 1358 |
[end] last insert id: 0 |
| 1359 |
[end] message: |
| 1360 |
======================================================================== |
| 1361 |
[srv_session_close] |
| 1362 |
Follows threaded run |
| 1363 |
======================================================================== |
| 1364 |
init thread |
| 1365 |
[srv_session_open] |
| 1366 |
======================================================================== |
| 1367 |
EXECUTING:[35][SELECT 'first complex command' as a] |
| 1368 |
[CS_TEXT_REPRESENTATION] |
| 1369 |
[meta] rows: 1 |
| 1370 |
[meta] cols: 1 |
| 1371 |
[meta] server status: 2 |
| 1372 |
[meta] server status: AUTOCOMMIT |
| 1373 |
[meta] warning count: 0 |
| 1374 |
|
| 1375 |
[meta][field] db name: |
| 1376 |
[meta][field] table name: |
| 1377 |
[meta][field] org table name: |
| 1378 |
[meta][field] col name: a |
| 1379 |
[meta][field] org col name: |
| 1380 |
[meta][field] length: 63 |
| 1381 |
[meta][field] charsetnr: 33 |
| 1382 |
[meta][field] flags: 1 (NOT_NULL ) |
| 1383 |
[meta][field] decimals: 31 |
| 1384 |
[meta][field] type: VARCHAR (15) |
| 1385 |
|
| 1386 |
|
| 1387 |
[meta][charset result] number: 33 |
| 1388 |
[meta][charset result] name: utf8mb3 |
| 1389 |
[meta][charset result] collation: utf8mb3_general_ci |
| 1390 |
[meta][charset result] sort order: |
| 1391 |
|
| 1392 |
[data][.a][ 21][first complex command] |
| 1393 |
|
| 1394 |
[end] server status: 2 |
| 1395 |
[end] server status: AUTOCOMMIT |
| 1396 |
[end] warning count: 0 |
| 1397 |
[end] affected rows: 0 |
| 1398 |
[end] last insert id: 0 |
| 1399 |
[end] message: |
| 1400 |
[CS_BINARY_REPRESENTATION] |
| 1401 |
[meta] rows: 1 |
| 1402 |
[meta] cols: 1 |
| 1403 |
[meta] server status: 2 |
| 1404 |
[meta] server status: AUTOCOMMIT |
| 1405 |
[meta] warning count: 0 |
| 1406 |
|
| 1407 |
[meta][field] db name: |
| 1408 |
[meta][field] table name: |
| 1409 |
[meta][field] org table name: |
| 1410 |
[meta][field] col name: a |
| 1411 |
[meta][field] org col name: |
| 1412 |
[meta][field] length: 63 |
| 1413 |
[meta][field] charsetnr: 33 |
| 1414 |
[meta][field] flags: 1 (NOT_NULL ) |
| 1415 |
[meta][field] decimals: 31 |
| 1416 |
[meta][field] type: VARCHAR (15) |
| 1417 |
|
| 1418 |
|
| 1419 |
[meta][charset result] number: 33 |
| 1420 |
[meta][charset result] name: utf8mb3 |
| 1421 |
[meta][charset result] collation: utf8mb3_general_ci |
| 1422 |
[meta][charset result] sort order: |
| 1423 |
|
| 1424 |
[data][.a][ 21][first complex command] |
| 1425 |
|
| 1426 |
[end] server status: 2 |
| 1427 |
[end] server status: AUTOCOMMIT |
| 1428 |
[end] warning count: 0 |
| 1429 |
[end] affected rows: 0 |
| 1430 |
[end] last insert id: 0 |
| 1431 |
[end] message: |
| 1432 |
======================================================================== |
| 1433 |
EXECUTING:[COM_INIT_DB][test] |
| 1434 |
======================================================================== |
| 1435 |
EXECUTING:[62][INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,1), (5,2), (6,3)] |
| 1436 |
[CS_TEXT_REPRESENTATION] |
| 1437 |
[meta] rows: 0 |
| 1438 |
[meta] cols: 0 |
| 1439 |
[meta] server status: 0 |
| 1440 |
[meta] server status: |
| 1441 |
[meta] warning count: 0 |
| 1442 |
|
| 1443 |
[meta] no columns |
| 1444 |
|
| 1445 |
[meta] no charset |
| 1446 |
|
| 1447 |
[data] no rows |
| 1448 |
|
| 1449 |
[end] server status: 2 |
| 1450 |
[end] server status: AUTOCOMMIT |
| 1451 |
[end] warning count: 0 |
| 1452 |
[end] affected rows: 6 |
| 1453 |
[end] last insert id: 0 |
| 1454 |
[end] message: Records: 6 Duplicates: 0 Warnings: 0 |
| 1455 |
======================================================================== |
| 1456 |
EXECUTING:[COM_INIT_DB][test] |
| 1457 |
======================================================================== |
| 1458 |
EXECUTING:[16][SELECT * FROM t1] |
| 1459 |
[CS_TEXT_REPRESENTATION] |
| 1460 |
[meta] rows: 24 |
| 1461 |
[meta] cols: 2 |
| 1462 |
[meta] server status: 34 |
| 1463 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1464 |
[meta] warning count: 0 |
| 1465 |
|
| 1466 |
[meta][field] db name: test |
| 1467 |
[meta][field] table name: t1 |
| 1468 |
[meta][field] org table name: t1 |
| 1469 |
[meta][field] col name: c1 |
| 1470 |
[meta][field] org col name: c1 |
| 1471 |
[meta][field] length: 11 |
| 1472 |
[meta][field] charsetnr: 8 |
| 1473 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 1474 |
[meta][field] decimals: 0 |
| 1475 |
[meta][field] type: LONG (3) |
| 1476 |
|
| 1477 |
[meta][field] db name: test |
| 1478 |
[meta][field] table name: t1 |
| 1479 |
[meta][field] org table name: t1 |
| 1480 |
[meta][field] col name: c2 |
| 1481 |
[meta][field] org col name: c2 |
| 1482 |
[meta][field] length: 11 |
| 1483 |
[meta][field] charsetnr: 8 |
| 1484 |
[meta][field] flags: 0 |
| 1485 |
[meta][field] decimals: 0 |
| 1486 |
[meta][field] type: LONG (3) |
| 1487 |
|
| 1488 |
|
| 1489 |
[meta][charset result] number: 33 |
| 1490 |
[meta][charset result] name: utf8mb3 |
| 1491 |
[meta][charset result] collation: utf8mb3_general_ci |
| 1492 |
[meta][charset result] sort order: |
| 1493 |
|
| 1494 |
[data][t1.c1][ 1][1] |
| 1495 |
[data][t1.c2][ 1][1] |
| 1496 |
|
| 1497 |
[data][t1.c1][ 3][100] |
| 1498 |
[data][t1.c2][ 1][2] |
| 1499 |
|
| 1500 |
[data][t1.c1][ 1][3] |
| 1501 |
[data][t1.c2][ 1][3] |
| 1502 |
|
| 1503 |
[data][t1.c1][ 1][4] |
| 1504 |
[data][t1.c2][ 1][1] |
| 1505 |
|
| 1506 |
[data][t1.c1][ 3][100] |
| 1507 |
[data][t1.c2][ 1][2] |
| 1508 |
|
| 1509 |
[data][t1.c1][ 1][6] |
| 1510 |
[data][t1.c2][ 1][3] |
| 1511 |
|
| 1512 |
[data][t1.c1][ 1][1] |
| 1513 |
[data][t1.c2][ 1][1] |
| 1514 |
|
| 1515 |
[data][t1.c1][ 3][100] |
| 1516 |
[data][t1.c2][ 1][2] |
| 1517 |
|
| 1518 |
[data][t1.c1][ 1][3] |
| 1519 |
[data][t1.c2][ 1][3] |
| 1520 |
|
| 1521 |
[data][t1.c1][ 1][4] |
| 1522 |
[data][t1.c2][ 1][1] |
| 1523 |
|
| 1524 |
[data][t1.c1][ 3][100] |
| 1525 |
[data][t1.c2][ 1][2] |
| 1526 |
|
| 1527 |
[data][t1.c1][ 1][6] |
| 1528 |
[data][t1.c2][ 1][3] |
| 1529 |
|
| 1530 |
[data][t1.c1][ 1][1] |
| 1531 |
[data][t1.c2][ 1][1] |
| 1532 |
|
| 1533 |
[data][t1.c1][ 3][100] |
| 1534 |
[data][t1.c2][ 1][2] |
| 1535 |
|
| 1536 |
[data][t1.c1][ 1][3] |
| 1537 |
[data][t1.c2][ 1][3] |
| 1538 |
|
| 1539 |
[data][t1.c1][ 1][4] |
| 1540 |
[data][t1.c2][ 1][1] |
| 1541 |
|
| 1542 |
[data][t1.c1][ 3][100] |
| 1543 |
[data][t1.c2][ 1][2] |
| 1544 |
|
| 1545 |
[data][t1.c1][ 1][6] |
| 1546 |
[data][t1.c2][ 1][3] |
| 1547 |
|
| 1548 |
[data][t1.c1][ 1][1] |
| 1549 |
[data][t1.c2][ 1][1] |
| 1550 |
|
| 1551 |
[data][t1.c1][ 1][2] |
| 1552 |
[data][t1.c2][ 1][2] |
| 1553 |
|
| 1554 |
[data][t1.c1][ 1][3] |
| 1555 |
[data][t1.c2][ 1][3] |
| 1556 |
|
| 1557 |
[data][t1.c1][ 1][4] |
| 1558 |
[data][t1.c2][ 1][1] |
| 1559 |
|
| 1560 |
[data][t1.c1][ 1][5] |
| 1561 |
[data][t1.c2][ 1][2] |
| 1562 |
|
| 1563 |
[data][t1.c1][ 1][6] |
| 1564 |
[data][t1.c2][ 1][3] |
| 1565 |
|
| 1566 |
[end] server status: 34 |
| 1567 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1568 |
[end] warning count: 0 |
| 1569 |
[end] affected rows: 0 |
| 1570 |
[end] last insert id: 0 |
| 1571 |
[end] message: |
| 1572 |
[CS_BINARY_REPRESENTATION] |
| 1573 |
[meta] rows: 24 |
| 1574 |
[meta] cols: 2 |
| 1575 |
[meta] server status: 34 |
| 1576 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1577 |
[meta] warning count: 0 |
| 1578 |
|
| 1579 |
[meta][field] db name: test |
| 1580 |
[meta][field] table name: t1 |
| 1581 |
[meta][field] org table name: t1 |
| 1582 |
[meta][field] col name: c1 |
| 1583 |
[meta][field] org col name: c1 |
| 1584 |
[meta][field] length: 11 |
| 1585 |
[meta][field] charsetnr: 8 |
| 1586 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 1587 |
[meta][field] decimals: 0 |
| 1588 |
[meta][field] type: LONG (3) |
| 1589 |
|
| 1590 |
[meta][field] db name: test |
| 1591 |
[meta][field] table name: t1 |
| 1592 |
[meta][field] org table name: t1 |
| 1593 |
[meta][field] col name: c2 |
| 1594 |
[meta][field] org col name: c2 |
| 1595 |
[meta][field] length: 11 |
| 1596 |
[meta][field] charsetnr: 8 |
| 1597 |
[meta][field] flags: 0 |
| 1598 |
[meta][field] decimals: 0 |
| 1599 |
[meta][field] type: LONG (3) |
| 1600 |
|
| 1601 |
|
| 1602 |
[meta][charset result] number: 33 |
| 1603 |
[meta][charset result] name: utf8mb3 |
| 1604 |
[meta][charset result] collation: utf8mb3_general_ci |
| 1605 |
[meta][charset result] sort order: |
| 1606 |
|
| 1607 |
[data][t1.c1][ 1][1] |
| 1608 |
[data][t1.c2][ 1][1] |
| 1609 |
|
| 1610 |
[data][t1.c1][ 3][100] |
| 1611 |
[data][t1.c2][ 1][2] |
| 1612 |
|
| 1613 |
[data][t1.c1][ 1][3] |
| 1614 |
[data][t1.c2][ 1][3] |
| 1615 |
|
| 1616 |
[data][t1.c1][ 1][4] |
| 1617 |
[data][t1.c2][ 1][1] |
| 1618 |
|
| 1619 |
[data][t1.c1][ 3][100] |
| 1620 |
[data][t1.c2][ 1][2] |
| 1621 |
|
| 1622 |
[data][t1.c1][ 1][6] |
| 1623 |
[data][t1.c2][ 1][3] |
| 1624 |
|
| 1625 |
[data][t1.c1][ 1][1] |
| 1626 |
[data][t1.c2][ 1][1] |
| 1627 |
|
| 1628 |
[data][t1.c1][ 3][100] |
| 1629 |
[data][t1.c2][ 1][2] |
| 1630 |
|
| 1631 |
[data][t1.c1][ 1][3] |
| 1632 |
[data][t1.c2][ 1][3] |
| 1633 |
|
| 1634 |
[data][t1.c1][ 1][4] |
| 1635 |
[data][t1.c2][ 1][1] |
| 1636 |
|
| 1637 |
[data][t1.c1][ 3][100] |
| 1638 |
[data][t1.c2][ 1][2] |
| 1639 |
|
| 1640 |
[data][t1.c1][ 1][6] |
| 1641 |
[data][t1.c2][ 1][3] |
| 1642 |
|
| 1643 |
[data][t1.c1][ 1][1] |
| 1644 |
[data][t1.c2][ 1][1] |
| 1645 |
|
| 1646 |
[data][t1.c1][ 3][100] |
| 1647 |
[data][t1.c2][ 1][2] |
| 1648 |
|
| 1649 |
[data][t1.c1][ 1][3] |
| 1650 |
[data][t1.c2][ 1][3] |
| 1651 |
|
| 1652 |
[data][t1.c1][ 1][4] |
| 1653 |
[data][t1.c2][ 1][1] |
| 1654 |
|
| 1655 |
[data][t1.c1][ 3][100] |
| 1656 |
[data][t1.c2][ 1][2] |
| 1657 |
|
| 1658 |
[data][t1.c1][ 1][6] |
| 1659 |
[data][t1.c2][ 1][3] |
| 1660 |
|
| 1661 |
[data][t1.c1][ 1][1] |
| 1662 |
[data][t1.c2][ 1][1] |
| 1663 |
|
| 1664 |
[data][t1.c1][ 1][2] |
| 1665 |
[data][t1.c2][ 1][2] |
| 1666 |
|
| 1667 |
[data][t1.c1][ 1][3] |
| 1668 |
[data][t1.c2][ 1][3] |
| 1669 |
|
| 1670 |
[data][t1.c1][ 1][4] |
| 1671 |
[data][t1.c2][ 1][1] |
| 1672 |
|
| 1673 |
[data][t1.c1][ 1][5] |
| 1674 |
[data][t1.c2][ 1][2] |
| 1675 |
|
| 1676 |
[data][t1.c1][ 1][6] |
| 1677 |
[data][t1.c2][ 1][3] |
| 1678 |
|
| 1679 |
[end] server status: 34 |
| 1680 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1681 |
[end] warning count: 0 |
| 1682 |
[end] affected rows: 0 |
| 1683 |
[end] last insert id: 0 |
| 1684 |
[end] message: |
| 1685 |
======================================================================== |
| 1686 |
EXECUTING:[COM_INIT_DB][test] |
| 1687 |
======================================================================== |
| 1688 |
EXECUTING:[35][UPDATE t1 SET c1 = 100 WHERE c2 = 2] |
| 1689 |
[CS_TEXT_REPRESENTATION] |
| 1690 |
[meta] rows: 0 |
| 1691 |
[meta] cols: 0 |
| 1692 |
[meta] server status: 0 |
| 1693 |
[meta] server status: |
| 1694 |
[meta] warning count: 0 |
| 1695 |
|
| 1696 |
[meta] no columns |
| 1697 |
|
| 1698 |
[meta] no charset |
| 1699 |
|
| 1700 |
[data] no rows |
| 1701 |
|
| 1702 |
[end] server status: 34 |
| 1703 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1704 |
[end] warning count: 0 |
| 1705 |
[end] affected rows: 2 |
| 1706 |
[end] last insert id: 0 |
| 1707 |
[end] message: Rows matched: 8 Changed: 2 Warnings: 0 |
| 1708 |
======================================================================== |
| 1709 |
EXECUTING:[COM_INIT_DB][test] |
| 1710 |
======================================================================== |
| 1711 |
EXECUTING:[16][SELECT * FROM t1] |
| 1712 |
[CS_TEXT_REPRESENTATION] |
| 1713 |
[meta] rows: 24 |
| 1714 |
[meta] cols: 2 |
| 1715 |
[meta] server status: 34 |
| 1716 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1717 |
[meta] warning count: 0 |
| 1718 |
|
| 1719 |
[meta][field] db name: test |
| 1720 |
[meta][field] table name: t1 |
| 1721 |
[meta][field] org table name: t1 |
| 1722 |
[meta][field] col name: c1 |
| 1723 |
[meta][field] org col name: c1 |
| 1724 |
[meta][field] length: 11 |
| 1725 |
[meta][field] charsetnr: 8 |
| 1726 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 1727 |
[meta][field] decimals: 0 |
| 1728 |
[meta][field] type: LONG (3) |
| 1729 |
|
| 1730 |
[meta][field] db name: test |
| 1731 |
[meta][field] table name: t1 |
| 1732 |
[meta][field] org table name: t1 |
| 1733 |
[meta][field] col name: c2 |
| 1734 |
[meta][field] org col name: c2 |
| 1735 |
[meta][field] length: 11 |
| 1736 |
[meta][field] charsetnr: 8 |
| 1737 |
[meta][field] flags: 0 |
| 1738 |
[meta][field] decimals: 0 |
| 1739 |
[meta][field] type: LONG (3) |
| 1740 |
|
| 1741 |
|
| 1742 |
[meta][charset result] number: 33 |
| 1743 |
[meta][charset result] name: utf8mb3 |
| 1744 |
[meta][charset result] collation: utf8mb3_general_ci |
| 1745 |
[meta][charset result] sort order: |
| 1746 |
|
| 1747 |
[data][t1.c1][ 1][1] |
| 1748 |
[data][t1.c2][ 1][1] |
| 1749 |
|
| 1750 |
[data][t1.c1][ 3][100] |
| 1751 |
[data][t1.c2][ 1][2] |
| 1752 |
|
| 1753 |
[data][t1.c1][ 1][3] |
| 1754 |
[data][t1.c2][ 1][3] |
| 1755 |
|
| 1756 |
[data][t1.c1][ 1][4] |
| 1757 |
[data][t1.c2][ 1][1] |
| 1758 |
|
| 1759 |
[data][t1.c1][ 3][100] |
| 1760 |
[data][t1.c2][ 1][2] |
| 1761 |
|
| 1762 |
[data][t1.c1][ 1][6] |
| 1763 |
[data][t1.c2][ 1][3] |
| 1764 |
|
| 1765 |
[data][t1.c1][ 1][1] |
| 1766 |
[data][t1.c2][ 1][1] |
| 1767 |
|
| 1768 |
[data][t1.c1][ 3][100] |
| 1769 |
[data][t1.c2][ 1][2] |
| 1770 |
|
| 1771 |
[data][t1.c1][ 1][3] |
| 1772 |
[data][t1.c2][ 1][3] |
| 1773 |
|
| 1774 |
[data][t1.c1][ 1][4] |
| 1775 |
[data][t1.c2][ 1][1] |
| 1776 |
|
| 1777 |
[data][t1.c1][ 3][100] |
| 1778 |
[data][t1.c2][ 1][2] |
| 1779 |
|
| 1780 |
[data][t1.c1][ 1][6] |
| 1781 |
[data][t1.c2][ 1][3] |
| 1782 |
|
| 1783 |
[data][t1.c1][ 1][1] |
| 1784 |
[data][t1.c2][ 1][1] |
| 1785 |
|
| 1786 |
[data][t1.c1][ 3][100] |
| 1787 |
[data][t1.c2][ 1][2] |
| 1788 |
|
| 1789 |
[data][t1.c1][ 1][3] |
| 1790 |
[data][t1.c2][ 1][3] |
| 1791 |
|
| 1792 |
[data][t1.c1][ 1][4] |
| 1793 |
[data][t1.c2][ 1][1] |
| 1794 |
|
| 1795 |
[data][t1.c1][ 3][100] |
| 1796 |
[data][t1.c2][ 1][2] |
| 1797 |
|
| 1798 |
[data][t1.c1][ 1][6] |
| 1799 |
[data][t1.c2][ 1][3] |
| 1800 |
|
| 1801 |
[data][t1.c1][ 1][1] |
| 1802 |
[data][t1.c2][ 1][1] |
| 1803 |
|
| 1804 |
[data][t1.c1][ 3][100] |
| 1805 |
[data][t1.c2][ 1][2] |
| 1806 |
|
| 1807 |
[data][t1.c1][ 1][3] |
| 1808 |
[data][t1.c2][ 1][3] |
| 1809 |
|
| 1810 |
[data][t1.c1][ 1][4] |
| 1811 |
[data][t1.c2][ 1][1] |
| 1812 |
|
| 1813 |
[data][t1.c1][ 3][100] |
| 1814 |
[data][t1.c2][ 1][2] |
| 1815 |
|
| 1816 |
[data][t1.c1][ 1][6] |
| 1817 |
[data][t1.c2][ 1][3] |
| 1818 |
|
| 1819 |
[end] server status: 34 |
| 1820 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1821 |
[end] warning count: 0 |
| 1822 |
[end] affected rows: 0 |
| 1823 |
[end] last insert id: 0 |
| 1824 |
[end] message: |
| 1825 |
[CS_BINARY_REPRESENTATION] |
| 1826 |
[meta] rows: 24 |
| 1827 |
[meta] cols: 2 |
| 1828 |
[meta] server status: 34 |
| 1829 |
[meta] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1830 |
[meta] warning count: 0 |
| 1831 |
|
| 1832 |
[meta][field] db name: test |
| 1833 |
[meta][field] table name: t1 |
| 1834 |
[meta][field] org table name: t1 |
| 1835 |
[meta][field] col name: c1 |
| 1836 |
[meta][field] org col name: c1 |
| 1837 |
[meta][field] length: 11 |
| 1838 |
[meta][field] charsetnr: 8 |
| 1839 |
[meta][field] flags: 4097 (NOT_NULL NO_DEFAULT_VALUE ) |
| 1840 |
[meta][field] decimals: 0 |
| 1841 |
[meta][field] type: LONG (3) |
| 1842 |
|
| 1843 |
[meta][field] db name: test |
| 1844 |
[meta][field] table name: t1 |
| 1845 |
[meta][field] org table name: t1 |
| 1846 |
[meta][field] col name: c2 |
| 1847 |
[meta][field] org col name: c2 |
| 1848 |
[meta][field] length: 11 |
| 1849 |
[meta][field] charsetnr: 8 |
| 1850 |
[meta][field] flags: 0 |
| 1851 |
[meta][field] decimals: 0 |
| 1852 |
[meta][field] type: LONG (3) |
| 1853 |
|
| 1854 |
|
| 1855 |
[meta][charset result] number: 33 |
| 1856 |
[meta][charset result] name: utf8mb3 |
| 1857 |
[meta][charset result] collation: utf8mb3_general_ci |
| 1858 |
[meta][charset result] sort order: |
| 1859 |
|
| 1860 |
[data][t1.c1][ 1][1] |
| 1861 |
[data][t1.c2][ 1][1] |
| 1862 |
|
| 1863 |
[data][t1.c1][ 3][100] |
| 1864 |
[data][t1.c2][ 1][2] |
| 1865 |
|
| 1866 |
[data][t1.c1][ 1][3] |
| 1867 |
[data][t1.c2][ 1][3] |
| 1868 |
|
| 1869 |
[data][t1.c1][ 1][4] |
| 1870 |
[data][t1.c2][ 1][1] |
| 1871 |
|
| 1872 |
[data][t1.c1][ 3][100] |
| 1873 |
[data][t1.c2][ 1][2] |
| 1874 |
|
| 1875 |
[data][t1.c1][ 1][6] |
| 1876 |
[data][t1.c2][ 1][3] |
| 1877 |
|
| 1878 |
[data][t1.c1][ 1][1] |
| 1879 |
[data][t1.c2][ 1][1] |
| 1880 |
|
| 1881 |
[data][t1.c1][ 3][100] |
| 1882 |
[data][t1.c2][ 1][2] |
| 1883 |
|
| 1884 |
[data][t1.c1][ 1][3] |
| 1885 |
[data][t1.c2][ 1][3] |
| 1886 |
|
| 1887 |
[data][t1.c1][ 1][4] |
| 1888 |
[data][t1.c2][ 1][1] |
| 1889 |
|
| 1890 |
[data][t1.c1][ 3][100] |
| 1891 |
[data][t1.c2][ 1][2] |
| 1892 |
|
| 1893 |
[data][t1.c1][ 1][6] |
| 1894 |
[data][t1.c2][ 1][3] |
| 1895 |
|
| 1896 |
[data][t1.c1][ 1][1] |
| 1897 |
[data][t1.c2][ 1][1] |
| 1898 |
|
| 1899 |
[data][t1.c1][ 3][100] |
| 1900 |
[data][t1.c2][ 1][2] |
| 1901 |
|
| 1902 |
[data][t1.c1][ 1][3] |
| 1903 |
[data][t1.c2][ 1][3] |
| 1904 |
|
| 1905 |
[data][t1.c1][ 1][4] |
| 1906 |
[data][t1.c2][ 1][1] |
| 1907 |
|
| 1908 |
[data][t1.c1][ 3][100] |
| 1909 |
[data][t1.c2][ 1][2] |
| 1910 |
|
| 1911 |
[data][t1.c1][ 1][6] |
| 1912 |
[data][t1.c2][ 1][3] |
| 1913 |
|
| 1914 |
[data][t1.c1][ 1][1] |
| 1915 |
[data][t1.c2][ 1][1] |
| 1916 |
|
| 1917 |
[data][t1.c1][ 3][100] |
| 1918 |
[data][t1.c2][ 1][2] |
| 1919 |
|
| 1920 |
[data][t1.c1][ 1][3] |
| 1921 |
[data][t1.c2][ 1][3] |
| 1922 |
|
| 1923 |
[data][t1.c1][ 1][4] |
| 1924 |
[data][t1.c2][ 1][1] |
| 1925 |
|
| 1926 |
[data][t1.c1][ 3][100] |
| 1927 |
[data][t1.c2][ 1][2] |
| 1928 |
|
| 1929 |
[data][t1.c1][ 1][6] |
| 1930 |
[data][t1.c2][ 1][3] |
| 1931 |
|
| 1932 |
[end] server status: 34 |
| 1933 |
[end] server status: AUTOCOMMIT QUERY_NO_INDEX_USED |
| 1934 |
[end] warning count: 0 |
| 1935 |
[end] affected rows: 0 |
| 1936 |
[end] last insert id: 0 |
| 1937 |
[end] message: |
| 1938 |
======================================================================== |
| 1939 |
[srv_session_close] |
| 1940 |
deinit thread |
| 1941 |
SELECT * FROM t1; |
| 1942 |
c1 c2 |
| 1943 |
1 1 |
| 1944 |
100 2 |
| 1945 |
3 3 |
| 1946 |
4 1 |
| 1947 |
100 2 |
| 1948 |
6 3 |
| 1949 |
1 1 |
| 1950 |
100 2 |
| 1951 |
3 3 |
| 1952 |
4 1 |
| 1953 |
100 2 |
| 1954 |
6 3 |
| 1955 |
1 1 |
| 1956 |
100 2 |
| 1957 |
3 3 |
| 1958 |
4 1 |
| 1959 |
100 2 |
| 1960 |
6 3 |
| 1961 |
1 1 |
| 1962 |
100 2 |
| 1963 |
3 3 |
| 1964 |
4 1 |
| 1965 |
100 2 |
| 1966 |
6 3 |
| 1967 |
include/sync_slave_sql_with_master.inc |
| 1968 |
[Connection Slave] |
| 1969 |
SELECT * FROM t1; |
| 1970 |
c1 c2 |
| 1971 |
1 1 |
| 1972 |
100 2 |
| 1973 |
3 3 |
| 1974 |
4 1 |
| 1975 |
100 2 |
| 1976 |
6 3 |
| 1977 |
1 1 |
| 1978 |
100 2 |
| 1979 |
3 3 |
| 1980 |
4 1 |
| 1981 |
100 2 |
| 1982 |
6 3 |
| 1983 |
1 1 |
| 1984 |
100 2 |
| 1985 |
3 3 |
| 1986 |
4 1 |
| 1987 |
100 2 |
| 1988 |
6 3 |
| 1989 |
1 1 |
| 1990 |
100 2 |
| 1991 |
3 3 |
| 1992 |
4 1 |
| 1993 |
100 2 |
| 1994 |
6 3 |
| 1995 |
include/diff_tables.inc [master:t1,slave:t1] |
| 1996 |
[Connection Master] |
| 1997 |
# Dropping the created table |
| 1998 |
DROP TABLE t1; |
| 1999 |
SELECT * FROM t1; |
| 2000 |
ERROR 42S02: Table 'test.t1' doesn't exist |
| 2001 |
include/sync_slave_sql_with_master.inc |
| 2002 |
[Connection Slave] |
| 2003 |
SELECT * FROM t1; |
| 2004 |
ERROR 42S02: Table 'test.t1' doesn't exist |
| 2005 |
include/rpl_end.inc |