Bug #92961 ado 3092 only first time.

• Submitted: 26 Oct 2018 11:13
• Modified: 28 Oct 2018 8:38
• Reporter: tj chang
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 8.0
• OS: Windows (win10)
• CPU Architecture: Any

[26 Oct 2018 11:13] tj chang

Description:
ADODB.Command.
ADODB.Connection
i create one procedure.

CString sql;
sql = "use myDbTest";
command->execute(sql );
sql =
"CREATE PROCEDURE  cmd_event_insert_procedure( "
		"in id bigint(8), "
		"in stationNo int, "
		"in nDeviceIP int, "
		"in deviceIP varchar(128), "
		"in nISCSIP int, "
		"in iscsIP varchar(128), "
		"in cmd varchar(256), "
		"in time bigint(8), "
		"in logDate varchar(64) ) "
		"begin "
		"insert into cmd_event( id,stationNo, nDeviceIP, deviceIP, nISCSIP, iscsIP, cmd, time, logDate) values( id, stationNo, nDeviceIP, deviceIP, nISCSIP, iscsIP, cmd, time, logDate); "
		"end";

command->ActiveConnection = ds.GetConnection();
command->CommandText = _bstr_t( "cmd_event_insert_procedure" );
command->CommandType = adCmdStoredProc;

add_command_param();

for( int i = 0; i < 1000; i ++)
{
 update_command_para();

 command.execute();
}

How to repeat:
close myaqpp

redo up

[26 Oct 2018 12:32] tj chang

sorry , it is my wrong.

[28 Oct 2018 8:38] MySQL Verification Team

Thank you for confirming, closing as per last comment.