Org-Babel SQL block: Narrows to buffer in background when pressing TAB

Org-Babel SQL block: Narrows to buffer in background when pressing TAB

[Jay Zawrotny]

[-- Attachment #1.1: Type: text/plain, Size: 1409 bytes --]

Hi Org ML,

I hope this is the right place. If not please let me know where I should
surface this 😅

*Issue:*

If I press TAB while the cursor is in a sql src block, it opens the code in
a new buffer in the background. Kind of like pressing C-C C-'
(org-edit-special) but silently. It's frustrating because it prevents me
from editing it until I find the buffer or use org-edit-special.

*Reproduction:*

   1. Create an org-mode buffer
   2. Add at least one headline
   3. Create a sql source block (sample below)
   4. Put the cursor on the "S" of the "SELECT" statement
   5. Press TAB


*Expected:*

Indents using either native sql-mode or sql-indent-mode if installed.

*Actual:*

Highlights the SQL src, opens it in a new buffer in the background, and I
can't edit the source.

*Notes:*

If I use M-x org-cycle directly this behavior also occurs. If I call
indent-for-tab-command on the SQL sample the behavior also occurs, but I
can nil-out the body of that function using the REPL and the behavior still
occurs. This does not happen when using TAB in a bash src block. This does
not happen in a sql-mode buffer which is why I currently suspect it to be
org-babel sql specific.

GIF reproducing behavior below

[image: 2020-10-06 23.13.44.gif]

I appreciate any help debugging this, or even links to docs to help me
learn how to debug it.

Thanks,
J

[-- Attachment #1.2: Type: text/html, Size: 1896 bytes --]

[-- Attachment #2: 2020-10-06 23.13.44.gif --]
[-- Type: image/gif, Size: 133695 bytes --]

Re: Org-Babel SQL block: Narrows to buffer in background when pressing TAB

[Jay Zawrotny]

[-- Attachment #1.1: Type: text/plain, Size: 2223 bytes --]

Still running into this issue often, but I tried some techniques others
have recommended to debug other issues:

Summary:
Pressing TAB in an org-mode sql src block opens the src in a background
buffer and locks the src block

- Behavior not reproducible when using emacs -Q
- Behavior not reproducible when running emacs in terminal with emacs -nw

Suggests behavior is not directly associated with org-babel as originally
thought. Not sure where to look yet to continue though. Is there a way to
capture all functions called when reproducing the behavior in the GUI?

Is anyone able to reproduce the behavior as a quick sanity check?

On Wed, Oct 7, 2020 at 12:38 AM Jay Zawrotny <jayzawrotny@gmail.com> wrote:

> Hi Org ML,
>
> I hope this is the right place. If not please let me know where I should
> surface this 😅
>
> *Issue:*
>
> If I press TAB while the cursor is in a sql src block, it opens the code
> in a new buffer in the background. Kind of like pressing C-C C-'
> (org-edit-special) but silently. It's frustrating because it prevents me
> from editing it until I find the buffer or use org-edit-special.
>
> *Reproduction:*
>
>    1. Create an org-mode buffer
>    2. Add at least one headline
>    3. Create a sql source block (sample below)
>    4. Put the cursor on the "S" of the "SELECT" statement
>    5. Press TAB
>
>
> *Expected:*
>
> Indents using either native sql-mode or sql-indent-mode if installed.
>
> *Actual:*
>
> Highlights the SQL src, opens it in a new buffer in the background, and I
> can't edit the source.
>
> *Notes:*
>
> If I use M-x org-cycle directly this behavior also occurs. If I call
> indent-for-tab-command on the SQL sample the behavior also occurs, but I
> can nil-out the body of that function using the REPL and the behavior still
> occurs. This does not happen when using TAB in a bash src block. This does
> not happen in a sql-mode buffer which is why I currently suspect it to be
> org-babel sql specific.
>
> GIF reproducing behavior below
>
> [image: 2020-10-06 23.13.44.gif]
>
> I appreciate any help debugging this, or even links to docs to help me
> learn how to debug it.
>
> Thanks,
> J
>

[-- Attachment #1.2: Type: text/html, Size: 3181 bytes --]

[-- Attachment #2: 2020-10-06 23.13.44.gif --]
[-- Type: image/gif, Size: 133695 bytes --]

Re: Org-Babel SQL block: Narrows to buffer in background when pressing TAB

[Jay Zawrotny]

[-- Attachment #1.1: Type: text/plain, Size: 2484 bytes --]

Found the cause! It was because I was using :engine postgresql instead of
:engine postgres.

On Sun, Oct 11, 2020 at 11:41 AM Jay Zawrotny <jayzawrotny@gmail.com> wrote:

> Still running into this issue often, but I tried some techniques others
> have recommended to debug other issues:
>
> Summary:
> Pressing TAB in an org-mode sql src block opens the src in a background
> buffer and locks the src block
>
> - Behavior not reproducible when using emacs -Q
> - Behavior not reproducible when running emacs in terminal with emacs -nw
>
> Suggests behavior is not directly associated with org-babel as originally
> thought. Not sure where to look yet to continue though. Is there a way to
> capture all functions called when reproducing the behavior in the GUI?
>
> Is anyone able to reproduce the behavior as a quick sanity check?
>
> On Wed, Oct 7, 2020 at 12:38 AM Jay Zawrotny <jayzawrotny@gmail.com>
> wrote:
>
>> Hi Org ML,
>>
>> I hope this is the right place. If not please let me know where I should
>> surface this 😅
>>
>> *Issue:*
>>
>> If I press TAB while the cursor is in a sql src block, it opens the code
>> in a new buffer in the background. Kind of like pressing C-C C-'
>> (org-edit-special) but silently. It's frustrating because it prevents me
>> from editing it until I find the buffer or use org-edit-special.
>>
>> *Reproduction:*
>>
>>    1. Create an org-mode buffer
>>    2. Add at least one headline
>>    3. Create a sql source block (sample below)
>>    4. Put the cursor on the "S" of the "SELECT" statement
>>    5. Press TAB
>>
>>
>> *Expected:*
>>
>> Indents using either native sql-mode or sql-indent-mode if installed.
>>
>> *Actual:*
>>
>> Highlights the SQL src, opens it in a new buffer in the background, and I
>> can't edit the source.
>>
>> *Notes:*
>>
>> If I use M-x org-cycle directly this behavior also occurs. If I call
>> indent-for-tab-command on the SQL sample the behavior also occurs, but I
>> can nil-out the body of that function using the REPL and the behavior still
>> occurs. This does not happen when using TAB in a bash src block. This does
>> not happen in a sql-mode buffer which is why I currently suspect it to be
>> org-babel sql specific.
>>
>> GIF reproducing behavior below
>>
>> [image: 2020-10-06 23.13.44.gif]
>>
>> I appreciate any help debugging this, or even links to docs to help me
>> learn how to debug it.
>>
>> Thanks,
>> J
>>
>

[-- Attachment #1.2: Type: text/html, Size: 3615 bytes --]

[-- Attachment #2: 2020-10-06 23.13.44.gif --]
[-- Type: image/gif, Size: 133695 bytes --]