Delete's busted in batch mode

[timsehn]

Repro:

1. Checkout dolthub/menus @ b6t51opv92q0aoqb9a6miq06emgj10sq
2. Run dolt sql < fix-bad-rows.sql

menus $ cat fix-bad-rows.sql 
DELETE FROM menu_items WHERE 'name' = 'GREEN CHILE PEPPERS*, PORTION FOR 16 INCH EXTRA LARGE HAND TOSSED PIZZA';
DELETE FROM menu_items WHERE 'name' = 'GREEN OLIVE*, PORTION FOR 16 INCH EXTRA LARGE HAND TOSSED PIZZA';
DELETE FROM menu_items WHERE 'name' = 'GARLIC*, PORTION FOR 16 INCH EXTRA LARGE HAND TOSSED PIZZA';
DELETE FROM menu_items WHERE 'name' = 'CHORIZO*, PORTION FOR 16 INCH EXTRA LARGE HAND TOSSED PIZZA';
DELETE FROM menu_items WHERE 'name' = 'ANCHOVIES*, PORTION FOR 16 INCH EXTRA LARGE HAND TOSSED PIZZA';

[VinaiRachakonda]

We're giving a bad error message but the problem is that you are single quoting the column. Change the 'name' to name with tick marks or just name

To be clear, these queries should error.

[timsehn]

Cool. Fix the error message. And running the same query with `dolt sql -q` worked.

…

On Tue, Jul 20, 2021 at 2:58 PM Vinai Rachakonda ***@***.***> wrote: We're giving a bad error message but the problem is that you are single quoting the column. Change the 'name' to name with tick marks or just name — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#1923 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABJAR3GSIT5QIEUZG4OJ3ALTYXWPRANCNFSM5AOQNERA> .