Bug #69113 | script working perfectly having sytex error | ||
---|---|---|---|
Submitted: | 1 May 2013 12:13 | Modified: | 1 May 2013 16:53 |
Reporter: | Rami Jamleh | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: General | Severity: | S2 (Serious) |
Version: | 5.6.11-log | OS: | Windows (7 ultimate SP1) |
Assigned to: | CPU Architecture: | Any | |
Tags: | prepared statements, sytex error |
[1 May 2013 12:13]
Rami Jamleh
[1 May 2013 13:30]
Rami Jamleh
Same thing over here (other tables) SET @did = CEIL(RAND()*(SELECT MAX(id) FROM drawing)); SET @sidCount = CEIL(RAND()*(SELECT COUNT(*) FROM shopdrawing_revision)); SET @s := 'SET @sid := (select sid from shopdrawing_revision limit ?,1)'; PREPARE st3 FROM @s; EXECUTE st3 USING @sidCount; INSERT INTO shopdrawing_submiteddrawings VALUES(@sid,@did, FLOOR(rand()*5),ceil(rand()*2)) ON DUPLICATE KEY UPDATE sid = @sid; DEALLOCATE st3;
[1 May 2013 16:27]
MySQL Verification Team
"DEALLOCATE st3;" is that is wrong syntax. Surely you mean: "DEALLOCATE PREPARE st3; http://dev.mysql.com/doc/refman/5.6/en/deallocate-prepare.html
[1 May 2013 16:53]
Rami Jamleh
Sorry for bothering thanks