Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

[BUG] "Order By <computed_colum>" in SQL query doesn't have effect. #2583

Open
MauMau666 opened this issue Jan 20, 2025 · 0 comments
Open

[BUG] "Order By <computed_colum>" in SQL query doesn't have effect. #2583

MauMau666 opened this issue Jan 20, 2025 · 0 comments
Labels

Comments

@MauMau666
Copy link

MauMau666 commented 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.

@MauMau666 MauMau666 added the bug label Jan 20, 2025
@MauMau666 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
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant