bug#22027: CREATE TABLE IF NOT EXISTS SELECT logged improperly with rbr binlog,

and #22762: create talbe if not exists like a-temp-table binlogged w/o "if not exists"
    These are rbr bugs.
    store_create_info, which generates the create statement e.g for binlogging,
    did not account a lex option HA_LEX_CREATE_IF_NOT_EXISTS.
    
    The fix makes the generated query to include the parent's statement option
if
  that was supplied.


mysql-test/extra/binlog_tests/binlog.test:
  test cases for #22027, #22762
mysql-test/r/binlog_row_binlog.result:
  results changed
mysql-test/r/binlog_row_mix_innodb_myisam.result:
  results changed because of the test's query has "if not exists"
mysql-test/r/binlog_stm_binlog.result:
  results changed
sql/sql_show.cc:
  store_create_info inserts "if not exists" into output when an input query contains
  the qualifier.

1 files changed, 13 insertions, 0 deletions

diff --git a/mysql-test/extra/binlog_tests/binlog.test b/mysql-test/extra/binlog_tests/binlog.test
index 81c813e78d0..82c09301110 100644
--- a/mysql-test/extra/binlog_tests/binlog.test
+++ b/mysql-test/extra/binlog_tests/binlog.test
@@ -59,4 +59,17 @@ insert into t1 values(null);
 select * from t1;
 drop table t1;
 
+# bug#22027 
+create table t1 (a int);
+create table if not exists t2 select * from t1;
+
+# bug#22762
+create temporary table tt1 (a int);
+create table if not exists t3 like tt1;
+
+--replace_column 2 # 5 #
+--replace_regex /table_id: [0-9]+/table_id: #/ /\/\* xid=.* \*\//\/* xid= *\//
+show binlog events;
+drop table t1,t2,t3,tt1;
+
 -- source extra/binlog_tests/binlog_insert_delayed.test