reddit / emacs

Extra comma in org-babel sql src block

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/recipes/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...