search

dckc / finquick

family finance tools of a closet librarian
https://www.madmode.com/search/label/finances/
MIT License
12 stars 4 forks source link

update clause, views broken due to JSON compare #17

Open dckc opened 2 years ago

dckc commented 2 years ago

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

https://github.com/dckc/finquick/blob/4279c8e09956f9b07b4011cbd1acae1a5dbeeafb/brcal/src/book_ops.sql#L40

dckc commented 2 years ago

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.