diff options
| author | aivanov@mysql.com <> | 2005-11-21 13:36:48 +0300 |
|---|---|---|
| committer | aivanov@mysql.com <> | 2005-11-21 13:36:48 +0300 |
| commit | 9a7efe36c6687ae34f0e697e33c2598086b69f97 (patch) | |
| tree | a8ce80739b2e9bb6b6ba033e51aaf5e1e4ff7e96 /client/mysqldump.c | |
| parent | b040ad35b1007508c7825b3c496db22f4ff4992f (diff) | |
| download | mariadb-git-9a7efe36c6687ae34f0e697e33c2598086b69f97.tar.gz | |
Fixed BUG #14554: mysqldump does not separate "ROW" and trigger
statement for tables created in the IGNORE_SPACE sql mode.
Diffstat (limited to 'client/mysqldump.c')
| -rw-r--r-- | client/mysqldump.c | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/client/mysqldump.c b/client/mysqldump.c index b92b971ea4f..c6a57959d6d 100644 --- a/client/mysqldump.c +++ b/client/mysqldump.c @@ -1841,12 +1841,13 @@ DELIMITER ;;\n"); while ((row= mysql_fetch_row(result))) { fprintf(sql_file, "/*!50003 SET SESSION SQL_MODE=\"%s\" */;;\n\ -/*!50003 CREATE TRIGGER %s %s %s ON %s FOR EACH ROW%s */;;\n\n", +/*!50003 CREATE TRIGGER %s %s %s ON %s FOR EACH ROW%s%s */;;\n\n", row[6], /* sql_mode */ quote_name(row[0], name_buff, 0), /* Trigger */ row[4], /* Timing */ row[1], /* Event */ result_table, + (strchr(" \t\n\r", *(row[3]))) ? "" : " ", row[3] /* Statement */); } if (mysql_num_rows(result)) |