Comments - Issue with INSERT data not being available for immediate SELECT
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
If you can correctly insert and query the results manually from the command line, but not in your script, then the problem is likely in your script.
Except I've checked and re-checked my code, and I can't see anything wrong. I have two functions -- one that INSERTs data into table A, and the other that INSERT/SELECTs the data into table B. Except for the difference in SQL statements being executed and the exact parameters being bound to each one, the two functions are identical. The insert into table A works, the INSERT/SELECT into table B doesn't. That's why I'm really leaning towards "there's something about MariaDB going on that I don't understand" -- like the write from my INSERT is being delayed such that the data isn't there when it comes time to do the INSERT/SELECT.