Suppress continuation prompts in SQL interactive mode

        * progmodes/sql.el: Version 2.5
        (sql-product-alist): Add :prompt-cont-regexp property for several
        database products.
        (sql-prompt-cont-regexp): New variable.
        (sql-output-newline-count, sql-output-by-send): New
        variables. Record number of newlines in input text.
        (sql-send-string): Handle multiple filters and count newlines.
        (sql-send-magic-terminator): Count terminator newline.
        (sql-interactive-remove-continuation-prompt): Filters output to
        remove continuation prompts; one for each newline.
        (sql-interactive-mode): Set up new variables, prompt regexp and
        output filter.
        (sql-mode-sqlite-font-lock-keywords): Correct some keywords.
        (sql-make-alternate-buffer-name): Correct buffer name in edge
        cases.

1 files changed, 10 insertions, 1 deletions

diff --git a/etc/NEWS b/etc/NEWS
index bec5b3b3468..9837e6c95b8 100644
--- a/etc/NEWS
+++ b/etc/NEWS
@@ -283,6 +283,14 @@ variables `sql-product', `sql-user', `sql-server', `sql-database' and
 The custom variable `sql-port' can be specified for connection to
 MySQL servers.
 
+*** Command continuation prompts in SQL interactive mode are suppressed.
+Multiple line commands in SQL interactive mode, generate command
+continuation prompts which needlessly confuse the output.  These
+prompts are now filtered out from the output.  This change impacts
+multiple line SQL statements entered with C-j between each line,
+statements yanked into the buffer and statements sent with
+`sql-send-*' functions.
+
 *** Custom variables control prompting for login parameters.
 Each supported product has a custom variable `sql-*-login-params'
 which is a list of the parameters to be prompted for before a
@@ -302,7 +310,8 @@ names (without the directory portion).  Generally these strings will
 be of the form ".+\.SUF" where SUF is the desired file suffix.
 
 When :completion is specified, the ARG corresponds to the PREDICATE
-argument to the `completing-read' function.
+argument to the `completing-read' function (a list of possible values
+or a function returning such a list).
 
 *** Added `sql-connection-alist' to record login parameter values.
 An alist for recording different username, database and server