hi
in one of my php scripts i'm using temporary table
i create it, use some selects to insert data into the table to finaly use the data to render the page
but sometimes, a query results in an error - the error is, that a column name does not exist!?
i've checked all query strings, everything is fine, mysql runs perfect, so i did a text search on all hosted sites with the name of my temp table and found another site using the same name for their temp table
as there is the number of possible temp tables in a mysql server limited (i know i can change it), could it be possible, that while executing my script, another scipt creates temporary table which overwrites my table and i am accessing a temp table with the same name but with a different structure?
something like - my mysql connection session stores a temptable id (max id = max number of temp tables) and uses this id when accesing the temp table but is not checking if that's the right one, as the temp tables are bound to the connection sessions which created them
any idea if this is possible? could be a bug?
in one of my php scripts i'm using temporary table
i create it, use some selects to insert data into the table to finaly use the data to render the page
but sometimes, a query results in an error - the error is, that a column name does not exist!?
i've checked all query strings, everything is fine, mysql runs perfect, so i did a text search on all hosted sites with the name of my temp table and found another site using the same name for their temp table
as there is the number of possible temp tables in a mysql server limited (i know i can change it), could it be possible, that while executing my script, another scipt creates temporary table which overwrites my table and i am accessing a temp table with the same name but with a different structure?
something like - my mysql connection session stores a temptable id (max id = max number of temp tables) and uses this id when accesing the temp table but is not checking if that's the right one, as the temp tables are bound to the connection sessions which created them
any idea if this is possible? could be a bug?