tursodatabase/turso

Default returning order is different from SQLite

開放

#2,925 建立於 2025年9月4日

 (6 則留言) (0 個反應) (0 位負責人)Rust (1,001 個分叉)github user discovery
compatibilitygood first issue

倉庫指標

星標
 (19,103 顆星)
PR 合併指標
 (平均合併 2天 11小時) (30 天內合併 147 個 PR)

描述

More in the saga of the new testing database ™️

For the following query:

    select u.first_name, p.name, o.status, r.rating
    from users u
    inner join orders o on u.id = o.user_id and o.status in ('shipped', 'delivered')
    left join order_items oi on o.id = oi.order_id
    inner join products p on oi.product_id = p.id and p.price > 50
    left join reviews r on p.id = r.product_id and r.user_id = u.id and r.rating >= 4
    where u.age between 25 and 35
    limit 10;

SQLite returns:

Shawn|shorts|delivered|
Vanessa|accessories|shipped|
Felicia|sweatshirt|shipped|

turso returns:

Vanessa|accessories|shipped|
Shawn|shorts|delivered|
Felicia|sweatshirt|shipped|

貢獻者指南