Bug #65299 21.5.6.1. Tutorial: MySQL Connector - Scenario 2 references non-existent proc
Submitted: 13 May 2012 3:02 Modified: 15 Mar 2013 14:54
Reporter: sw Dev Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / C++ Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Paul Dubois CPU Architecture:Any
Triage: Needs Triage: D3 (Medium)

[13 May 2012 3:02] sw Dev
Description:
http://dev.mysql.com/doc/refman/5.1/en/connector-cpp-tutorials-stored-routines-statements.... "Scenario 2" references non-existent procedures 'get_pop_continent' and 'get_world_pop' causing the compiles example to fail with the following error:

Connector/C++ tutorial framework...

Population of Uganda: 21778000
# ERR: SQLException in frmwk-2.cpp(main) on line 74
# ERR: PROCEDURE world.get_pop_continent does not exist (MySQL error code: 1305, SQLState: 42000 )

It seems the two procedures were simply forgotten in the documentation for the page. The required for the first Scenario were defined, just not the two above.

How to repeat:
Visit: http://dev.mysql.com/doc/refman/5.1/en/connector-cpp-tutorials-stored-routines-statements...., follow the example for Scenario 2, then run the example.

Suggested fix:
That's it.
[13 May 2012 8:30] Valeriy Kravchuk
Thank you for the problem report. Indeed, procedure definitions are missing.
[15 Mar 2013 14:54] Paul Dubois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

Definitiions for the required stored procedures are all given here now:

http://dev.mysql.com/doc/refman/5.1/en/connector-cpp-tutorials-stored-routines-statements....

Note that get_world_pop was renamed to get_pop_world for better naming consistency with the other get_popxxx routines.