// This cpp file is a generated trace that consists of the following "sections":
//
// - Connection parameters for mysql_real_connect:
// - Helper functions
// - The actual trace (marked by ****** Begin/End of trace ******)
// - Functions to create and populate the necessary tables
// - A dump of the current mysql variables

// This cpp file should be compilable with:
// 	gcc -g -I ${MYSQL_DIR}/include ${THIS_FILE} ${MYSQL_DIR}/lib/libmysqlclient.a -lm -lz -lstdc++

// To replay the trace you should have a database "baan", or you can change the
// DB_NAME variable below. 
// You should also have two users: bsp/bsp, who has SELECT, INSERT, UPDATE, DELETE
// privileges on all objects and baan/baan (the owner), who has ALL PRIVILEGES.
// You may choose to use other users/passwords by changing the USER_*/OWNER_*
// variables below.
// You can connect to MySQL through TCP/IP by setting the HOST_NAME variable, or
// you can use sockets by setting HOST_NAME to NULL and setting the right UNIX_SOCKET.
//
// The trace replays successfully if the program silently terminates with exit status 0.

#include <stdlib.h>
#include <stdio.h>
#include <string.h>
#include <assert.h>
#include <string>

// Connection parameters
const char *HOST_NAME = NULL;
const char *USER_NAME = "bsp";
const char *USER_PWD = "bsp";
const char *DB_NAME = "baan";
const char *UNIX_SOCKET = "/var/lib/mysql/mysql.sock";
// For ddl statements we use a different user/pwd
const char *OWNER_NAME = "baan";
const char *OWNER_PWD = "baan";

// use "#define ASSERT_EQ (void)" to disable data validation
#define ASSERT(C) assert(C)
#define ASSERT_EQ(X,Y) assert( check_eq(X,Y) )
#define ASSERT_EQ_DATETIME(X,Y,M,D,h,m,s) assert( check_eq_datetime(X,Y,M,D,h,m,s) )

#include "mysql.h"

void create_tables(void);

// Global variables
const char *stmt_text;
int mysql_ret;
int count;
int mysql_err;
MYSQL_TIME mysql_time;
MYSQL_RES *mysql_result;
MYSQL_ROW mysql_row;

const unsigned long select_cursor = CURSOR_TYPE_READ_ONLY;
const unsigned long update_cursor = CURSOR_TYPE_FOR_UPDATE;
const unsigned long no_cursor = CURSOR_TYPE_NO_CURSOR;

// Helper functions
void set_bind_attrs( MYSQL_BIND *mysql_bind, enum_field_types ext_type, void *buf, int bufsz, unsigned long *act_len, my_bool *is_null )
{
	mysql_bind->buffer_type = ext_type;
	mysql_bind->buffer = buf;
	mysql_bind->length = act_len;
	mysql_bind->is_null = is_null;
	mysql_bind->buffer_length = bufsz;
}

void bind_time(void *ptr,int ye,int mo,int da,int ho,int mi,int se)
{
	MYSQL_TIME t = {ye,mo,da,ho,mi,se};
	memcpy(ptr,&t,sizeof(t));
}

int check_eq(unsigned long v,unsigned long val)
	{ return( v == val ); }
int check_eq(void *ptr,const char *val)
	{ return( memcmp((char*)ptr,val,strlen(val))==0); }
int check_eq(void *ptr,int val)
	{ return( *((int*)ptr) == val ); }
int check_eq(void *ptr,float val)
	{ return( *((float*)ptr) == val ); }
int check_eq(void *ptr,double val)
	{ return( *((double*)ptr) == val ); }
int check_eq_datetime(void *ptr,int ye,int mo,int da,int ho,int mi,int se)
{
	MYSQL_TIME *t = (MYSQL_TIME*)ptr;
	return (t->year == ye) && (t->month == mo) && (t->day == da)
		 && (t->hour == ho) && (t->minute == mi) && (t->second == se);
}

int main(void)
{
	// Create the tables needed to run this trace
	create_tables();

	// ****** Begin of trace ******

	MYSQL *sess_1;
	sess_1 = mysql_init( NULL ); assert(sess_1);
	mysql_real_connect(sess_1, HOST_NAME, USER_NAME, USER_PWD, DB_NAME, 0, UNIX_SOCKET, 0); 
	mysql_autocommit(sess_1, 0);
	mysql_query(sess_1, "SET SESSION sql_mode=ERROR_FOR_DIVISION_BY_ZERO");
	mysql_query(sess_1, "SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED");
	MYSQL_STMT *stmt_1;
	stmt_1 = mysql_stmt_init(sess_1);
	mysql_ret = mysql_stmt_attr_set(stmt_1,STMT_ATTR_CURSOR_TYPE,(const void *) &select_cursor); assert(mysql_ret==0);
	stmt_text = "SELECT a0.t_empno,a0.t_workdept FROM ( tdbtst120000 AS a0 LEFT  JOIN  tdbtst100000 AS a1 ON a1.t_deptno = a0.t_workdept) WHERE a1.t_deptno IN (SELECT a2.t_deptno FROM ( tdbtst120000 AS a3 LEFT  JOIN  tdbtst100000 AS a2 ON a2.t_deptno = a3.t_workdept) WHERE a3.t_empno = ?) ORDER BY 1";
	mysql_ret = mysql_stmt_prepare(stmt_1,stmt_text,strlen(stmt_text)); assert(mysql_ret==0);
	count = mysql_stmt_param_count(stmt_1); assert( count==1 );
	MYSQL_BIND *param_1 = (MYSQL_BIND *)calloc(1, sizeof(MYSQL_BIND));
	MYSQL_BIND *output_1 = (MYSQL_BIND *)calloc(2, sizeof(MYSQL_BIND));
	char data_1[4];
	unsigned long len_1;
	my_bool null_1;
	set_bind_attrs(&param_1[0],MYSQL_TYPE_LONG,&data_1,4,&len_1,&null_1);
	char data_2[4];
	unsigned long len_2;
	my_bool null_2;
	set_bind_attrs(&output_1[0],MYSQL_TYPE_LONG,&data_2,4,&len_2,&null_2);
	char data_3[6];
	unsigned long len_3;
	my_bool null_3;
	set_bind_attrs(&output_1[1],MYSQL_TYPE_VAR_STRING,&data_3,6,&len_3,&null_3);
	null_1 = 0;
	len_1 = 0;
	*((int*)data_1) = 10;
	mysql_stmt_bind_param(stmt_1,param_1);
	count = mysql_warning_count(sess_1); assert(count==0);

// ERROR: next statement causes a server crash

	mysql_ret = mysql_stmt_execute(stmt_1); assert(mysql_ret==1);
	count = mysql_warning_count(sess_1); assert(count==0);
	mysql_err = mysql_stmt_errno(stmt_1); assert( mysql_err==2013 ); // Lost connection to MySQL server during query
	mysql_ret = mysql_stmt_close(stmt_1); assert(mysql_ret==1);
	mysql_ret = mysql_rollback(sess_1); assert(mysql_ret==1);
	mysql_err = mysql_errno(sess_1); assert( mysql_err==2006 ); // MySQL server has gone away
	mysql_ret = mysql_rollback(sess_1); assert(mysql_ret==1);
	mysql_err = mysql_errno(sess_1); assert( mysql_err==2006 ); // MySQL server has gone away

	// ****** End of trace ******

}

// Following code creates all tables needed to run this trace

void create_dbtst100000( void )
{
	FILE *fp = fopen("/tmp/baan_table_dump","w");
	fprintf(fp,"%s\n","-- MySQL dump 10.10");
	fprintf(fp,"%s\n","--");
	fprintf(fp,"%s\n","-- Host: localhost    Database: baan");
	fprintf(fp,"%s\n","-- ------------------------------------------------------");
	fprintf(fp,"%s\n","-- Server version\0115.0.10-beta-nightly-20050712-debug");
	fprintf(fp,"%s\n","");
	fprintf(fp,"%s\n","/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;");
	fprintf(fp,"%s\n","/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;");
	fprintf(fp,"%s\n","/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;");
	fprintf(fp,"%s\n","/*!40101 SET NAMES utf8 */;");
	fprintf(fp,"%s\n","/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;");
	fprintf(fp,"%s\n","/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;");
	fprintf(fp,"%s\n","/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;");
	fprintf(fp,"%s\n","/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;");
	fprintf(fp,"%s\n","");
	fprintf(fp,"%s\n","--");
	fprintf(fp,"%s\n","-- Table structure for table `tdbtst100000`");
	fprintf(fp,"%s\n","--");
	fprintf(fp,"%s\n","");
	fprintf(fp,"%s\n","DROP TABLE IF EXISTS `tdbtst100000`;");
	fprintf(fp,"%s\n","CREATE TABLE `tdbtst100000` (");
	fprintf(fp,"%s\n","  `t_deptno` varchar(6) collate latin1_bin NOT NULL,");
	fprintf(fp,"%s\n","  `t_deptname` varchar(20) collate latin1_bin NOT NULL,");
	fprintf(fp,"%s\n","  `t_mgrno` int(11) NOT NULL,");
	fprintf(fp,"%s\n","  `t_location` varchar(20) collate latin1_bin NOT NULL,");
	fprintf(fp,"%s\n","  `t_admrdept` varchar(6) collate latin1_bin NOT NULL,");
	fprintf(fp,"%s\n","  `t_Refcntd` int(11) NOT NULL,");
	fprintf(fp,"%s\n","  `t_Refcntu` int(11) NOT NULL,");
	fprintf(fp,"%s\n","  PRIMARY KEY  (`t_deptno`)");
	fprintf(fp,"%s\n",") ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;");
	fprintf(fp,"%s\n","");
	fprintf(fp,"%s\n","--");
	fprintf(fp,"%s\n","-- Dumping data for table `tdbtst100000`");
	fprintf(fp,"%s\n","--");
	fprintf(fp,"%s\n","");
	fprintf(fp,"%s\n","");
	fprintf(fp,"%s\n","/*!40000 ALTER TABLE `tdbtst100000` DISABLE KEYS */;");
	fprintf(fp,"%s\n","LOCK TABLES `tdbtst100000` WRITE;");
	fprintf(fp,"%s\n","INSERT INTO `tdbtst100000` VALUES ('A00   ','SPIFFY COMPUTER SERV',10,'                    ','A00   ',0,0),('B01   ','PLANNING            ',20,'                    ','A00   ',0,0),('C01   ','INFORMATION CENTER  ',30,'                    ','A00   ',0,0),('D01   ','DEVELOPMENT CENTER  ',0,'                    ','A00   ',0,0),('D11   ','MANUFACTURING SYSTEM',60,'                    ','D01   ',0,0),('D21   ','ADMINISTRATION SYSTE',70,'                    ','D01   ',0,0),('E01   ','SUPPORT SERVICES    ',50,'                    ','A00   ',0,0),('E11   ','OPERATIONS          ',90,'                    ','E01   ',0,0),('E21   ','SOFTWARE SUPPORT    ',100,'                    ','E01   ',0,0);");
	fprintf(fp,"%s\n","UNLOCK TABLES;");
	fprintf(fp,"%s\n","/*!40000 ALTER TABLE `tdbtst100000` ENABLE KEYS */;");
	fprintf(fp,"%s\n","");
	fprintf(fp,"%s\n","/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;");
	fprintf(fp,"%s\n","/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;");
	fprintf(fp,"%s\n","/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;");
	fprintf(fp,"%s\n","/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;");
	fprintf(fp,"%s\n","/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;");
	fprintf(fp,"%s\n","/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;");
	fprintf(fp,"%s\n","/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;");
	fprintf(fp,"%s\n","");
	fclose(fp);
	std::string cmd = std::string("mysql");
	if ( OWNER_NAME ) cmd += std::string(" --user=") + OWNER_NAME;
	if ( OWNER_PWD ) cmd += std::string(" --password=") + OWNER_PWD;
	if ( HOST_NAME ) cmd += std::string(" --host=") + HOST_NAME;
	if ( UNIX_SOCKET ) cmd += std::string(" --socket=") + UNIX_SOCKET;
	cmd += std::string(" ") + DB_NAME;
	cmd += " < /tmp/baan_table_dump";
	int ret = system(cmd.data());
	if ( ret != 0 ) fprintf(stderr,"Command \"%s\" failed\n",cmd.data());
}

void create_dbtst120000( void )
{
	FILE *fp = fopen("/tmp/baan_table_dump","w");
	fprintf(fp,"%s\n","-- MySQL dump 10.10");
	fprintf(fp,"%s\n","--");
	fprintf(fp,"%s\n","-- Host: localhost    Database: baan");
	fprintf(fp,"%s\n","-- ------------------------------------------------------");
	fprintf(fp,"%s\n","-- Server version\0115.0.10-beta-nightly-20050712-debug");
	fprintf(fp,"%s\n","");
	fprintf(fp,"%s\n","/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;");
	fprintf(fp,"%s\n","/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;");
	fprintf(fp,"%s\n","/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;");
	fprintf(fp,"%s\n","/*!40101 SET NAMES utf8 */;");
	fprintf(fp,"%s\n","/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;");
	fprintf(fp,"%s\n","/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;");
	fprintf(fp,"%s\n","/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;");
	fprintf(fp,"%s\n","/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;");
	fprintf(fp,"%s\n","");
	fprintf(fp,"%s\n","--");
	fprintf(fp,"%s\n","-- Table structure for table `tdbtst120000`");
	fprintf(fp,"%s\n","--");
	fprintf(fp,"%s\n","");
	fprintf(fp,"%s\n","DROP TABLE IF EXISTS `tdbtst120000`;");
	fprintf(fp,"%s\n","CREATE TABLE `tdbtst120000` (");
	fprintf(fp,"%s\n","  `t_empno` int(11) NOT NULL,");
	fprintf(fp,"%s\n","  `t_firstnme` varchar(20) collate latin1_bin NOT NULL,");
	fprintf(fp,"%s\n","  `t_midinit` varchar(20) collate latin1_bin NOT NULL,");
	fprintf(fp,"%s\n","  `t_lastname` varchar(20) collate latin1_bin NOT NULL,");
	fprintf(fp,"%s\n","  `t_workdept` varchar(6) collate latin1_bin NOT NULL,");
	fprintf(fp,"%s\n","  `t_phoneno_1` varchar(20) collate latin1_bin NOT NULL,");
	fprintf(fp,"%s\n","  `t_phoneno_2` varchar(20) collate latin1_bin NOT NULL,");
	fprintf(fp,"%s\n","  `t_phoneno_3` varchar(20) collate latin1_bin NOT NULL,");
	fprintf(fp,"%s\n","  `t_hiredate` date NOT NULL,");
	fprintf(fp,"%s\n","  `t_job` varchar(20) collate latin1_bin NOT NULL,");
	fprintf(fp,"%s\n","  `t_edlevel` int(11) NOT NULL,");
	fprintf(fp,"%s\n","  `t_sex` int(11) NOT NULL,");
	fprintf(fp,"%s\n","  `t_birthdte` date NOT NULL,");
	fprintf(fp,"%s\n","  `t_salary` double NOT NULL,");
	fprintf(fp,"%s\n","  `t_bonus` float NOT NULL,");
	fprintf(fp,"%s\n","  `t_Refcntd` int(11) NOT NULL,");
	fprintf(fp,"%s\n","  `t_Refcntu` int(11) NOT NULL,");
	fprintf(fp,"%s\n","  PRIMARY KEY  (`t_empno`),");
	fprintf(fp,"%s\n","  UNIQUE KEY `Itdbtst120000_2` (`t_workdept`,`t_empno`)");
	fprintf(fp,"%s\n",") ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;");
	fprintf(fp,"%s\n","");
	fprintf(fp,"%s\n","--");
	fprintf(fp,"%s\n","-- Dumping data for table `tdbtst120000`");
	fprintf(fp,"%s\n","--");
	fprintf(fp,"%s\n","");
	fprintf(fp,"%s\n","");
	fprintf(fp,"%s\n","/*!40000 ALTER TABLE `tdbtst120000` DISABLE KEYS */;");
	fprintf(fp,"%s\n","LOCK TABLES `tdbtst120000` WRITE;");
	fprintf(fp,"%s\n","INSERT INTO `tdbtst120000` VALUES (10,'CHRISTINE           ','I                   ','HAAS                ','A00   ','15972               ','1218                ','23548               ','1965-01-01','PRES                ',18,2,'1933-08-24',52750,1000,0,0),(20,'MICHAEL             ','L                   ','THOMPSON            ','B01   ','5164                ','27599               ','25190               ','1973-10-10','MANAGER             ',18,1,'1948-02-02',41250,800,0,0),(30,'SALLY               ','A                   ','KWAN                ','C01   ','9478                ','19968               ','2310                ','1975-04-05','MANAGER             ',20,2,'1941-05-11',38250,800,0,0),(50,'JOHN                ','B                   ','GEYER               ','E01   ','4375                ','22823               ','14762               ','1949-08-17','MANAGER             ',16,1,'1925-09-15',40175,800,0,0),(60,'IRVING              ','F                   ','STERN               ','D11   ','1028                ','23402               ','2418                ','1973-09-14','MANAGER             ',16,1,'1945-07-07',32250,500,0,0),(70,'EVA                 ','D                   ','PULASKI             ','D21   ','19520               ','22171               ','32503               ','1980-09-30','MANAGER             ',16,2,'1953-05-26',36170,700,0,0),(90,'EILEEN              ','W                   ','HENDERSON           ','E11   ','6933                ','27989               ','3896                ','1970-08-15','MANAGER             ',16,2,'1941-05-15',29750,600,0,0),(100,'THEODORE            ','Q                   ','SPENSER             ','E21   ','14707               ','1498                ','32072               ','1980-06-19','MANAGER             ',14,1,'1956-12-18',26150,500,0,0),(110,'VINCENZO            ','G                   ','LUCCHESSI           ','A00   ','15740               ','16047               ','2234                ','1958-05-16','SALESREP            ',19,1,'1929-11-05',46500,900,0,0),(120,'SEAN                ','                    ','O\\'CONNELL           ','A00   ','3275                ','4340                ','5832                ','1963-12-05','CLERK               ',14,1,'1942-10-18',29250,600,0,0),(130,'DOLORES             ','M                   ','QUINTANA            ','C01   ','14216               ','15493               ','16966               ','1971-07-28','ANALYST             ',16,2,'1925-09-15',23800,500,0,0),(140,'HEATHER             ','A                   ','NICHOLLS            ','C01   ','30764               ','22995               ','32329               ','1976-12-15','ANALYST             ',18,2,'1946-01-19',28420,600,0,0),(150,'BRUCE               ','                    ','ADAMSON             ','D11   ','25621               ','11648               ','14230               ','1972-02-12','DESIGNER            ',16,1,'1947-05-17',25280,500,0,0),(160,'ELIZABETH           ','R                   ','PIANKA              ','D11   ','6345                ','6588                ','8396                ','1977-10-11','DESIGNER            ',17,2,'1955-04-12',22250,400,0,0),(170,'MASATOSHI           ','J                   ','YOSHIMURA           ','D11   ','29194               ','18786               ','5457                ','1978-09-15','DESIGNER            ',16,1,'1951-01-05',24680,500,0,0),(180,'MARILYN             ','S                   ','SCOUTTEN            ','D11   ','5278                ','28881               ','16126               ','1973-07-07','DESIGNER            ',17,2,'1949-02-21',21340,500,0,0),(190,'JAMES               ','H                   ','WALKER              ','D11   ','23003               ','16523               ','27274               ','1974-07-26','DESIGNER            ',16,1,'1952-06-25',20450,400,0,0),(200,'DAVID               ','                    ','BROWN               ','D11   ','26612               ','26000               ','14007               ','1966-03-03','DESIGNER            ',16,1,'1941-05-29',27740,600,0,0),(210,'WILLIAM             ','T                   ','JONES               ','D11   ','774                 ','13176               ','2622                ','1979-04-11','DESIGNER            ',17,1,'1953-02-23',18270,400,0,0),(220,'JENNIFER            ','K                   ','LUTZ                ','D11   ','25314               ','21587               ','31867               ','1968-08-29','DESIGNER            ',18,2,'1948-03-19',29840,600,0,0),(230,'JAMES               ','J                   ','JEFFERSON           ','D21   ','6552                ','6721                ','7385                ','1966-11-21','CLERK               ',14,1,'1935-05-30',22180,400,0,0),(240,'SALVATORE           ','M                   ','MARINO              ','D21   ','22216               ','20176               ','17659               ','1979-12-05','CLERK               ',17,1,'1954-03-31',28760,600,0,0),(250,'DANIEL              ','S                   ','SMITH               ','D21   ','5032                ','7192                ','25007               ','1969-10-30','CLERK               ',15,1,'1939-12-12',19180,400,0,0),(260,'SYBIL               ','P                   ','JOHNSON             ','D21   ','29652               ','27544               ','24212               ','1975-09-11','CLERK               ',16,2,'1936-10-05',17250,300,0,0),(270,'MARIA               ','L                   ','PEREZ               ','D21   ','26329               ','22223               ','8325                ','1980-09-30','CLERK               ',15,2,'1953-05-26',27380,500,0,0),(280,'ETHEL               ','R                   ','SCHNEIDER           ','E11   ','22144               ','1434                ','15052               ','1967-03-24','OPERATOR            ',17,2,'1936-03-28',26250,500,0,0),(290,'JOHN                ','R                   ','PARKER              ','E11   ','28122               ','5712                ','19208               ','1980-05-30','OPERATOR            ',12,1,'1946-07-09',15340,300,0,0),(300,'PHILIP              ','X                   ','SMITH               ','E11   ','17680               ','27551               ','10202               ','1972-06-19','OPERATOR            ',14,1,'1936-10-27',17750,400,0,0),(310,'MAUDE               ','F                   ','SETRIGHT            ','E11   ','32231               ','31781               ','20050               ','1964-09-12','OPERATOR            ',12,2,'1931-04-21',15900,300,0,0),(320,'RAMLAL              ','V                   ','MEHTA               ','E21   ','7446                ','32718               ','14876               ','1965-07-07','FIELDREP            ',16,1,'1932-08-11',19950,400,0,0),(330,'WING                ','                    ','LEE                 ','E21   ','11336               ','5872                ','5226                ','1000-01-01','FIELDREP            ',14,1,'1941-07-18',25370,500,0,0),(340,'JASON               ','R                   ','GOUNOT              ','E21   ','28911               ','18216               ','26017               ','1947-05-05','FIELDREP            ',16,1,'1926-05-17',23840,500,0,0);");
	fprintf(fp,"%s\n","UNLOCK TABLES;");
	fprintf(fp,"%s\n","/*!40000 ALTER TABLE `tdbtst120000` ENABLE KEYS */;");
	fprintf(fp,"%s\n","");
	fprintf(fp,"%s\n","/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;");
	fprintf(fp,"%s\n","/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;");
	fprintf(fp,"%s\n","/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;");
	fprintf(fp,"%s\n","/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;");
	fprintf(fp,"%s\n","/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;");
	fprintf(fp,"%s\n","/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;");
	fprintf(fp,"%s\n","/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;");
	fprintf(fp,"%s\n","");
	fclose(fp);
	std::string cmd = std::string("mysql");
	if ( OWNER_NAME ) cmd += std::string(" --user=") + OWNER_NAME;
	if ( OWNER_PWD ) cmd += std::string(" --password=") + OWNER_PWD;
	if ( HOST_NAME ) cmd += std::string(" --host=") + HOST_NAME;
	if ( UNIX_SOCKET ) cmd += std::string(" --socket=") + UNIX_SOCKET;
	cmd += std::string(" ") + DB_NAME;
	cmd += " < /tmp/baan_table_dump";
	int ret = system(cmd.data());
	if ( ret != 0 ) fprintf(stderr,"Command \"%s\" failed\n",cmd.data());
}

void create_tables( void )
{
	create_dbtst100000();
	create_dbtst120000();
}

#if 0 // Output of "show variables"
#
#	Variable_name                 	Value
#	auto_increment_increment      	1
#	auto_increment_offset         	1
#	automatic_sp_privileges       	ON
#	back_log                      	50
#	basedir                       	/usr1/mysql/mysql-5.0.10-beta-nightly-20050712-linux-i686/
#	binlog_cache_size             	32768
#	bulk_insert_buffer_size       	8388608
#	character_set_client          	latin1
#	character_set_connection      	latin1
#	character_set_database        	latin1
#	character_set_results         	latin1
#	character_set_server          	latin1
#	character_set_system          	utf8
#	character_sets_dir            	/usr1/mysql/mysql-5.0.10-beta-nightly-20050712-linux-i686/share/mysql/charsets/
#	collation_connection          	latin1_swedish_ci
#	collation_database            	latin1_swedish_ci
#	collation_server              	latin1_swedish_ci
#	completion_type               	0
#	concurrent_insert             	1
#	connect_timeout               	5
#	datadir                       	/usr1/mysql/mysql-5.0.10-beta-nightly-20050712-linux-i686/data/
#	date_format                   	%Y-%m-%d
#	datetime_format               	%Y-%m-%d %H:%i:%s
#	div_precision_increment       	4
#	default_week_format           	0
#	delay_key_write               	ON
#	delayed_insert_limit          	100
#	delayed_insert_timeout        	300
#	delayed_queue_size            	1000
#	expire_logs_days              	0
#	flush                         	OFF
#	flush_time                    	0
#	ft_boolean_syntax             	+ -><()~*:""&|
#	ft_max_word_len               	84
#	ft_min_word_len               	4
#	ft_query_expansion_limit      	20
#	ft_stopword_file              	(built-in)
#	group_concat_max_len          	1024
#	have_archive                  	NO
#	have_bdb                      	NO
#	have_blackhole_engine         	NO
#	have_compress                 	YES
#	have_crypt                    	YES
#	have_csv                      	NO
#	have_example_engine           	NO
#	have_federated_engine         	NO
#	have_geometry                 	YES
#	have_innodb                   	YES
#	have_isam                     	NO
#	have_ndbcluster               	NO
#	have_openssl                  	NO
#	have_query_cache              	YES
#	have_raid                     	NO
#	have_rtree_keys               	YES
#	have_symlink                  	YES
#	init_connect                  	
#	init_file                     	
#	init_slave                    	
#	innodb_additional_mem_pool_size	1048576
#	innodb_autoextend_increment   	8
#	innodb_buffer_pool_awe_mem_mb 	0
#	innodb_buffer_pool_size       	8388608
#	innodb_checksums              	ON
#	innodb_concurrency_tickets    	500
#	innodb_data_file_path         	ibdata1:10M:autoextend
#	innodb_data_home_dir          	
#	innodb_doublewrite            	ON
#	innodb_fast_shutdown          	1
#	innodb_file_io_threads        	4
#	innodb_file_per_table         	OFF
#	innodb_flush_log_at_trx_commit	1
#	innodb_flush_method           	
#	innodb_force_recovery         	0
#	innodb_lock_wait_timeout      	10
#	innodb_locks_unsafe_for_binlog	OFF
#	innodb_log_arch_dir           	
#	innodb_log_archive            	OFF
#	innodb_log_buffer_size        	1048576
#	innodb_log_file_size          	5242880
#	innodb_log_files_in_group     	2
#	innodb_log_group_home_dir     	./
#	innodb_max_dirty_pages_pct    	90
#	innodb_max_purge_lag          	0
#	innodb_mirrored_log_groups    	1
#	innodb_open_files             	300
#	innodb_sync_spin_loops        	20
#	innodb_table_locks            	ON
#	innodb_support_xa             	ON
#	innodb_thread_concurrency     	20
#	innodb_thread_sleep_delay     	10000
#	interactive_timeout           	28800
#	join_buffer_size              	131072
#	key_buffer_size               	16777216
#	key_cache_age_threshold       	300
#	key_cache_block_size          	1024
#	key_cache_division_limit      	100
#	language                      	/usr1/mysql/mysql-5.0.10-beta-nightly-20050712-linux-i686/share/mysql/english/
#	large_files_support           	ON
#	large_pages                   	OFF
#	large_page_size               	0
#	license                       	GPL
#	local_infile                  	ON
#	locked_in_memory              	OFF
#	log                           	OFF
#	log_bin                       	OFF
#	log_bin_trust_routine_creators	OFF
#	log_error                     	
#	log_slave_updates             	OFF
#	log_slow_queries              	OFF
#	log_warnings                  	1
#	long_query_time               	10
#	low_priority_updates          	OFF
#	lower_case_file_system        	OFF
#	lower_case_table_names        	0
#	max_allowed_packet            	1047552
#	max_binlog_cache_size         	4294967295
#	max_binlog_size               	1073741824
#	max_connect_errors            	10
#	max_connections               	100
#	max_delayed_threads           	20
#	max_error_count               	64
#	max_heap_table_size           	16777216
#	max_insert_delayed_threads    	20
#	max_join_size                 	4294967295
#	max_length_for_sort_data      	1024
#	max_relay_log_size            	0
#	max_seeks_for_key             	4294967295
#	max_sort_length               	1024
#	max_tmp_tables                	32
#	max_user_connections          	0
#	max_write_lock_count          	4294967295
#	multi_range_count             	256
#	myisam_data_pointer_size      	6
#	myisam_max_sort_file_size     	2147483647
#	myisam_recover_options        	OFF
#	myisam_repair_threads         	1
#	myisam_sort_buffer_size       	8388608
#	engine_condition_pushdown     	OFF
#	net_buffer_length             	8192
#	net_read_timeout              	30
#	net_retry_count               	10
#	net_write_timeout             	60
#	new                           	OFF
#	old_passwords                 	OFF
#	open_files_limit              	1024
#	optimizer_prune_level         	1
#	optimizer_search_depth        	62
#	pid_file                      	/usr1/mysql/mysql-5.0.10-beta-nightly-20050712-linux-i686/data/nlbaldev1.pid
#	port                          	3306
#	preload_buffer_size           	32768
#	protocol_version              	10
#	query_alloc_block_size        	8192
#	query_cache_limit             	1048576
#	query_cache_min_res_unit      	4096
#	query_cache_size              	0
#	query_cache_type              	ON
#	query_cache_wlock_invalidate  	OFF
#	query_prealloc_size           	8192
#	range_alloc_block_size        	2048
#	read_buffer_size              	131072
#	read_only                     	OFF
#	read_rnd_buffer_size          	262144
#	relay_log_purge               	ON
#	relay_log_space_limit         	0
#	rpl_recovery_rank             	0
#	secure_auth                   	OFF
#	server_id                     	1
#	skip_external_locking         	ON
#	skip_networking               	OFF
#	skip_show_database            	OFF
#	slave_compressed_protocol     	OFF
#	slave_load_tmpdir             	/tmp/
#	slave_net_timeout             	3600
#	slave_skip_errors             	OFF
#	slave_transaction_retries     	10
#	slow_launch_time              	2
#	socket                        	/var/lib/mysql/mysql.sock
#	sort_buffer_size              	524252
#	sql_mode                      	
#	storage_engine                	MyISAM
#	sql_notes                     	ON
#	sql_warnings                  	ON
#	sync_binlog                   	0
#	sync_replication              	0
#	sync_replication_slave_id     	0
#	sync_replication_timeout      	10
#	sync_frm                      	ON
#	system_time_zone              	CEST
#	table_cache                   	64
#	table_type                    	MyISAM
#	thread_cache_size             	0
#	thread_stack                  	196608
#	time_format                   	%H:%i:%s
#	time_zone                     	SYSTEM
#	timed_mutexes                 	OFF
#	tmp_table_size                	33554432
#	tmpdir                        	
#	transaction_alloc_block_size  	8192
#	transaction_prealloc_size     	4096
#	tx_isolation                  	REPEATABLE-READ
#	updatable_views_with_limit    	YES
#	version                       	5.0.10-beta-nightly-20050712-debug
#	version_comment               	Source distribution
#	version_compile_machine       	i686
#	version_compile_os            	pc-linux-gnu
#	wait_timeout                  	28800
#
#endif // Output of "show variables"