Go to:
Gentoo Home
Documentation
Forums
Lists
Bugs
Planet
Store
Wiki
Get Gentoo!
Gentoo's Bugzilla – Attachment 203334 Details for
Bug 283926
dev-db/mysql-5.0.84: MySQL parameter binding doesn't work with gcc-4.4.1 but works with gcc-4.3.4
Home
|
New
–
[Ex]
|
Browse
|
Search
|
Privacy Policy
|
[?]
|
Reports
|
Requests
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
C++ source code
bind_test.cpp (text/plain), 4.74 KB, created by
Alexey Parshin
on 2009-09-07 05:09:58 UTC
(
hide
)
Description:
C++ source code
Filename:
MIME Type:
Creator:
Alexey Parshin
Created:
2009-09-07 05:09:58 UTC
Size:
4.74 KB
patch
obsolete
>#include <mysql/mysql.h> >#include <iostream> >#include <stdio.h> >#include <stdlib.h> >#include <string.h> > > >using namespace std; > >#define STRING_SIZE 50 > >#define DROP_SAMPLE_TABLE "DROP TABLE IF EXISTS test_table" >#define CREATE_SAMPLE_TABLE "CREATE TABLE test_table(col1 INT,\ > col2 VARCHAR(40),\ > col3 SMALLINT,\ > col4 TIMESTAMP)" >#define INSERT_SAMPLE "INSERT INTO \ > test_table(col1,col2,col3) \ > VALUES(?,?,?)" > >int main() { > >MYSQL mysql; >MYSQL* mysql2; >MYSQL_STMT *stmt; >MYSQL_BIND bind[3]; >my_ulonglong affected_rows; >int param_count; >short small_data; >int int_data; >char str_data[STRING_SIZE]; >unsigned long str_length; >my_bool is_null; > >mysql_init(&mysql); > >cout << "Sizeof bind[] " << sizeof(bind) << endl; > >if (!mysql_real_connect(&mysql, "localhost", "", "", "test", 3306, NULL, CLIENT_MULTI_RESULTS)) { > string error = mysql_error(&mysql); > mysql_close(&mysql); > cerr << "Connect to database failed: " << error << endl; > return 1; >} > > >if (mysql_query(&mysql, DROP_SAMPLE_TABLE)) >{ > fprintf(stderr, " DROP TABLE failed\n"); > fprintf(stderr, " %s\n", mysql_error(&mysql)); > exit(0); >} > >if (mysql_query(&mysql, CREATE_SAMPLE_TABLE)) >{ > fprintf(stderr, " CREATE TABLE failed\n"); > fprintf(stderr, " %s\n", mysql_error(&mysql)); > exit(0); >} > >/* Prepare an INSERT query with 3 parameters */ >/* (the TIMESTAMP column is not named; the server */ >/* sets it to the current date and time) */ >stmt = mysql_stmt_init(&mysql); >if (!stmt) >{ > fprintf(stderr, " mysql_stmt_init(), out of memory\n"); > exit(0); >} >if (mysql_stmt_prepare(stmt, INSERT_SAMPLE, strlen(INSERT_SAMPLE))) >{ > fprintf(stderr, " mysql_stmt_prepare(), INSERT failed\n"); > fprintf(stderr, " %s\n", mysql_stmt_error(stmt)); > exit(0); >} >fprintf(stdout, " prepare, INSERT successful\n"); > >/* Get the parameter count from the statement */ >param_count= mysql_stmt_param_count(stmt); >fprintf(stdout, " total parameters in INSERT: %d\n", param_count); > >if (param_count != 3) /* validate parameter count */ >{ > fprintf(stderr, " invalid parameter count returned by MySQL\n"); > exit(0); >} > >/* Bind the data for all 3 parameters */ > >memset(bind, 0, sizeof(bind)); > >/* INTEGER PARAM */ >/* This is a number type, so there is no need > to specify buffer_length */ >bind[0].buffer_type= MYSQL_TYPE_LONG; >bind[0].buffer= (char *)&int_data; >bind[0].is_null= 0; >bind[0].length= 0; > >/* STRING PARAM */ >bind[1].buffer_type= MYSQL_TYPE_STRING; >bind[1].buffer= (char *)str_data; >bind[1].buffer_length= STRING_SIZE; >bind[1].is_null= 0; >bind[1].length= &str_length; > >/* SMALLINT PARAM */ >bind[2].buffer_type= MYSQL_TYPE_SHORT; >bind[2].buffer= (char *)&small_data; >bind[2].is_null= &is_null; >bind[2].length= 0; > >/* Bind the buffers */ >if (mysql_stmt_bind_param(stmt, bind)) >{ > fprintf(stderr, " mysql_stmt_bind_param() failed\n"); > fprintf(stderr, " %s\n", mysql_stmt_error(stmt)); > exit(0); >} > >/* Specify the data values for the first row */ >int_data= 10; /* integer */ >strncpy(str_data, "MySQL", STRING_SIZE); /* string */ >str_length= strlen(str_data); > >/* INSERT SMALLINT data as NULL */ >is_null= 1; > >/* Execute the INSERT statement - 1*/ >if (mysql_stmt_execute(stmt)) >{ > fprintf(stderr, " mysql_stmt_execute(), 1 failed\n"); > fprintf(stderr, " %s\n", mysql_stmt_error(stmt)); > exit(0); >} > >/* Get the total number of affected rows */ >affected_rows= mysql_stmt_affected_rows(stmt); >fprintf(stdout, " total affected rows(insert 1): %lu\n", > (unsigned long) affected_rows); > >if (affected_rows != 1) /* validate affected rows */ >{ > fprintf(stderr, " invalid affected rows by MySQL\n"); > exit(0); >} > >/* Specify data values for second row, > then re-execute the statement */ >int_data= 1000; >strncpy(str_data, " The most popular Open Source database", > STRING_SIZE); >str_length= strlen(str_data); >small_data= 1000; /* smallint */ >is_null= 0; /* reset */ > >/* Execute the INSERT statement - 2*/ >if (mysql_stmt_execute(stmt)) >{ > fprintf(stderr, " mysql_stmt_execute, 2 failed\n"); > fprintf(stderr, " %s\n", mysql_stmt_error(stmt)); > exit(0); >} > >/* Get the total rows affected */ >affected_rows= mysql_stmt_affected_rows(stmt); >fprintf(stdout, " total affected rows(insert 2): %lu\n", > (unsigned long) affected_rows); > >if (affected_rows != 1) /* validate affected rows */ >{ > fprintf(stderr, " invalid affected rows by MySQL\n"); > exit(0); >} > >/* Close the statement */ >if (mysql_stmt_close(stmt)) >{ > fprintf(stderr, " failed while closing the statement\n"); > fprintf(stderr, " %s\n", mysql_stmt_error(stmt)); > exit(0); >} > >}
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 283926
: 203334 |
203335