You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Version
5.0.15 with LiteDB.Studio 1.0.3.0
5.0.21 in VS project
Describe the bug
"Order By <computed_colum>" in SQL query syntax doesn't have effect.
Code to Reproduce
[OK] SELECT importo, importo + 20 as plus20 FROM fattura order by importo asc
[OK] SELECT importo, importo + 20 as plus20 FROM fattura order by importo desc
[DOESN'T WORK] SELECT importo, importo + 20 as plus20 FROM fattura order by plus20 asc
[DOESN'T WORK] SELECT importo, importo + 20 as plus20 FROM fattura order by plus20 desc
Expected behavior
Order By clause should have the same behaviour with both kind of columns.
The text was updated successfully, but these errors were encountered:
MauMau666
changed the title
[BUG] "Order By <computed_colum>" in SQL query syntax doesn't have effect.
[BUG] "Order By <computed_colum>" in SQL query doesn't have effect.
Jan 20, 2025
Version
5.0.15 with LiteDB.Studio 1.0.3.0
5.0.21 in VS project
Describe the bug
"Order By <computed_colum>" in SQL query syntax doesn't have effect.
Code to Reproduce
[OK] SELECT importo, importo + 20 as plus20 FROM fattura order by importo asc
[OK] SELECT importo, importo + 20 as plus20 FROM fattura order by importo desc
[DOESN'T WORK] SELECT importo, importo + 20 as plus20 FROM fattura order by plus20 asc
[DOESN'T WORK] SELECT importo, importo + 20 as plus20 FROM fattura order by plus20 desc
Expected behavior
Order By clause should have the same behaviour with both kind of columns.
The text was updated successfully, but these errors were encountered: