Invalid indentation for recursive if/end if about emacs-sql-indent

[alex-hhh]

This is a known issue, and it is not simple to fix. The workaround is to use begin/end blocks around the nested if statements, as in the example below. I pushed a fix for indenting an end if line when there's an elsif in the if-else chain, see deb9885.

Unfortunately, I do not have time to fix this issue. If you want to try fixing it, the problem is that sqlind-beginning-of-statement-1 does not detect the beginning of the statement correctly for nested if blocks, so the sqlind-syntax-of-line function computes an incorrect syntax.

begin
  if 1 = 0 then
    begin
      if 1 = 0 then
        null;
      else
        null;
      end if;
    end;
  elsif 1 = 2
    begin
      if 1 = 0 then
        null;
      else
        null;
      end if;
    end;
  else
    null;
  end if;
end;
/

[PierreTechoueyres]

Thanks for the hint. Unfortunately I must work with existing code and I can't enclose If blocks.
I'll try to work on this. Thanks for the start point.

[alex-hhh]

After a bit of thinking I think I got this working. Can you please try it out and see if it OK?

I wrote this code about 10 years ago and back than this seemed like a hard task...

[PierreTechoueyres]

Whaou, You're faster than light !!!
Many thanks for fixing this. And you've maybe wrote this code 10 years ago but it's always useful (at least for me).