Description:
If a table say 'xxx' is created from within a procedure. After calling the procedure for first time it displays an error message "Table xxx doesn't exists"
How to repeat:
Repro Steps :
1. Use database 'test' i.e. execute the following SQL statement:
use test;
2. Create and Run the follwing query:
Drop Procedure if exists sp1 //
Drop table if exists t123//
Create procedure sp1 ()
Begin
Create table t123 (f1 decimal (64,30));
End //
Call sp1 ()//
3. Observe that the procedure execution displays the error message as,
ERROR 1146 (42S02): Table 'test.t123' doesn't exist
Expected Results: The procedure execution should complete without any errors
Actual Results : The execution fails with the following error:
ERROR 1146 (42S02): Table 'test.t123' doesn't exist
Additional Info (if any) : We have observed that the table is actually getting created
Description: If a table say 'xxx' is created from within a procedure. After calling the procedure for first time it displays an error message "Table xxx doesn't exists" How to repeat: Repro Steps : 1. Use database 'test' i.e. execute the following SQL statement: use test; 2. Create and Run the follwing query: Drop Procedure if exists sp1 // Drop table if exists t123// Create procedure sp1 () Begin Create table t123 (f1 decimal (64,30)); End // Call sp1 ()// 3. Observe that the procedure execution displays the error message as, ERROR 1146 (42S02): Table 'test.t123' doesn't exist Expected Results: The procedure execution should complete without any errors Actual Results : The execution fails with the following error: ERROR 1146 (42S02): Table 'test.t123' doesn't exist Additional Info (if any) : We have observed that the table is actually getting created