//gcc bug20090.c -g -o bug20090 -L/home/sbester/server/6.0/mysql-6.0.2-alpha-linux-i686/lib -I/home/sbester/server/6.0/mysql-6.0.2-alpha-linux-i686/include   -lmysqlclient_r -lz -lpthread

/*This is generated code!*/

/*section: includes*/
#include <stdio.h>
#include <stdlib.h>
#include <time.h>
#include <mysql.h>
#include <pthread.h>

#define TESTTIME (3600)

#define NUMTHREADS (20)

#define DATASIZE (16*1024*1024)

/*section: globals*/
char host[]="127.0.0.1";
char username[]="root";
char password[]="";
char database[]="test";
int port=3306;
pthread_t pthreads[NUMTHREADS];
int threaddone=0;
char *databucket=NULL;

/*section: function declarations*/
void *worker_thread(void *arg);
MYSQL *db_connect(MYSQL *dbc);
int write_string(char *buf,const int minlen,const int maxlen,const int flag);

/*section: functions*/
int db_query(MYSQL *dbc,char *sql,int showresults)
{
	int res=0;
	MYSQL_RES *r=NULL;
	MYSQL_ROW w;
	MYSQL_FIELD *field=NULL;
	int i=0,moreresult=0;
	if(NULL == dbc) return 0;
	res = mysql_query(dbc,sql);
	if(res != 0 && showresults > 0)
	{
		printf("query failed '%s' : %d (%s)\n",sql,mysql_errno(dbc),mysql_error(dbc));
		return 0;
	}

	do
	{
		r = mysql_store_result(dbc);
		if(r)
		{
			unsigned int numfields = mysql_num_fields(r);
			unsigned int numrows=mysql_num_rows(r);
			while((field = mysql_fetch_field(r)))
			{
					//print metadata information about each field
					if(showresults > 1)
					{
						printf("%s	",field->name);
					}
			}
			if(showresults > 1)
			{
				printf("\n------------------------------------\n");
			}

			while ((w = mysql_fetch_row(r)))
			{
				for(i = 0; i < numfields; i++)
				{
					//print each field here
					if(showresults > 1)
					{
						printf("%s\t",w[i]);
					}
				}

				if(showresults > 1)
				{
						printf("\n");
				}
			}
			if(showresults > 1)
			{
				printf("\n");
			}
			mysql_free_result(r);
		}
		else //no rows returned. was it a select?
		{
			if(mysql_field_count(dbc) > 0 && showresults > 0)
			{
				printf("No results for '%s'.  (%d) - %s\n",sql,mysql_errno(dbc),mysql_error(dbc));
			}
			else //it could have been some insert/update/delete
			{
				//this is successful query
			}
		}
		moreresult=mysql_next_result(dbc);
		if(moreresult > 0 && showresults > 0)
		{
			printf("mysql_next_result returned %d, mysql error %s, (%d)\n",moreresult,mysql_error(dbc),mysql_errno(dbc));
			break;
		}
	} while (0==moreresult);
}

char* alocmem(const int num)
{
	char *r=calloc(num,1);
	if(NULL == r)
	{
		printf("cannot calloc %d bytes of memory\n",num);
		exit(1);
	}
	return r;
}

int write_string(char *buf,const int minlen,const int maxlen,const int flag)
{
	if(!buf || maxlen==0)
		return 0;
	int lengt=minlen + lrand48() % (maxlen-minlen) - 1;
	int start_lengt = lrand48()%(DATASIZE - lengt - 1);
	if(lengt<0) lengt=0;
	if(start_lengt<0) start_lengt=0;
	memcpy(buf,databucket+start_lengt,lengt);
	buf[lengt]=0;
	return lengt;
}

void *worker_thread(void *arg)
{
	MYSQL *dbc=NULL;
	int cancelstate=0;
	pthread_setcancelstate(PTHREAD_CANCEL_DISABLE,&cancelstate);

	if (!(dbc = mysql_init(NULL)))
	{
		printf("mysql_init\n");
		dbc=NULL;
		goto threadexit;
	}
	else
	{
		if (!mysql_real_connect(dbc,host,username,password,database,port, NULL, CLIENT_FOUND_ROWS|CLIENT_MULTI_STATEMENTS|CLIENT_MULTI_RESULTS))
		{
			printf("mysql_real_connect failed: %s (%d)", mysql_error(dbc),mysql_errno(dbc));
			dbc=NULL;
		}
	}

	unsigned int counter=0;
	char shortquery[1024]={0};
	char *longquery=NULL;
	char *c=NULL;
	while(!threaddone && dbc!=NULL)
	{
	/* printing 26 SQL statements */

		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","set @name='");
					c+=write_string(c,0,255,0);
					c+=sprintf(c,"%s","'");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","set @birthday='");
					c+=sprintf(c,"%04d-%02d-%02d %02d:%02d:%02d",1000 + (lrand48()%(9999-1000)),01 + (lrand48()%(12-1)),01 + (lrand48()%(31-1)),(lrand48()%(24-0)),(lrand48()%(60-0)),(lrand48()%(60)));
					c+=sprintf(c,"%s","'");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","set @data='");
					c+=write_string(c,0,255,0);
					c+=sprintf(c,"%s","'");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","insert into t1(name,birthday) values (@name,@birthday)");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","set @id=last_insert_id()");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","insert ignore into t2 (birthday,name,id) select birthday,name,id+1 from t1 where id=@id");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","insert ignore into t3(data) values (concat(@name,@birthdate))");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","insert ignore into t4(id,data) values(last_insert_id()+abs(");
					c+=sprintf(c,"%d",-128 + lrand48()%255);
					c+=sprintf(c,"%s","),'");
					c+=write_string(c,0,255,0);
					c+=sprintf(c,"%s","')");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","start transaction");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","update t4 set data=reverse(data) order by id limit 1");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","select count(*) from t1,t2,t3 where t1.id=t2.id and t2.id=t3.id");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","select count(*) from t1 where id%5=0");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","select * from t3 where data like '");
					c+=write_string(c,0,255,0);
					c+=sprintf(c,"%s","%'");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","select max(id) from t1");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","insert ignore into t4(id) select max(id)+1 from t2");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","insert ignore into t3(id) select max(id)+1 from t2");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","insert ignore into t2(id) select max(id)+1 from t1");
					db_query(dbc,shortquery,1);

		}


		if(lrand48()%5==0)
		{
					c=shortquery;
					c+=sprintf(c,"%s","insert ignore into t1(id) select max(id)+1 from t2");
					db_query(dbc,shortquery,1);

		}


	}
threadexit:
	mysql_close(dbc);
	mysql_thread_end();
	pthread_exit(0);
}


int main(int argc, const char *argv[])
{
	MYSQL *dbc=NULL;
	int i=0,err=0;

	srand48((unsigned long)time(NULL));
	time_t timestart=0,timenow=0;

	unsigned int counter=0;
	char shortquery[1024]={0};
	char *longquery=NULL;
	char *c=NULL;
	my_init();
	if (!(dbc = mysql_init(NULL)))
	{
		printf("mysql_init\n");
		dbc=NULL;
		goto threadexit;
	}
	else
	{
		if (!mysql_real_connect(dbc,host,username,password,database,port, NULL, CLIENT_FOUND_ROWS|CLIENT_MULTI_STATEMENTS|CLIENT_MULTI_RESULTS))
		{
			printf("mysql_real_connect failed: %s (%d)", mysql_error(dbc),mysql_errno(dbc));
			dbc=NULL;
			goto threadexit;
		}
	}

	printf("running initializations..\n");
	printf("pre-generating %d bytes of random data\n",DATASIZE);
   databucket=calloc(DATASIZE,sizeof(char*));
   if(NULL == databucket)
	{
		printf("error: cannot calloc data buffer.\n");
		exit(1);
	}
	for(i=0;i<DATASIZE-1;i++)
	{
		databucket[i]=0x61+(lrand48()%26);
	}
					c=shortquery;
					c+=sprintf(c,"%s","drop table if exists `t1`");
					db_query(dbc,shortquery,1);

					c=shortquery;
					c+=sprintf(c,"%s","drop table if exists `t2`");
					db_query(dbc,shortquery,1);

					c=shortquery;
					c+=sprintf(c,"%s","drop table if exists `t3`");
					db_query(dbc,shortquery,1);

					c=shortquery;
					c+=sprintf(c,"%s","drop table if exists `t4`");
					db_query(dbc,shortquery,1);

					c=shortquery;
					c+=sprintf(c,"%s","create table `t1`(`id` int not null auto_increment primary key,`name` varchar(20),`birthday` datetime,key(`name`(5),`birthday`))engine=innodb");
					db_query(dbc,shortquery,1);

					c=shortquery;
					c+=sprintf(c,"%s","create table `t2`(`birthday` datetime,`name` char(21),`id` int,key(`birthday`,`id`))engine=innodb");
					db_query(dbc,shortquery,1);

					c=shortquery;
					c+=sprintf(c,"%s","create table `t3`(`id` int not null auto_increment primary key,`data` varchar(255),key(`data`(5)))engine=innodb");
					db_query(dbc,shortquery,1);

					c=shortquery;
					c+=sprintf(c,"%s","create table `t4`(`id` int not null auto_increment primary key,`data` varchar(255),key(`data`(7)))engine=innodb");
					db_query(dbc,shortquery,1);

	mysql_close(dbc);

	printf("about to spawn %d threads\n",NUMTHREADS);
	for (i=0;i<NUMTHREADS;i++)
	{
		err=pthread_create(&pthreads[i], NULL, worker_thread, (void *)i);
		if(err!=0)
		{
			printf("error spawning thread %lu, pthread_create returned %lu\n",(unsigned long)i,(unsigned long)err);
		}
	printf(".");
	}
	printf("\n");
	printf("completed spawning new database worker threads\n");

	printf("testcase is now running, so watch for error output\n");

	timestart=time(NULL);
	timenow=time(NULL);
	for(i=0;(timenow-timestart) < TESTTIME;timenow=time(NULL))
	{
		sleep(1);
	}
	threaddone=1;

	printf("waiting for worker threads to finish...\n");

	for (i=0;i<NUMTHREADS;i++)
	{
		pthread_join(pthreads[i], NULL);
	}

	exit(0);
threadexit:
	exit(-1);
}