Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL), 10.5
-
None
-
All
Description
Following test case different way It print different no of rows the actual rows.
--source include/have_binlog_format_row.inc
|
|
--let $MYSQLD_DATADIR= `select @@datadir`
|
--let $binlog_file= $MYSQLD_DATADIR/master-bin.000001
|
--let $output_file= $MYSQLTEST_VARDIR/tmp/mysqlbinlog.output
|
|
CREATE TABLE t1(c_char_utf8 CHAR(10) ,
|
c_varchar_utf8 char(10) ,
|
c_text_utf8 blob );
|
|
INSERT into t1 values("B", "B", REPEAT("!", 20000));
|
|
--exec $MYSQL_BINLOG -F $binlog_file > $output_file
|
--remove_file $output_file
|
drop table t1;
|
Output
ISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEh
|
ISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEh
|
ISEhISEhISEhISEhISEhISEhISEhISEhISEhISEpm2rJ
|
'/*!*/;
|
# Number of rows: 313
|
So instead of ! we use # in repeat
INSERT into t1 values("B", "B", REPEAT("#", 20000));
|
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
|
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMLiFNr
|
'/*!*/;
|
# Number of rows: 3670
|
INSERT into t1 values("B", "B", REPEAT("#", 2000));
|
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMj
|
IyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMLiFNr
|
'/*!*/;
|
# Number of rows: 2
|
Attachments
Issue Links
- causes
-
MDEV-20582 Asan failure in table_def::calc_field_size
- Closed