SqlBuilder regex expression removes chars outside /** **/ clauses

[feugen24]

The issue is on SqlBuilder line 67:

private static readonly Regex _regex = new Regex(@"\/\*\*.+\*\*\/", RegexOptions.Compiled | RegexOptions.Multiline);

Given the following sql input:

 select table.* FROM SomeTable as table /**innerjoin**/  /**fulljoin**/  /**leftjoin**/  /**rightjoin**/ INNER          JOIN some join data /**where**/  /**orderby**/ OFFSET @skip ROWS FETCH NEXT @take ROWS    ONLY

it deletes "INNER JOIN some join data" if where/order by clause are not present.
It can be tested online on:
http://regexstorm.net/tester
with above sqlinput and \/\*\*.+\*\*\/ expression.

If I change the expression to /\*\*(.+?)\*\*/ seems to work fine.

[madagaga]

Same as #280 ?

[feugen24]

It's the same problem.

I tested input from here and #280 with both proposed regular expressions

\/\*\*[^\*]*\*\*\/ 
/\*\*(.+?)\*\*/

on http://regexstorm.net/tester tester side by side and they give similar results except for the split-list tab(regex split function?) where the expression in #280 omits some results.

I'm not sure what expression is better.

[RCGodward]

We started encountering this issue today. Guess we've been lucky before. Adding the question mark fixed it with no ill effects in our codebase.

\/\*\*.+?\*\*\/

[jods4]

This can be closed as a dup of #280.