← Back to team overview

enterprise-support team mailing list archive

[Bug 1074485] Re: Reproducibility issue: stored procedures/functions not correctly prefixed with delimiters in query log

 

Applied this patch:

=== modified file 'lib/GenTest/Executor/MySQL.pm'
--- lib/GenTest/Executor/MySQL.pm       2012-10-01 09:56:06 +0000
+++ lib/GenTest/Executor/MySQL.pm       2013-01-30 09:37:34 +0000
@@ -645,7 +645,11 @@
                $trace_query =~ s/\n/\n# [sqltrace]    /g;
                print '# [sqltrace] ERROR '.$err.": $trace_query;\n";
            } else {
-               print "$query;\n";
+               if ($query =~ m{(procedure|function)}sgio) {
+                       print "DELIMITER |\n$query|\nDELIMITER ;\n";
+               } else {
+                       print "$query;\n";
+               }
            }
        }

** Changed in: randgen
     Assignee: (unassigned) => RoelV (roel11)

** Changed in: randgen
       Status: Confirmed => Fix Released

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1074485

Title:
  Reproducibility issue: stored procedures/functions not correctly
  prefixed with delimiters in query log

To manage notifications about this bug go to:
https://bugs.launchpad.net/randgen/+bug/1074485/+subscriptions