How use arithmetic operators in Orchard Core SQL Query select clause

39 Views Asked by At

I have tried to run this SQL-92 query:

select (Rating * 100.0) as ratingCalc from BlogPostStatsPartIndex;

on "Run SQL Query" page in admin but it has failed with error:

"Syntax error, expected: ALL, DISTINCT, id_simple, * at line:0, col:7".

This query executes correctly on SQLite but "OrchardCore.Queries.Sql.SqlParser" class produces syntax error for this. This query looks like SQL-92 compatible. I have looked at Orchard Core's "SqlParserTests" implementation, but I haven't found any example how to use arithmetic operators in select clause.

0

There are 0 best solutions below