Extra comma in org-babel sql src block
reddit / emacs

----------------------------------------------------------------------
cradlemann · 2022-04-04 16:23

I'm still org newbie and I have a super annoying issue in org-babel
src blocks for sql. Every time I press <tab> it add extra comma before
~\*~

Before <tab>

    #+name: test
    #+begin_src sql
    SELECT
      *
    FROM balance_cte
    #+end_src

After <tab>

    #+name: test
    #+begin_src sql
    SELECT
      ,*
    FROM balance_cte
    #+end_src

My [org](https://github.com/Crandel/home/blob/master/.config/emacs/rec
ipes/org-mode-rcp.el) setup

P.S. Was fixed. Issue was in org setup

----------------------------------------------------------------------
ftrx · 2022-04-04 17:12

That comma is not passed on, is a way (ugly, IMVHO indeed) to tell
org-mode not to consider the * as a heading. In export and if you run
the block the comma disappear so beside the annoyance nothing will
stop to work :-)

I pass the ball to others about how to tell org-mode to ignore leading
* if inside a babel block...

----------------------------------------------------------------------
cradlemann · 2022-04-04 17:15

But I got sql syntax error when i evaluate sql code. Without extra
comma I got normal results, as it should be

----------------------------------------------------------------------
ftrx · 2022-04-04 20:43

That's strange... I can't reproduce it, could you please add header
args of the babel block ?

----------------------------------------------------------------------
cradlemann · 2022-04-05 08:28

Headers were added to post

----------------------------------------------------------------------
ftrx · 2022-04-05 12:38

Still can't reproduce...

----------------------------------------------------------------------
cradlemann · 2022-04-05 12:40

I fix it. The issue was in org setup. `ob-restclient` override `org-
babel-load-languages` so only restclient setup left

----------------------------------------------------------------------
ftrx · 2022-04-05 16:57

glad you fix it :-)

Honestly I've tried the babel block but not your org config...