[Orgmode] [babel] Tiny "problems"

[Sébastien Vauban]

Hello,

Here is the Org file is use to illustrate my saying:

--8<---------------cut here---------------start------------->8---
* Test file

  Here is the main SQL script.

#+srcname: CP111.sql
      #+begin_src sql :tangle CP111.sql
          -- no longer display the count message
          SET NOCOUNT ON
          
          SELECT TOP 10
                 etpNom,
                 etpID,
          FROM etp
          WHERE etpID
              IN (SELECT actID
                  FROM actions
                  WHERE actID = 338)
              AND
              <<Condition>>
          ORDER BY pfiID
      #+end_src

  And here the extra condition:

#+srcname: Condition
      #+begin_src sql
          -- extra condition
          pfiAuth = 1
          AND SUBSTRING(etpCPNum, 1, 3) = "111"
      #+end_src
--8<---------------cut here---------------end--------------->8---

Here the "problems" (details, though) I've observed:

- srcname must be in column 0 for the highlighting to be correct.

- *after* =C-c '= forth and back, all the blank lines in my source block (in
  my example, the one between "SET NOCOUNT ON" and "SELECT TOP 10") are filled
  with an amount of whitespaces (and, in my Emacs config, highlighted as
  useless spaces).

- the condition block is not indented properly in the tangled output file;
  only the first line is:

--8<---------------cut here---------------start------------->8---
-- generated by org-babel-tangle
-- [[id:d7557df2-6921-428f-8433-68fad551abec][CP111.sql]]
-- no longer display the count message
SET NOCOUNT ON

SELECT TOP 10
       etpNom,
       etpID,
FROM etp
WHERE etpID
    IN (SELECT actID
        FROM actions
        WHERE actID = 338)
    AND
    -- extra condition                                   << OK
pfiAuth = 1                                              << not
AND SUBSTRING(etpCPNum, 1, 3) = "111"                    << not
ORDER BY pfiID
-- CP111.sql ends here
--8<---------------cut here---------------end--------------->8---

Best regards,
  Seb

-- 
Sébastien Vauban