• unknown's avatar
    Bug#28223: mysqldump --compact --routines restores from @OLD_SQL_MODE w/o ever setting it · 434eeb50
    unknown authored
    mysqldump generated output that set OLD_SQL_MODE twice, to different values
    (for triggers), or not at all (for routines) in some cases.
    ---
    Merge blasphemy.mysql.com:/home/tnurnberg/28223/50-28223
    into  blasphemy.mysql.com:/home/tnurnberg/28223/51-28223
    
    
    client/mysqldump.c:
      Bug#28223: mysqldump --compact --routines restores from @OLD_SQL_MODE w/o ever setting it
      
      Only save SQL_MODE in dump_triggers if in --compact mode. Otherwise,
      it's already been saved in write_header(). Likewise for dumpe_routines,
      where it was never saved.
    mysql-test/r/mysqldump.result:
      Bug#28223: mysqldump --compact --routines restores from @OLD_SQL_MODE w/o ever setting it
      
      mysqldump output has subtly changed. Adjust test-results. This also shows
      OLD_SQL_MODE is always set exactly once now.
      ---
      manual merge
    434eeb50
mysqldump.c 133 KB