tursodatabase/turso

Default returning order is different from SQLite

Open

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

在 GitHub 查看
 (5 留言) (0 反應) (0 負責人)Rust (1,001 fork)github user discovery
compatibilitygood first issue

倉庫指標

Star
 (19,103 star)
PR 合併指標
 (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|

貢獻者指南