tursodatabase/turso
Default returning order is different from SQLite
Aberta
#2.925 aberto em 4 de set. de 2025
compatibilitygood first issue
Métricas do repositório
- Stars
- (19.103 estrelas)
- Métricas de merge de PR
- (Mesclagem média 2d 11h) (147 fundiu PRs em 30d)
Description
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|