tursodatabase/turso

Default returning order is different from SQLite

オープン

#2,925 opened on 2025/09/04

 (6 件のコメント) (0 件のリアクション) (0 人の担当者)Rust (1,001 件のフォーク)github user discovery
compatibilitygood first issue

Repository metrics

Stars
 (19,103 個のスター)
PR merge metrics
 (平均マージ 2d 11h) (30d で 147 merged PRs)

説明

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|

コントリビューターガイド