You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Dolt gives unsupported syntax error for this query for having extra parentheses on join statements generated from mysqldump
CREATE VIEW sales_by_film_category AS
select c.name AS category,
sum(p.amount) AS total_sales
from (((((payment p
join rental r on((p.rental_id = r.rental_id)))
join inventory i on((r.inventory_id = i.inventory_id)))
join film f on((i.film_id = f.film_id)))
join film_category fc on((f.film_id = fc.film_id)))
join category c on((fc.category_id = c.category_id)))
group by c.name order by total_sales desc;
without join statements in parentheses, query works fine
CREATE VIEW sales_by_film_category AS
select c.name AS category,
sum(p.amount) AS total_sales
from payment p
join rental r onp.rental_id = r.rental_id
join inventory i on r.inventory_id = i.inventory_id
join film f on i.film_id = f.film_id
join film_category fc on f.film_id = fc.film_id
join category c on fc.category_id = c.category_id
group by c.name order by total_sales desc;
The text was updated successfully, but these errors were encountered:
Dolt gives unsupported syntax error for this query for having extra parentheses on join statements generated from mysqldump
without join statements in parentheses, query works fine
The text was updated successfully, but these errors were encountered: