title: MySQL fetch next cursor issue
body: <p>I have a problem fetching values from a MySQL cursor.</p>
  
  <p>I create a temporary table which is a mere copy of another table (the original table has a variable name, that's passed as the procedure's parameter, and because MySQL doesn't support variable table names, I have to create a copy - can't use the original directly). </p>
  
  <p>The temporary table creation goes just fine, all data that are supposed to be in it are there. Then I define a cursor to iterate through my temporary table... but when I try to fetch from the cursor in a while loop my variables are not filled with data from the "cursored" table... most of them are just NULL, only last 2 seem to have correct values inside.</p>
  
  <p>Here is the chunk of my code:</p>
  
  <pre><code>-- variables to be filled from the cursor
  DECLARE id,rain,snow,hs,clouds,rain2,cape,status,done int;
  DECLARE v_v,v_u double;
  
  -- cursor declaration
  DECLARE iter CURSOR FOR (SELECT id,cape,rain,snow,hstones,clouds,raining,wind_u,wind_v FROM temp_tbl);
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
  
  -- drop the old temporary table if any
  DROP TABLE IF EXISTS temp_tbl;
  
  -- a statement to create the temporary table from a table with the specified name
  -- (table_name is a parameter of the stored procedure this chunk is from)
  
  SET @temp_table = CONCAT('CREATE TABLE temp_tbl AS SELECT * FROM ', table_name, ' WHERE 1'); 
  
  -- prepare, execute and deallocate the statement
  PREPARE ctmp FROM @temp_table;
  EXECUTE ctmp;
  DEALLOCATE PREPARE ctmp;
  
  -- now the temp_table exists, open the cursor
  OPEN iter;
  
  WHILE NOT done DO
  
          -- fetch the values
          FETCH iter INTO id,cape,rain,snow,hs,clouds,rain2,v_u,v_v;
  
          -- fetch doesnt work, only v_u and v_v variables are fetched correctly, others are null
  
          -- ... further statements go here
  
  END WHILE;
  
  CLOSE iter;
  </code></pre>
  
  <p>Is there any type-checking within the FETCH statement that might cause such problem? The columns in my temporary table (which is derived from the original one) are just small-ints or tiny-ints, so these should be perfectly compatible with ints I use in the fetch statement. Those two last ones are doubles, but weird that only these two doubles are fetched. Even the ID int column, which is the primary key isn't fetched.</p>
  
  <p>I work with the dbForge Studio to step into and debug my procedures, but that shouldn't be the problem.</p>