New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

update clause, views broken due to JSON compare #17

Open

dckc opened this issue Nov 18, 2021 · 1 comment

Owner

dckc commented Nov 18, 2021

Comparing JSON values in a where clause doesn't seem to work in mysql.

finquick/brcal/src/book_ops.sql

Line 40 in 4279c8e

where sl.string_val != sl.string_val;

Owner Author

dckc commented Dec 20, 2021

In the npm API, I'm also getting 0 for affectedRows and changedRows pretty much all the time.

But that's not the whole story, cuz dbeaver goes kerflewey over these JSON comparisons.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment