bug#74996: 28.2; sql interactive mode prints output of executed query where the pointer is instead of the bottom of the buffer

[Eli Zaretskii <eliz@gnu.org>]

> Date: Fri, 20 Dec 2024 13:47:08 -0300
> From: José Júnior <jjnilton@gmail.com>
> 
> Hi, after updating to Emacs 28 I noticed that when I execute a command in a sql-mode buffer connected to a sql-interactive-mode buffer, it prints the output where the pointer is at in the SQLi buffer, and if the pointer is not at the end, it messes up what was already printed, so I have to keep track where the pointer is before executing a query. I don´t remember seeing this behavior in Emacs 27, and it looks like a bug to me. I don't see how printing the output of a query in the middle of another output could be useful.
> 
> To reproduce:
> 
> 1. Open sql-mode buffer conntected to a SQLi buffer
> 
> 2. Run a sql query
> 
> 3. Move the pointer to a line that has the previous output printed
> 
> 4. Run another sql query

Thanks, but could you please provide a more detailed reproduction
recipe, without assuming that we know about sql-mode and SQLi as much
as you do?  Preferably starting from "emacs -Q", please.

Also, please show the information collected about your system and
build of Emacs by "M-x report-emacs-bug".  Some of the info there
might be relevant to your report.