From unknown Fri Jun 20 20:10:49 2025 X-Loop: help-debbugs@gnu.org Subject: bug#74996: 28.2; sql interactive mode prints output of executed query where the pointer is instead of the bottom of the buffer Resent-From: =?UTF-8?Q?Jos=C3=A9_?= =?UTF-8?Q?J=C3=BAnior?= Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Fri, 20 Dec 2024 16:48:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 74996 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: 74996@debbugs.gnu.org X-Debbugs-Original-To: bug-gnu-emacs@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.17347132398738 (code B ref -1); Fri, 20 Dec 2024 16:48:02 +0000 Received: (at submit) by debbugs.gnu.org; 20 Dec 2024 16:47:19 +0000 Received: from localhost ([127.0.0.1]:43799 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOg9n-0002Gs-78 for submit@debbugs.gnu.org; Fri, 20 Dec 2024 11:47:19 -0500 Received: from lists.gnu.org ([209.51.188.17]:48196) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOg9l-0002Gl-IC for submit@debbugs.gnu.org; Fri, 20 Dec 2024 11:47:18 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1tOg9j-0004V8-J4 for bug-gnu-emacs@gnu.org; Fri, 20 Dec 2024 11:47:17 -0500 Received: from mail-pg1-x52c.google.com ([2607:f8b0:4864:20::52c]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1tOg9i-0008Sy-3T for bug-gnu-emacs@gnu.org; Fri, 20 Dec 2024 11:47:15 -0500 Received: by mail-pg1-x52c.google.com with SMTP id 41be03b00d2f7-7fd49d85f82so1703662a12.3 for ; Fri, 20 Dec 2024 08:47:13 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734713232; x=1735318032; darn=gnu.org; h=content-transfer-encoding:subject:from:to:content-language :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=c7XCBZfXV4DPMMm/4i34x5OlikyqYWyhoYCmdusa1hU=; b=Ho32VYGJo2EWcOaGd8bXrXFBsr7nXvbsJXlSpdPrF/qyjybT6sC4VfPBH5fuqEXSZh UUu8jWX4Py6Gz2cXOtWfE5kA9wKNvTGN7eg6L5ktIfk+WmWqvSlvff0Fsm7uDuOjhlbv KWIaQCXLFjhksAyG8vWp7krYtehqY3MjDA1itqPFG57d6ZcMsNhG8KvUxxwYV6KLlZcA p9PB/bUkhZHlJ9M9HVKmfLBlhTFOYw14MA2WDB0Y9UCciGtZKGAkWdpfPSCGZu4Xvek6 hPtXsuC7odN87nDgUpgDl6m2e28VLNEG7Mx+bw73ngrOFer/ToaGyeoNTY8RjZIGxIXB bMvQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734713232; x=1735318032; h=content-transfer-encoding:subject:from:to:content-language :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=c7XCBZfXV4DPMMm/4i34x5OlikyqYWyhoYCmdusa1hU=; b=h0FmvM0srWs4pD8d1vi8IS/L0qMr/Kq6CLNhbzGq5uCDcTiFtbM2aH6FMYnLayhREE PuKp6W3TprgM+hJjb0KqlEB5fV2D0DQgUCEEpDNOrJuWnqfv6tgd3drV2Bi5HjSO+YQI 28a4XoTNsguIa9rXn3+K/HhXhbjIdRu7hEashBzztlhYVmKiylXhgJlpS8lIZB7onwND GJ487zrRf/ZMHfsePRZ0hUJV1X1cQnioOrsyhGCAxACk7SzT/M38xSCS9sPtoupuZssh 9CxMXL5Ijjxp5Y8QzUygqs/AaTyOIbgMqscpbTUkqHGc9Wd9Kk97Azxg9rzs/oGS8PaB OMFQ== X-Gm-Message-State: AOJu0Yzx5am4TQrAIe9UmdSbgH/lpq+JMmaJsnV+yXMVOc2U2wijnvMX JD7komXmAvJNlBshL7AoqUmulLkO8SeM4TNa476CGXQs4fcQ6Rf+KoXm/FSW X-Gm-Gg: ASbGnctcb7Sqd62N/RZDz7m5qTLzXArmdAD96mRWw2FVCpdgNK7AWubicUuFN+lht5v D2bcGidM5Ct9bl5AZoV87U6gzjSspIjVg3wP/haPVnqafnJ08tfL6iusQAIJ1AY+8YAE/C81VOo XX1W2sWXT4s6hoIFaphmVBPdjMbLBIZOv2IscIG9QgPJBhP5aiXHo+apv9vH0/sockJmhiAg+E6 dYgPtlQWa2jkDaz8O+wkrPBrEtYjU/G5sGmzAtK4mHdlHFbiZGsOO459PNnbgxsfOy2btjkKihi uNitapVBpMrtkVrSxNeGEOHrahQ= X-Google-Smtp-Source: AGHT+IFQAyW7RXudHIOt8MbBYuJHEU0EmVvozLo+650hDuDe5tK7FWzxQUefQ+BYEOyIf2vyDoh2eA== X-Received: by 2002:a05:6a20:158c:b0:1e0:d6ef:521a with SMTP id adf61e73a8af0-1e5e043f6c0mr6308222637.1.1734713231885; Fri, 20 Dec 2024 08:47:11 -0800 (PST) Received: from ?IPV6:2804:d47:60cb:1c00:b18d:19d2:9fd9:d41e? ([2804:d47:60cb:1c00:b18d:19d2:9fd9:d41e]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-72aad8dee97sm3423946b3a.126.2024.12.20.08.47.10 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 20 Dec 2024 08:47:11 -0800 (PST) Message-ID: <93b8da79-dea6-4ef4-9b65-8857410d85e1@gmail.com> Date: Fri, 20 Dec 2024 13:47:08 -0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Content-Language: en-US From: =?UTF-8?Q?Jos=C3=A9_?= =?UTF-8?Q?J=C3=BAnior?= Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Received-SPF: pass client-ip=2607:f8b0:4864:20::52c; envelope-from=jjnilton@gmail.com; helo=mail-pg1-x52c.google.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-Spam-Score: -1.3 (-) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -2.3 (--) 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 From unknown Fri Jun 20 20:10:49 2025 X-Loop: help-debbugs@gnu.org Subject: bug#74996: 28.2; sql interactive mode prints output of executed query where the pointer is instead of the bottom of the buffer Resent-From: Eli Zaretskii Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Fri, 20 Dec 2024 17:02:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 74996 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: =?UTF-8?Q?Jos=C3=A9_?= =?UTF-8?Q?J=C3=BAnior?= Cc: 74996@debbugs.gnu.org Received: via spool by 74996-submit@debbugs.gnu.org id=B74996.173471407811350 (code B ref 74996); Fri, 20 Dec 2024 17:02:01 +0000 Received: (at 74996) by debbugs.gnu.org; 20 Dec 2024 17:01:18 +0000 Received: from localhost ([127.0.0.1]:43819 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOgNJ-0002wx-OV for submit@debbugs.gnu.org; Fri, 20 Dec 2024 12:01:18 -0500 Received: from eggs.gnu.org ([209.51.188.92]:37818) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOgNG-0002wX-AY for 74996@debbugs.gnu.org; Fri, 20 Dec 2024 12:01:16 -0500 Received: from fencepost.gnu.org ([2001:470:142:3::e]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1tOgNA-0003KR-SQ; Fri, 20 Dec 2024 12:01:08 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org; s=fencepost-gnu-org; h=MIME-version:References:Subject:In-Reply-To:To:From: Date; bh=LR4vC+v4DTa0NNNOK6Z8+wRdln8NeiEempumxqfpq2g=; b=nUPil4bOjVZxTXCKy9uE Vl7s3hJgtNJoelL8usYJkdKEmZs3tDdtcnsyD2TgJReNPNTshPuC2AFw+KYO/LvmTLvvbVQ45IN7c pJEEllNoRPEu4zEzOIxBQXqqIJoi3oXa/km2g6A5DdtW5AL55/kMKFfIYPj8zXJcM/Q2tJ5yXvDt+ LIEgaKh16XhGA0OxmUN8b6sK8xxFqKb6TDDJMCtcjR3YnZfVUQw5e6+dNXObN/GweI4ZRDMavgiUN UstnuFmJVhgQ/j7jIjYaK5qphZN7GB0UhB3V3iXc8orVIWSmMUKVl34EfdjJNK3c7o8ZFpBlH6R5O uVgVNS7tP5uIQA==; Date: Fri, 20 Dec 2024 19:01:04 +0200 Message-Id: <86frmi9tm7.fsf@gnu.org> From: Eli Zaretskii In-Reply-To: <93b8da79-dea6-4ef4-9b65-8857410d85e1@gmail.com> (message from =?UTF-8?Q?Jos=C3=A9_?= =?UTF-8?Q?J=C3=BAnior?= on Fri, 20 Dec 2024 13:47:08 -0300) References: <93b8da79-dea6-4ef4-9b65-8857410d85e1@gmail.com> MIME-version: 1.0 Content-type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Spam-Score: 0.0 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -3.3 (---) > Date: Fri, 20 Dec 2024 13:47:08 -0300 > From: José Júnior > > 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. From unknown Fri Jun 20 20:10:49 2025 X-Loop: help-debbugs@gnu.org Subject: bug#74996: 28.2; sql interactive mode prints output of executed query where the pointer is instead of the bottom of the buffer Resent-From: =?UTF-8?Q?Jos=C3=A9_?= =?UTF-8?Q?J=C3=BAnior?= Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Fri, 20 Dec 2024 19:06:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 74996 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: Eli Zaretskii Cc: 74996@debbugs.gnu.org Received: via spool by 74996-submit@debbugs.gnu.org id=B74996.17347215092416 (code B ref 74996); Fri, 20 Dec 2024 19:06:02 +0000 Received: (at 74996) by debbugs.gnu.org; 20 Dec 2024 19:05:09 +0000 Received: from localhost ([127.0.0.1]:44052 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOiJA-0000by-W9 for submit@debbugs.gnu.org; Fri, 20 Dec 2024 14:05:09 -0500 Received: from mail-pf1-f172.google.com ([209.85.210.172]:58735) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOiJ7-0000Ye-30 for 74996@debbugs.gnu.org; Fri, 20 Dec 2024 14:05:07 -0500 Received: by mail-pf1-f172.google.com with SMTP id d2e1a72fcca58-7242f559a9fso2791559b3a.1 for <74996@debbugs.gnu.org>; Fri, 20 Dec 2024 11:05:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734721444; x=1735326244; darn=debbugs.gnu.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=ibIJueXoYEbk8moZKofAtJUOmI3aBwMsPznUASIYIsc=; b=jczrqDU4KLm7C1SvbzPQCj6p3XqPLXGUfVdwxE7KtHh9Pj0C2aJK1df6CmD1xf1Jx8 AAD7w7SPq7Q36zITYXgp2+qQkL/293XIYJUZf6cPtIBp4aBjeq05x0GgJHKFWGN+kBfo pxv8Q4crDKeojWFV2bLTqklURAhs1Qs9iLb2DLNYcsOcIPa5eWC8QhWm0zIC26AY61+U GM9xD4XKXREVHY8bCK1ksjLiejWeBAEjaA5PugJl1mEZ3+N+g74yVQdOWuQq1OS0RO5u ztwJfQBJsRWYxiR+ygNq+jbcpw/qv6yuHQnQHu/vMwfcCumPiOGGRcE5eRL5y9LbSmUF MqjQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734721444; x=1735326244; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=ibIJueXoYEbk8moZKofAtJUOmI3aBwMsPznUASIYIsc=; b=iCbYcBShR2MaJR4MqkXe3znX8lzyvqrtD2AwX4FYR/IHevooB2QWCvLbs9gvp8ZpB4 L90zhHJBim0fs7AeK0RmurFzV2h5GrN2dPiyx0IKz1c3no572DpPjFEC6nj8Bw4++188 TKOAm8WHzN4smpqgE1W59Pk0+j+Pqyqr3YAmhuXtlPVWAKg4zk7bbusceIArVyd3ZgLJ hwsihZ991ptrz99VTXyS5f1nSVWPrRFEvEYFQXSEc5JxzlbpiO0vphyFtriCAyNYV44e /k2wSrkIIy9oVf3dFehntXkYNtHrQRmQd/PxiKbbQhyvMTlAveWmPu3Y6rF5ETfL90W8 /vew== X-Gm-Message-State: AOJu0Yw4tWs2BJGQui3bSHe49b97udnGpacTHTl3udFO/VOrwaru/yR6 GfZ5utnwO3Y6wX1EfaVorgV1S7CQogfJ1WF3li9DdplkTKxMDxo5 X-Gm-Gg: ASbGncvLaXYPJkLl+7v8k8oPeNZY2q/p9f5H+Ipv1GE48pffSBD1QC7/2QPC4h8Evmg Yxr7LzoyY8kf+W/6AaWL374Z6+BR5TkzAxZuGuruZnvfCfI4NdJOHXxgDYJpuRdMDRrN73peoJN jfN+DhxwaO1w5/99RdPaiyH8uyl2Wh68MFZkCJwWgaQ7F1b3DClouOABCqJ368TGn/fdUhNg7nI TeQHfZI/6OIpBdIfWfdPGyeSWDh7CXjeIRiGTkn+inH8n5tg3TQIGFQVHNLtKVep7aBfsPPFRS8 0/0pKE893vpnBFd0zT1DqsgWVOk= X-Google-Smtp-Source: AGHT+IGd7nLyjnC+4nLH8PvXloYeq0Q7iNZ/iwdzKGfAB422OMpaBMYalfKQIs4kWVruHY4RXEIsNQ== X-Received: by 2002:a05:6a20:7f82:b0:1e0:d575:8d4f with SMTP id adf61e73a8af0-1e5e081c5acmr7284702637.37.1734721443662; Fri, 20 Dec 2024 11:04:03 -0800 (PST) Received: from ?IPV6:2804:d47:60cb:1c00:b18d:19d2:9fd9:d41e? ([2804:d47:60cb:1c00:b18d:19d2:9fd9:d41e]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-72aad816459sm3565265b3a.23.2024.12.20.11.04.02 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 20 Dec 2024 11:04:03 -0800 (PST) Message-ID: Date: Fri, 20 Dec 2024 16:03:59 -0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird References: <93b8da79-dea6-4ef4-9b65-8857410d85e1@gmail.com> <86frmi9tm7.fsf@gnu.org> Content-Language: en-US From: =?UTF-8?Q?Jos=C3=A9_?= =?UTF-8?Q?J=C3=BAnior?= In-Reply-To: <86frmi9tm7.fsf@gnu.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Spam-Score: 0.0 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) Alright, I'll try. 1. Install mysql or mariadb, on Debian I installed the package `mysql-common` `sudo apt install mysql-common` 2. Start the mysql/mariadb server: `sudo service mysql start` 3. Log in into the server and create a unprivileged user in the interactive mysql shell: `sudo mysql -u root` `CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';` 4. On Emacs, create a new buffer like `*sql*`, then enable sql-mode `M-x sql-mode`; 5. Connect to the server using `sql-mysql` by providing the values for what's prompted: - user: user - password: password - database: (leave it empty) - host: localhost A sql-interactive-mode buffer should be opened if the connection is successful. 6. In ther *sql* buffer enter the following query: `show databases;` And press `C-c C-c` (sql-send-paragraph) on the line of this query to send it to the server; An output of this query should be printed on the interactive buffer. 7. Now switch to the interactive buffer, move the pointer to a line where the output of the previous action was printed. 8. Switch to the *sql* buffer and press `C-C C-c` to send the command again. Now you should see that the second execution is mixed with the previous one. ---- Here's the information about my system and Emacs build: ``` In GNU Emacs 28.2 (build 1, x86_64-pc-linux-gnu, GTK+ Version 3.24.38, cairo version 1.16.0)  of 2024-06-25, modified by Debian built on x86-conova-01 Windowing system distributor 'The X.Org Foundation', version 11.0.12101007 System Description: Debian GNU/Linux 12 (bookworm) Configured using:  'configure --build x86_64-linux-gnu --prefix=/usr  --sharedstatedir=/var/lib --libexecdir=/usr/libexec  --localstatedir=/var/lib --infodir=/usr/share/info  --mandir=/usr/share/man --with-libsystemd --with-pop=yes  --enable-locallisppath=/etc/emacs:/usr/local/share/emacs/28.2/site-lisp:/usr/local/share/emacs/site-lisp:/usr/share/emacs/28.2/site-lisp:/usr/share/emacs/site-lisp  --with-sound=alsa --without-gconf --with-mailutils  --with-native-compilation --build x86_64-linux-gnu --prefix=/usr  --sharedstatedir=/var/lib --libexecdir=/usr/libexec  --localstatedir=/var/lib --infodir=/usr/share/info  --mandir=/usr/share/man --with-libsystemd --with-pop=yes  --enable-locallisppath=/etc/emacs:/usr/local/share/emacs/28.2/site-lisp:/usr/local/share/emacs/site-lisp:/usr/share/emacs/28.2/site-lisp:/usr/share/emacs/site-lisp  --with-sound=alsa --without-gconf --with-mailutils  --with-native-compilation --with-cairo --with-x=yes  --with-x-toolkit=gtk3 --with-toolkit-scroll-bars 'CFLAGS=-g -O2  -ffile-prefix-map=/build/reproducible-path/emacs-28.2+1=. -fstack-protector-strong  -Wformat -Werror=format-security -Wall' 'CPPFLAGS=-Wdate-time  -D_FORTIFY_SOURCE=2' LDFLAGS=-Wl,-z,relro' Configured features: ACL CAIRO DBUS FREETYPE GIF GLIB GMP GNUTLS GPM GSETTINGS HARFBUZZ JPEG JSON LCMS2 LIBOTF LIBSELINUX LIBSYSTEMD LIBXML2 M17N_FLT MODULES NATIVE_COMP NOTIFY INOTIFY PDUMPER PNG RSVG SECCOMP SOUND THREADS TIFF TOOLKIT_SCROLL_BARS X11 XDBE XIM XPM GTK3 ZLIB Important settings:   value of $LC_MONETARY: pt_BR.UTF-8   value of $LC_NUMERIC: pt_BR.UTF-8   value of $LC_TIME: en_US.UTF-8   value of $LANG: en_US.UTF-8   locale-coding-system: utf-8-unix Major mode: Lisp Interaction Minor modes in effect:   tooltip-mode: t   global-eldoc-mode: t   eldoc-mode: t   show-paren-mode: t   electric-indent-mode: t   mouse-wheel-mode: t   tool-bar-mode: t   menu-bar-mode: t   file-name-shadow-mode: t   global-font-lock-mode: t   font-lock-mode: t   blink-cursor-mode: t   auto-composition-mode: t   auto-encryption-mode: t   auto-compression-mode: t   line-number-mode: t   indent-tabs-mode: t   transient-mark-mode: t Load-path shadows: None found. Features: (shadow sort mail-extr emacsbug message rmc puny dired dired-loaddefs rfc822 mml mml-sec epa derived epg rfc6068 epg-config gnus-util rmail rmail-loaddefs auth-source cl-seq eieio eieio-core cl-macs eieio-loaddefs password-cache json map text-property-search time-date subr-x seq byte-opt gv bytecomp byte-compile cconv mm-decode mm-bodies mm-encode mail-parse rfc2231 mailabbrev gmm-utils mailheader cl-loaddefs cl-lib sendmail rfc2047 rfc2045 ietf-drums mm-util mail-prsvr mail-utils iso-transl tooltip eldoc paren electric uniquify ediff-hook vc-hooks lisp-float-type elisp-mode mwheel term/x-win x-win term/common-win x-dnd tool-bar dnd fontset image regexp-opt fringe tabulated-list replace newcomment text-mode lisp-mode prog-mode register page tab-bar menu-bar rfn-eshadow isearch easymenu timer select scroll-bar mouse jit-lock font-lock syntax font-core term/tty-colors frame minibuffer cl-generic cham georgian utf-8-lang misc-lang vietnamese tibetan thai tai-viet lao korean japanese eucjp-ms cp51932 hebrew greek romanian slovak czech european ethiopic indian cyrillic chinese composite emoji-zwj charscript charprop case-table epa-hook jka-cmpr-hook help simple abbrev obarray cl-preloaded nadvice button loaddefs faces cus-face macroexp files window text-properties overlay sha1 md5 base64 format env code-pages mule custom widget hashtable-print-readable backquote threads dbusbind inotify lcms2 dynamic-setting system-font-setting font-render-setting cairo move-toolbar gtk x-toolkit x multi-tty make-network-process native-compile emacs) Memory information: ((conses 16 67701 7304)  (symbols 48 6640 0)  (strings 32 19402 1678)  (string-bytes 1 657582)  (vectors 16 13801)  (vector-slots 8 295271 11392)  (floats 8 23 31)  (intervals 56 280 0)  (buffers 992 11)) ``` On 12/20/24 14:01, Eli Zaretskii wrote: >> Date: Fri, 20 Dec 2024 13:47:08 -0300 >> From: José Júnior >> >> 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. From unknown Fri Jun 20 20:10:49 2025 X-Loop: help-debbugs@gnu.org Subject: bug#74996: 28.2; sql interactive mode prints output of executed query where the pointer is instead of the bottom of the buffer Resent-From: Eli Zaretskii Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Fri, 20 Dec 2024 19:36:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 74996 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: =?UTF-8?Q?Jos=C3=A9_?= =?UTF-8?Q?J=C3=BAnior?= Cc: 74996@debbugs.gnu.org Received: via spool by 74996-submit@debbugs.gnu.org id=B74996.17347233147570 (code B ref 74996); Fri, 20 Dec 2024 19:36:02 +0000 Received: (at 74996) by debbugs.gnu.org; 20 Dec 2024 19:35:14 +0000 Received: from localhost ([127.0.0.1]:44085 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOimH-0001xV-Pw for submit@debbugs.gnu.org; Fri, 20 Dec 2024 14:35:14 -0500 Received: from eggs.gnu.org ([209.51.188.92]:51430) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOimE-0001vS-NT for 74996@debbugs.gnu.org; Fri, 20 Dec 2024 14:35:12 -0500 Received: from fencepost.gnu.org ([2001:470:142:3::e]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1tOik3-0000RJ-0l; Fri, 20 Dec 2024 14:32:55 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org; s=fencepost-gnu-org; h=MIME-version:References:Subject:In-Reply-To:To:From: Date; bh=PbFT3QE4AtDg6/pUJnaQssqSx2U1ZWERkkU2ZeTFb+c=; b=nb6MJLveAG/SOoB6xz6L de0he3SwPWcNMygmAQYRJtIckAFE1iDj6LDuhJwVPxnrBO5F79vl54RFcS+nTPTAtD90IKyCrz3rn ca4Vr3A7N1/IT1CuxUchVoi/KuTWvoYdwcsU2yyxiCq1ZudVJGCMr17tKfZdFqs4w+3jTv80dr9ye 77migHxpgbcBC4YLbu9gJmyKjsUNSHd4mal/YFBhz3F1lJJXhS5Ln8E5sqW4XEN5meh1z4Rc3aRNm T8R7r4nkbwjcmu0cADcsECwZBbkRgmOmtscxBvqowBIRx83Zh/QQoYo6DnXkvOBwGaqA0UvIY4O1L 9+sqkaiiAq//Mw==; Date: Fri, 20 Dec 2024 21:32:53 +0200 Message-Id: <86ed229ml6.fsf@gnu.org> From: Eli Zaretskii In-Reply-To: (message from =?UTF-8?Q?Jos=C3=A9_?= =?UTF-8?Q?J=C3=BAnior?= on Fri, 20 Dec 2024 16:03:59 -0300) References: <93b8da79-dea6-4ef4-9b65-8857410d85e1@gmail.com> <86frmi9tm7.fsf@gnu.org> MIME-version: 1.0 Content-type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Spam-Score: -2.3 (--) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -3.3 (---) > Date: Fri, 20 Dec 2024 16:03:59 -0300 > Cc: 74996@debbugs.gnu.org > From: José Júnior > > Alright, I'll try. > > 1. Install mysql or mariadb, on Debian I installed the package `mysql-common` > > `sudo apt install mysql-common` > > 2. Start the mysql/mariadb server: > > `sudo service mysql start` > > 3. Log in into the server and create a unprivileged user in the interactive mysql shell: > > `sudo mysql -u root` > > `CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';` > > 4. On Emacs, create a new buffer like `*sql*`, then enable sql-mode `M-x sql-mode`; > > 5. Connect to the server using `sql-mysql` by providing the values for what's prompted: > > - user: user > > - password: password > > - database: (leave it empty) > > - host: localhost > > A sql-interactive-mode buffer should be opened if the connection is successful. > > 6. In ther *sql* buffer enter the following query: > > `show databases;` > > And press `C-c C-c` (sql-send-paragraph) on the line of this query to send it to the server; > > An output of this query should be printed on the interactive buffer. > > 7. Now switch to the interactive buffer, move the pointer to a line where the output of the previous action was printed. > > 8. Switch to the *sql* buffer and press `C-C C-c` to send the command again. > > Now you should see that the second execution is mixed with the previous one. Thanks. If this needs the mysql package, then why do you think the problem is in Emacs and not in mysql? (Apologies if this makes no sense: I know nothing about mysql and almost nothing about sql-mode.) From unknown Fri Jun 20 20:10:49 2025 X-Loop: help-debbugs@gnu.org Subject: bug#74996: 28.2; sql interactive mode prints output of executed query where the pointer is instead of the bottom of the buffer Resent-From: Stephen Berman Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Fri, 20 Dec 2024 20:09:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 74996 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: Eli Zaretskii Cc: 74996@debbugs.gnu.org, =?UTF-8?Q?Jos=C3=A9_?= =?UTF-8?Q?J=C3=BAnior?= Received: via spool by 74996-submit@debbugs.gnu.org id=B74996.173472533313884 (code B ref 74996); Fri, 20 Dec 2024 20:09:01 +0000 Received: (at 74996) by debbugs.gnu.org; 20 Dec 2024 20:08:53 +0000 Received: from localhost ([127.0.0.1]:44144 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOjIq-0003bs-Q8 for submit@debbugs.gnu.org; Fri, 20 Dec 2024 15:08:53 -0500 Received: from mout.gmx.net ([212.227.15.18]:36193) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOjIp-0003bb-0f for 74996@debbugs.gnu.org; Fri, 20 Dec 2024 15:08:51 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1734725318; x=1735330118; i=stephen.berman@gmx.net; bh=piGdwMmF9bi2TZX5y+61Wm707UwXDBPM3+4D//c2inM=; h=X-UI-Sender-Class:From:To:Cc:Subject:In-Reply-To:References:Date: Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=RuZZu5FZR4wWYOoz0GTVM02DQmxZwEcG1Y8nO8Hdia/LU1E7CSMHX/c9oOZLNjuN Ha3THldNu2+PEphETq6v9W3ZUKlCg4gV9hFPIw/aER0ziJuXp/u8On3W7Y3KA7qUh QN/Yykuo2JepseaqXePAJmUS8FpM5EpjDWs4DiZnm1YsIV1slqznuQ04dCSiu5vxm lnhxvvep9o5J00T4MSb09ELig+f25zqoxTu0nQ4kiWbniMYgJaGB5gfIxS/6EPEyP 8Rvh2NlcD2Zi+dY2U0AuSyPkhnIcApw2V8yTaLwGYdbligQmuJ20jPNjqIUE+FqsT DIPBPQR4ayLG1KH5Tw== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from strobelfssd ([94.134.95.89]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MSKuA-1t0UKE0Io4-00TVSs; Fri, 20 Dec 2024 21:08:38 +0100 From: Stephen Berman In-Reply-To: <86ed229ml6.fsf@gnu.org> (Eli Zaretskii's message of "Fri, 20 Dec 2024 21:32:53 +0200") References: <93b8da79-dea6-4ef4-9b65-8857410d85e1@gmail.com> <86frmi9tm7.fsf@gnu.org> <86ed229ml6.fsf@gnu.org> Date: Fri, 20 Dec 2024 21:08:36 +0100 Message-ID: <87a5cqnmm3.fsf@gmx.net> User-Agent: Gnus/5.13 (Gnus v5.13) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:Hgg1eLMZmxuPT6VjLPEG1ftrQ4BtqYC1wrgEbkO/ZxtL14jZauE m0DbYI1r1CWPhsAaXrxAWEhFar2Ns7L3d8YODBIV3YeqkyB6uIzuV44lN0eGus2Pn0rHpsl RFvdmLD4vAZcb/H1rpr/tUC3+IC3P1xoNDqZ47oVREidAHSUg8EfzOYZWsZd1q7o5nLSt/c xdnP3It3GTzL9pR6OZYmg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:et/w++v3WRk=;Zq5z0q5+X1f39uXLz3bbFBfAr0a /s53dhrpXgktncpa3BUbVaTVWCV4euXfmlTSEjgIflq17IuUl4pEZ084y+E9yUkGO0tT8n3E6 MzeIyVYTg3RhYfpvNnWbTpZcWBvtb4CLrHzqArzU/1vZtAv46fppaM4oIGE+7eSCTUjM0lnb+ BIxruJ9VfWnccq7rgmKxecXaBZzeceg6x4b6HskZ739YMUJ7POs3Yds9jtGtyV15chA4GQ30T T8SiRmoCsYiY326YMXPBJ/8qwL0ge+t1PUjgX30dJFdanb94Sn7UC1yqtDQj0Ql7dsH/qy80A IMUc1mbDFxkj0yYbqaRYHh0JDpr3Rrhhv232gIGORs2mShEBokImDchTN2yw0ZHV3ja/Lg57l iEUphmxOGdIeLD9P2/4aWV94dzgAaVI6JptJufrPdqOvPp+VCWaqWPu5yxXOjGiLXTHMtoeyq 7U4Xbx9iOTXGKnfCPuYmVB/eREY8U2+y8FUK2HS0UjOf/+/UwieXx3xtLJQU9D4IvVUTVh/97 yhORJnjFS19/hTccVr9jpZ3zTp9TFTme+0bUe6nTtLnaNA0Bal2kg7zbJPmdoxMVMJw9u4MJh 4ViCDsN9sUR/fkAG/np+Fc/6SMZMiOgXAF55BixMNZZYEGbOpUBscwVoXgA9O8VCsBkPqVUnW /IxduOoNRmlkKdBQ9N3WJ7QxfjN4a30slO2vJNIGnWYVkfiSLqhBxi/mIu2tzqrhqtxbhr3EN pPq3apCk+O1NeKjbQack4wzYxbgCGrDro2gPkMG188ajPu6y9CBR/HMbjZ1LlK3rmvYbVvckW Fts1hBeDUsG34nfN8QcNxVhrgXAWPfjG09p+SuSPS1BXIrqzLrMRVH2zJGmNnFij1HIzjgm2r OePY0/Xu1jJvLRodUzQasGdiA/73Qzd2FLlO6F3VUHkeoU+egyXnvtRwCGDx1FHYbu55+SuPg 7NphI7t9NAEHR3cRF/cG/ZrmbfHM8prE2WliVR/WO9HoraVkJHRUY7EX0/f9Ex0spUQO854ml Yvw0mUKVzQ0/Hjbqqgy8xhbKyae5UrS76BVwG2EOTvcYvidU2HjcqRBSaVvrsaUGq1VW/wDmi lAUec//Qi8jbwLKiiRWpgQpyaAO0Sk X-Spam-Score: -0.7 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.7 (-) On Fri, 20 Dec 2024 21:32:53 +0200 Eli Zaretskii wrote: >> Date: Fri, 20 Dec 2024 16:03:59 -0300 >> Cc: 74996@debbugs.gnu.org >> From: Jos=C3=A9 J=C3=BAnior >>=20 >> Alright, I'll try. >>=20 >> 1. Install mysql or mariadb, on Debian I installed the package `mysql-co= mmon` >>=20 >> `sudo apt install mysql-common` >>=20 >> 2. Start the mysql/mariadb server: >>=20 >> `sudo service mysql start` >>=20 >> 3. Log in into the server and create a unprivileged user in the interact= ive >> mysql shell: >>=20 >> `sudo mysql -u root` >>=20 >> `CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';` >>=20 >> 4. On Emacs, create a new buffer like `*sql*`, then enable sql-mode `M-x= sql-mode`; >>=20 >> 5. Connect to the server using `sql-mysql` by providing the values for >> what's prompted: >>=20 >> - user: user >>=20 >> - password: password >>=20 >> - database: (leave it empty) >>=20 >> - host: localhost >>=20 >> A sql-interactive-mode buffer should be opened if the connection is succ= essful. >>=20 >> 6. In ther *sql* buffer enter the following query: >>=20 >> `show databases;` >>=20 >> And press `C-c C-c` (sql-send-paragraph) on the line of this query to se= nd >> it to the server; >>=20 >> An output of this query should be printed on the interactive buffer. >>=20 >> 7. Now switch to the interactive buffer, move the pointer to a line where >> the output of the previous action was printed. >>=20 >> 8. Switch to the *sql* buffer and press `C-C C-c` to send the command ag= ain. >>=20 >> Now you should see that the second execution is mixed with the previous = one. > > Thanks. If this needs the mysql package, then why do you think the > problem is in Emacs and not in mysql? (Apologies if this makes no > sense: I know nothing about mysql and almost nothing about sql-mode.) I don't have MySQL or mariadb but I can reproduce the problem with PostgreSQL in Emacs 29.4, but not in 30 or master, so it seems to have been fixed since Emacs 30. Steve Berman From unknown Fri Jun 20 20:10:49 2025 X-Loop: help-debbugs@gnu.org Subject: bug#74996: 28.2; sql interactive mode prints output of executed query where the pointer is instead of the bottom of the buffer Resent-From: Eli Zaretskii Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Fri, 20 Dec 2024 20:13:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 74996 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: Stephen Berman Cc: 74996@debbugs.gnu.org, jjnilton@gmail.com Received: via spool by 74996-submit@debbugs.gnu.org id=B74996.173472552314593 (code B ref 74996); Fri, 20 Dec 2024 20:13:02 +0000 Received: (at 74996) by debbugs.gnu.org; 20 Dec 2024 20:12:03 +0000 Received: from localhost ([127.0.0.1]:44154 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOjLv-0003nJ-FV for submit@debbugs.gnu.org; Fri, 20 Dec 2024 15:12:03 -0500 Received: from eggs.gnu.org ([209.51.188.92]:60434) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOjLt-0003mh-76 for 74996@debbugs.gnu.org; Fri, 20 Dec 2024 15:12:01 -0500 Received: from fencepost.gnu.org ([2001:470:142:3::e]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1tOjLo-0002T7-0a; Fri, 20 Dec 2024 15:11:56 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org; s=fencepost-gnu-org; h=MIME-version:References:Subject:In-Reply-To:To:From: Date; bh=tMAcJuP4757Z6MpN7A+9ZeJbn0DWms+ESU0YzKxdkwk=; b=dAeKN3lp5n79DQPOV+Av uc8SpM3iMQXpqY8Ic48YYKvOSSAi8nNGbx5zTEgB6kGDDz7n7yJpi+QqM2yyAF4fA+qEcechxaaD6 TEt/QbGoRf6VVqds/gKOTposC6w/Yr8vW2UrY+qQg4TyMm1L0FCt9oP7njgVjRIYC+duoJN0pAhUN ZiO4h7i+1joFDaZm9zYUlT/h92bmkk2x+7zgKh0Q3LH7Rd68ovnuSMogumfXbl1tDEVV0GY1etxzb o0jgJBNNDEYfE7foFHkL5whwR/+n8CIww1hA1d+NIKNE8fUCsGXSRpM9qrvjThwT7nDNJFWS3+JEH NO7uVk+FOwJ+3A==; Date: Fri, 20 Dec 2024 22:11:54 +0200 Message-Id: <86a5cq9ks5.fsf@gnu.org> From: Eli Zaretskii In-Reply-To: <87a5cqnmm3.fsf@gmx.net> (message from Stephen Berman on Fri, 20 Dec 2024 21:08:36 +0100) References: <93b8da79-dea6-4ef4-9b65-8857410d85e1@gmail.com> <86frmi9tm7.fsf@gnu.org> <86ed229ml6.fsf@gnu.org> <87a5cqnmm3.fsf@gmx.net> MIME-version: 1.0 Content-type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Spam-Score: -2.3 (--) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -3.3 (---) > From: Stephen Berman > Cc: José Júnior , > 74996@debbugs.gnu.org > Date: Fri, 20 Dec 2024 21:08:36 +0100 > > I don't have MySQL or mariadb but I can reproduce the problem with > PostgreSQL in Emacs 29.4, but not in 30 or master, so it seems to have > been fixed since Emacs 30. Thanks. José, can you try Emacs 30? The latest pretest is here: https://alpha.gnu.org/gnu/emacs/pretest/emacs-30.0.93.tar.xz From unknown Fri Jun 20 20:10:49 2025 X-Loop: help-debbugs@gnu.org Subject: bug#74996: 28.2; sql interactive mode prints output of executed query where the pointer is instead of the bottom of the buffer Resent-From: =?UTF-8?Q?Jos=C3=A9_?= =?UTF-8?Q?J=C3=BAnior?= Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Fri, 20 Dec 2024 20:15:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 74996 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: Eli Zaretskii Cc: 74996@debbugs.gnu.org Received: via spool by 74996-submit@debbugs.gnu.org id=B74996.173472565414842 (code B ref 74996); Fri, 20 Dec 2024 20:15:02 +0000 Received: (at 74996) by debbugs.gnu.org; 20 Dec 2024 20:14:14 +0000 Received: from localhost ([127.0.0.1]:44163 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOjO2-0003rK-AU for submit@debbugs.gnu.org; Fri, 20 Dec 2024 15:14:14 -0500 Received: from mail-pl1-f171.google.com ([209.85.214.171]:48254) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOjNz-0003r4-OJ for 74996@debbugs.gnu.org; Fri, 20 Dec 2024 15:14:12 -0500 Received: by mail-pl1-f171.google.com with SMTP id d9443c01a7336-216281bc30fso25825955ad.0 for <74996@debbugs.gnu.org>; Fri, 20 Dec 2024 12:14:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734725586; x=1735330386; darn=debbugs.gnu.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=SzjoIn32NvbMTdpv0mXvgsJvGTixy0uXbKWcUUDtTiY=; b=N/ZI/oS1EVeHAQIA+nC+mO0kb9jeuvR31oBwiycJY1DdBU47NCfb8llXvGXZmYKK9U rOWH1JvxFsrtYnLp+2n9pevDcwHF5K2mSGsawuq7iX1BymiB+9BQMQiMH/rBFf+QrE3D GsejPVB6yL6BB5/fHonrfe0h+OV5RBPKUVsYANEqR78KUeN418HXVVeRO2PkEZJ8+/rx Ic77I0Z3vJch1W/TmR2O6XK4IZ9nKWSMjyYfYJDirJJXG9gsgKu2/bscEL95gAlI/gqx IpAJopvn9KqTKUs+ErSVgqeT8kKXl/X6RdpV0HVbcZFcAPebeev/gFFnAHXXs9ssL8QS m3HA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734725586; x=1735330386; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=SzjoIn32NvbMTdpv0mXvgsJvGTixy0uXbKWcUUDtTiY=; b=szxJdfwUGi6QdfTlKPofIGjl/4peU87ULAFRWdKGopvhghXhIPviz8mKEiwwZL0Wd8 OE6EUdSsvGjjK/kPKocUYrggO1qF05QZ4xC0QpLslGXMwP/5FJFIncBoV0nR0+NrbX1t F3kBveFryBNhjdcCqoV1c+rfx1bXuiE9tSxopyEtYPUDf0F21g8LAEqROTyrH1N5LRlJ FoKw02O+NHtZVA/Wncn5yDJO/MlFITziE7i4octDf+vsKdKbYxwV8h5+LosIEiw2Fnow B+M+dYNp3DwgaoW1pDWjZnw2gcrDRtbOLtTJaHu2e9ygqAMdwQH+J3c1cXW6Era+M/9o Wn2g== X-Gm-Message-State: AOJu0YwwBpWN4WIk4doR7DWMCK3WW3TXehJ66OexyI7YxEFajW1Z2o7C GPMQF3h0yKGK71I8P4LNHkUy7S1fEmEkdMSyKhF090+YKSEY0wMJ X-Gm-Gg: ASbGnctWojOmS8rapwlHavRpHal3QbBY6IZZCT8aw3ttcu2t1ZoD8+VMnqX1dQj8XsJ jITkGdZf0WcqASj86U8AvcPL/UW0v9fBiYVMVEg3pv9Pf3OKL8g3btl0wM9p9SzhziEcbIhGwh4 5oohoDtwkgWj9bQ3gWMUQOZRLRpJYjGeNBq2UdjHVUn2ftoqz0eOB/ymYb8muJpEXYJYBT6b41C OF/6+zzwO3/FjxYT2kjx5iHwYfN/a5IvDUwnWBlOaJoVWXBRMCuz2Fpq+YoG/yBGUr+GInknUoU ENkvP2k+UGaDoYnKVTQIJlWfqxA= X-Google-Smtp-Source: AGHT+IFUnnBehy3pWglGkIHoEkCpRkpVMLz1I6gYQpY+zAThVgDE/cufhMVmwWvD87aIvxopUZEZ7w== X-Received: by 2002:a17:903:244c:b0:215:8d29:af2d with SMTP id d9443c01a7336-219e6f25f55mr57022645ad.38.1734725585864; Fri, 20 Dec 2024 12:13:05 -0800 (PST) Received: from ?IPV6:2804:d47:60cb:1c00:b18d:19d2:9fd9:d41e? ([2804:d47:60cb:1c00:b18d:19d2:9fd9:d41e]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-219dc9f4413sm32906415ad.172.2024.12.20.12.13.04 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 20 Dec 2024 12:13:05 -0800 (PST) Message-ID: <41535963-d753-49aa-b8a3-eb5ed464f1b4@gmail.com> Date: Fri, 20 Dec 2024 17:13:02 -0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird References: <93b8da79-dea6-4ef4-9b65-8857410d85e1@gmail.com> <86frmi9tm7.fsf@gnu.org> <86ed229ml6.fsf@gnu.org> Content-Language: en-US From: =?UTF-8?Q?Jos=C3=A9_?= =?UTF-8?Q?J=C3=BAnior?= In-Reply-To: <86ed229ml6.fsf@gnu.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Spam-Score: 0.0 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) I think because the issue is where the output is printed on the buffer, so it would be something after the mysql package gives the output to Emacs. As I understand, the mysql package only gives the output of the SQL query to Emacs, then Emacs should be in control to where to print it. And since it's taking into account where the pointer is to print the output, it seems to be the case. >> Date: Fri, 20 Dec 2024 16:03:59 -0300 >> Cc: 74996@debbugs.gnu.org >> From: José Júnior >> >> Alright, I'll try. >> >> 1. Install mysql or mariadb, on Debian I installed the package `mysql-common` >> >> `sudo apt install mysql-common` >> >> 2. Start the mysql/mariadb server: >> >> `sudo service mysql start` >> >> 3. Log in into the server and create a unprivileged user in the interactive mysql shell: >> >> `sudo mysql -u root` >> >> `CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';` >> >> 4. On Emacs, create a new buffer like `*sql*`, then enable sql-mode `M-x sql-mode`; >> >> 5. Connect to the server using `sql-mysql` by providing the values for what's prompted: >> >> - user: user >> >> - password: password >> >> - database: (leave it empty) >> >> - host: localhost >> >> A sql-interactive-mode buffer should be opened if the connection is successful. >> >> 6. In ther *sql* buffer enter the following query: >> >> `show databases;` >> >> And press `C-c C-c` (sql-send-paragraph) on the line of this query to send it to the server; >> >> An output of this query should be printed on the interactive buffer. >> >> 7. Now switch to the interactive buffer, move the pointer to a line where the output of the previous action was printed. >> >> 8. Switch to the *sql* buffer and press `C-C C-c` to send the command again. >> >> Now you should see that the second execution is mixed with the previous one. > Thanks. If this needs the mysql package, then why do you think the > problem is in Emacs and not in mysql? (Apologies if this makes no > sense: I know nothing about mysql and almost nothing about sql-mode.) From unknown Fri Jun 20 20:10:49 2025 X-Loop: help-debbugs@gnu.org Subject: bug#74996: 28.2; sql interactive mode prints output of executed query where the pointer is instead of the bottom of the buffer Resent-From: =?UTF-8?Q?Jos=C3=A9_?= =?UTF-8?Q?J=C3=BAnior?= Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Fri, 20 Dec 2024 20:36:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 74996 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: Eli Zaretskii , Stephen Berman Cc: 74996@debbugs.gnu.org Received: via spool by 74996-submit@debbugs.gnu.org id=B74996.173472691919002 (code B ref 74996); Fri, 20 Dec 2024 20:36:02 +0000 Received: (at 74996) by debbugs.gnu.org; 20 Dec 2024 20:35:19 +0000 Received: from localhost ([127.0.0.1]:44219 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOjiR-0004wP-7S for submit@debbugs.gnu.org; Fri, 20 Dec 2024 15:35:19 -0500 Received: from mail-pf1-f176.google.com ([209.85.210.176]:51703) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOjiO-0004wE-KT for 74996@debbugs.gnu.org; Fri, 20 Dec 2024 15:35:17 -0500 Received: by mail-pf1-f176.google.com with SMTP id d2e1a72fcca58-725dbdf380aso2003845b3a.3 for <74996@debbugs.gnu.org>; Fri, 20 Dec 2024 12:35:16 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734726856; x=1735331656; darn=debbugs.gnu.org; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=0pckzeUXeuYfVBqoLUww37Q1W9yZPIRh+p/COXofHIE=; b=k8ZasK1PwXB0bJYu7r598PBa3wD+agl28K/oIkIcVlQarhANTYBV/A3gTJKJo56RdP m10qD8lmwX/kONfnJrFQZQNgLq6TT0UdFNiD66GF5TwXsiCU8KOjzx9fQYxh25BDGh9Q oqAZNT5BtXnkPJf7DMPM3LkMBlSC7/Wsl1F7ooDe+6tqHln/mu0B6h1c28WVh8nMgoaH SGSqXGfXz9xfPKFUYcZHy+liaATgVV0UfLPnKmAr9XRsRN2jL8V0jlYFb3f45tE8SzMj erVqyJJFSkYkHLBu85MqMM5RYiN7OPihQnVujsyX7muyDbmdH90WJszXiDA+WhJPCyhM Jwdg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734726856; x=1735331656; h=content-transfer-encoding:in-reply-to:from:content-language :references:cc:to:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=0pckzeUXeuYfVBqoLUww37Q1W9yZPIRh+p/COXofHIE=; b=BrmQkhkp5xvOG35cmOC5oECphTmuiTP9cuqo1CtgVQdhGrprpXlxraF5WDDdYAz5La qvKUR5ZZQNXoT3+8kHJpGAmovz0+CKUnGVpvDW21SmbNA43UugYilwVamJBpLvciehqH p8s/OLtRp1nV160teAHjeDn24wBxk/MkL6GVoXxJIaCxW2HE2Nm+qVhnRA9ymUe/h/oW 17CkDE6y20eW0xZ9ws0J8qeYelo+eIXi6QUNRgPE5b5CPJLHv+DnRb8p3ucqtoPU0g+5 UQqJB6HUD9Y5kw7PEdnUwhqGGAW297AXHm2wQYuNbf2LORzkHsnGg3wVJc8n/mhCBiaz 9ZaA== X-Gm-Message-State: AOJu0YzKWjBUAG76o1rCM1WPYyiHLqVSeFGp26E9LWGoIAltqsG3eSJV htsxc9nIYDP9qiGHZ4JELR7x7FvxjUrO8+360kXnWq1yRG8oyjyS X-Gm-Gg: ASbGncuO3R+2EAf+3y43R6jXOrPYB4tHS/aAbOhpD/rPvrFBP4cEtQaGlXGpcUNJWvm w6cco7IyE/4uxNDhwMmaQf/qLmJ8ZY/NePiCgWohZRMLXp41LdVT3gNG6BvYijrXaYNwvXfcDex DT4kl4jutZhIa76cqRoRH5T9JreDiYXQHqK/FPNq5Cedgo0Fdsips3wHpFsu7iG8/8CO0EhshOI 23ym+knt8M5Nvd2rc+SJfnNpnBJEkv94HNyC7T7MDyaBOpAEtgbAQt0qnYzzd4lE8M2OKrXzqHJ YUHlY1OyAryXQU5nTx6FeZlCwNE= X-Google-Smtp-Source: AGHT+IHwB0W/+IbW/xVe3Ms/o1ZrBRaaOQmq0aqNvQn4nzarCY6P9nEkvmrj1MTdvxuH3dZmDM6VXA== X-Received: by 2002:a05:6a00:600c:b0:71e:16b3:e5dc with SMTP id d2e1a72fcca58-72abde84e5cmr6370548b3a.19.1734726855851; Fri, 20 Dec 2024 12:34:15 -0800 (PST) Received: from ?IPV6:2804:d47:60cb:1c00:b18d:19d2:9fd9:d41e? ([2804:d47:60cb:1c00:b18d:19d2:9fd9:d41e]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-842b1ce1fd5sm3261236a12.25.2024.12.20.12.34.14 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 20 Dec 2024 12:34:15 -0800 (PST) Message-ID: <3dfb3baf-b79b-4e8e-b7e1-7980b5163078@gmail.com> Date: Fri, 20 Dec 2024 17:34:12 -0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird References: <93b8da79-dea6-4ef4-9b65-8857410d85e1@gmail.com> <86frmi9tm7.fsf@gnu.org> <86ed229ml6.fsf@gnu.org> <87a5cqnmm3.fsf@gmx.net> <86a5cq9ks5.fsf@gnu.org> Content-Language: en-US From: =?UTF-8?Q?Jos=C3=A9_?= =?UTF-8?Q?J=C3=BAnior?= In-Reply-To: <86a5cq9ks5.fsf@gnu.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Spam-Score: 0.0 (/) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.0 (-) Just tried on Emacs 30 (emacs-30.0.93) and could not reproduce the bug. On 12/20/24 17:11, Eli Zaretskii wrote: >> From: Stephen Berman >> Cc: José Júnior , >> 74996@debbugs.gnu.org >> Date: Fri, 20 Dec 2024 21:08:36 +0100 >> >> I don't have MySQL or mariadb but I can reproduce the problem with >> PostgreSQL in Emacs 29.4, but not in 30 or master, so it seems to have >> been fixed since Emacs 30. > Thanks. José, can you try Emacs 30? The latest pretest is here: > > https://alpha.gnu.org/gnu/emacs/pretest/emacs-30.0.93.tar.xz From unknown Fri Jun 20 20:10:49 2025 MIME-Version: 1.0 X-Mailer: MIME-tools 5.505 (Entity 5.505) X-Loop: help-debbugs@gnu.org From: help-debbugs@gnu.org (GNU bug Tracking System) To: =?UTF-8?Q?Jos=C3=A9_?= =?UTF-8?Q?J=C3=BAnior?= Subject: bug#74996: closed (Re: bug#74996: 28.2; sql interactive mode prints output of executed query where the pointer is instead of the bottom of the buffer) Message-ID: References: <865xnda6hn.fsf@gnu.org> <93b8da79-dea6-4ef4-9b65-8857410d85e1@gmail.com> X-Gnu-PR-Message: they-closed 74996 X-Gnu-PR-Package: emacs Reply-To: 74996@debbugs.gnu.org Date: Sat, 21 Dec 2024 06:38:02 +0000 Content-Type: multipart/mixed; boundary="----------=_1734763082-28743-1" This is a multi-part message in MIME format... ------------=_1734763082-28743-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" Your bug report #74996: 28.2; sql interactive mode prints output of executed query where th= e pointer is instead of the bottom of the buffer which was filed against the emacs package, has been closed. The explanation is attached below, along with your original report. If you require more details, please reply to 74996@debbugs.gnu.org. --=20 74996: https://debbugs.gnu.org/cgi/bugreport.cgi?bug=3D74996 GNU Bug Tracking System Contact help-debbugs@gnu.org with problems ------------=_1734763082-28743-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at 74996-done) by debbugs.gnu.org; 21 Dec 2024 06:37:34 +0000 Received: from localhost ([127.0.0.1]:44982 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOt7F-0007So-Va for submit@debbugs.gnu.org; Sat, 21 Dec 2024 01:37:34 -0500 Received: from eggs.gnu.org ([209.51.188.92]:46838) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOt7E-0007Sa-9x for 74996-done@debbugs.gnu.org; Sat, 21 Dec 2024 01:37:33 -0500 Received: from fencepost.gnu.org ([2001:470:142:3::e]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1tOt53-0002NO-1s; Sat, 21 Dec 2024 01:35:17 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org; s=fencepost-gnu-org; h=MIME-version:References:Subject:In-Reply-To:To:From: Date; bh=MusIx2mvvOxZ545dSQRkp+ume2v0VNhkWX+uCdyM5R0=; b=lRvT8Y86mw+t5oL6ws8b TBDzzxzNVoboTi/pJhV+JB7kZsbYmsgAw6bYWuyfpVf2Cy/cpJj3gkHFHum/kGW1+wM1gVqJHWoGl VQuNfYqhXcCutVYOEazmlw34yt1rlEUbYG9BCbaiGqaBxU3IzN8XSl+ErAT5qID47/nlgBY3nMEQB 5ivFd6ToMp1NtSUmYK9X8jUCHhRw4pIegLR/kI2W3AuxX2hI5cZCmLc9dL/2x+QssdmTTbd9b6k81 YLXaQFc6QloJcitdrSyEl6mnpy/BDmXBC+jgLUIeHifga2qvvALnnlzGaHPeciDSDKnhAMUyX94Zo x6DDGxJmRn6IEw==; Date: Sat, 21 Dec 2024 08:35:16 +0200 Message-Id: <865xnda6hn.fsf@gnu.org> From: Eli Zaretskii To: =?utf-8?B?Sm9zw6kgSsO6bmlvcg==?= In-Reply-To: <3dfb3baf-b79b-4e8e-b7e1-7980b5163078@gmail.com> (message from =?utf-8?B?Sm9zw6kgSsO6bmlvcg==?= on Fri, 20 Dec 2024 17:34:12 -0300) Subject: Re: bug#74996: 28.2; sql interactive mode prints output of executed query where the pointer is instead of the bottom of the buffer References: <93b8da79-dea6-4ef4-9b65-8857410d85e1@gmail.com> <86frmi9tm7.fsf@gnu.org> <86ed229ml6.fsf@gnu.org> <87a5cqnmm3.fsf@gmx.net> <86a5cq9ks5.fsf@gnu.org> <3dfb3baf-b79b-4e8e-b7e1-7980b5163078@gmail.com> MIME-version: 1.0 Content-type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Spam-Score: -2.3 (--) X-Debbugs-Envelope-To: 74996-done Cc: stephen.berman@gmx.net, 74996-done@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -3.3 (---) > Date: Fri, 20 Dec 2024 17:34:12 -0300 > Cc: 74996@debbugs.gnu.org > From: José Júnior > > Just tried on Emacs 30 (emacs-30.0.93) and could not reproduce the bug. Great, thanks. So I'm therefore closing this bug. ------------=_1734763082-28743-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at submit) by debbugs.gnu.org; 20 Dec 2024 16:47:19 +0000 Received: from localhost ([127.0.0.1]:43799 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOg9n-0002Gs-78 for submit@debbugs.gnu.org; Fri, 20 Dec 2024 11:47:19 -0500 Received: from lists.gnu.org ([209.51.188.17]:48196) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1tOg9l-0002Gl-IC for submit@debbugs.gnu.org; Fri, 20 Dec 2024 11:47:18 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1tOg9j-0004V8-J4 for bug-gnu-emacs@gnu.org; Fri, 20 Dec 2024 11:47:17 -0500 Received: from mail-pg1-x52c.google.com ([2607:f8b0:4864:20::52c]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1tOg9i-0008Sy-3T for bug-gnu-emacs@gnu.org; Fri, 20 Dec 2024 11:47:15 -0500 Received: by mail-pg1-x52c.google.com with SMTP id 41be03b00d2f7-7fd49d85f82so1703662a12.3 for ; Fri, 20 Dec 2024 08:47:13 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1734713232; x=1735318032; darn=gnu.org; h=content-transfer-encoding:subject:from:to:content-language :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=c7XCBZfXV4DPMMm/4i34x5OlikyqYWyhoYCmdusa1hU=; b=Ho32VYGJo2EWcOaGd8bXrXFBsr7nXvbsJXlSpdPrF/qyjybT6sC4VfPBH5fuqEXSZh UUu8jWX4Py6Gz2cXOtWfE5kA9wKNvTGN7eg6L5ktIfk+WmWqvSlvff0Fsm7uDuOjhlbv KWIaQCXLFjhksAyG8vWp7krYtehqY3MjDA1itqPFG57d6ZcMsNhG8KvUxxwYV6KLlZcA p9PB/bUkhZHlJ9M9HVKmfLBlhTFOYw14MA2WDB0Y9UCciGtZKGAkWdpfPSCGZu4Xvek6 hPtXsuC7odN87nDgUpgDl6m2e28VLNEG7Mx+bw73ngrOFer/ToaGyeoNTY8RjZIGxIXB bMvQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1734713232; x=1735318032; h=content-transfer-encoding:subject:from:to:content-language :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=c7XCBZfXV4DPMMm/4i34x5OlikyqYWyhoYCmdusa1hU=; b=h0FmvM0srWs4pD8d1vi8IS/L0qMr/Kq6CLNhbzGq5uCDcTiFtbM2aH6FMYnLayhREE PuKp6W3TprgM+hJjb0KqlEB5fV2D0DQgUCEEpDNOrJuWnqfv6tgd3drV2Bi5HjSO+YQI 28a4XoTNsguIa9rXn3+K/HhXhbjIdRu7hEashBzztlhYVmKiylXhgJlpS8lIZB7onwND GJ487zrRf/ZMHfsePRZ0hUJV1X1cQnioOrsyhGCAxACk7SzT/M38xSCS9sPtoupuZssh 9CxMXL5Ijjxp5Y8QzUygqs/AaTyOIbgMqscpbTUkqHGc9Wd9Kk97Azxg9rzs/oGS8PaB OMFQ== X-Gm-Message-State: AOJu0Yzx5am4TQrAIe9UmdSbgH/lpq+JMmaJsnV+yXMVOc2U2wijnvMX JD7komXmAvJNlBshL7AoqUmulLkO8SeM4TNa476CGXQs4fcQ6Rf+KoXm/FSW X-Gm-Gg: ASbGnctcb7Sqd62N/RZDz7m5qTLzXArmdAD96mRWw2FVCpdgNK7AWubicUuFN+lht5v D2bcGidM5Ct9bl5AZoV87U6gzjSspIjVg3wP/haPVnqafnJ08tfL6iusQAIJ1AY+8YAE/C81VOo XX1W2sWXT4s6hoIFaphmVBPdjMbLBIZOv2IscIG9QgPJBhP5aiXHo+apv9vH0/sockJmhiAg+E6 dYgPtlQWa2jkDaz8O+wkrPBrEtYjU/G5sGmzAtK4mHdlHFbiZGsOO459PNnbgxsfOy2btjkKihi uNitapVBpMrtkVrSxNeGEOHrahQ= X-Google-Smtp-Source: AGHT+IFQAyW7RXudHIOt8MbBYuJHEU0EmVvozLo+650hDuDe5tK7FWzxQUefQ+BYEOyIf2vyDoh2eA== X-Received: by 2002:a05:6a20:158c:b0:1e0:d6ef:521a with SMTP id adf61e73a8af0-1e5e043f6c0mr6308222637.1.1734713231885; Fri, 20 Dec 2024 08:47:11 -0800 (PST) Received: from ?IPV6:2804:d47:60cb:1c00:b18d:19d2:9fd9:d41e? ([2804:d47:60cb:1c00:b18d:19d2:9fd9:d41e]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-72aad8dee97sm3423946b3a.126.2024.12.20.08.47.10 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 20 Dec 2024 08:47:11 -0800 (PST) Message-ID: <93b8da79-dea6-4ef4-9b65-8857410d85e1@gmail.com> Date: Fri, 20 Dec 2024 13:47:08 -0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Content-Language: en-US To: bug-gnu-emacs@gnu.org From: =?UTF-8?B?Sm9zw6kgSsO6bmlvcg==?= Subject: 28.2; sql interactive mode prints output of executed query where the pointer is instead of the bottom of the buffer Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Received-SPF: pass client-ip=2607:f8b0:4864:20::52c; envelope-from=jjnilton@gmail.com; helo=mail-pg1-x52c.google.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-Spam-Score: -1.3 (-) X-Debbugs-Envelope-To: submit X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -2.3 (--) 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 ------------=_1734763082-28743-1--