I have a query that works very well when done from the SQL Editor of SingleStore. Here’s the query.
INSERT INTO mytbl(interaction_id, user_id, msg, created_by) VALUES ('29','admin@gmail.com','{"query":"What was the different loyalty revenue from each segment in this period, in bullet points","response":"Yes, here is the answer to the question:\\n\\n- The Avatar was released January of 2023","created_at":"2023-03-27T08:17:36.609Z"}','admin@gmail.com')
From my NodeJS application, I tried using two libraries… MySQL2 and Sequelize (we use raw queries only). Both of them gave the same error:
Error: Leaf Error (127.0.0.1:3307): Invalid JSON value for column ‘msg’
Any idea why this would fail only via app?