We recognized, that the filter function in the livetable Macro is not working on MS SQL. The macro function livetable_addColumnToQuery (defined in XWiki.LiveTableResultsMacros) uses in an HQL Statement the function str (Line 576) with an string parameter. This function call is not correctly mapped in to the SQL statement.
The resulting SQL statement:
produces the follwoing SQL error:
Error converting data type varchar to float.
Why tried it with the hibernate dialects
Both produce the same result.
Is the str function here necessary? When removing it the code works fine.
It seems that the call of the str function is in the SQL statement not necessary at all.
We know MS SQL is not officially supported, however this is so far the only issue we detected when using MS SQL.