We are experiencing malformed SQL when ordering/filtering on a calculated boolean field.
Reproduction solution is available at:
Github reproduction for Devart errorReproduction path:
- Open the solution DevartReproduction.sln in Visual Studio 2022
- On an Oracle database: execute the script from the project in Database\Devart_repro_carmodel.sql
- Open Startup.cs and fill in the valid connection string in ConfigureServices() starting on line 30
- Press run (F5) and wait for the default URL to open
- add an oData orderby and filter on the IsLuxery property :
/DevartReproduction?$filter=isluxery eq true &$orderby=isluxery
Expected:
- valid JSON with cars data from the database is returned where the filter and orderby have been applied.
Actual:
- code breaks with an exception about invalid SQL:
On filter: "ORA-00933: SQL command not properly ended"
On order by: "ORA-00920: invalid relational operator"