Comments - Issue with INSERT data not being available for immediate SELECT

4 years, 7 months ago Matt Cole

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.

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.