Incorrect explanation of the default sorting direction of ORDER BY in SQLite
tatsuyafujisaki opened this issue · 0 comments
tatsuyafujisaki commented
URL of codelab
https://developer.android.com/codelabs/basic-android-kotlin-compose-sql#6
In which task and step of the codelab can this issue be found?
By default, the sort direction is DESC for descending order, which you can omit from the ORDER BY clause. If you want the results grouped in ascending order, add ASC after the column name.
Describe the problem
According to the following SQLite documentation, the default sorting direction is ASC, not DESC.
If neither ASC or DESC are specified, rows are sorted in ascending (smaller values first) order by default.
https://www.sqlite.org/lang_select.html
Additional information