libmysql.c 147 KB
Newer Older
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1
/* Copyright (C) 2000-2003 MySQL AB
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2 3 4 5 6 7 8

   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.

   This program is distributed in the hope that it will be useful,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
9
   but WITHOUT ANY WARRANTY; without even the implied warranty of
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
10 11 12 13 14 15
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.

   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
16

17
#include <my_global.h>
bk@work.mysql.com's avatar
bk@work.mysql.com committed
18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
#if defined(__WIN__) || defined(_WIN32) || defined(_WIN64)
#include <winsock.h>
#include <odbcinst.h>
#endif
#include <my_sys.h>
#include <mysys_err.h>
#include <m_string.h>
#include <m_ctype.h>
#include "mysql.h"
#include "mysql_version.h"
#include "mysqld_error.h"
#include "errmsg.h"
#include <violite.h>
#include <sys/stat.h>
#include <signal.h>
#include <time.h>
34
#include <assert.h> /* for DBUG_ASSERT() */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
35 36 37 38 39 40 41 42 43
#ifdef	 HAVE_PWD_H
#include <pwd.h>
#endif
#if !defined(MSDOS) && !defined(__WIN__)
#include <sys/socket.h>
#include <netinet/in.h>
#include <arpa/inet.h>
#include <netdb.h>
#ifdef HAVE_SELECT_H
44
#include <select.h>
bk@work.mysql.com's avatar
bk@work.mysql.com committed
45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62
#endif
#ifdef HAVE_SYS_SELECT_H
#include <sys/select.h>
#endif
#endif
#ifdef HAVE_SYS_UN_H
#  include <sys/un.h>
#endif
#if defined(THREAD) && !defined(__WIN__)
#include <my_pthread.h>				/* because of signal()	*/
#endif
#ifndef INADDR_NONE
#define INADDR_NONE	-1
#endif

static my_bool	mysql_client_init=0;
uint		mysql_port=0;
my_string	mysql_unix_port=0;
63
ulong 		net_buffer_length=8192;
64
ulong		max_allowed_packet= 1024L*1024L*1024L;
65 66
ulong		net_read_timeout=  NET_READ_TIMEOUT;
ulong		net_write_timeout= NET_WRITE_TIMEOUT;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
67

68 69
#define CLIENT_CAPABILITIES (CLIENT_LONG_PASSWORD | CLIENT_LONG_FLAG	  \
                             | CLIENT_LOCAL_FILES   | CLIENT_TRANSACTIONS \
70
			     | CLIENT_PROTOCOL_41 | CLIENT_SECURE_CONNECTION)
71

bk@work.mysql.com's avatar
bk@work.mysql.com committed
72

73 74 75 76 77 78
#ifdef __WIN__
#define CONNECT_TIMEOUT 20
#else
#define CONNECT_TIMEOUT 0
#endif

bk@work.mysql.com's avatar
bk@work.mysql.com committed
79
#if defined(MSDOS) || defined(__WIN__)
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
80
/* socket_errno is defined in my_global.h for all platforms */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
81 82 83 84
#define perror(A)
#else
#include <errno.h>
#define SOCKET_ERROR -1
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
85
#endif /* __WIN__ */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
86

87 88 89 90 91 92 93 94 95
#ifdef HAVE_SMEM
char *shared_memory_base_name=0;
const char *def_shared_memory_base_name=default_shared_memory_base_name;
#endif

const char *sql_protocol_names_lib[] =
{ "TCP", "SOCKET", "PIPE", "MEMORY",NullS };
TYPELIB sql_protocol_typelib = {array_elements(sql_protocol_names_lib)-1,"",
			   sql_protocol_names_lib};
96 97 98 99 100
/*
  If allowed through some configuration, then this needs to
  be changed
*/
#define MAX_LONG_DATA_LENGTH 8192
101 102 103
#define protocol_41(A) ((A)->server_capabilities & CLIENT_PROTOCOL_41)
#define unsigned_field(A) ((A)->flags & UNSIGNED_FLAG)

bk@work.mysql.com's avatar
bk@work.mysql.com committed
104 105 106 107 108 109 110 111
static MYSQL_DATA *read_rows (MYSQL *mysql,MYSQL_FIELD *fields,
			      uint field_count);
static int read_one_row(MYSQL *mysql,uint fields,MYSQL_ROW row,
			ulong *lengths);
static void end_server(MYSQL *mysql);
static void read_user_name(char *name);
static void append_wild(char *to,char *end,const char *wild);
static my_bool mysql_reconnect(MYSQL *mysql);
112
static my_bool send_file_to_server(MYSQL *mysql,const char *filename);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
113 114 115
static sig_handler pipe_sig_handler(int sig);
static ulong mysql_sub_escape_string(CHARSET_INFO *charset_info, char *to,
				     const char *from, ulong length);
116
static my_bool stmt_close(MYSQL_STMT *stmt, my_bool skip_list);
117
static void fetch_lengths(ulong *to, MYSQL_ROW column, uint field_count);
118 119
static my_bool org_my_init_done=0;

120 121 122
int STDCALL mysql_server_init(int argc __attribute__((unused)),
			      char **argv __attribute__((unused)),
			      char **groups __attribute__((unused)))
123
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
124
  mysql_once_init();
125 126
  return 0;
}
tim@black.box's avatar
tim@black.box committed
127

128
void STDCALL mysql_server_end()
129 130 131 132
{
  /* If library called my_init(), free memory allocated by it */
  if (!org_my_init_done)
    my_end(0);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
133 134
  else
    mysql_thread_end();
135
}
tim@black.box's avatar
tim@black.box committed
136

137
my_bool STDCALL mysql_thread_init()
tim@black.box's avatar
tim@black.box committed
138 139 140 141 142 143 144 145
{
#ifdef THREAD
    return my_thread_init();
#else
    return 0;
#endif
}

146
void STDCALL mysql_thread_end()
tim@black.box's avatar
tim@black.box committed
147 148 149 150 151 152
{
#ifdef THREAD
    my_thread_end();
#endif
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
153 154 155 156 157 158 159 160 161 162 163 164 165 166 167
/*
  Let the user specify that we don't want SIGPIPE;  This doesn't however work
  with threaded applications as we can have multiple read in progress.
*/

#if !defined(__WIN__) && defined(SIGPIPE) && !defined(THREAD)
#define init_sigpipe_variables  sig_return old_signal_handler=(sig_return) 0;
#define set_sigpipe(mysql)     if ((mysql)->client_flag & CLIENT_IGNORE_SIGPIPE) old_signal_handler=signal(SIGPIPE,pipe_sig_handler)
#define reset_sigpipe(mysql) if ((mysql)->client_flag & CLIENT_IGNORE_SIGPIPE) signal(SIGPIPE,old_signal_handler);
#else
#define init_sigpipe_variables
#define set_sigpipe(mysql)
#define reset_sigpipe(mysql)
#endif

168 169 170 171 172 173
static MYSQL* spawn_init(MYSQL* parent, const char* host,
			 unsigned int port,
			 const char* user,
			 const char* passwd);


bk@work.mysql.com's avatar
bk@work.mysql.com committed
174
/****************************************************************************
175
  A modified version of connect().  my_connect() allows you to specify
176 177 178 179 180
  a timeout value, in seconds, that we should wait until we
  derermine we can't connect to a particular host.  If timeout is 0,
  my_connect() will behave exactly like connect().

  Base version coded by Steve Bernacki, Jr. <steve@navinet.net>
bk@work.mysql.com's avatar
bk@work.mysql.com committed
181 182
*****************************************************************************/

183 184
my_bool my_connect(my_socket s, const struct sockaddr *name,
		   uint namelen, uint timeout)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
185
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
186
#if defined(__WIN__) || defined(OS2) || defined(__NETWARE__)
187
  return connect(s, (struct sockaddr*) name, namelen) != 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
188 189
#else
  int flags, res, s_err;
190
  SOCKOPT_OPTLEN_TYPE s_err_size = sizeof(uint);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
191 192 193 194
  fd_set sfds;
  struct timeval tv;
  time_t start_time, now_time;

195 196 197 198
  /*
    If they passed us a timeout of zero, we should behave
    exactly like the normal connect() call does.
  */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
199

200
  if (timeout == 0)
201
    return connect(s, (struct sockaddr*) name, namelen) != 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
202 203 204 205 206 207 208 209 210 211 212 213

  flags = fcntl(s, F_GETFL, 0);		  /* Set socket to not block */
#ifdef O_NONBLOCK
  fcntl(s, F_SETFL, flags | O_NONBLOCK);  /* and save the flags..  */
#endif

  res = connect(s, (struct sockaddr*) name, namelen);
  s_err = errno;			/* Save the error... */
  fcntl(s, F_SETFL, flags);
  if ((res != 0) && (s_err != EINPROGRESS))
  {
    errno = s_err;			/* Restore it */
214
    return(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
215 216 217 218
  }
  if (res == 0)				/* Connected quickly! */
    return(0);

219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234
  /*
    Otherwise, our connection is "in progress."  We can use
    the select() call to wait up to a specified period of time
    for the connection to succeed.  If select() returns 0
    (after waiting howevermany seconds), our socket never became
    writable (host is probably unreachable.)  Otherwise, if
    select() returns 1, then one of two conditions exist:

    1. An error occured.  We use getsockopt() to check for this.
    2. The connection was set up sucessfully: getsockopt() will
    return 0 as an error.

    Thanks goes to Andrew Gierth <andrew@erlenstar.demon.co.uk>
    who posted this method of timing out a connect() in
    comp.unix.programmer on August 15th, 1997.
  */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
235 236 237 238

  FD_ZERO(&sfds);
  FD_SET(s, &sfds);
  /*
239 240 241 242 243 244
    select could be interrupted by a signal, and if it is,
    the timeout should be adjusted and the select restarted
    to work around OSes that don't restart select and
    implementations of select that don't adjust tv upon
    failure to reflect the time remaining
  */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
245 246 247
  start_time = time(NULL);
  for (;;)
  {
248
    tv.tv_sec = (long) timeout;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
249
    tv.tv_usec = 0;
250
#if defined(HPUX10) && defined(THREAD)
251
    if ((res = select(s+1, NULL, (int*) &sfds, NULL, &tv)) > 0)
252 253
      break;
#else
254
    if ((res = select(s+1, NULL, &sfds, NULL, &tv)) > 0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
255
      break;
256
#endif
257 258
    if (res == 0)					/* timeout */
      return -1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
259
    now_time=time(NULL);
260 261
    timeout-= (uint) (now_time - start_time);
    if (errno != EINTR || (int) timeout <= 0)
262
      return 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
263 264
  }

265 266 267 268 269
  /*
    select() returned something more interesting than zero, let's
    see if we have any errors.  If the next two statements pass,
    we've got an open socket!
  */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
270 271 272

  s_err=0;
  if (getsockopt(s, SOL_SOCKET, SO_ERROR, (char*) &s_err, &s_err_size) != 0)
273
    return(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
274 275

  if (s_err)
276
  {						/* getsockopt could succeed */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
277
    errno = s_err;
278
    return(1);					/* but return an error... */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
279
  }
280 281
  return (0);					/* ok */

bk@work.mysql.com's avatar
bk@work.mysql.com committed
282 283 284
#endif
}

285

bk@work.mysql.com's avatar
bk@work.mysql.com committed
286
/*
287
  Create a named pipe connection
bk@work.mysql.com's avatar
bk@work.mysql.com committed
288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357
*/

#ifdef __WIN__

HANDLE create_named_pipe(NET *net, uint connect_timeout, char **arg_host,
			 char **arg_unix_socket)
{
  HANDLE hPipe=INVALID_HANDLE_VALUE;
  char szPipeName [ 257 ];
  DWORD dwMode;
  int i;
  my_bool testing_named_pipes=0;
  char *host= *arg_host, *unix_socket= *arg_unix_socket;

  if ( ! unix_socket || (unix_socket)[0] == 0x00)
    unix_socket = mysql_unix_port;
  if (!host || !strcmp(host,LOCAL_HOST))
    host=LOCAL_HOST_NAMEDPIPE;

  sprintf( szPipeName, "\\\\%s\\pipe\\%s", host, unix_socket);
  DBUG_PRINT("info",("Server name: '%s'.  Named Pipe: %s",
		     host, unix_socket));

  for (i=0 ; i < 100 ; i++)			/* Don't retry forever */
  {
    if ((hPipe = CreateFile(szPipeName,
			    GENERIC_READ | GENERIC_WRITE,
			    0,
			    NULL,
			    OPEN_EXISTING,
			    0,
			    NULL )) != INVALID_HANDLE_VALUE)
      break;
    if (GetLastError() != ERROR_PIPE_BUSY)
    {
      net->last_errno=CR_NAMEDPIPEOPEN_ERROR;
      sprintf(net->last_error,ER(net->last_errno),host, unix_socket,
	      (ulong) GetLastError());
      return INVALID_HANDLE_VALUE;
    }
    /* wait for for an other instance */
    if (! WaitNamedPipe(szPipeName, connect_timeout*1000) )
    {
      net->last_errno=CR_NAMEDPIPEWAIT_ERROR;
      sprintf(net->last_error,ER(net->last_errno),host, unix_socket,
	      (ulong) GetLastError());
      return INVALID_HANDLE_VALUE;
    }
  }
  if (hPipe == INVALID_HANDLE_VALUE)
  {
    net->last_errno=CR_NAMEDPIPEOPEN_ERROR;
    sprintf(net->last_error,ER(net->last_errno),host, unix_socket,
	    (ulong) GetLastError());
    return INVALID_HANDLE_VALUE;
  }
  dwMode = PIPE_READMODE_BYTE | PIPE_WAIT;
  if ( !SetNamedPipeHandleState(hPipe, &dwMode, NULL, NULL) )
  {
    CloseHandle( hPipe );
    net->last_errno=CR_NAMEDPIPESETSTATE_ERROR;
    sprintf(net->last_error,ER(net->last_errno),host, unix_socket,
	    (ulong) GetLastError());
    return INVALID_HANDLE_VALUE;
  }
  *arg_host=host ; *arg_unix_socket=unix_socket;	/* connect arg */
  return (hPipe);
}
#endif

358

peter@mysql.com's avatar
peter@mysql.com committed
359
/*
360 361 362 363
  Create new shared memory connection, return handler of connection

  SYNOPSIS
    create_shared_memory()
364 365 366
    mysql		Pointer of mysql structure
    net			Pointer of net structure
    connect_timeout	Timeout of connection
367
*/
368

369 370 371 372
#ifdef HAVE_SMEM
HANDLE create_shared_memory(MYSQL *mysql,NET *net, uint connect_timeout)
{
  ulong smem_buffer_length = shared_memory_buffer_length + 4;
peter@mysql.com's avatar
peter@mysql.com committed
373 374
/*
  event_connect_request is event object for start connection actions
375
  event_connect_answer is event object for confirm, that server put data
peter@mysql.com's avatar
peter@mysql.com committed
376
  handle_connect_file_map is file-mapping object, use for create shared memory
377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395
  handle_connect_map is pointer on shared memory
  handle_map is pointer on shared memory for client
  event_server_wrote,
  event_server_read,
  event_client_wrote,
  event_client_read are events for transfer data between server and client
  handle_file_map is file-mapping object, use for create shared memory
*/
  HANDLE event_connect_request = NULL;
  HANDLE event_connect_answer = NULL;
  HANDLE handle_connect_file_map = NULL;
  char *handle_connect_map = NULL;

  char *handle_map = NULL;
  HANDLE event_server_wrote = NULL;
  HANDLE event_server_read = NULL;
  HANDLE event_client_wrote = NULL;
  HANDLE event_client_read = NULL;
  HANDLE handle_file_map = NULL;
peter@mysql.com's avatar
peter@mysql.com committed
396
  ulong connect_number;
397 398
  char connect_number_char[22], *p;
  char tmp[64];
peter@mysql.com's avatar
peter@mysql.com committed
399
  char *suffix_pos;
400 401 402 403 404 405 406 407 408 409 410 411 412
  DWORD error_allow = 0;
  DWORD error_code = 0;
  char *shared_memory_base_name = mysql->options.shared_memory_base_name;

/*
  The name of event and file-mapping events create agree next rule:
            shared_memory_base_name+unique_part
  Where:
    shared_memory_base_name is unique value for each server
    unique_part is uniquel value for each object (events and file-mapping)
*/
  suffix_pos = strxmov(tmp,shared_memory_base_name,"_",NullS);
  strmov(suffix_pos, "CONNECT_REQUEST");
413
  if (!(event_connect_request= OpenEvent(EVENT_ALL_ACCESS,FALSE,tmp)))
414 415 416 417 418
  {
    error_allow = CR_SHARED_MEMORY_CONNECT_REQUEST_ERROR;
    goto err;
  }
  strmov(suffix_pos, "CONNECT_ANSWER");
419
  if (!(event_connect_answer= OpenEvent(EVENT_ALL_ACCESS,FALSE,tmp)))
420 421 422 423 424
  {
    error_allow = CR_SHARED_MEMORY_CONNECT_ANSWER_ERROR;
    goto err;
  }
  strmov(suffix_pos, "CONNECT_DATA");
425
  if (!(handle_connect_file_map= OpenFileMapping(FILE_MAP_WRITE,FALSE,tmp)))
426 427 428 429
  {
    error_allow = CR_SHARED_MEMORY_CONNECT_FILE_MAP_ERROR;
    goto err;
  }
430 431
  if (!(handle_connect_map= MapViewOfFile(handle_connect_file_map,
					  FILE_MAP_WRITE,0,0,sizeof(DWORD))))
432 433 434 435
  {
    error_allow = CR_SHARED_MEMORY_CONNECT_MAP_ERROR;
    goto err;
  }
436 437 438
  /*
    Send to server request of connection
  */
peter@mysql.com's avatar
peter@mysql.com committed
439
  if (!SetEvent(event_connect_request))
440 441 442 443
  {
    error_allow = CR_SHARED_MEMORY_CONNECT_SET_ERROR;
    goto err;
  }
444 445 446 447 448
  /*
    Wait of answer from server
  */
  if (WaitForSingleObject(event_connect_answer,connect_timeout*1000) !=
      WAIT_OBJECT_0)
449 450 451 452
  {
    error_allow = CR_SHARED_MEMORY_CONNECT_ABANDODED_ERROR;
    goto err;
  }
453 454 455
  /*
    Get number of connection
  */
456
  connect_number = uint4korr(handle_connect_map);/*WAX2*/
457
  p= int2str(connect_number, connect_number_char, 10);
458

459 460
  /*
    The name of event and file-mapping events create agree next rule:
461
    shared_memory_base_name+unique_part+number_of_connection
462 463 464 465 466
    Where:
      shared_memory_base_name is uniquel value for each server
      unique_part is uniquel value for each object (events and file-mapping)
      number_of_connection is number of connection between server and client
  */
467 468
  suffix_pos = strxmov(tmp,shared_memory_base_name,"_",connect_number_char,
		       "_",NullS);
469 470 471 472
  strmov(suffix_pos, "DATA");
  if ((handle_file_map = OpenFileMapping(FILE_MAP_WRITE,FALSE,tmp)) == NULL)
  {
    error_allow = CR_SHARED_MEMORY_FILE_MAP_ERROR;
peter@mysql.com's avatar
peter@mysql.com committed
473
    goto err2;
474
  }
475 476
  if ((handle_map = MapViewOfFile(handle_file_map,FILE_MAP_WRITE,0,0,
				  smem_buffer_length)) == NULL)
477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508
  {
    error_allow = CR_SHARED_MEMORY_MAP_ERROR;
    goto err2;
  }

  strmov(suffix_pos, "SERVER_WROTE");
  if ((event_server_wrote = OpenEvent(EVENT_ALL_ACCESS,FALSE,tmp)) == NULL)
  {
    error_allow = CR_SHARED_MEMORY_EVENT_ERROR;
    goto err2;
  }

  strmov(suffix_pos, "SERVER_READ");
  if ((event_server_read = OpenEvent(EVENT_ALL_ACCESS,FALSE,tmp)) == NULL)
  {
    error_allow = CR_SHARED_MEMORY_EVENT_ERROR;
    goto err2;
  }

  strmov(suffix_pos, "CLIENT_WROTE");
  if ((event_client_wrote = OpenEvent(EVENT_ALL_ACCESS,FALSE,tmp)) == NULL)
  {
    error_allow = CR_SHARED_MEMORY_EVENT_ERROR;
    goto err2;
  }

  strmov(suffix_pos, "CLIENT_READ");
  if ((event_client_read = OpenEvent(EVENT_ALL_ACCESS,FALSE,tmp)) == NULL)
  {
    error_allow = CR_SHARED_MEMORY_EVENT_ERROR;
    goto err2;
  }
509 510 511
  /*
    Set event that server should send data
  */
512 513
  SetEvent(event_server_read);

peter@mysql.com's avatar
peter@mysql.com committed
514 515
err2:
  if (error_allow == 0)
516
  {
517 518 519 520
    net->vio= vio_new_win32shared_memory(net,handle_file_map,handle_map,
					 event_server_wrote,
                                         event_server_read,event_client_wrote,
					 event_client_read);
peter@mysql.com's avatar
peter@mysql.com committed
521 522
  }
  else
523 524
  {
    error_code = GetLastError();
525 526 527 528 529 530 531 532 533 534 535 536
    if (event_server_read)
      CloseHandle(event_server_read);
    if (event_server_wrote)
      CloseHandle(event_server_wrote);
    if (event_client_read)
      CloseHandle(event_client_read);
    if (event_client_wrote)
      CloseHandle(event_client_wrote);
    if (handle_map)
      UnmapViewOfFile(handle_map);
    if (handle_file_map)
      CloseHandle(handle_file_map);
537 538
  }
err:
539 540 541 542 543 544 545 546 547 548
  if (error_allow)
    error_code = GetLastError();
  if (event_connect_request)
    CloseHandle(event_connect_request);
  if (event_connect_answer)
    CloseHandle(event_connect_answer);
  if (handle_connect_map)
    UnmapViewOfFile(handle_connect_map);
  if (handle_connect_file_map)
    CloseHandle(handle_connect_file_map);
peter@mysql.com's avatar
peter@mysql.com committed
549
  if (error_allow)
550 551 552 553 554 555 556
  {
    net->last_errno=error_allow;
    if (error_allow == CR_SHARED_MEMORY_EVENT_ERROR)
      sprintf(net->last_error,ER(net->last_errno),suffix_pos,error_code);
    else
      sprintf(net->last_error,ER(net->last_errno),error_code);
    return(INVALID_HANDLE_VALUE);
peter@mysql.com's avatar
peter@mysql.com committed
557
  }
558
  return(handle_map);
559
}
560
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
561

562

bk@work.mysql.com's avatar
bk@work.mysql.com committed
563
/*****************************************************************************
564
  Read a packet from server. Give error message if socket was down
565
  or packet is an error message
bk@work.mysql.com's avatar
bk@work.mysql.com committed
566 567
*****************************************************************************/

568
ulong
bk@work.mysql.com's avatar
bk@work.mysql.com committed
569 570 571
net_safe_read(MYSQL *mysql)
{
  NET *net= &mysql->net;
572
  ulong len=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
573 574 575 576 577 578 579 580 581 582 583 584 585
  init_sigpipe_variables

  /* Don't give sigpipe errors if the client doesn't want them */
  set_sigpipe(mysql);
  if (net->vio != 0)
    len=my_net_read(net);
  reset_sigpipe(mysql);

  if (len == packet_error || len == 0)
  {
    DBUG_PRINT("error",("Wrong connection or packet. fd: %s  len: %d",
			vio_description(net->vio),len));
    end_server(mysql);
peter@mysql.com's avatar
peter@mysql.com committed
586
    net->last_errno=(net->last_errno == ER_NET_PACKET_TOO_LARGE ?
bk@work.mysql.com's avatar
bk@work.mysql.com committed
587 588 589
		     CR_NET_PACKET_TOO_LARGE:
		     CR_SERVER_LOST);
    strmov(net->last_error,ER(net->last_errno));
590
    return (packet_error);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
591 592 593 594 595 596
  }
  if (net->read_pos[0] == 255)
  {
    if (len > 3)
    {
      char *pos=(char*) net->read_pos+1;
597 598 599
      net->last_errno=uint2korr(pos);
      pos+=2;
      len-=2;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
600
      (void) strmake(net->last_error,(char*) pos,
601
		     min((uint) len,(uint) sizeof(net->last_error)-1));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683
    }
    else
    {
      net->last_errno=CR_UNKNOWN_ERROR;
      (void) strmov(net->last_error,ER(net->last_errno));
    }
    DBUG_PRINT("error",("Got error: %d (%s)", net->last_errno,
			net->last_error));
    return(packet_error);
  }
  return len;
}


/* Get the length of next field. Change parameter to point at fieldstart */
static ulong
net_field_length(uchar **packet)
{
  reg1 uchar *pos= *packet;
  if (*pos < 251)
  {
    (*packet)++;
    return (ulong) *pos;
  }
  if (*pos == 251)
  {
    (*packet)++;
    return NULL_LENGTH;
  }
  if (*pos == 252)
  {
    (*packet)+=3;
    return (ulong) uint2korr(pos+1);
  }
  if (*pos == 253)
  {
    (*packet)+=4;
    return (ulong) uint3korr(pos+1);
  }
  (*packet)+=9;					/* Must be 254 when here */
  return (ulong) uint4korr(pos+1);
}

/* Same as above, but returns ulonglong values */

static my_ulonglong
net_field_length_ll(uchar **packet)
{
  reg1 uchar *pos= *packet;
  if (*pos < 251)
  {
    (*packet)++;
    return (my_ulonglong) *pos;
  }
  if (*pos == 251)
  {
    (*packet)++;
    return (my_ulonglong) NULL_LENGTH;
  }
  if (*pos == 252)
  {
    (*packet)+=3;
    return (my_ulonglong) uint2korr(pos+1);
  }
  if (*pos == 253)
  {
    (*packet)+=4;
    return (my_ulonglong) uint3korr(pos+1);
  }
  (*packet)+=9;					/* Must be 254 when here */
#ifdef NO_CLIENT_LONGLONG
  return (my_ulonglong) uint4korr(pos+1);
#else
  return (my_ulonglong) uint8korr(pos+1);
#endif
}


static void free_rows(MYSQL_DATA *cur)
{
  if (cur)
  {
684
    free_root(&cur->alloc,MYF(0));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
685 686 687 688 689
    my_free((gptr) cur,MYF(0));
  }
}


690 691 692 693
static my_bool
advanced_command(MYSQL *mysql, enum enum_server_command command,
		 const char *header, ulong header_length,
		 const char *arg, ulong arg_length, my_bool skip_check)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
694 695
{
  NET *net= &mysql->net;
696
  my_bool result= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
697 698 699 700
  init_sigpipe_variables

  /* Don't give sigpipe errors if the client doesn't want them */
  set_sigpipe(mysql);
701

bk@work.mysql.com's avatar
bk@work.mysql.com committed
702 703 704
  if (mysql->net.vio == 0)
  {						/* Do reconnect if possible */
    if (mysql_reconnect(mysql))
705
      return 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
706 707 708 709
  }
  if (mysql->status != MYSQL_STATUS_READY)
  {
    strmov(net->last_error,ER(mysql->net.last_errno=CR_COMMANDS_OUT_OF_SYNC));
710
    return 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
711 712 713 714 715 716
  }

  mysql->net.last_error[0]=0;
  mysql->net.last_errno=0;
  mysql->info=0;
  mysql->affected_rows= ~(my_ulonglong) 0;
717
  net_clear(&mysql->net);			/* Clear receive buffer */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
718

719 720
  if (net_write_command(net,(uchar) command, header, header_length,
			arg, arg_length))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
721
  {
722 723
    DBUG_PRINT("error",("Can't send command to server. Error: %d",
			socket_errno));
724
    if (net->last_errno == ER_NET_PACKET_TOO_LARGE)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
725
    {
726
      net->last_errno=CR_NET_PACKET_TOO_LARGE;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
727
      strmov(net->last_error,ER(net->last_errno));
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
728
      goto end;
729
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
730
    end_server(mysql);
731 732
    if (mysql_reconnect(mysql))
      goto end;
733 734
    if (net_write_command(net,(uchar) command, header, header_length,
			  arg, arg_length))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
735 736 737 738 739 740 741
    {
      net->last_errno=CR_SERVER_GONE_ERROR;
      strmov(net->last_error,ER(net->last_errno));
      goto end;
    }
  }
  result=0;
742
  if (!skip_check)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
743
    result= ((mysql->packet_length=net_safe_read(mysql)) == packet_error ?
744
	     1 : 0);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
745 746 747 748 749 750
 end:
  reset_sigpipe(mysql);
  return result;
}


751 752 753 754 755 756 757 758
my_bool
simple_command(MYSQL *mysql,enum enum_server_command command, const char *arg,
	       ulong length, my_bool skip_check)
{
  return advanced_command(mysql, command, NullS, 0, arg, length, skip_check);
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
759 760 761 762
static void free_old_query(MYSQL *mysql)
{
  DBUG_ENTER("free_old_query");
  if (mysql->fields)
763 764
    free_root(&mysql->field_alloc,MYF(0));
  init_alloc_root(&mysql->field_alloc,8192,0);	/* Assume rowlength < 8192 */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
765 766 767 768 769
  mysql->fields=0;
  mysql->field_count=0;				/* For API */
  DBUG_VOID_RETURN;
}

770

771
#if defined(HAVE_GETPWUID) && defined(NO_GETPWUID_DECL)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
772 773 774 775
struct passwd *getpwuid(uid_t);
char* getlogin(void);
#endif

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
776 777 778 779 780

#if defined(__NETWARE__)
/* default to "root" on NetWare */
static void read_user_name(char *name)
{
781 782
  char *str=getenv("USER");
  strmake(name, str ? str : "UNKNOWN_USER", USERNAME_LENGTH);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
783 784 785 786
}

#elif !defined(MSDOS) && ! defined(VMS) && !defined(__WIN__) && !defined(OS2)

bk@work.mysql.com's avatar
bk@work.mysql.com committed
787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818
static void read_user_name(char *name)
{
  DBUG_ENTER("read_user_name");
  if (geteuid() == 0)
    (void) strmov(name,"root");		/* allow use of surun */
  else
  {
#ifdef HAVE_GETPWUID
    struct passwd *skr;
    const char *str;
    if ((str=getlogin()) == NULL)
    {
      if ((skr=getpwuid(geteuid())) != NULL)
	str=skr->pw_name;
      else if (!(str=getenv("USER")) && !(str=getenv("LOGNAME")) &&
	       !(str=getenv("LOGIN")))
	str="UNKNOWN_USER";
    }
    (void) strmake(name,str,USERNAME_LENGTH);
#elif HAVE_CUSERID
    (void) cuserid(name);
#else
    strmov(name,"UNKNOWN_USER");
#endif
  }
  DBUG_VOID_RETURN;
}

#else /* If MSDOS || VMS */

static void read_user_name(char *name)
{
819 820
  char *str=getenv("USER");		/* ODBC will send user variable */
  strmake(name,str ? str : "ODBC", USERNAME_LENGTH);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
821 822 823 824 825 826 827 828 829 830 831 832 833
}

#endif

#ifdef __WIN__
static my_bool is_NT(void)
{
  char *os=getenv("OS");
  return (os && !strcmp(os, "Windows_NT")) ? 1 : 0;
}
#endif

/*
834
  Expand wildcard to a sql string
bk@work.mysql.com's avatar
bk@work.mysql.com committed
835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858
*/

static void
append_wild(char *to, char *end, const char *wild)
{
  end-=5;					/* Some extra */
  if (wild && wild[0])
  {
    to=strmov(to," like '");
    while (*wild && to < end)
    {
      if (*wild == '\\' || *wild == '\'')
	*to++='\\';
      *to++= *wild++;
    }
    if (*wild)					/* Too small buffer */
      *to++='%';				/* Nicer this way */
    to[0]='\'';
    to[1]=0;
  }
}


/**************************************************************************
859
  Init debugging if MYSQL_DEBUG environment variable is found
bk@work.mysql.com's avatar
bk@work.mysql.com committed
860 861 862
**************************************************************************/

void STDCALL
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
863
mysql_debug(const char *debug __attribute__((unused)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
864 865 866 867 868 869 870 871 872 873 874 875 876 877 878 879 880 881 882 883 884 885 886 887 888 889 890 891 892 893 894 895
{
#ifndef DBUG_OFF
  char	*env;
  if (_db_on_)
    return;					/* Already using debugging */
  if (debug)
  {
    DEBUGGER_ON;
    DBUG_PUSH(debug);
  }
  else if ((env = getenv("MYSQL_DEBUG")))
  {
    DEBUGGER_ON;
    DBUG_PUSH(env);
#if !defined(_WINVER) && !defined(WINVER)
    puts("\n-------------------------------------------------------");
    puts("MYSQL_DEBUG found. libmysql started with the following:");
    puts(env);
    puts("-------------------------------------------------------\n");
#else
    {
      char buff[80];
      strmov(strmov(buff,"libmysql: "),env);
      MessageBox((HWND) 0,"Debugging variable MYSQL_DEBUG used",buff,MB_OK);
    }
#endif
  }
#endif
}


/**************************************************************************
896
  Close the server connection if we get a SIGPIPE
bk@work.mysql.com's avatar
bk@work.mysql.com committed
897 898 899 900 901 902 903 904 905 906 907 908 909 910
   ARGSUSED
**************************************************************************/

static sig_handler
pipe_sig_handler(int sig __attribute__((unused)))
{
  DBUG_PRINT("info",("Hit by signal %d",sig));
#ifdef DONT_REMEMBER_SIGNAL
  (void) signal(SIGPIPE,pipe_sig_handler);
#endif
}


/**************************************************************************
911
  Shut down connection
bk@work.mysql.com's avatar
bk@work.mysql.com committed
912 913 914 915 916 917 918 919 920 921 922 923 924 925 926 927 928 929 930 931 932 933 934 935 936 937 938 939 940 941
**************************************************************************/

static void
end_server(MYSQL *mysql)
{
  DBUG_ENTER("end_server");
  if (mysql->net.vio != 0)
  {
    init_sigpipe_variables
    DBUG_PRINT("info",("Net: %s", vio_description(mysql->net.vio)));
    set_sigpipe(mysql);
    vio_delete(mysql->net.vio);
    reset_sigpipe(mysql);
    mysql->net.vio= 0;          /* Marker */
  }
  net_end(&mysql->net);
  free_old_query(mysql);
  DBUG_VOID_RETURN;
}


void STDCALL
mysql_free_result(MYSQL_RES *result)
{
  DBUG_ENTER("mysql_free_result");
  DBUG_PRINT("enter",("mysql_res: %lx",result));
  if (result)
  {
    if (result->handle && result->handle->status == MYSQL_STATUS_USE_RESULT)
    {
942
      DBUG_PRINT("warning",("Not all rows in set where read; Ignoring rows"));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
943 944
      for (;;)
      {
945 946
	ulong pkt_len;
	if ((pkt_len=net_safe_read(result->handle)) == packet_error)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
947
	  break;
948
	if (pkt_len <= 8 && result->handle->net.read_pos[0] == 254)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
949 950 951 952 953 954
	  break;				/* End of data */
      }
      result->handle->status=MYSQL_STATUS_READY;
    }
    free_rows(result->data);
    if (result->fields)
955
      free_root(&result->field_alloc,MYF(0));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
956 957 958 959 960 961 962 963 964
    if (result->row)
      my_free((gptr) result->row,MYF(0));
    my_free((gptr) result,MYF(0));
  }
  DBUG_VOID_RETURN;
}


/****************************************************************************
965
  Get options from my.cnf
bk@work.mysql.com's avatar
bk@work.mysql.com committed
966 967 968
****************************************************************************/

static const char *default_options[]=
969 970 971 972
{
  "port","socket","compress","password","pipe", "timeout", "user",
  "init-command", "host", "database", "debug", "return-found-rows",
  "ssl-key" ,"ssl-cert" ,"ssl-ca" ,"ssl-capath",
973
  "character-sets-dir", "default-character-set", "interactive-timeout",
974
  "connect-timeout", "local-infile", "disable-local-infile",
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
975
  "replication-probe", "enable-reads-from-master", "repl-parse-query",
976
  "ssl-cipher", "max-allowed-packet",
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
977
  "protocol", "shared-memory-base-name",
venu@myvenu.com's avatar
venu@myvenu.com committed
978
  NullS
bk@work.mysql.com's avatar
bk@work.mysql.com committed
979 980 981 982 983
};

static TYPELIB option_types={array_elements(default_options)-1,
			     "options",default_options};

984 985
static int add_init_command(struct st_mysql_options *options, const char *cmd)
{
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
986
  char *tmp;
987 988 989 990 991 992 993 994 995

  if (!options->init_commands)
  {
    options->init_commands= (DYNAMIC_ARRAY*)my_malloc(sizeof(DYNAMIC_ARRAY),
						      MYF(MY_WME));
    init_dynamic_array(options->init_commands,sizeof(char*),0,5 CALLER_INFO);
  }

  if (!(tmp= my_strdup(cmd,MYF(MY_WME))) ||
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
996
      insert_dynamic(options->init_commands, (gptr)&tmp))
997 998 999 1000 1001 1002 1003 1004
  {
    my_free(tmp, MYF(MY_ALLOW_ZERO_PTR));
    return 1;
  }

  return 0;
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032
static void mysql_read_default_options(struct st_mysql_options *options,
				       const char *filename,const char *group)
{
  int argc;
  char *argv_buff[1],**argv;
  const char *groups[3];
  DBUG_ENTER("mysql_read_default_options");
  DBUG_PRINT("enter",("file: %s  group: %s",filename,group ? group :"NULL"));

  argc=1; argv=argv_buff; argv_buff[0]= (char*) "client";
  groups[0]= (char*) "client"; groups[1]= (char*) group; groups[2]=0;

  load_defaults(filename, groups, &argc, &argv);
  if (argc != 1)				/* If some default option */
  {
    char **option=argv;
    while (*++option)
    {
      /* DBUG_PRINT("info",("option: %s",option[0])); */
      if (option[0][0] == '-' && option[0][1] == '-')
      {
	char *end=strcend(*option,'=');
	char *opt_arg=0;
	if (*end)
	{
	  opt_arg=end+1;
	  *end=0;				/* Remove '=' */
	}
1033
	/* Change all '_' in variable name to '-' */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1034
	for (end= *option ; *(end= strcend(end,'_')) ; )
1035
	  *end= '-';
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049
	switch (find_type(*option+2,&option_types,2)) {
	case 1:				/* port */
	  if (opt_arg)
	    options->port=atoi(opt_arg);
	  break;
	case 2:				/* socket */
	  if (opt_arg)
	  {
	    my_free(options->unix_socket,MYF(MY_ALLOW_ZERO_PTR));
	    options->unix_socket=my_strdup(opt_arg,MYF(MY_WME));
	  }
	  break;
	case 3:				/* compress */
	  options->compress=1;
1050
	  options->client_flag|= CLIENT_COMPRESS;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1051 1052 1053 1054 1055 1056 1057 1058
	  break;
	case 4:				/* password */
	  if (opt_arg)
	  {
	    my_free(options->password,MYF(MY_ALLOW_ZERO_PTR));
	    options->password=my_strdup(opt_arg,MYF(MY_WME));
	  }
	  break;
1059 1060
        case 5:
          options->protocol = MYSQL_PROTOCOL_PIPE;
1061
	case 20:			/* connect_timeout */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073
	case 6:				/* timeout */
	  if (opt_arg)
	    options->connect_timeout=atoi(opt_arg);
	  break;
	case 7:				/* user */
	  if (opt_arg)
	  {
	    my_free(options->user,MYF(MY_ALLOW_ZERO_PTR));
	    options->user=my_strdup(opt_arg,MYF(MY_WME));
	  }
	  break;
	case 8:				/* init-command */
1074
	  add_init_command(options,opt_arg);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127
	  break;
	case 9:				/* host */
	  if (opt_arg)
	  {
	    my_free(options->host,MYF(MY_ALLOW_ZERO_PTR));
	    options->host=my_strdup(opt_arg,MYF(MY_WME));
	  }
	  break;
	case 10:			/* database */
	  if (opt_arg)
	  {
	    my_free(options->db,MYF(MY_ALLOW_ZERO_PTR));
	    options->db=my_strdup(opt_arg,MYF(MY_WME));
	  }
	  break;
	case 11:			/* debug */
	  mysql_debug(opt_arg ? opt_arg : "d:t:o,/tmp/client.trace");
	  break;
	case 12:			/* return-found-rows */
	  options->client_flag|=CLIENT_FOUND_ROWS;
	  break;
#ifdef HAVE_OPENSSL
	case 13:			/* ssl_key */
	  my_free(options->ssl_key, MYF(MY_ALLOW_ZERO_PTR));
          options->ssl_key = my_strdup(opt_arg, MYF(MY_WME));
          break;
	case 14:			/* ssl_cert */
	  my_free(options->ssl_cert, MYF(MY_ALLOW_ZERO_PTR));
          options->ssl_cert = my_strdup(opt_arg, MYF(MY_WME));
          break;
	case 15:			/* ssl_ca */
	  my_free(options->ssl_ca, MYF(MY_ALLOW_ZERO_PTR));
          options->ssl_ca = my_strdup(opt_arg, MYF(MY_WME));
          break;
	case 16:			/* ssl_capath */
	  my_free(options->ssl_capath, MYF(MY_ALLOW_ZERO_PTR));
          options->ssl_capath = my_strdup(opt_arg, MYF(MY_WME));
          break;
#else
	case 13:				/* Ignore SSL options */
	case 14:
	case 15:
	case 16:
	  break;
#endif /* HAVE_OPENSSL */
	case 17:			/* charset-lib */
	  my_free(options->charset_dir,MYF(MY_ALLOW_ZERO_PTR));
          options->charset_dir = my_strdup(opt_arg, MYF(MY_WME));
	  break;
	case 18:
	  my_free(options->charset_name,MYF(MY_ALLOW_ZERO_PTR));
          options->charset_name = my_strdup(opt_arg, MYF(MY_WME));
	  break;
1128
	case 19:				/* Interactive-timeout */
1129 1130 1131 1132 1133 1134 1135
	  options->client_flag|= CLIENT_INTERACTIVE;
	  break;
	case 21:
	  if (!opt_arg || atoi(opt_arg) != 0)
	    options->client_flag|= CLIENT_LOCAL_FILES;
	  else
	    options->client_flag&= ~CLIENT_LOCAL_FILES;
1136
	  break;
1137 1138
	case 22:
	  options->client_flag&= CLIENT_LOCAL_FILES;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1139 1140
          break;
	case 23:  /* replication probe */
1141
	  options->rpl_probe= 1;
1142
	  break;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1143
	case 24: /* enable-reads-from-master */
1144
	  options->no_master_reads= 0;
1145
	  break;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1146
	case 25: /* repl-parse-query */
1147
	  options->rpl_parse= 1;
1148
	  break;
1149 1150 1151
	case 27:
	  options->max_allowed_packet= atoi(opt_arg);
	  break;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1152
        case 28:		/* protocol */
1153 1154 1155 1156 1157 1158
          if ((options->protocol = find_type(opt_arg, &sql_protocol_typelib,0)) == ~(ulong) 0)
          {
            fprintf(stderr, "Unknown option to protocol: %s\n", opt_arg);
            exit(1);
          }
          break;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1159
        case 29:		/* shared_memory_base_name */
1160 1161 1162 1163 1164
#ifdef HAVE_SMEM
          if (options->shared_memory_base_name != def_shared_memory_base_name)
            my_free(options->shared_memory_base_name,MYF(MY_ALLOW_ZERO_PTR));
          options->shared_memory_base_name=my_strdup(opt_arg,MYF(MY_WME));
#endif
peter@mysql.com's avatar
peter@mysql.com committed
1165
          break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177
	default:
	  DBUG_PRINT("warning",("unknown option: %s",option[0]));
	}
      }
    }
  }
  free_defaults(argv);
  DBUG_VOID_RETURN;
}


/***************************************************************************
1178
  Change field rows to field structs
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1179 1180 1181 1182
***************************************************************************/

static MYSQL_FIELD *
unpack_fields(MYSQL_DATA *data,MEM_ROOT *alloc,uint fields,
1183
	      my_bool default_value, uint server_capabilities)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1184 1185 1186
{
  MYSQL_ROWS	*row;
  MYSQL_FIELD	*field,*result;
1187
  ulong lengths[8];				/* Max of fields */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1188 1189
  DBUG_ENTER("unpack_fields");

1190 1191
  field=result=(MYSQL_FIELD*) alloc_root(alloc,
					 (uint) sizeof(MYSQL_FIELD)*fields);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1192
  if (!result)
1193 1194
  {
    free_rows(data);				/* Free old data */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1195
    DBUG_RETURN(0);
1196
  }
1197
  bzero((char*) field, (uint) sizeof(MYSQL_FIELD)*fields);
1198
  if (server_capabilities & CLIENT_PROTOCOL_41)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1199
  {
1200 1201
    /* server is 4.1, and returns the new field result format */
    for (row=data->data; row ; row = row->next,field++)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1202
    {
1203
      uchar *pos;
1204
      fetch_lengths(&lengths[0], row->data, default_value ? 7 : 6);
1205 1206 1207 1208 1209
      field->db       = strdup_root(alloc,(char*) row->data[0]);
      field->table    = strdup_root(alloc,(char*) row->data[1]);
      field->org_table= strdup_root(alloc,(char*) row->data[2]);
      field->name     = strdup_root(alloc,(char*) row->data[3]);
      field->org_name = strdup_root(alloc,(char*) row->data[4]);
1210 1211 1212 1213 1214 1215 1216

      field->db_length=		lengths[0];
      field->table_length=	lengths[1];
      field->org_table_length=	lengths[2];
      field->name_length=	lengths[3];
      field->org_name_length=	lengths[4];

1217 1218 1219 1220 1221 1222 1223
      /* Unpack fixed length parts */
      pos= (uchar*) row->data[5];
      field->charsetnr= uint2korr(pos);
      field->length=	(uint) uint3korr(pos+2);
      field->type=	(enum enum_field_types) pos[5];
      field->flags=	uint2korr(pos+6);
      field->decimals=  (uint) pos[8];
1224 1225 1226

      if (INTERNAL_NUM_FIELD(field))
        field->flags|= NUM_FLAG;
1227
      if (default_value && row->data[6])
1228
      {
1229
        field->def=strdup_root(alloc,(char*) row->data[6]);
1230 1231
	field->def_length= lengths[6];
      }
1232 1233 1234
      else
        field->def=0;
      field->max_length= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1235
    }
1236
  }
1237 1238
#ifndef DELETE_SUPPORT_OF_4_0_PROTOCOL
  else
1239
  {
1240
    /* old protocol, for backward compatibility */
1241
    for (row=data->data; row ; row = row->next,field++)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1242
    {
1243
      fetch_lengths(&lengths[0], row->data, default_value ? 6 : 5);
1244 1245 1246 1247
      field->org_table= field->table=  strdup_root(alloc,(char*) row->data[0]);
      field->name=   strdup_root(alloc,(char*) row->data[1]);
      field->length= (uint) uint3korr(row->data[2]);
      field->type=   (enum enum_field_types) (uchar) row->data[3][0];
peter@mysql.com's avatar
peter@mysql.com committed
1248

1249 1250 1251
      field->org_table_length=	field->table_length=	lengths[0];
      field->name_length=	lengths[1];

1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264
      if (server_capabilities & CLIENT_LONG_FLAG)
      {
        field->flags=   uint2korr(row->data[4]);
        field->decimals=(uint) (uchar) row->data[4][2];
      }
      else
      {
        field->flags=   (uint) (uchar) row->data[4][0];
        field->decimals=(uint) (uchar) row->data[4][1];
      }
      if (INTERNAL_NUM_FIELD(field))
        field->flags|= NUM_FLAG;
      if (default_value && row->data[5])
1265
      {
1266
        field->def=strdup_root(alloc,(char*) row->data[5]);
1267 1268
	field->def_length= lengths[5];
      }
1269 1270 1271
      else
        field->def=0;
      field->max_length= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1272 1273
    }
  }
1274
#endif /* DELETE_SUPPORT_OF_4_0_PROTOCOL */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1275 1276 1277 1278 1279 1280 1281 1282 1283 1284
  free_rows(data);				/* Free old data */
  DBUG_RETURN(result);
}


/* Read all rows (fields or data) from server */

static MYSQL_DATA *read_rows(MYSQL *mysql,MYSQL_FIELD *mysql_fields,
			     uint fields)
{
1285 1286
  uint	field;
  ulong pkt_len;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1287 1288
  ulong len;
  uchar *cp;
1289
  char	*to, *end_to;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1290 1291 1292 1293 1294
  MYSQL_DATA *result;
  MYSQL_ROWS **prev_ptr,*cur;
  NET *net = &mysql->net;
  DBUG_ENTER("read_rows");

1295
  if ((pkt_len= net_safe_read(mysql)) == packet_error)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1296 1297 1298 1299 1300 1301 1302 1303
    DBUG_RETURN(0);
  if (!(result=(MYSQL_DATA*) my_malloc(sizeof(MYSQL_DATA),
				       MYF(MY_WME | MY_ZEROFILL))))
  {
    net->last_errno=CR_OUT_OF_MEMORY;
    strmov(net->last_error,ER(net->last_errno));
    DBUG_RETURN(0);
  }
1304
  init_alloc_root(&result->alloc,8192,0);	/* Assume rowlength < 8192 */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1305 1306 1307 1308 1309
  result->alloc.min_malloc=sizeof(MYSQL_ROWS);
  prev_ptr= &result->data;
  result->rows=0;
  result->fields=fields;

1310 1311 1312 1313 1314 1315 1316 1317 1318
  /*
    The last EOF packet is either a single 254 character or (in MySQL 4.1)
    254 followed by 1-7 status bytes.

    This doesn't conflict with normal usage of 254 which stands for a
    string where the length of the string is 8 bytes. (see net_field_length())
  */

  while (*(cp=net->read_pos) != 254 || pkt_len >= 8)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1319 1320 1321
  {
    result->rows++;
    if (!(cur= (MYSQL_ROWS*) alloc_root(&result->alloc,
1322
					sizeof(MYSQL_ROWS))) ||
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1323 1324
	!(cur->data= ((MYSQL_ROW)
		      alloc_root(&result->alloc,
1325
				 (fields+1)*sizeof(char *)+pkt_len))))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1326 1327 1328 1329 1330 1331 1332 1333 1334
    {
      free_rows(result);
      net->last_errno=CR_OUT_OF_MEMORY;
      strmov(net->last_error,ER(net->last_errno));
      DBUG_RETURN(0);
    }
    *prev_ptr=cur;
    prev_ptr= &cur->next;
    to= (char*) (cur->data+fields+1);
1335
    end_to=to+pkt_len-1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1336 1337 1338 1339 1340 1341 1342 1343 1344
    for (field=0 ; field < fields ; field++)
    {
      if ((len=(ulong) net_field_length(&cp)) == NULL_LENGTH)
      {						/* null field */
	cur->data[field] = 0;
      }
      else
      {
	cur->data[field] = to;
1345
        if (len > (ulong) (end_to - to))
1346 1347
        {
          free_rows(result);
1348
          net->last_errno=CR_MALFORMED_PACKET;
1349 1350 1351
          strmov(net->last_error,ER(net->last_errno));
          DBUG_RETURN(0);
        }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369
	memcpy(to,(char*) cp,len); to[len]=0;
	to+=len+1;
	cp+=len;
	if (mysql_fields)
	{
	  if (mysql_fields[field].max_length < len)
	    mysql_fields[field].max_length=len;
	}
      }
    }
    cur->data[field]=to;			/* End of last field */
    if ((pkt_len=net_safe_read(mysql)) == packet_error)
    {
      free_rows(result);
      DBUG_RETURN(0);
    }
  }
  *prev_ptr=0;					/* last pointer is null */
1370 1371 1372 1373 1374
  if (pkt_len > 1)				/* MySQL 4.1 protocol */
  {
    mysql->warning_count= uint2korr(cp+1);
    DBUG_PRINT("info",("warning_count:  %ld", mysql->warning_count));
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1375 1376 1377 1378 1379 1380
  DBUG_PRINT("exit",("Got %d rows",result->rows));
  DBUG_RETURN(result);
}


/*
1381 1382
  Read one row. Uses packet buffer as storage for fields.
  When next packet is read, the previous field values are destroyed
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1383 1384 1385 1386 1387 1388 1389 1390
*/


static int
read_one_row(MYSQL *mysql,uint fields,MYSQL_ROW row, ulong *lengths)
{
  uint field;
  ulong pkt_len,len;
1391
  uchar *pos,*prev_pos, *end_pos;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1392

1393
  if ((pkt_len=net_safe_read(mysql)) == packet_error)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1394
    return -1;
1395 1396 1397 1398
  if (pkt_len <= 8 && mysql->net.read_pos[0] == 254)
  {
    if (pkt_len > 1)				/* MySQL 4.1 protocol */
      mysql->warning_count= uint2korr(mysql->net.read_pos+1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1399
    return 1;				/* End of data */
1400
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1401 1402
  prev_pos= 0;				/* allowed to write at packet[-1] */
  pos=mysql->net.read_pos;
1403
  end_pos=pos+pkt_len;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1404 1405 1406 1407 1408 1409 1410 1411 1412
  for (field=0 ; field < fields ; field++)
  {
    if ((len=(ulong) net_field_length(&pos)) == NULL_LENGTH)
    {						/* null field */
      row[field] = 0;
      *lengths++=0;
    }
    else
    {
1413
      if (len > (ulong) (end_pos - pos))
1414 1415 1416 1417 1418
      {
        mysql->net.last_errno=CR_UNKNOWN_ERROR;
        strmov(mysql->net.last_error,ER(mysql->net.last_errno));
        return -1;
      }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431
      row[field] = (char*) pos;
      pos+=len;
      *lengths++=len;
    }
    if (prev_pos)
      *prev_pos=0;				/* Terminate prev field */
    prev_pos=pos;
  }
  row[field]=(char*) prev_pos+1;		/* End of last field */
  *prev_pos=0;					/* Terminate last field */
  return 0;
}

1432
/* perform query on master */
1433
my_bool STDCALL mysql_master_query(MYSQL *mysql, const char *q,
1434
			       unsigned long length)
1435
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1436
  DBUG_ENTER("mysql_master_query");
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1437
  if (mysql_master_send_query(mysql, q, length))
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1438 1439
    DBUG_RETURN(1);
  DBUG_RETURN(mysql_read_query_result(mysql));
1440 1441
}

1442 1443
my_bool STDCALL mysql_master_send_query(MYSQL *mysql, const char *q,
					unsigned long length)
1444
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1445 1446
  MYSQL *master = mysql->master;
  DBUG_ENTER("mysql_master_send_query");
1447
  if (!master->net.vio && !mysql_real_connect(master,0,0,0,0,0,0,0))
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1448
    DBUG_RETURN(1);
1449
  mysql->last_used_con = master;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1450
  DBUG_RETURN(simple_command(master, COM_QUERY, q, length, 1));
1451 1452
}

1453

peter@mysql.com's avatar
peter@mysql.com committed
1454
/* perform query on slave */
1455 1456
my_bool STDCALL mysql_slave_query(MYSQL *mysql, const char *q,
				  unsigned long length)
1457
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1458
  DBUG_ENTER("mysql_slave_query");
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1459
  if (mysql_slave_send_query(mysql, q, length))
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1460 1461
    DBUG_RETURN(1);
  DBUG_RETURN(mysql_read_query_result(mysql));
1462 1463
}

1464 1465

my_bool STDCALL mysql_slave_send_query(MYSQL *mysql, const char *q,
1466
				   unsigned long length)
1467 1468
{
  MYSQL* last_used_slave, *slave_to_use = 0;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1469
  DBUG_ENTER("mysql_slave_send_query");
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1470

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1471
  if ((last_used_slave = mysql->last_used_slave))
1472 1473 1474
    slave_to_use = last_used_slave->next_slave;
  else
    slave_to_use = mysql->next_slave;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1475 1476 1477
  /*
    Next_slave is always safe to use - we have a circular list of slaves
    if there are no slaves, mysql->next_slave == mysql
1478
  */
1479
  mysql->last_used_con = mysql->last_used_slave = slave_to_use;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1480
  if (!slave_to_use->net.vio && !mysql_real_connect(slave_to_use, 0,0,0,
1481
						   0,0,0,0))
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1482 1483
    DBUG_RETURN(1);
  DBUG_RETURN(simple_command(slave_to_use, COM_QUERY, q, length, 1));
1484 1485
}

1486

1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498
/* enable/disable parsing of all queries to decide
   if they go on master or slave */
void STDCALL mysql_enable_rpl_parse(MYSQL* mysql)
{
  mysql->options.rpl_parse = 1;
}

void STDCALL mysql_disable_rpl_parse(MYSQL* mysql)
{
  mysql->options.rpl_parse = 0;
}

peter@mysql.com's avatar
peter@mysql.com committed
1499
/* get the value of the parse flag */
1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515
int STDCALL mysql_rpl_parse_enabled(MYSQL* mysql)
{
  return mysql->options.rpl_parse;
}

/*  enable/disable reads from master */
void STDCALL mysql_enable_reads_from_master(MYSQL* mysql)
{
  mysql->options.no_master_reads = 0;
}

void STDCALL mysql_disable_reads_from_master(MYSQL* mysql)
{
  mysql->options.no_master_reads = 1;
}

peter@mysql.com's avatar
peter@mysql.com committed
1516
/* get the value of the master read flag */
1517
my_bool STDCALL mysql_reads_from_master_enabled(MYSQL* mysql)
1518 1519 1520 1521
{
  return !(mysql->options.no_master_reads);
}

1522 1523 1524 1525 1526

/*
  We may get an error while doing replication internals.
  In this case, we add a special explanation to the original
  error
1527
*/
1528 1529

static void expand_error(MYSQL* mysql, int error)
1530 1531
{
  char tmp[MYSQL_ERRMSG_SIZE];
1532 1533 1534 1535 1536 1537
  char *p;
  uint err_length;
  strmake(tmp, mysql->net.last_error, MYSQL_ERRMSG_SIZE-1);
  p = strmake(mysql->net.last_error, ER(error), MYSQL_ERRMSG_SIZE-1);
  err_length= (uint) (p - mysql->net.last_error);
  strmake(p, tmp, MYSQL_ERRMSG_SIZE-1 - err_length);
1538 1539 1540
  mysql->net.last_errno = error;
}

1541 1542 1543
/*
  This function assumes we have just called SHOW SLAVE STATUS and have
  read the given result and row
1544
*/
1545

1546
static my_bool get_master(MYSQL* mysql, MYSQL_RES* res, MYSQL_ROW row)
1547 1548
{
  MYSQL* master;
1549
  DBUG_ENTER("get_master");
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1550
  if (mysql_num_fields(res) < 3)
1551
    DBUG_RETURN(1); /* safety */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1552

1553
  /* use the same username and password as the original connection */
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1554
  if (!(master = spawn_init(mysql, row[0], atoi(row[2]), 0, 0)))
1555
    DBUG_RETURN(1);
1556
  mysql->master = master;
1557
  DBUG_RETURN(0);
1558 1559
}

1560 1561 1562 1563

/*
  Assuming we already know that mysql points to a master connection,
  retrieve all the slaves
1564
*/
1565

1566
static my_bool get_slaves_from_master(MYSQL* mysql)
1567
{
1568 1569
  MYSQL_RES* res = 0;
  MYSQL_ROW row;
1570
  my_bool error = 1;
1571
  int has_auth_info;
sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
1572
  int port_ind;
1573
  DBUG_ENTER("get_slaves_from_master");
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1574

1575 1576 1577
  if (!mysql->net.vio && !mysql_real_connect(mysql,0,0,0,0,0,0,0))
  {
    expand_error(mysql, CR_PROBE_MASTER_CONNECT);
1578
    DBUG_RETURN(1);
1579 1580 1581
  }

  if (mysql_query(mysql, "SHOW SLAVE HOSTS") ||
1582
      !(res = mysql_store_result(mysql)))
1583 1584
  {
    expand_error(mysql, CR_PROBE_SLAVE_HOSTS);
1585
    DBUG_RETURN(1);
1586 1587
  }

1588
  switch (mysql_num_fields(res)) {
sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
1589 1590 1591 1592 1593 1594 1595 1596
  case 5:
    has_auth_info = 0;
    port_ind=2;
    break;
  case 7:
    has_auth_info = 1;
    port_ind=4;
    break;
1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607
  default:
    goto err;
  }

  while ((row = mysql_fetch_row(res)))
  {
    MYSQL* slave;
    const char* tmp_user, *tmp_pass;

    if (has_auth_info)
    {
sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
1608 1609
      tmp_user = row[2];
      tmp_pass = row[3];
1610 1611 1612 1613 1614 1615 1616
    }
    else
    {
      tmp_user = mysql->user;
      tmp_pass = mysql->passwd;
    }

sasha@mysql.sashanet.com's avatar
sasha@mysql.sashanet.com committed
1617
    if (!(slave = spawn_init(mysql, row[1], atoi(row[port_ind]),
1618 1619
			    tmp_user, tmp_pass)))
      goto err;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1620

1621 1622 1623 1624 1625 1626
    /* Now add slave into the circular linked list */
    slave->next_slave = mysql->next_slave;
    mysql->next_slave = slave;
  }
  error = 0;
err:
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1627
  if (res)
1628
   mysql_free_result(res);
1629
  DBUG_RETURN(error);
1630 1631
}

1632

1633
my_bool STDCALL mysql_rpl_probe(MYSQL* mysql)
1634
{
1635
  MYSQL_RES *res= 0;
1636
  MYSQL_ROW row;
1637
  my_bool error= 1;
1638 1639
  DBUG_ENTER("mysql_rpl_probe");

1640 1641 1642 1643 1644
  /*
    First determine the replication role of the server we connected to
    the most reliable way to do this is to run SHOW SLAVE STATUS and see
    if we have a non-empty master host. This is still not fool-proof -
    it is not a sin to have a master that has a dormant slave thread with
peter@mysql.com's avatar
peter@mysql.com committed
1645
    a non-empty master host. However, it is more reliable to check
1646
    for empty master than whether the slave thread is actually running
1647
  */
1648
  if (mysql_query(mysql, "SHOW SLAVE STATUS") ||
1649
      !(res = mysql_store_result(mysql)))
1650 1651
  {
    expand_error(mysql, CR_PROBE_SLAVE_STATUS);
1652
    DBUG_RETURN(1);
1653
  }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1654

1655 1656 1657 1658 1659 1660
  row= mysql_fetch_row(res);
  /*
    Check master host for emptiness/NULL
    For MySQL 4.0 it's enough to check for row[0]
  */
  if (row && row[0] && *(row[0]))
1661 1662
  {
    /* this is a slave, ask it for the master */
1663
    if (get_master(mysql, res, row) || get_slaves_from_master(mysql))
1664 1665 1666 1667 1668
      goto err;
  }
  else
  {
    mysql->master = mysql;
1669
    if (get_slaves_from_master(mysql))
1670 1671 1672 1673 1674
      goto err;
  }

  error = 0;
err:
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
1675
  if (res)
1676
    mysql_free_result(res);
1677
  DBUG_RETURN(error);
1678 1679 1680
}


1681 1682 1683 1684 1685 1686 1687 1688 1689 1690
/*
  Make a not so fool-proof decision on where the query should go, to
  the master or the slave. Ideally the user should always make this
  decision himself with mysql_master_query() or mysql_slave_query().
  However, to be able to more easily port the old code, we support the
  option of an educated guess - this should work for most applications,
  however, it may make the wrong decision in some particular cases. If
  that happens, the user would have to change the code to call
  mysql_master_query() or mysql_slave_query() explicitly in the place
  where we have made the wrong decision
1691
*/
1692

1693 1694
enum mysql_rpl_type
STDCALL mysql_rpl_query_type(const char* q, int len)
1695
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1696
  const char *q_end= q + len;
1697
  for (; q < q_end; ++q)
1698 1699
  {
    char c;
1700
    if (my_isalpha(&my_charset_latin1, (c= *q)))
1701
    {
1702
      switch (my_tolower(&my_charset_latin1,c)) {
1703 1704 1705 1706 1707 1708 1709
      case 'i':  /* insert */
      case 'u':  /* update or unlock tables */
      case 'l':  /* lock tables or load data infile */
      case 'd':  /* drop or delete */
      case 'a':  /* alter */
	return MYSQL_RPL_MASTER;
      case 'c':  /* create or check */
1710
	return my_tolower(&my_charset_latin1,q[1]) == 'h' ? MYSQL_RPL_ADMIN :
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1711
	  MYSQL_RPL_MASTER;
1712
      case 's': /* select or show */
1713
	return my_tolower(&my_charset_latin1,q[1]) == 'h' ? MYSQL_RPL_ADMIN :
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1714
	  MYSQL_RPL_SLAVE;
1715 1716 1717 1718 1719 1720 1721 1722
      case 'f': /* flush */
      case 'r': /* repair */
      case 'g': /* grant */
	return MYSQL_RPL_ADMIN;
      default:
	return MYSQL_RPL_SLAVE;
      }
    }
1723
  }
1724
  return MYSQL_RPL_MASTER;		/* By default, send to master */
1725 1726 1727
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
1728
/****************************************************************************
1729
  Init MySQL structure or allocate one
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743
****************************************************************************/

MYSQL * STDCALL
mysql_init(MYSQL *mysql)
{
  mysql_once_init();
  if (!mysql)
  {
    if (!(mysql=(MYSQL*) my_malloc(sizeof(*mysql),MYF(MY_WME | MY_ZEROFILL))))
      return 0;
    mysql->free_me=1;
  }
  else
    bzero((char*) (mysql),sizeof(*(mysql)));
1744
  mysql->options.connect_timeout=CONNECT_TIMEOUT;
1745
  mysql->last_used_con = mysql->next_slave = mysql->master = mysql;
1746

1747 1748 1749
  /*
    By default, we are a replication pivot. The caller must reset it
    after we return if this is not the case.
1750
  */
peter@mysql.com's avatar
peter@mysql.com committed
1751
  mysql->rpl_pivot = 1;
1752
#if defined(SIGPIPE) && defined(THREAD) && !defined(__WIN__)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1753 1754 1755
  if (!((mysql)->client_flag & CLIENT_IGNORE_SIGPIPE))
    (void) signal(SIGPIPE,pipe_sig_handler);
#endif
1756 1757 1758

/*
  Only enable LOAD DATA INFILE by default if configured with
1759
  --enable-local-infile
1760 1761 1762 1763
*/
#ifdef ENABLED_LOCAL_INFILE
  mysql->options.client_flag|= CLIENT_LOCAL_FILES;
#endif
1764 1765
#ifdef HAVE_SMEM
  mysql->options.shared_memory_base_name=(char*)def_shared_memory_base_name;
peter@mysql.com's avatar
peter@mysql.com committed
1766
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1767 1768 1769 1770
  return mysql;
}


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1771 1772 1773 1774 1775 1776 1777 1778 1779 1780 1781 1782 1783
/*
  Initialize the MySQL library

  SYNOPSIS
    mysql_once_init()

  NOTES
    Can't be static on NetWare
    This function is called by mysql_init() and indirectly called
    by mysql_query(), so one should never have to call this from an
    outside program.
*/

1784
void mysql_once_init(void)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1785 1786 1787 1788
{
  if (!mysql_client_init)
  {
    mysql_client_init=1;
1789
    org_my_init_done=my_init_done;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817
    my_init();					/* Will init threads */
    init_client_errs();
    if (!mysql_port)
    {
      mysql_port = MYSQL_PORT;
#ifndef MSDOS
      {
	struct servent *serv_ptr;
	char	*env;
	if ((serv_ptr = getservbyname("mysql", "tcp")))
	  mysql_port = (uint) ntohs((ushort) serv_ptr->s_port);
	if ((env = getenv("MYSQL_TCP_PORT")))
	  mysql_port =(uint) atoi(env);
      }
#endif
    }
    if (!mysql_unix_port)
    {
      char *env;
#ifdef __WIN__
      mysql_unix_port = (char*) MYSQL_NAMEDPIPE;
#else
      mysql_unix_port = (char*) MYSQL_UNIX_ADDR;
#endif
      if ((env = getenv("MYSQL_UNIX_PORT")))
	mysql_unix_port = env;
    }
    mysql_debug(NullS);
1818
#if defined(SIGPIPE) && !defined(THREAD) && !defined(__WIN__)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1819 1820 1821 1822 1823 1824 1825 1826 1827
    (void) signal(SIGPIPE,SIG_IGN);
#endif
  }
#ifdef THREAD
  else
    my_thread_init();         /* Init if new thread */
#endif
}

1828 1829

/*
1830 1831
  Fill in SSL part of MYSQL structure and set 'use_ssl' flag.
  NB! Errors are not reported until you do mysql_real_connect.
1832
*/
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1833

1834 1835
#define strdup_if_not_null(A) (A) == 0 ? 0 : my_strdup((A),MYF(MY_WME))

1836
my_bool STDCALL
1837
mysql_ssl_set(MYSQL *mysql __attribute__((unused)) ,
peter@mysql.com's avatar
peter@mysql.com committed
1838
	      const char *key __attribute__((unused)),
1839
	      const char *cert __attribute__((unused)),
peter@mysql.com's avatar
peter@mysql.com committed
1840
	      const char *ca __attribute__((unused)),
1841 1842
	      const char *capath __attribute__((unused)),
	      const char *cipher __attribute__((unused)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1843
{
1844
#ifdef HAVE_OPENSSL
1845 1846 1847 1848 1849
  mysql->options.ssl_key=    strdup_if_not_null(key);
  mysql->options.ssl_cert=   strdup_if_not_null(cert);
  mysql->options.ssl_ca=     strdup_if_not_null(ca);
  mysql->options.ssl_capath= strdup_if_not_null(capath);
  mysql->options.ssl_cipher= strdup_if_not_null(cipher);
1850
#endif /* HAVE_OPENSSL */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1851 1852 1853
  return 0;
}

1854

1855
/*
1856 1857
  Free strings in the SSL structure and clear 'use_ssl' flag.
  NB! Errors are not reported until you do mysql_real_connect.
1858
*/
1859

bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1860
#ifdef HAVE_OPENSSL
1861
static void
1862
mysql_ssl_free(MYSQL *mysql __attribute__((unused)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1863 1864 1865 1866 1867
{
  my_free(mysql->options.ssl_key, MYF(MY_ALLOW_ZERO_PTR));
  my_free(mysql->options.ssl_cert, MYF(MY_ALLOW_ZERO_PTR));
  my_free(mysql->options.ssl_ca, MYF(MY_ALLOW_ZERO_PTR));
  my_free(mysql->options.ssl_capath, MYF(MY_ALLOW_ZERO_PTR));
1868
  my_free(mysql->options.ssl_cipher, MYF(MY_ALLOW_ZERO_PTR));
1869
  my_free(mysql->connector_fd,MYF(MY_ALLOW_ZERO_PTR));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1870 1871 1872 1873
  mysql->options.ssl_key = 0;
  mysql->options.ssl_cert = 0;
  mysql->options.ssl_ca = 0;
  mysql->options.ssl_capath = 0;
1874
  mysql->options.ssl_cipher= 0;
1875
  mysql->options.use_ssl = FALSE;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1876
  mysql->connector_fd = 0;
1877
}
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1878
#endif /* HAVE_OPENSSL */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1879

1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891 1892 1893 1894 1895 1896 1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 1945 1946 1947 1948

/*
  Handle password authentication
*/

static my_bool mysql_autenticate(MYSQL *mysql, const char *passwd)
{
  ulong pkt_length;
  NET *net= &mysql->net;
  char buff[SCRAMBLE41_LENGTH];
  char password_hash[SCRAMBLE41_LENGTH]; /* Used for storage of stage1 hash */

  /* We shall only query server if it expect us to do so */
  if ((pkt_length=net_safe_read(mysql)) == packet_error)
    goto error;

  if (mysql->server_capabilities & CLIENT_SECURE_CONNECTION)
  {
    /*
      This should always happen with new server unless empty password
      OK/Error packets have zero as the first char
    */
    if (pkt_length == 24 && net->read_pos[0])
    {
      /* Old passwords will have '*' at the first byte of hash */
      if (net->read_pos[0] != '*')
      {
        /* Build full password hash as it is required to decode scramble */
        password_hash_stage1(buff, passwd);
        /* Store copy as we'll need it later */
        memcpy(password_hash,buff,SCRAMBLE41_LENGTH);
        /* Finally hash complete password using hash we got from server */
        password_hash_stage2(password_hash,(const char*) net->read_pos);
        /* Decypt and store scramble 4 = hash for stage2 */
        password_crypt((const char*) net->read_pos+4,mysql->scramble_buff,
		       password_hash, SCRAMBLE41_LENGTH);
        mysql->scramble_buff[SCRAMBLE41_LENGTH]=0;
        /* Encode scramble with password. Recycle buffer */
        password_crypt(mysql->scramble_buff,buff,buff,SCRAMBLE41_LENGTH);
      }
      else
      {
	/* Create password to decode scramble */
	create_key_from_old_password(passwd,password_hash);
	/* Decypt and store scramble 4 = hash for stage2 */
	password_crypt((const char*) net->read_pos+4,mysql->scramble_buff,
		       password_hash, SCRAMBLE41_LENGTH);
	mysql->scramble_buff[SCRAMBLE41_LENGTH]=0;
	/* Finally scramble decoded scramble with password */
	scramble(buff, mysql->scramble_buff, passwd,0);
      }
      /* Write second package of authentication */
      if (my_net_write(net,buff,SCRAMBLE41_LENGTH) || net_flush(net))
      {
        net->last_errno= CR_SERVER_LOST;
        strmov(net->last_error,ER(net->last_errno));
        goto error;
      }
      /* Read what server thinks about out new auth message report */
      if (net_safe_read(mysql) == packet_error)
	goto error;
    }
  }
  return 0;

error:
  return 1;
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
1949
/**************************************************************************
1950 1951
  Connect to sql server
  If host == 0 then use localhost
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1952 1953
**************************************************************************/

1954
#ifdef USE_OLD_FUNCTIONS
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970
MYSQL * STDCALL
mysql_connect(MYSQL *mysql,const char *host,
	      const char *user, const char *passwd)
{
  MYSQL *res;
  mysql=mysql_init(mysql);			/* Make it thread safe */
  {
    DBUG_ENTER("mysql_connect");
    if (!(res=mysql_real_connect(mysql,host,user,passwd,NullS,0,NullS,0)))
    {
      if (mysql->free_me)
	my_free((gptr) mysql,MYF(0));
    }
    DBUG_RETURN(res);
  }
}
1971
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1972 1973 1974


/*
1975 1976
  Note that the mysql argument must be initialized with mysql_init()
  before calling mysql_real_connect !
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1977 1978 1979 1980 1981
*/

MYSQL * STDCALL
mysql_real_connect(MYSQL *mysql,const char *host, const char *user,
		   const char *passwd, const char *db,
1982
		   uint port, const char *unix_socket,ulong client_flag)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1983
{
1984 1985
  char		buff[NAME_LEN+USERNAME_LENGTH+100],charset_name_buff[16];
  char		*end,*host_info,*charset_name;
1986
  my_socket	sock;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1987 1988
  uint32	ip_addr;
  struct	sockaddr_in sock_addr;
1989
  ulong		pkt_length;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1990 1991 1992 1993 1994 1995 1996 1997 1998
  NET		*net= &mysql->net;
#ifdef __WIN__
  HANDLE	hPipe=INVALID_HANDLE_VALUE;
#endif
#ifdef HAVE_SYS_UN_H
  struct	sockaddr_un UNIXaddr;
#endif
  init_sigpipe_variables
  DBUG_ENTER("mysql_real_connect");
1999
  LINT_INIT(host_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030

  DBUG_PRINT("enter",("host: %s  db: %s  user: %s",
		      host ? host : "(Null)",
		      db ? db : "(Null)",
		      user ? user : "(Null)"));

  /* Don't give sigpipe errors if the client doesn't want them */
  set_sigpipe(mysql);
  net->vio = 0;				/* If something goes wrong */
  /* use default options */
  if (mysql->options.my_cnf_file || mysql->options.my_cnf_group)
  {
    mysql_read_default_options(&mysql->options,
			       (mysql->options.my_cnf_file ?
				mysql->options.my_cnf_file : "my"),
			       mysql->options.my_cnf_group);
    my_free(mysql->options.my_cnf_file,MYF(MY_ALLOW_ZERO_PTR));
    my_free(mysql->options.my_cnf_group,MYF(MY_ALLOW_ZERO_PTR));
    mysql->options.my_cnf_file=mysql->options.my_cnf_group=0;
  }

  /* Some empty-string-tests are done because of ODBC */
  if (!host || !host[0])
    host=mysql->options.host;
  if (!user || !user[0])
    user=mysql->options.user;
  if (!passwd)
  {
    passwd=mysql->options.password;
#ifndef DONT_USE_MYSQL_PWD
    if (!passwd)
2031
      passwd=getenv("MYSQL_PWD");		/* get it from environment */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2032 2033 2034 2035 2036 2037 2038 2039 2040
#endif
  }
  if (!db || !db[0])
    db=mysql->options.db;
  if (!port)
    port=mysql->options.port;
  if (!unix_socket)
    unix_socket=mysql->options.unix_socket;

2041
  mysql->reconnect=1;				/* Reconnect as default */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2042 2043 2044
  mysql->server_status=SERVER_STATUS_AUTOCOMMIT;

  /*
2045
    Grab a socket and connect it to the server
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2046
  */
2047
#if defined(HAVE_SMEM)
2048 2049
  if ((!mysql->options.protocol ||
       mysql->options.protocol == MYSQL_PROTOCOL_MEMORY) &&
2050 2051
      (!host || !strcmp(host,LOCAL_HOST)))
  {
peter@mysql.com's avatar
peter@mysql.com committed
2052
    if ((create_shared_memory(mysql,net, mysql->options.connect_timeout)) ==
2053
	INVALID_HANDLE_VALUE)
2054 2055
    {
      DBUG_PRINT("error",
2056 2057 2058 2059 2060 2061 2062 2063
		 ("host: '%s'  socket: '%s'  shared memory: %s  have_tcpip: %d",
		  host ? host : "<null>",
		  unix_socket ? unix_socket : "<null>",
		  (int) mysql->options.shared_memory_base_name,
		  (int) have_tcpip));
      if (mysql->options.protocol == MYSQL_PROTOCOL_MEMORY)
	goto error;
      /* Try also with PIPE or TCP/IP */
peter@mysql.com's avatar
peter@mysql.com committed
2064
    }
2065 2066 2067 2068 2069 2070 2071 2072 2073
    else
    {
      mysql->options.protocol=MYSQL_PROTOCOL_MEMORY;
      sock=0;
      unix_socket = 0;
      host=mysql->options.shared_memory_base_name;
      host_info=(char*) ER(CR_SHARED_MEMORY_CONNECTION);
    }
  } else
2074
#endif /* HAVE_SMEM */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2075
#if defined(HAVE_SYS_UN_H)
2076 2077 2078 2079
    if ((!mysql->options.protocol ||
	 mysql->options.protocol == MYSQL_PROTOCOL_SOCKET)&&
	(!host || !strcmp(host,LOCAL_HOST)) &&
	(unix_socket || mysql_unix_port))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2080
    {
2081 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106
      host=LOCAL_HOST;
      if (!unix_socket)
	unix_socket=mysql_unix_port;
      host_info=(char*) ER(CR_LOCALHOST_CONNECTION);
      DBUG_PRINT("info",("Using UNIX sock '%s'",unix_socket));
      if ((sock = socket(AF_UNIX,SOCK_STREAM,0)) == SOCKET_ERROR)
      {
	net->last_errno=CR_SOCKET_CREATE_ERROR;
	sprintf(net->last_error,ER(net->last_errno),socket_errno);
	goto error;
      }
      net->vio = vio_new(sock, VIO_TYPE_SOCKET, TRUE);
      bzero((char*) &UNIXaddr,sizeof(UNIXaddr));
      UNIXaddr.sun_family = AF_UNIX;
      strmov(UNIXaddr.sun_path, unix_socket);
      if (my_connect(sock,(struct sockaddr *) &UNIXaddr, sizeof(UNIXaddr),
		     mysql->options.connect_timeout))
      {
	DBUG_PRINT("error",("Got error %d on connect to local server",
			    socket_errno));
	net->last_errno=CR_CONNECTION_ERROR;
	sprintf(net->last_error,ER(net->last_errno),unix_socket,socket_errno);
	goto error;
      }
      else
	mysql->options.protocol=MYSQL_PROTOCOL_SOCKET;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2107
    }
2108
    else
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2109 2110
#elif defined(__WIN__)
    {
2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127 2128 2129 2130 2131 2132 2133 2134 2135 2136 2137 2138 2139
      if ((!mysql->options.protocol ||
	   mysql->options.protocol == MYSQL_PROTOCOL_PIPE)&&
	  ((unix_socket || !host && is_NT() ||
	    host && !strcmp(host,LOCAL_HOST_NAMEDPIPE) ||! have_tcpip))&&
	  (!net->vio))
      {
	sock=0;
	if ((hPipe=create_named_pipe(net, mysql->options.connect_timeout,
				     (char**) &host, (char**) &unix_socket)) ==
	    INVALID_HANDLE_VALUE)
	{
	  DBUG_PRINT("error",
		     ("host: '%s'  socket: '%s'  have_tcpip: %d",
		      host ? host : "<null>",
		      unix_socket ? unix_socket : "<null>",
		      (int) have_tcpip));
	  if (mysql->options.protocol == MYSQL_PROTOCOL_PIPE ||
	      (host && !strcmp(host,LOCAL_HOST_NAMEDPIPE)) ||
	      (unix_socket && !strcmp(unix_socket,MYSQL_NAMEDPIPE)))
	    goto error;
	  /* Try also with TCP/IP */
	}
	else
	{
	  net->vio=vio_new_win32pipe(hPipe);
	  sprintf(host_info=buff, ER(CR_NAMEDPIPE_CONNECTION), host,
		  unix_socket);
	}
      }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2140 2141
    }
#endif
2142 2143
  if ((!mysql->options.protocol ||
       mysql->options.protocol == MYSQL_PROTOCOL_TCP)&&(!net->vio))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2144 2145 2146 2147 2148 2149 2150 2151
  {
    unix_socket=0;				/* This is not used */
    if (!port)
      port=mysql_port;
    if (!host)
      host=LOCAL_HOST;
    sprintf(host_info=buff,ER(CR_TCP_CONNECTION),host);
    DBUG_PRINT("info",("Server name: '%s'.  TCP sock: %d", host,port));
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
2152
    /* _WIN64 ;  Assume that the (int) range is enough for socket() */
2153
    if ((sock = (my_socket) socket(AF_INET,SOCK_STREAM,0)) == SOCKET_ERROR)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2154 2155
    {
      net->last_errno=CR_IPSOCK_ERROR;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2156
      sprintf(net->last_error,ER(net->last_errno),socket_errno);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2157 2158 2159 2160 2161 2162 2163
      goto error;
    }
    net->vio = vio_new(sock,VIO_TYPE_TCPIP,FALSE);
    bzero((char*) &sock_addr,sizeof(sock_addr));
    sock_addr.sin_family = AF_INET;

    /*
2164
      The server name may be a host name or IP address
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2165 2166 2167 2168 2169 2170 2171 2172 2173 2174 2175 2176 2177 2178 2179
    */

    if ((int) (ip_addr = inet_addr(host)) != (int) INADDR_NONE)
    {
      memcpy_fixed(&sock_addr.sin_addr,&ip_addr,sizeof(ip_addr));
    }
    else
    {
      int tmp_errno;
      struct hostent tmp_hostent,*hp;
      char buff2[GETHOSTBYNAME_BUFF_SIZE];
      hp = my_gethostbyname_r(host,&tmp_hostent,buff2,sizeof(buff2),
			      &tmp_errno);
      if (!hp)
      {
2180
	my_gethostbyname_r_free();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2181 2182 2183 2184 2185
	net->last_errno=CR_UNKNOWN_HOST;
	sprintf(net->last_error, ER(CR_UNKNOWN_HOST), host, tmp_errno);
	goto error;
      }
      memcpy(&sock_addr.sin_addr,hp->h_addr, (size_t) hp->h_length);
2186
      my_gethostbyname_r_free();
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2187 2188
    }
    sock_addr.sin_port = (ushort) htons((ushort) port);
2189
    if (my_connect(sock,(struct sockaddr *) &sock_addr, sizeof(sock_addr),
2190
		   mysql->options.connect_timeout))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2191
    {
2192 2193
      DBUG_PRINT("error",("Got error %d on connect to '%s'",socket_errno,
			  host));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2194
      net->last_errno= CR_CONN_HOST_ERROR;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2195
      sprintf(net->last_error ,ER(CR_CONN_HOST_ERROR), host, socket_errno);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2196 2197 2198
      goto error;
    }
  }
2199 2200 2201 2202 2203 2204 2205
  else if (!net->vio)
  {
    DBUG_PRINT("error",("Unknow protocol %d ",mysql->options.protocol));
    net->last_errno= CR_CONN_UNKNOW_PROTOCOL;
    sprintf(net->last_error ,ER(CR_CONN_UNKNOW_PROTOCOL));
    goto error;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2206 2207 2208 2209

  if (!net->vio || my_net_init(net, net->vio))
  {
    vio_delete(net->vio);
2210
    net->vio = 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2211 2212 2213 2214 2215 2216 2217 2218
    net->last_errno=CR_OUT_OF_MEMORY;
    strmov(net->last_error,ER(net->last_errno));
    goto error;
  }
  vio_keepalive(net->vio,TRUE);

  /* Get version info */
  mysql->protocol_version= PROTOCOL_VERSION;	/* Assume this */
2219 2220 2221 2222
  if (mysql->options.connect_timeout &&
      vio_poll_read(net->vio, mysql->options.connect_timeout))
  {
    net->last_errno= CR_SERVER_LOST;
peter@mysql.com's avatar
peter@mysql.com committed
2223
    strmov(net->last_error,ER(net->last_errno));
2224 2225
    goto error;
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2226 2227 2228
  if ((pkt_length=net_safe_read(mysql)) == packet_error)
    goto error;

2229
  /* Check if version of protocol matches current one */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2230 2231 2232 2233 2234

  mysql->protocol_version= net->read_pos[0];
  DBUG_DUMP("packet",(char*) net->read_pos,10);
  DBUG_PRINT("info",("mysql protocol version %d, server=%d",
		     PROTOCOL_VERSION, mysql->protocol_version));
2235
  if (mysql->protocol_version != PROTOCOL_VERSION)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2236 2237 2238 2239 2240 2241 2242 2243 2244 2245 2246 2247 2248 2249 2250 2251 2252 2253 2254 2255 2256 2257 2258 2259 2260 2261 2262 2263 2264 2265 2266 2267 2268 2269
  {
    net->last_errno= CR_VERSION_ERROR;
    sprintf(net->last_error, ER(CR_VERSION_ERROR), mysql->protocol_version,
	    PROTOCOL_VERSION);
    goto error;
  }
  end=strend((char*) net->read_pos+1);
  mysql->thread_id=uint4korr(end+1);
  end+=5;
  strmake(mysql->scramble_buff,end,8);
  end+=9;
  if (pkt_length >= (uint) (end+1 - (char*) net->read_pos))
    mysql->server_capabilities=uint2korr(end);
  if (pkt_length >= (uint) (end+18 - (char*) net->read_pos))
  {
    /* New protocol with 16 bytes to describe server characteristics */
    mysql->server_language=end[2];
    mysql->server_status=uint2korr(end+3);
  }

  /* Set character set */
  if ((charset_name=mysql->options.charset_name))
  {
    const char *save=charsets_dir;
    if (mysql->options.charset_dir)
      charsets_dir=mysql->options.charset_dir;
    mysql->charset=get_charset_by_name(mysql->options.charset_name,
                                       MYF(MY_WME));
    charsets_dir=save;
  }
  else if (mysql->server_language)
  {
    charset_name=charset_name_buff;
    sprintf(charset_name,"%d",mysql->server_language);	/* In case of errors */
2270
    if (!(mysql->charset =
2271
	  get_charset((uint8) mysql->server_language, MYF(0))))
2272
      mysql->charset = default_charset_info; /* shouldn't be fatal */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2273 2274 2275 2276 2277 2278 2279
  }
  else
    mysql->charset=default_charset_info;

  if (!mysql->charset)
  {
    net->last_errno=CR_CANT_READ_CHARSET;
2280 2281 2282 2283 2284 2285 2286 2287 2288 2289 2290 2291
    if (mysql->options.charset_dir)
      sprintf(net->last_error,ER(net->last_errno),
              charset_name ? charset_name : "unknown",
              mysql->options.charset_dir);
    else
    {
      char cs_dir_name[FN_REFLEN];
      get_charsets_dir(cs_dir_name);
      sprintf(net->last_error,ER(net->last_errno),
              charset_name ? charset_name : "unknown",
              cs_dir_name);
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2292 2293
    goto error;
  }
peter@mysql.com's avatar
peter@mysql.com committed
2294

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2295 2296 2297 2298 2299 2300 2301 2302 2303 2304 2305 2306 2307 2308 2309 2310 2311 2312 2313 2314 2315 2316 2317 2318 2319
  /* Save connection information */
  if (!user) user="";
  if (!passwd) passwd="";
  if (!my_multi_malloc(MYF(0),
		       &mysql->host_info, (uint) strlen(host_info)+1,
		       &mysql->host,      (uint) strlen(host)+1,
		       &mysql->unix_socket,unix_socket ?
		       (uint) strlen(unix_socket)+1 : (uint) 1,
		       &mysql->server_version,
		       (uint) (end - (char*) net->read_pos),
		       NullS) ||
      !(mysql->user=my_strdup(user,MYF(0))) ||
      !(mysql->passwd=my_strdup(passwd,MYF(0))))
  {
    strmov(net->last_error, ER(net->last_errno=CR_OUT_OF_MEMORY));
    goto error;
  }
  strmov(mysql->host_info,host_info);
  strmov(mysql->host,host);
  if (unix_socket)
    strmov(mysql->unix_socket,unix_socket);
  else
    mysql->unix_socket=0;
  strmov(mysql->server_version,(char*) net->read_pos+1);
  mysql->port=port;
2320
  client_flag|=mysql->options.client_flag;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2321 2322 2323 2324 2325

  /* Send client information for access check */
  client_flag|=CLIENT_CAPABILITIES;

#ifdef HAVE_OPENSSL
2326 2327 2328 2329
  if (mysql->options.ssl_key || mysql->options.ssl_cert ||
      mysql->options.ssl_ca || mysql->options.ssl_capath ||
      mysql->options.ssl_cipher)
    mysql->options.use_ssl= 1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2330 2331 2332 2333 2334
  if (mysql->options.use_ssl)
    client_flag|=CLIENT_SSL;
#endif /* HAVE_OPENSSL */
  if (db)
    client_flag|=CLIENT_CONNECT_WITH_DB;
2335 2336
  /* Remove options that server doesn't support */
  client_flag= ((client_flag &
2337
		 ~(CLIENT_COMPRESS | CLIENT_SSL | CLIENT_PROTOCOL_41)) |
2338 2339 2340 2341
		(client_flag & mysql->server_capabilities));

#ifndef HAVE_COMPRESS
  client_flag&= ~CLIENT_COMPRESS;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2342 2343
#endif

2344
  if (client_flag & CLIENT_PROTOCOL_41)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2345
  {
2346 2347 2348 2349
    /* 4.1 server and 4.1 client has a 4 byte option flag */
    int4store(buff,client_flag);
    int4store(buff+4,max_allowed_packet);
    end= buff+8;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2350 2351 2352
  }
  else
  {
2353 2354 2355
    int2store(buff,client_flag);
    int3store(buff+2,max_allowed_packet);
    end= buff+5;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2356 2357 2358 2359
  }
  mysql->client_flag=client_flag;

#ifdef HAVE_OPENSSL
2360 2361 2362 2363
  /*
    Oops.. are we careful enough to not send ANY information without
    encryption?
  */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2364 2365
  if (client_flag & CLIENT_SSL)
  {
2366
    struct st_mysql_options *options= &mysql->options;
2367
    if (my_net_write(net,buff,(uint) (end-buff)) || net_flush(net))
2368 2369
    {
      net->last_errno= CR_SERVER_LOST;
peter@mysql.com's avatar
peter@mysql.com committed
2370
      strmov(net->last_error,ER(net->last_errno));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2371
      goto error;
2372
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2373
    /* Do the SSL layering. */
2374 2375 2376 2377 2378 2379 2380
    if (!(mysql->connector_fd=
	  (gptr) new_VioSSLConnectorFd(options->ssl_key,
				       options->ssl_cert,
				       options->ssl_ca,
				       options->ssl_capath,
				       options->ssl_cipher)))
    {
2381
      net->last_errno= CR_SSL_CONNECTION_ERROR;
peter@mysql.com's avatar
peter@mysql.com committed
2382
      strmov(net->last_error,ER(net->last_errno));
2383 2384
      goto error;
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2385
    DBUG_PRINT("info", ("IO layer change in progress..."));
2386 2387
    if (sslconnect((struct st_VioSSLConnectorFd*)(mysql->connector_fd),
		   mysql->net.vio, (long) (mysql->options.connect_timeout)))
2388 2389 2390
    {
      net->last_errno= CR_SSL_CONNECTION_ERROR;
      strmov(net->last_error,ER(net->last_errno));
peter@mysql.com's avatar
peter@mysql.com committed
2391
      goto error;
2392
    }
2393
    DBUG_PRINT("info", ("IO layer change done!"));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2394 2395 2396
  }
#endif /* HAVE_OPENSSL */

2397
  DBUG_PRINT("info",("Server version = '%s'  capabilites: %lu  status: %u  client_flag: %lu",
2398 2399
		     mysql->server_version,mysql->server_capabilities,
		     mysql->server_status, client_flag));
2400
  /* This needs to be changed as it's not useful with big packets */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2401
  if (user && user[0])
2402
    strmake(end,user,32);			/* Max user name */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2403
  else
2404
    read_user_name((char*) end);
peter@mysql.com's avatar
peter@mysql.com committed
2405
  /* We have to handle different version of handshake here */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2406 2407 2408
#ifdef _CUSTOMCONFIG_
#include "_cust_libmysql.h";
#endif
2409
  DBUG_PRINT("info",("user: %s",end));
peter@mysql.com's avatar
peter@mysql.com committed
2410
  /*
2411 2412
    We always start with old type handshake the only difference is message sent
    If server handles secure connection type we'll not send the real scramble
2413
  */
2414 2415 2416 2417
  if (mysql->server_capabilities & CLIENT_SECURE_CONNECTION)
  {
    if (passwd[0])
    {
2418
      /* Prepare false scramble  */
2419
      end=strend(end)+1;
2420 2421 2422
      bfill(end, SCRAMBLE_LENGTH, 'x');
      end+=SCRAMBLE_LENGTH;
      *end=0;
peter@mysql.com's avatar
peter@mysql.com committed
2423
    }
2424
    else				/* For empty password*/
2425
    {
2426
      end=strend(end)+1;
2427
      *end=0;				/* Store zero length scramble */
2428 2429 2430
    }
  }
  else
2431
  {
2432
    /*
2433 2434
      Real scramble is only sent to old servers. This can be blocked 
      by calling mysql_options(MYSQL *, MYSQL_SECURE_CONNECT, (char*) &1);
2435
    */
2436
    end=scramble(strend(end)+1, mysql->scramble_buff, passwd,
2437
                 (my_bool) (mysql->protocol_version == 9));
2438
  }
peter@mysql.com's avatar
peter@mysql.com committed
2439
  /* Add database if needed */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2440 2441
  if (db && (mysql->server_capabilities & CLIENT_CONNECT_WITH_DB))
  {
peter@mysql.com's avatar
peter@mysql.com committed
2442
    end=strmake(end+1,db,NAME_LEN);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2443 2444 2445
    mysql->db=my_strdup(db,MYF(MY_WME));
    db=0;
  }
peter@mysql.com's avatar
peter@mysql.com committed
2446
  /* Write authentication package */
2447 2448
  if (my_net_write(net,buff,(ulong) (end-buff)) || net_flush(net))
  {
peter@mysql.com's avatar
peter@mysql.com committed
2449 2450
    net->last_errno= CR_SERVER_LOST;
    strmov(net->last_error,ER(net->last_errno));
2451 2452
    goto error;
  }
peter@mysql.com's avatar
peter@mysql.com committed
2453

2454
  if (mysql_autenticate(mysql, passwd))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2455
    goto error;
2456

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2457 2458
  if (client_flag & CLIENT_COMPRESS)		/* We will use compression */
    net->compress=1;
2459 2460
  if (mysql->options.max_allowed_packet)
    net->max_packet_size= mysql->options.max_allowed_packet;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2461 2462
  if (db && mysql_select_db(mysql,db))
    goto error;
2463 2464

  if (mysql->options.init_commands)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2465
  {
2466 2467 2468 2469
    DYNAMIC_ARRAY *init_commands= mysql->options.init_commands;
    char **ptr= (char**)init_commands->buffer;
    char **end= ptr + init_commands->elements;

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2470 2471
    my_bool reconnect=mysql->reconnect;
    mysql->reconnect=0;
2472 2473 2474 2475 2476 2477 2478 2479 2480 2481 2482 2483 2484 2485

    for (; ptr<end; ptr++)
    {
      MYSQL_RES *res;
      if (mysql_query(mysql,*ptr))
	goto error;
      if (mysql->fields)
      {
	if (!(res= mysql_use_result(mysql)))
	  goto error;
	mysql_free_result(res);
      }
    }

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2486 2487 2488
    mysql->reconnect=reconnect;
  }

2489 2490
  if (mysql->options.rpl_probe && mysql_rpl_probe(mysql))
    goto error;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2491

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2492 2493 2494 2495 2496 2497 2498 2499 2500 2501 2502 2503 2504 2505 2506 2507 2508 2509
  DBUG_PRINT("exit",("Mysql handler: %lx",mysql));
  reset_sigpipe(mysql);
  DBUG_RETURN(mysql);

error:
  reset_sigpipe(mysql);
  DBUG_PRINT("error",("message: %u (%s)",net->last_errno,net->last_error));
  {
    /* Free alloced memory */
    my_bool free_me=mysql->free_me;
    end_server(mysql);
    mysql->free_me=0;
    mysql_close(mysql);
    mysql->free_me=free_me;
  }
  DBUG_RETURN(0);
}

2510

2511
/* needed when we move MYSQL structure to a different address */
2512

2513 2514 2515 2516 2517 2518 2519 2520 2521 2522 2523 2524 2525 2526 2527 2528
static void mysql_fix_pointers(MYSQL* mysql, MYSQL* old_mysql)
{
  MYSQL *tmp, *tmp_prev;
  if (mysql->master == old_mysql)
    mysql->master = mysql;
  if (mysql->last_used_con == old_mysql)
    mysql->last_used_con = mysql;
  if (mysql->last_used_slave == old_mysql)
    mysql->last_used_slave = mysql;
  for (tmp_prev = mysql, tmp = mysql->next_slave;
       tmp != old_mysql;tmp = tmp->next_slave)
  {
    tmp_prev = tmp;
  }
  tmp_prev->next_slave = mysql;
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2529

2530

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2531 2532 2533 2534 2535 2536 2537 2538
static my_bool mysql_reconnect(MYSQL *mysql)
{
  MYSQL tmp_mysql;
  DBUG_ENTER("mysql_reconnect");

  if (!mysql->reconnect ||
      (mysql->server_status & SERVER_STATUS_IN_TRANS) || !mysql->host_info)
  {
2539
   /* Allow reconnect next time */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2540
    mysql->server_status&= ~SERVER_STATUS_IN_TRANS;
2541 2542
    mysql->net.last_errno=CR_SERVER_GONE_ERROR;
    strmov(mysql->net.last_error,ER(mysql->net.last_errno));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2543 2544 2545 2546
    DBUG_RETURN(1);
  }
  mysql_init(&tmp_mysql);
  tmp_mysql.options=mysql->options;
2547
  bzero((char*) &mysql->options,sizeof(mysql->options));
2548
  tmp_mysql.rpl_pivot = mysql->rpl_pivot;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2549 2550 2551
  if (!mysql_real_connect(&tmp_mysql,mysql->host,mysql->user,mysql->passwd,
			  mysql->db, mysql->port, mysql->unix_socket,
			  mysql->client_flag))
2552 2553 2554
  {
    mysql->net.last_errno= tmp_mysql.net.last_errno;
    strmov(mysql->net.last_error, tmp_mysql.net.last_error);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2555
    DBUG_RETURN(1);
2556
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2557 2558 2559 2560
  tmp_mysql.free_me=mysql->free_me;
  mysql->free_me=0;
  mysql_close(mysql);
  *mysql=tmp_mysql;
peter@mysql.com's avatar
peter@mysql.com committed
2561
  mysql_fix_pointers(mysql, &tmp_mysql); /* adjust connection pointers */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2562 2563 2564 2565 2566 2567 2568
  net_clear(&mysql->net);
  mysql->affected_rows= ~(my_ulonglong) 0;
  DBUG_RETURN(0);
}


/**************************************************************************
peter@mysql.com's avatar
peter@mysql.com committed
2569
  Change user and database
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2570 2571
**************************************************************************/

peter@mysql.com's avatar
peter@mysql.com committed
2572
my_bool	STDCALL mysql_change_user(MYSQL *mysql, const char *user,
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2573 2574
				  const char *passwd, const char *db)
{
peter@mysql.com's avatar
peter@mysql.com committed
2575
  char buff[512],*end=buff;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2576 2577 2578 2579 2580 2581
  DBUG_ENTER("mysql_change_user");

  if (!user)
    user="";
  if (!passwd)
    passwd="";
peter@mysql.com's avatar
peter@mysql.com committed
2582

peter@mysql.com's avatar
peter@mysql.com committed
2583 2584
   /* Store user into the buffer */
  end=strmov(end,user)+1;
peter@mysql.com's avatar
peter@mysql.com committed
2585 2586

  /*
peter@mysql.com's avatar
peter@mysql.com committed
2587 2588 2589 2590 2591 2592 2593
    We always start with old type handshake the only difference is message sent
    If server handles secure connection type we'll not send the real scramble
  */
  if (mysql->server_capabilities & CLIENT_SECURE_CONNECTION)
  {
    if (passwd[0])
    {
2594 2595 2596 2597 2598
      /* Prepare false scramble  */
      bfill(end, SCRAMBLE_LENGTH, 'x');
      end+=SCRAMBLE_LENGTH;
      *end=0;

peter@mysql.com's avatar
peter@mysql.com committed
2599 2600
    }
    else  /* For empty password*/
peter@mysql.com's avatar
peter@mysql.com committed
2601 2602 2603
      *end=0; /* Store zero length scramble */
  }
  else
2604
  {
2605
   /*
2606 2607
     Real scramble is only sent to old servers. This can be blocked 
     by calling mysql_options(MYSQL *, MYSQL_SECURE_CONNECT, (char*) &1);
2608
   */
peter@mysql.com's avatar
peter@mysql.com committed
2609 2610
    end=scramble(end, mysql->scramble_buff, passwd,
                 (my_bool) (mysql->protocol_version == 9));
2611
  }
peter@mysql.com's avatar
peter@mysql.com committed
2612
  /* Add database if needed */
peter@mysql.com's avatar
peter@mysql.com committed
2613
  end=strmov(end+1,db ? db : "");
peter@mysql.com's avatar
peter@mysql.com committed
2614 2615

  /* Write authentication package */
peter@mysql.com's avatar
peter@mysql.com committed
2616
  simple_command(mysql,COM_CHANGE_USER, buff,(ulong) (end-buff),1);
peter@mysql.com's avatar
peter@mysql.com committed
2617

2618
  if (mysql_autenticate(mysql, passwd))
peter@mysql.com's avatar
peter@mysql.com committed
2619
    goto error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2620

2621
  /* Free old connect information */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2622 2623 2624 2625
  my_free(mysql->user,MYF(MY_ALLOW_ZERO_PTR));
  my_free(mysql->passwd,MYF(MY_ALLOW_ZERO_PTR));
  my_free(mysql->db,MYF(MY_ALLOW_ZERO_PTR));

2626
  /* alloc new connect information */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2627 2628 2629 2630
  mysql->user=  my_strdup(user,MYF(MY_WME));
  mysql->passwd=my_strdup(passwd,MYF(MY_WME));
  mysql->db=    db ? my_strdup(db,MYF(MY_WME)) : 0;
  DBUG_RETURN(0);
peter@mysql.com's avatar
peter@mysql.com committed
2631

2632
error:
peter@mysql.com's avatar
peter@mysql.com committed
2633
  DBUG_RETURN(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2634 2635 2636 2637
}


/**************************************************************************
2638
  Set current database
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2639 2640 2641 2642 2643 2644 2645 2646 2647
**************************************************************************/

int STDCALL
mysql_select_db(MYSQL *mysql, const char *db)
{
  int error;
  DBUG_ENTER("mysql_select_db");
  DBUG_PRINT("enter",("db: '%s'",db));

2648
  if ((error=simple_command(mysql,COM_INIT_DB,db,(ulong) strlen(db),0)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2649 2650 2651 2652 2653 2654 2655 2656
    DBUG_RETURN(error);
  my_free(mysql->db,MYF(MY_ALLOW_ZERO_PTR));
  mysql->db=my_strdup(db,MYF(MY_WME));
  DBUG_RETURN(0);
}


/*************************************************************************
2657 2658
  Send a QUIT to the server and close the connection
  If handle is alloced by mysql connect free it.
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2659 2660 2661 2662 2663 2664 2665 2666 2667 2668 2669 2670
*************************************************************************/

void STDCALL
mysql_close(MYSQL *mysql)
{
  DBUG_ENTER("mysql_close");
  if (mysql)					/* Some simple safety */
  {
    if (mysql->net.vio != 0)
    {
      free_old_query(mysql);
      mysql->status=MYSQL_STATUS_READY; /* Force command */
2671
      mysql->reconnect=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2672
      simple_command(mysql,COM_QUIT,NullS,0,1);
2673
      end_server(mysql);			/* Sets mysql->net.vio= 0 */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2674 2675 2676 2677 2678 2679 2680 2681 2682 2683 2684 2685 2686 2687
    }
    my_free((gptr) mysql->host_info,MYF(MY_ALLOW_ZERO_PTR));
    my_free(mysql->user,MYF(MY_ALLOW_ZERO_PTR));
    my_free(mysql->passwd,MYF(MY_ALLOW_ZERO_PTR));
    my_free(mysql->db,MYF(MY_ALLOW_ZERO_PTR));
    my_free(mysql->options.user,MYF(MY_ALLOW_ZERO_PTR));
    my_free(mysql->options.host,MYF(MY_ALLOW_ZERO_PTR));
    my_free(mysql->options.password,MYF(MY_ALLOW_ZERO_PTR));
    my_free(mysql->options.unix_socket,MYF(MY_ALLOW_ZERO_PTR));
    my_free(mysql->options.db,MYF(MY_ALLOW_ZERO_PTR));
    my_free(mysql->options.my_cnf_file,MYF(MY_ALLOW_ZERO_PTR));
    my_free(mysql->options.my_cnf_group,MYF(MY_ALLOW_ZERO_PTR));
    my_free(mysql->options.charset_dir,MYF(MY_ALLOW_ZERO_PTR));
    my_free(mysql->options.charset_name,MYF(MY_ALLOW_ZERO_PTR));
2688 2689
    if (mysql->options.init_commands)
    {
vva@eagle.mysql.r18.ru's avatar
vva@eagle.mysql.r18.ru committed
2690 2691 2692 2693 2694 2695 2696
      DYNAMIC_ARRAY *init_commands= mysql->options.init_commands;
      char **ptr= (char**)init_commands->buffer;
      char **end= ptr + init_commands->elements;
      for (; ptr<end; ptr++)
	my_free(*ptr,MYF(MY_WME));
      delete_dynamic(init_commands);
      my_free((char*)init_commands,MYF(MY_WME));
2697
    }
2698
#ifdef HAVE_OPENSSL
2699
    mysql_ssl_free(mysql);
2700
#endif /* HAVE_OPENSSL */
2701 2702 2703 2704
#ifdef HAVE_SMEM
    if (mysql->options.shared_memory_base_name != def_shared_memory_base_name)
      my_free(mysql->options.shared_memory_base_name,MYF(MY_ALLOW_ZERO_PTR));
#endif /* HAVE_SMEM */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2705 2706 2707
    /* Clear pointers for better safety */
    mysql->host_info=mysql->user=mysql->passwd=mysql->db=0;
    bzero((char*) &mysql->options,sizeof(mysql->options));
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2708

2709 2710 2711 2712 2713 2714 2715 2716 2717 2718 2719
    /* free/close slave list */
    if (mysql->rpl_pivot)
    {
      MYSQL* tmp;
      for (tmp = mysql->next_slave; tmp != mysql; )
      {
	/* trick to avoid following freed pointer */
	MYSQL* tmp1 = tmp->next_slave;
	mysql_close(tmp);
	tmp = tmp1;
      }
2720
      mysql->rpl_pivot=0;
2721
    }
2722 2723 2724 2725 2726 2727 2728 2729
    if (mysql->stmts)
    {
      /* Free any open prepared statements */
      LIST *element, *next_element;
      for (element= mysql->stmts; element; element= next_element)
      {
        next_element= element->next;
        stmt_close((MYSQL_STMT *)element->data, 0);
peter@mysql.com's avatar
peter@mysql.com committed
2730
      }
2731
    }
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2732
    if (mysql != mysql->master)
2733
      mysql_close(mysql->master);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2734 2735 2736 2737 2738 2739 2740 2741
    if (mysql->free_me)
      my_free((gptr) mysql,MYF(0));
  }
  DBUG_VOID_RETURN;
}


/**************************************************************************
2742 2743
  Do a query. If query returned rows, free old rows.
  Read data by mysql_store_result or by repeat call of mysql_fetch_row
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2744 2745 2746 2747 2748 2749 2750 2751
**************************************************************************/

int STDCALL
mysql_query(MYSQL *mysql, const char *query)
{
  return mysql_real_query(mysql,query, (uint) strlen(query));
}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2752

2753
static MYSQL* spawn_init(MYSQL* parent, const char* host,
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2754 2755
			 unsigned int port, const char* user,
			 const char* passwd)
2756 2757 2758 2759
{
  MYSQL* child;
  if (!(child = mysql_init(0)))
    return 0;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2760

2761 2762
  child->options.user = my_strdup((user) ? user :
				  (parent->user ? parent->user :
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2763 2764 2765 2766
				   parent->options.user), MYF(0));
  child->options.password = my_strdup((passwd) ? passwd :
				      (parent->passwd ?
				       parent->passwd :
2767 2768
				       parent->options.password), MYF(0));
  child->options.port = port;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2769 2770 2771 2772 2773
  child->options.host = my_strdup((host) ? host :
				  (parent->host ?
				   parent->host :
				   parent->options.host), MYF(0));
  if (parent->db)
2774
    child->options.db = my_strdup(parent->db, MYF(0));
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2775
  else if (parent->options.db)
2776 2777 2778
    child->options.db = my_strdup(parent->options.db, MYF(0));

  child->options.rpl_parse = child->options.rpl_probe = child->rpl_pivot = 0;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2779

2780 2781 2782 2783 2784 2785
  return child;
}


int
STDCALL mysql_set_master(MYSQL* mysql, const char* host,
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2786 2787
			 unsigned int port, const char* user,
			 const char* passwd)
2788 2789 2790
{
  if (mysql->master != mysql && !mysql->master->rpl_pivot)
    mysql_close(mysql->master);
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2791
  if (!(mysql->master = spawn_init(mysql, host, port, user, passwd)))
2792 2793 2794 2795 2796 2797 2798 2799 2800 2801 2802 2803 2804 2805
    return 1;
  mysql->master->rpl_pivot = 0;
  mysql->master->options.rpl_parse = 0;
  mysql->master->options.rpl_probe = 0;
  return 0;
}

int
STDCALL mysql_add_slave(MYSQL* mysql, const char* host,
					   unsigned int port,
					   const char* user,
					   const char* passwd)
{
  MYSQL* slave;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2806
  if (!(slave = spawn_init(mysql, host, port, user, passwd)))
2807 2808 2809 2810 2811 2812 2813
    return 1;
  slave->next_slave = mysql->next_slave;
  mysql->next_slave = slave;
  return 0;
}


2814 2815 2816 2817
/*
  Send the query and return so we can do something else.
  Needs to be followed by mysql_read_query_result() when we want to
  finish processing it.
peter@mysql.com's avatar
peter@mysql.com committed
2818
*/
2819 2820

int STDCALL
2821
mysql_send_query(MYSQL* mysql, const char* query, ulong length)
2822
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2823 2824 2825 2826
  DBUG_ENTER("mysql_send_query");
  DBUG_PRINT("enter",("rpl_parse: %d  rpl_pivot: %d",
		      mysql->options.rpl_parse, mysql->rpl_pivot));

2827 2828
  if (mysql->options.rpl_parse && mysql->rpl_pivot)
  {
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2829
    switch (mysql_rpl_query_type(query, length)) {
2830
    case MYSQL_RPL_MASTER:
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2831
      DBUG_RETURN(mysql_master_send_query(mysql, query, length));
2832
    case MYSQL_RPL_SLAVE:
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2833
      DBUG_RETURN(mysql_slave_send_query(mysql, query, length));
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2834 2835
    case MYSQL_RPL_ADMIN:
      break;					/* fall through */
2836 2837 2838 2839
    }
  }

  mysql->last_used_con = mysql;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2840
  DBUG_RETURN(simple_command(mysql, COM_QUERY, query, length, 1));
2841
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2842

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2843

2844
my_bool STDCALL mysql_read_query_result(MYSQL *mysql)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2845 2846 2847 2848
{
  uchar *pos;
  ulong field_count;
  MYSQL_DATA *fields;
2849
  ulong length;
2850
  DBUG_ENTER("mysql_read_query_result");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2851

2852 2853 2854 2855
  /*
    Read from the connection which we actually used, which
    could differ from the original connection if we have slaves
  */
2856
  mysql = mysql->last_used_con;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2857

2858
  if ((length = net_safe_read(mysql)) == packet_error)
2859
    DBUG_RETURN(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2860
  free_old_query(mysql);			/* Free old result */
2861
get_info:
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2862 2863 2864 2865 2866
  pos=(uchar*) mysql->net.read_pos;
  if ((field_count= net_field_length(&pos)) == 0)
  {
    mysql->affected_rows= net_field_length_ll(&pos);
    mysql->insert_id=	  net_field_length_ll(&pos);
venu@myvenu.com's avatar
venu@myvenu.com committed
2867
    if (protocol_41(mysql))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2868 2869
    {
      mysql->server_status=uint2korr(pos); pos+=2;
2870
      mysql->warning_count=uint2korr(pos); pos+=2;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2871
    }
2872
    else if (mysql->server_capabilities & CLIENT_TRANSACTIONS)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2873 2874
    {
      mysql->server_status=uint2korr(pos); pos+=2;
2875
      mysql->warning_count= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2876
    }
2877 2878
    DBUG_PRINT("info",("status: %ld  warning_count:  %ld",
		       mysql->server_status, mysql->warning_count));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2879 2880 2881 2882 2883 2884 2885 2886
    if (pos < mysql->net.read_pos+length && net_field_length(&pos))
      mysql->info=(char*) pos;
    DBUG_RETURN(0);
  }
  if (field_count == NULL_LENGTH)		/* LOAD DATA LOCAL INFILE */
  {
    int error=send_file_to_server(mysql,(char*) pos);
    if ((length=net_safe_read(mysql)) == packet_error || error)
2887
      DBUG_RETURN(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2888 2889 2890 2891 2892 2893
    goto get_info;				/* Get info packet */
  }
  if (!(mysql->server_status & SERVER_STATUS_AUTOCOMMIT))
    mysql->server_status|= SERVER_STATUS_IN_TRANS;

  mysql->extra_info= net_field_length_ll(&pos); /* Maybe number of rec */
2894

2895
  if (!(fields=read_rows(mysql,(MYSQL_FIELD*)0, protocol_41(mysql) ? 6 : 5)))
2896
    DBUG_RETURN(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2897 2898
  if (!(mysql->fields=unpack_fields(fields,&mysql->field_alloc,
				    (uint) field_count,0,
2899
				    mysql->server_capabilities)))
2900 2901
    DBUG_RETURN(1);
  mysql->status= MYSQL_STATUS_GET_RESULT;
2902
  mysql->field_count= (uint) field_count;
2903
  mysql->warning_count= 0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2904 2905 2906
  DBUG_RETURN(0);
}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2907

2908
int STDCALL
2909
mysql_real_query(MYSQL *mysql, const char *query, ulong length)
2910 2911 2912
{
  DBUG_ENTER("mysql_real_query");
  DBUG_PRINT("enter",("handle: %lx",mysql));
2913
  DBUG_PRINT("query",("Query = '%-.4096s'",query));
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2914

2915
  if (mysql_send_query(mysql,query,length))
2916 2917
    DBUG_RETURN(1);
  DBUG_RETURN((int) mysql_read_query_result(mysql));
2918
}
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2919

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2920

2921
static my_bool
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2922 2923
send_file_to_server(MYSQL *mysql, const char *filename)
{
2924 2925
  int fd, readcount;
  my_bool result= 1;
2926 2927
  uint packet_length=MY_ALIGN(mysql->net.max_packet-16,IO_SIZE);
  char *buf, tmp_name[FN_REFLEN];
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2928 2929
  DBUG_ENTER("send_file_to_server");

2930
  if (!(buf=my_malloc(packet_length,MYF(0))))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2931 2932
  {
    strmov(mysql->net.last_error, ER(mysql->net.last_errno=CR_OUT_OF_MEMORY));
2933
    DBUG_RETURN(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2934
  }
2935 2936

  fn_format(tmp_name,filename,"","",4);		/* Convert to client format */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2937 2938
  if ((fd = my_open(tmp_name,O_RDONLY, MYF(0))) < 0)
  {
2939 2940
    my_net_write(&mysql->net,"",0);		/* Server needs one packet */
    net_flush(&mysql->net);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2941
    mysql->net.last_errno=EE_FILENOTFOUND;
2942 2943
    my_snprintf(mysql->net.last_error,sizeof(mysql->net.last_error)-1,
		EE(mysql->net.last_errno),tmp_name, errno);
2944
    goto err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2945 2946
  }

2947
  while ((readcount = (int) my_read(fd,(byte*) buf,packet_length,MYF(0))) > 0)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2948 2949 2950
  {
    if (my_net_write(&mysql->net,buf,readcount))
    {
2951
      DBUG_PRINT("error",("Lost connection to MySQL server during LOAD DATA of local file"));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2952 2953
      mysql->net.last_errno=CR_SERVER_LOST;
      strmov(mysql->net.last_error,ER(mysql->net.last_errno));
2954
      goto err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2955 2956 2957 2958 2959 2960
    }
  }
  /* Send empty packet to mark end of file */
  if (my_net_write(&mysql->net,"",0) || net_flush(&mysql->net))
  {
    mysql->net.last_errno=CR_SERVER_LOST;
2961 2962
    sprintf(mysql->net.last_error,ER(mysql->net.last_errno),errno);
    goto err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2963 2964 2965 2966
  }
  if (readcount < 0)
  {
    mysql->net.last_errno=EE_READ; /* the errmsg for not entire file read */
2967 2968
    my_snprintf(mysql->net.last_error,sizeof(mysql->net.last_error)-1,
		tmp_name,errno);
2969
    goto err;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2970
  }
2971 2972 2973 2974 2975 2976 2977
  result=0;					/* Ok */

err:
  if (fd >= 0)
    (void) my_close(fd,MYF(0));
  my_free(buf,MYF(0));
  DBUG_RETURN(result);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2978 2979 2980 2981
}


/**************************************************************************
2982 2983
  Alloc result struct for buffered results. All rows are read to buffer.
  mysql_data_seek may be used.
bk@work.mysql.com's avatar
bk@work.mysql.com committed
2984 2985 2986 2987 2988 2989 2990 2991
**************************************************************************/

MYSQL_RES * STDCALL
mysql_store_result(MYSQL *mysql)
{
  MYSQL_RES *result;
  DBUG_ENTER("mysql_store_result");

2992 2993
  /* read from the actually used connection */
  mysql = mysql->last_used_con;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
2994

bk@work.mysql.com's avatar
bk@work.mysql.com committed
2995 2996 2997 2998 2999 3000 3001 3002 3003
  if (!mysql->fields)
    DBUG_RETURN(0);
  if (mysql->status != MYSQL_STATUS_GET_RESULT)
  {
    strmov(mysql->net.last_error,
	   ER(mysql->net.last_errno=CR_COMMANDS_OUT_OF_SYNC));
    DBUG_RETURN(0);
  }
  mysql->status=MYSQL_STATUS_READY;		/* server is ready */
3004 3005 3006
  if (!(result=(MYSQL_RES*) my_malloc((uint) (sizeof(MYSQL_RES)+
					      sizeof(ulong) *
					      mysql->field_count),
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3007 3008 3009 3010 3011 3012 3013 3014 3015 3016 3017 3018 3019 3020 3021 3022 3023 3024 3025 3026 3027 3028 3029 3030 3031 3032
				      MYF(MY_WME | MY_ZEROFILL))))
  {
    mysql->net.last_errno=CR_OUT_OF_MEMORY;
    strmov(mysql->net.last_error, ER(mysql->net.last_errno));
    DBUG_RETURN(0);
  }
  result->eof=1;				/* Marker for buffered */
  result->lengths=(ulong*) (result+1);
  if (!(result->data=read_rows(mysql,mysql->fields,mysql->field_count)))
  {
    my_free((gptr) result,MYF(0));
    DBUG_RETURN(0);
  }
  mysql->affected_rows= result->row_count= result->data->rows;
  result->data_cursor=	result->data->data;
  result->fields=	mysql->fields;
  result->field_alloc=	mysql->field_alloc;
  result->field_count=	mysql->field_count;
  result->current_field=0;
  result->current_row=0;			/* Must do a fetch first */
  mysql->fields=0;				/* fields is now in result */
  DBUG_RETURN(result);				/* Data fetched */
}


/**************************************************************************
3033 3034 3035 3036 3037 3038 3039
  Alloc struct for use with unbuffered reads. Data is fetched by domand
  when calling to mysql_fetch_row.
  mysql_data_seek is a noop.

  No other queries may be specified with the same MYSQL handle.
  There shouldn't be much processing per row because mysql server shouldn't
  have to wait for the client (and will not wait more than 30 sec/packet).
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3040 3041 3042 3043 3044 3045 3046 3047
**************************************************************************/

MYSQL_RES * STDCALL
mysql_use_result(MYSQL *mysql)
{
  MYSQL_RES *result;
  DBUG_ENTER("mysql_use_result");

3048
  mysql = mysql->last_used_con;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3049

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3050 3051 3052 3053 3054 3055 3056 3057 3058 3059 3060 3061 3062 3063 3064 3065 3066 3067 3068 3069 3070 3071 3072 3073 3074 3075 3076 3077 3078 3079 3080 3081 3082
  if (!mysql->fields)
    DBUG_RETURN(0);
  if (mysql->status != MYSQL_STATUS_GET_RESULT)
  {
    strmov(mysql->net.last_error,
	   ER(mysql->net.last_errno=CR_COMMANDS_OUT_OF_SYNC));
    DBUG_RETURN(0);
  }
  if (!(result=(MYSQL_RES*) my_malloc(sizeof(*result)+
				      sizeof(ulong)*mysql->field_count,
				      MYF(MY_WME | MY_ZEROFILL))))
    DBUG_RETURN(0);
  result->lengths=(ulong*) (result+1);
  if (!(result->row=(MYSQL_ROW)
	my_malloc(sizeof(result->row[0])*(mysql->field_count+1), MYF(MY_WME))))
  {					/* Ptrs: to one row */
    my_free((gptr) result,MYF(0));
    DBUG_RETURN(0);
  }
  result->fields=	mysql->fields;
  result->field_alloc=	mysql->field_alloc;
  result->field_count=	mysql->field_count;
  result->current_field=0;
  result->handle=	mysql;
  result->current_row=	0;
  mysql->fields=0;			/* fields is now in result */
  mysql->status=MYSQL_STATUS_USE_RESULT;
  DBUG_RETURN(result);			/* Data is read to be fetched */
}



/**************************************************************************
3083
  Return next field of the query results
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3084 3085 3086 3087 3088 3089 3090 3091 3092 3093 3094 3095
**************************************************************************/

MYSQL_FIELD * STDCALL
mysql_fetch_field(MYSQL_RES *result)
{
  if (result->current_field >= result->field_count)
    return(NULL);
  return &result->fields[result->current_field++];
}


/**************************************************************************
3096
   Return next row of the query results
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3097 3098 3099 3100 3101 3102 3103 3104 3105 3106 3107 3108 3109 3110 3111 3112 3113 3114 3115 3116
**************************************************************************/

MYSQL_ROW STDCALL
mysql_fetch_row(MYSQL_RES *res)
{
  DBUG_ENTER("mysql_fetch_row");
  if (!res->data)
  {						/* Unbufferred fetch */
    if (!res->eof)
    {
      if (!(read_one_row(res->handle,res->field_count,res->row, res->lengths)))
      {
	res->row_count++;
	DBUG_RETURN(res->current_row=res->row);
      }
      else
      {
	DBUG_PRINT("info",("end of data"));
	res->eof=1;
	res->handle->status=MYSQL_STATUS_READY;
3117 3118
	/* Don't clear handle in mysql_free_results */
	res->handle=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3119 3120 3121 3122 3123 3124 3125 3126 3127 3128 3129 3130 3131 3132 3133 3134 3135 3136
      }
    }
    DBUG_RETURN((MYSQL_ROW) NULL);
  }
  {
    MYSQL_ROW tmp;
    if (!res->data_cursor)
    {
      DBUG_PRINT("info",("end of data"));
      DBUG_RETURN(res->current_row=(MYSQL_ROW) NULL);
    }
    tmp = res->data_cursor->data;
    res->data_cursor = res->data_cursor->next;
    DBUG_RETURN(res->current_row=tmp);
  }
}

/**************************************************************************
3137 3138 3139
  Get column lengths of the current row
  If one uses mysql_use_result, res->lengths contains the length information,
  else the lengths are calculated from the offset between pointers.
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3140 3141
**************************************************************************/

3142 3143 3144 3145 3146 3147 3148 3149 3150 3151 3152 3153 3154 3155 3156 3157 3158 3159 3160 3161 3162 3163
static void fetch_lengths(ulong *to, MYSQL_ROW column, uint field_count)
{ 
  ulong *prev_length;
  byte *start=0;
  MYSQL_ROW end;

  prev_length=0;				/* Keep gcc happy */
  for (end=column + field_count + 1 ; column != end ; column++, to++)
  {
    if (!*column)
    {
      *to= 0;					/* Null */
      continue;
    }
    if (start)					/* Found end of prev string */
      *prev_length= (ulong) (*column-start-1);
    start= *column;
    prev_length= to;
  }
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
3164 3165 3166
ulong * STDCALL
mysql_fetch_lengths(MYSQL_RES *res)
{
3167
  MYSQL_ROW column;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3168 3169 3170 3171

  if (!(column=res->current_row))
    return 0;					/* Something is wrong */
  if (res->data)
3172
    fetch_lengths(res->lengths, column, res->field_count);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3173 3174 3175 3176
  return res->lengths;
}

/**************************************************************************
3177
  Move to a specific row and column
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3178 3179 3180 3181 3182 3183 3184 3185 3186 3187 3188 3189 3190 3191
**************************************************************************/

void STDCALL
mysql_data_seek(MYSQL_RES *result, my_ulonglong row)
{
  MYSQL_ROWS	*tmp=0;
  DBUG_PRINT("info",("mysql_data_seek(%ld)",(long) row));
  if (result->data)
    for (tmp=result->data->data; row-- && tmp ; tmp = tmp->next) ;
  result->current_row=0;
  result->data_cursor = tmp;
}

/*************************************************************************
3192 3193 3194
  put the row or field cursor one a position one got from mysql_row_tell()
  This doesn't restore any data. The next mysql_fetch_row or
  mysql_fetch_field will return the next row or field after the last used
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3195 3196 3197 3198 3199 3200 3201 3202 3203 3204 3205 3206 3207 3208 3209 3210 3211 3212 3213 3214 3215
*************************************************************************/

MYSQL_ROW_OFFSET STDCALL
mysql_row_seek(MYSQL_RES *result, MYSQL_ROW_OFFSET row)
{
  MYSQL_ROW_OFFSET return_value=result->data_cursor;
  result->current_row= 0;
  result->data_cursor= row;
  return return_value;
}


MYSQL_FIELD_OFFSET STDCALL
mysql_field_seek(MYSQL_RES *result, MYSQL_FIELD_OFFSET field_offset)
{
  MYSQL_FIELD_OFFSET return_value=result->current_field;
  result->current_field=field_offset;
  return return_value;
}

/*****************************************************************************
3216
  List all databases
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3217 3218 3219 3220 3221 3222 3223 3224 3225 3226 3227 3228 3229 3230 3231 3232
*****************************************************************************/

MYSQL_RES * STDCALL
mysql_list_dbs(MYSQL *mysql, const char *wild)
{
  char buff[255];
  DBUG_ENTER("mysql_list_dbs");

  append_wild(strmov(buff,"show databases"),buff+sizeof(buff),wild);
  if (mysql_query(mysql,buff))
    DBUG_RETURN(0);
  DBUG_RETURN (mysql_store_result(mysql));
}


/*****************************************************************************
3233 3234
  List all tables in a database
  If wild is given then only the tables matching wild is returned
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3235 3236 3237 3238 3239 3240 3241 3242 3243 3244 3245 3246 3247 3248 3249 3250
*****************************************************************************/

MYSQL_RES * STDCALL
mysql_list_tables(MYSQL *mysql, const char *wild)
{
  char buff[255];
  DBUG_ENTER("mysql_list_tables");

  append_wild(strmov(buff,"show tables"),buff+sizeof(buff),wild);
  if (mysql_query(mysql,buff))
    DBUG_RETURN(0);
  DBUG_RETURN (mysql_store_result(mysql));
}


/**************************************************************************
3251 3252 3253 3254
  List all fields in a table
  If wild is given then only the fields matching wild is returned
  Instead of this use query:
  show fields in 'table' like "wild"
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3255 3256 3257 3258 3259 3260 3261 3262 3263 3264 3265 3266 3267 3268
**************************************************************************/

MYSQL_RES * STDCALL
mysql_list_fields(MYSQL *mysql, const char *table, const char *wild)
{
  MYSQL_RES *result;
  MYSQL_DATA *query;
  char	     buff[257],*end;
  DBUG_ENTER("mysql_list_fields");
  DBUG_PRINT("enter",("table: '%s'  wild: '%s'",table,wild ? wild : ""));

  LINT_INIT(query);

  end=strmake(strmake(buff, table,128)+1,wild ? wild : "",128);
3269
  if (simple_command(mysql,COM_FIELD_LIST,buff,(ulong) (end-buff),1) ||
3270 3271
      !(query = read_rows(mysql,(MYSQL_FIELD*) 0, 
			  protocol_41(mysql) ? 7 : 6)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3272 3273 3274 3275 3276 3277 3278 3279 3280 3281 3282 3283 3284
    DBUG_RETURN(NULL);

  free_old_query(mysql);
  if (!(result = (MYSQL_RES *) my_malloc(sizeof(MYSQL_RES),
					 MYF(MY_WME | MY_ZEROFILL))))
  {
    free_rows(query);
    DBUG_RETURN(NULL);
  }
  result->field_alloc=mysql->field_alloc;
  mysql->fields=0;
  result->field_count = (uint) query->rows;
  result->fields= unpack_fields(query,&result->field_alloc,
3285 3286
				result->field_count, 1,
				mysql->server_capabilities);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3287 3288 3289 3290
  result->eof=1;
  DBUG_RETURN(result);
}

3291

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3292 3293 3294 3295 3296 3297 3298 3299 3300 3301 3302 3303 3304 3305 3306 3307
/* List all running processes (threads) in server */

MYSQL_RES * STDCALL
mysql_list_processes(MYSQL *mysql)
{
  MYSQL_DATA *fields;
  uint field_count;
  uchar *pos;
  DBUG_ENTER("mysql_list_processes");

  LINT_INIT(fields);
  if (simple_command(mysql,COM_PROCESS_INFO,0,0,0))
    DBUG_RETURN(0);
  free_old_query(mysql);
  pos=(uchar*) mysql->net.read_pos;
  field_count=(uint) net_field_length(&pos);
3308 3309
  if (!(fields = read_rows(mysql,(MYSQL_FIELD*) 0,
			   protocol_41(mysql) ? 6 : 5)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3310 3311
    DBUG_RETURN(NULL);
  if (!(mysql->fields=unpack_fields(fields,&mysql->field_alloc,field_count,0,
3312
				    mysql->server_capabilities)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3313 3314 3315 3316 3317 3318 3319
    DBUG_RETURN(0);
  mysql->status=MYSQL_STATUS_GET_RESULT;
  mysql->field_count=field_count;
  DBUG_RETURN(mysql_store_result(mysql));
}


3320
#ifdef USE_OLD_FUNCTIONS
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3321 3322 3323 3324 3325
int  STDCALL
mysql_create_db(MYSQL *mysql, const char *db)
{
  DBUG_ENTER("mysql_createdb");
  DBUG_PRINT("enter",("db: %s",db));
3326
  DBUG_RETURN(simple_command(mysql,COM_CREATE_DB,db, (ulong) strlen(db),0));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3327 3328 3329 3330 3331 3332 3333 3334
}


int  STDCALL
mysql_drop_db(MYSQL *mysql, const char *db)
{
  DBUG_ENTER("mysql_drop_db");
  DBUG_PRINT("enter",("db: %s",db));
3335
  DBUG_RETURN(simple_command(mysql,COM_DROP_DB,db,(ulong) strlen(db),0));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3336
}
3337
#endif
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3338 3339 3340 3341 3342 3343 3344 3345 3346 3347 3348 3349 3350 3351 3352 3353 3354 3355 3356 3357 3358 3359 3360 3361 3362 3363 3364 3365 3366 3367 3368 3369 3370 3371 3372 3373


int STDCALL
mysql_shutdown(MYSQL *mysql)
{
  DBUG_ENTER("mysql_shutdown");
  DBUG_RETURN(simple_command(mysql,COM_SHUTDOWN,0,0,0));
}


int STDCALL
mysql_refresh(MYSQL *mysql,uint options)
{
  uchar bits[1];
  DBUG_ENTER("mysql_refresh");
  bits[0]= (uchar) options;
  DBUG_RETURN(simple_command(mysql,COM_REFRESH,(char*) bits,1,0));
}

int STDCALL
mysql_kill(MYSQL *mysql,ulong pid)
{
  char buff[12];
  DBUG_ENTER("mysql_kill");
  int4store(buff,pid);
  DBUG_RETURN(simple_command(mysql,COM_PROCESS_KILL,buff,4,0));
}


int STDCALL
mysql_dump_debug_info(MYSQL *mysql)
{
  DBUG_ENTER("mysql_dump_debug_info");
  DBUG_RETURN(simple_command(mysql,COM_DEBUG,0,0,0));
}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3374
const char * STDCALL
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3375 3376 3377 3378 3379 3380 3381 3382 3383 3384 3385 3386 3387 3388 3389 3390 3391 3392 3393 3394 3395 3396 3397 3398
mysql_stat(MYSQL *mysql)
{
  DBUG_ENTER("mysql_stat");
  if (simple_command(mysql,COM_STATISTICS,0,0,0))
    return mysql->net.last_error;
  mysql->net.read_pos[mysql->packet_length]=0;	/* End of stat string */
  if (!mysql->net.read_pos[0])
  {
    mysql->net.last_errno=CR_WRONG_HOST_INFO;
    strmov(mysql->net.last_error, ER(mysql->net.last_errno));
    return mysql->net.last_error;
  }
  DBUG_RETURN((char*) mysql->net.read_pos);
}


int STDCALL
mysql_ping(MYSQL *mysql)
{
  DBUG_ENTER("mysql_ping");
  DBUG_RETURN(simple_command(mysql,COM_PING,0,0,0));
}


monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3399
const char * STDCALL
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3400 3401 3402 3403 3404 3405
mysql_get_server_info(MYSQL *mysql)
{
  return((char*) mysql->server_version);
}


3406 3407 3408 3409 3410 3411 3412 3413 3414 3415 3416 3417 3418 3419 3420 3421 3422 3423 3424 3425 3426 3427 3428 3429 3430 3431 3432 3433 3434
/*
  Get version number for server in a form easy to test on

  SYNOPSIS
    mysql_get_server_version()
    mysql		Connection

  EXAMPLE
    4.1.0-alfa ->  40100
  
  NOTES
    We will ensure that a newer server always has a bigger number.

  RETURN
   Signed number > 323000
*/

ulong STDCALL
mysql_get_server_version(MYSQL *mysql)
{
  uint major, minor, version;
  char *pos= mysql->server_version, *end_pos;
  major=   (uint) strtoul(pos, &end_pos, 10);	pos=end_pos+1;
  minor=   (uint) strtoul(pos, &end_pos, 10);	pos=end_pos+1;
  version= (uint) strtoul(pos, &end_pos, 10);
  return (ulong) major*10000L+(ulong) (minor*100+version);
}


monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3435
const char * STDCALL
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3436 3437 3438 3439 3440 3441 3442 3443 3444 3445 3446 3447
mysql_get_host_info(MYSQL *mysql)
{
  return(mysql->host_info);
}


uint STDCALL
mysql_get_proto_info(MYSQL *mysql)
{
  return (mysql->protocol_version);
}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3448
const char * STDCALL
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3449 3450 3451 3452 3453 3454 3455 3456 3457 3458 3459 3460 3461 3462 3463 3464
mysql_get_client_info(void)
{
  return (char*) MYSQL_SERVER_VERSION;
}


int STDCALL
mysql_options(MYSQL *mysql,enum mysql_option option, const char *arg)
{
  DBUG_ENTER("mysql_option");
  DBUG_PRINT("enter",("option: %d",(int) option));
  switch (option) {
  case MYSQL_OPT_CONNECT_TIMEOUT:
    mysql->options.connect_timeout= *(uint*) arg;
    break;
  case MYSQL_OPT_COMPRESS:
3465
    mysql->options.compress= 1;			/* Remember for connect */
3466
    mysql->options.client_flag|= CLIENT_COMPRESS;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3467 3468
    break;
  case MYSQL_OPT_NAMED_PIPE:
3469
    mysql->options.protocol=MYSQL_PROTOCOL_PIPE; /* Force named pipe */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3470
    break;
3471 3472
  case MYSQL_OPT_LOCAL_INFILE:			/* Allow LOAD DATA LOCAL ?*/
    if (!arg || test(*(uint*) arg))
3473
      mysql->options.client_flag|= CLIENT_LOCAL_FILES;
3474
    else
3475
      mysql->options.client_flag&= ~CLIENT_LOCAL_FILES;
3476
    break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3477
  case MYSQL_INIT_COMMAND:
3478
    add_init_command(&mysql->options,arg);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3479 3480 3481 3482 3483 3484 3485 3486 3487 3488 3489 3490 3491 3492 3493 3494 3495
    break;
  case MYSQL_READ_DEFAULT_FILE:
    my_free(mysql->options.my_cnf_file,MYF(MY_ALLOW_ZERO_PTR));
    mysql->options.my_cnf_file=my_strdup(arg,MYF(MY_WME));
    break;
  case MYSQL_READ_DEFAULT_GROUP:
    my_free(mysql->options.my_cnf_group,MYF(MY_ALLOW_ZERO_PTR));
    mysql->options.my_cnf_group=my_strdup(arg,MYF(MY_WME));
    break;
  case MYSQL_SET_CHARSET_DIR:
    my_free(mysql->options.charset_dir,MYF(MY_ALLOW_ZERO_PTR));
    mysql->options.charset_dir=my_strdup(arg,MYF(MY_WME));
    break;
  case MYSQL_SET_CHARSET_NAME:
    my_free(mysql->options.charset_name,MYF(MY_ALLOW_ZERO_PTR));
    mysql->options.charset_name=my_strdup(arg,MYF(MY_WME));
    break;
3496 3497 3498 3499 3500 3501 3502 3503 3504 3505
  case MYSQL_OPT_PROTOCOL:
    mysql->options.protocol= *(uint*) arg;
    break;
  case MYSQL_SHARED_MEMORY_BASE_NAME:
#ifdef HAVE_SMEM
    if (mysql->options.shared_memory_base_name != def_shared_memory_base_name)
      my_free(mysql->options.shared_memory_base_name,MYF(MY_ALLOW_ZERO_PTR));
    mysql->options.shared_memory_base_name=my_strdup(arg,MYF(MY_WME));
#endif
    break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3506
  default:
3507
    DBUG_RETURN(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3508 3509 3510 3511 3512
  }
  DBUG_RETURN(0);
}

/****************************************************************************
3513 3514
  Functions to get information from the MySQL structure
  These are functions to make shared libraries more usable.
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3515 3516 3517 3518 3519 3520 3521 3522 3523 3524 3525 3526 3527 3528 3529 3530 3531 3532 3533 3534 3535 3536 3537 3538 3539 3540 3541 3542
****************************************************************************/

/* MYSQL_RES */
my_ulonglong STDCALL mysql_num_rows(MYSQL_RES *res)
{
  return res->row_count;
}

unsigned int STDCALL mysql_num_fields(MYSQL_RES *res)
{
  return res->field_count;
}

my_bool STDCALL mysql_eof(MYSQL_RES *res)
{
  return res->eof;
}

MYSQL_FIELD * STDCALL mysql_fetch_field_direct(MYSQL_RES *res,uint fieldnr)
{
  return &(res)->fields[fieldnr];
}

MYSQL_FIELD * STDCALL mysql_fetch_fields(MYSQL_RES *res)
{
  return (res)->fields;
}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3543
MYSQL_ROW_OFFSET STDCALL mysql_row_tell(MYSQL_RES *res)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3544 3545 3546 3547
{
  return res->data_cursor;
}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3548
MYSQL_FIELD_OFFSET STDCALL mysql_field_tell(MYSQL_RES *res)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3549 3550 3551 3552 3553 3554 3555 3556
{
  return (res)->current_field;
}

/* MYSQL */

unsigned int STDCALL mysql_field_count(MYSQL *mysql)
{
3557
  return mysql->last_used_con->field_count;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3558 3559 3560 3561
}

my_ulonglong STDCALL mysql_affected_rows(MYSQL *mysql)
{
3562
  return mysql->last_used_con->affected_rows;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3563 3564 3565 3566
}

my_ulonglong STDCALL mysql_insert_id(MYSQL *mysql)
{
3567
  return mysql->last_used_con->insert_id;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3568 3569 3570 3571
}

uint STDCALL mysql_errno(MYSQL *mysql)
{
3572
  return mysql->net.last_errno;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3573 3574
}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3575
const char * STDCALL mysql_error(MYSQL *mysql)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3576
{
3577
  return mysql->net.last_error;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3578 3579
}

3580 3581 3582 3583 3584
uint STDCALL mysql_warning_count(MYSQL *mysql)
{
  return mysql->warning_count;
}

monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
3585
const char *STDCALL mysql_info(MYSQL *mysql)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3586
{
3587
  return mysql->info;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3588 3589 3590 3591 3592 3593 3594 3595 3596 3597 3598 3599 3600 3601 3602 3603 3604 3605 3606 3607 3608 3609 3610
}

ulong STDCALL mysql_thread_id(MYSQL *mysql)
{
  return (mysql)->thread_id;
}

const char * STDCALL mysql_character_set_name(MYSQL *mysql)
{
  return mysql->charset->name;
}


uint STDCALL mysql_thread_safe(void)
{
#ifdef THREAD
  return 1;
#else
  return 0;
#endif
}

/****************************************************************************
3611
  Some support functions
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3612 3613
****************************************************************************/

3614 3615 3616 3617 3618 3619 3620 3621 3622
/*
  Functions called my my_net_init() to set some application specific variables
*/

void my_net_local_init(NET *net)
{
  net->max_packet=   (uint) net_buffer_length;
  net->read_timeout= (uint) net_read_timeout;
  net->write_timeout=(uint) net_write_timeout;
3623
  net->retry_count=  1;
3624 3625 3626
  net->max_packet_size= max(net_buffer_length, max_allowed_packet);
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3627
/*
3628 3629 3630
  Add escape characters to a string (blob?) to make it suitable for a insert
  to should at least have place for length*2+1 chars
  Returns the length of the to string
bk@work.mysql.com's avatar
bk@work.mysql.com committed
3631 3632 3633 3634 3635 3636 3637 3638 3639 3640 3641 3642 3643 3644 3645 3646 3647 3648 3649 3650 3651 3652 3653 3654 3655 3656 3657 3658 3659 3660 3661 3662 3663 3664 3665 3666 3667 3668 3669 3670 3671 3672 3673 3674 3675 3676 3677 3678 3679 3680 3681 3682 3683 3684 3685 3686 3687 3688 3689 3690 3691 3692 3693 3694 3695 3696 3697 3698 3699 3700 3701 3702 3703 3704 3705 3706 3707 3708 3709 3710 3711 3712 3713 3714 3715 3716 3717 3718 3719 3720 3721 3722 3723 3724 3725 3726 3727 3728 3729 3730 3731 3732 3733 3734 3735 3736 3737 3738 3739 3740 3741 3742 3743 3744 3745 3746 3747 3748 3749 3750 3751 3752 3753 3754 3755 3756 3757 3758 3759 3760 3761 3762 3763 3764 3765 3766 3767 3768 3769 3770 3771 3772 3773 3774 3775 3776 3777 3778 3779 3780 3781 3782 3783 3784 3785 3786 3787 3788 3789 3790 3791 3792 3793 3794 3795 3796 3797 3798 3799 3800 3801 3802 3803 3804 3805 3806
*/

ulong STDCALL
mysql_escape_string(char *to,const char *from,ulong length)
{
  return mysql_sub_escape_string(default_charset_info,to,from,length);
}

ulong STDCALL
mysql_real_escape_string(MYSQL *mysql, char *to,const char *from,
			 ulong length)
{
  return mysql_sub_escape_string(mysql->charset,to,from,length);
}


static ulong
mysql_sub_escape_string(CHARSET_INFO *charset_info, char *to,
			const char *from, ulong length)
{
  const char *to_start=to;
  const char *end;
#ifdef USE_MB
  my_bool use_mb_flag=use_mb(charset_info);
#endif
  for (end=from+length; from != end ; from++)
  {
#ifdef USE_MB
    int l;
    if (use_mb_flag && (l = my_ismbchar(charset_info, from, end)))
    {
      while (l--)
	  *to++ = *from++;
      from--;
      continue;
    }
#endif
    switch (*from) {
    case 0:				/* Must be escaped for 'mysql' */
      *to++= '\\';
      *to++= '0';
      break;
    case '\n':				/* Must be escaped for logs */
      *to++= '\\';
      *to++= 'n';
      break;
    case '\r':
      *to++= '\\';
      *to++= 'r';
      break;
    case '\\':
      *to++= '\\';
      *to++= '\\';
      break;
    case '\'':
      *to++= '\\';
      *to++= '\'';
      break;
    case '"':				/* Better safe than sorry */
      *to++= '\\';
      *to++= '"';
      break;
    case '\032':			/* This gives problems on Win32 */
      *to++= '\\';
      *to++= 'Z';
      break;
    default:
      *to++= *from;
    }
  }
  *to=0;
  return (ulong) (to-to_start);
}


char * STDCALL
mysql_odbc_escape_string(MYSQL *mysql,
			 char *to, ulong to_length,
			 const char *from, ulong from_length,
			 void *param,
			 char * (*extend_buffer)
			 (void *, char *, ulong *))
{
  char *to_end=to+to_length-5;
  const char *end;
#ifdef USE_MB
  my_bool use_mb_flag=use_mb(mysql->charset);
#endif

  for (end=from+from_length; from != end ; from++)
  {
    if (to >= to_end)
    {
      to_length = (ulong) (end-from)+512;	/* We want this much more */
      if (!(to=(*extend_buffer)(param, to, &to_length)))
	return to;
      to_end=to+to_length-5;
    }
#ifdef USE_MB
    {
      int l;
      if (use_mb_flag && (l = my_ismbchar(mysql->charset, from, end)))
      {
	while (l--)
	  *to++ = *from++;
	from--;
	continue;
      }
    }
#endif
    switch (*from) {
    case 0:				/* Must be escaped for 'mysql' */
      *to++= '\\';
      *to++= '0';
      break;
    case '\n':				/* Must be escaped for logs */
      *to++= '\\';
      *to++= 'n';
      break;
    case '\r':
      *to++= '\\';
      *to++= 'r';
      break;
    case '\\':
      *to++= '\\';
      *to++= '\\';
      break;
    case '\'':
      *to++= '\\';
      *to++= '\'';
      break;
    case '"':				/* Better safe than sorry */
      *to++= '\\';
      *to++= '"';
      break;
    case '\032':			/* This gives problems on Win32 */
      *to++= '\\';
      *to++= 'Z';
      break;
    default:
      *to++= *from;
    }
  }
  return to;
}

void STDCALL
myodbc_remove_escape(MYSQL *mysql,char *name)
{
  char *to;
#ifdef USE_MB
  my_bool use_mb_flag=use_mb(mysql->charset);
  char *end;
  LINT_INIT(end);
  if (use_mb_flag)
    for (end=name; *end ; end++) ;
#endif

  for (to=name ; *name ; name++)
  {
#ifdef USE_MB
    int l;
    if (use_mb_flag && (l = my_ismbchar( mysql->charset, name , end ) ) )
    {
      while (l--)
	*to++ = *name++;
      name--;
      continue;
    }
#endif
    if (*name == '\\' && name[1])
      name++;
    *to++= *name;
  }
  *to=0;
}
3807 3808 3809 3810 3811 3812 3813 3814 3815 3816 3817 3818 3819 3820 3821

/********************************************************************

 Implementation of new client-server prototypes for 4.1 version
 starts from here ..

 mysql_* are real prototypes used by applications

*********************************************************************/

/********************************************************************
 Misc Utility functions
********************************************************************/

/*
3822
  Set the internal stmt error messages
3823 3824 3825 3826 3827
*/

static void set_stmt_error(MYSQL_STMT * stmt, int errcode)
{
  DBUG_ENTER("set_stmt_error");
3828
  DBUG_PRINT("enter", ("error: %d '%s'", errcode, ER(errcode)));
3829 3830
  DBUG_ASSERT(stmt != 0);

3831 3832
  stmt->last_errno= errcode;
  strmov(stmt->last_error, ER(errcode));
3833 3834 3835 3836

  DBUG_VOID_RETURN;
}

3837

3838
/*
3839
  Copy error message to statement handler
3840 3841 3842 3843 3844
*/

static void set_stmt_errmsg(MYSQL_STMT * stmt, char *err, int errcode)
{
  DBUG_ENTER("set_stmt_error_msg");
3845
  DBUG_PRINT("enter", ("error: %d '%s'", errcode, err));
3846 3847
  DBUG_ASSERT(stmt != 0);

3848
  stmt->last_errno= errcode;
3849
  if (err && err[0])
3850
    strmov(stmt->last_error, err);
3851 3852 3853 3854

  DBUG_VOID_RETURN;
}

3855

3856
/*
3857
  Set the internal error message to mysql handler
3858 3859 3860 3861 3862
*/

static void set_mysql_error(MYSQL * mysql, int errcode)
{
  DBUG_ENTER("set_mysql_error");
3863
  DBUG_PRINT("enter", ("error :%d '%s'", errcode, ER(errcode)));
3864 3865
  DBUG_ASSERT(mysql != 0);

3866
  mysql->net.last_errno= errcode;
3867 3868 3869 3870 3871
  strmov(mysql->net.last_error, ER(errcode));
}


/*
3872
  Reallocate the NET package to be at least of 'length' bytes
3873

3874 3875 3876 3877
  SYNPOSIS
   my_realloc_str()
   net			The NET structure to modify
   int length		Ensure that net->buff is at least this big
3878

3879 3880 3881
  RETURN VALUES
  0	ok
  1	Error
3882 3883 3884

*/

3885
static my_bool my_realloc_str(NET *net, ulong length)
3886
{
3887 3888 3889 3890
  ulong buf_length= (ulong) (net->write_pos - net->buff);
  my_bool res=0;
  DBUG_ENTER("my_realloc_str");
  if (buf_length + length > net->max_packet)
3891
  {
3892 3893
    res= net_realloc(net, buf_length + length);
    net->write_pos= net->buff+ buf_length;
3894
  }
3895
  DBUG_RETURN(res);
3896 3897 3898
}

/********************************************************************
3899
  Prepare related implementations
3900 3901 3902 3903
********************************************************************/

/*
  Read the prepare statement results ..
3904 3905 3906 3907 3908 3909 3910 3911

  NOTE
    This is only called for connection to servers that supports
    prepared statements (and thus the 4.1 protocol)

  RETURN VALUES
    0	ok
    1	error
3912 3913
*/

3914
static my_bool read_prepare_result(MYSQL_STMT *stmt)
3915 3916
{
  uchar *pos;
3917
  uint field_count;
3918
  ulong length, param_count;
3919
  MYSQL_DATA *fields_data;
3920
  MYSQL *mysql= stmt->mysql;
3921
  DBUG_ENTER("read_prepare_result");
3922

3923 3924 3925
  mysql= mysql->last_used_con;
  if ((length= net_safe_read(mysql)) == packet_error)
    DBUG_RETURN(1);
3926

3927
  pos= (uchar*) mysql->net.read_pos;
3928 3929 3930
  stmt->stmt_id= uint4korr(pos); pos+=4;
  field_count=   uint2korr(pos); pos+=2;
  param_count=   uint2korr(pos); pos+=2;
3931

3932 3933 3934 3935
  if (field_count != 0)
  {
    if (!(mysql->server_status & SERVER_STATUS_AUTOCOMMIT))
      mysql->server_status|= SERVER_STATUS_IN_TRANS;
3936

3937 3938 3939 3940 3941 3942 3943 3944 3945 3946
    mysql->extra_info= net_field_length_ll(&pos);
    if (!(fields_data= read_rows(mysql, (MYSQL_FIELD*) 0, 8)))
      DBUG_RETURN(1);
    if (!(stmt->fields= unpack_fields(fields_data,&stmt->mem_root,
				      field_count,0,
				      mysql->server_capabilities)))
      DBUG_RETURN(1);
  }
  if (!(stmt->params= (MYSQL_BIND *) alloc_root(&stmt->mem_root,
						sizeof(MYSQL_BIND)*
3947 3948
                                                (param_count + 
                                                 field_count))))
3949
  {
3950
    set_stmt_error(stmt, CR_OUT_OF_MEMORY);
3951 3952
    DBUG_RETURN(0);
  }
3953 3954 3955 3956
  stmt->bind=	      (stmt->params + param_count);
  stmt->field_count=  (uint) field_count;
  stmt->param_count=  (ulong) param_count;
  mysql->status=      MYSQL_STATUS_READY;
3957 3958 3959 3960 3961
  DBUG_RETURN(0);
}


/*
3962 3963 3964 3965 3966
  Prepare the query and return the new statement handle to
  caller.

  Also update the total parameter count along with resultset
  metadata information by reading from server
3967 3968
*/

3969 3970 3971

MYSQL_STMT *STDCALL
mysql_prepare(MYSQL  *mysql, const char *query, ulong length)
3972 3973
{
  MYSQL_STMT  *stmt;
venu@myvenu.com's avatar
venu@myvenu.com committed
3974
  DBUG_ENTER("mysql_prepare");
3975 3976
  DBUG_ASSERT(mysql != 0);

venu@myvenu.com's avatar
venu@myvenu.com committed
3977
#ifdef CHECK_EXTRA_ARGUMENTS
3978 3979 3980 3981 3982 3983 3984
  if (!query)
  {
    set_mysql_error(mysql, CR_NULL_POINTER);
    DBUG_RETURN(0);
  }
#endif

3985 3986 3987 3988 3989 3990
  if (!(stmt= (MYSQL_STMT *) my_malloc(sizeof(MYSQL_STMT),
				       MYF(MY_WME | MY_ZEROFILL))) ||
      !(stmt->query= my_strdup_with_length((byte *) query, length, MYF(0))))
  {
    my_free((gptr) stmt, MYF(MY_ALLOW_ZERO_PTR));
    set_mysql_error(mysql, CR_OUT_OF_MEMORY);
3991
    DBUG_RETURN(0);
3992 3993 3994
  }
  if (simple_command(mysql, COM_PREPARE, query, length, 1))
  {
3995
    stmt_close(stmt, 1);
3996 3997 3998
    DBUG_RETURN(0);
  }

3999
  init_alloc_root(&stmt->mem_root,8192,0);
4000 4001
  stmt->mysql= mysql;
  if (read_prepare_result(stmt))
4002
  {
4003
    stmt_close(stmt, 1);
4004 4005
    DBUG_RETURN(0);
  }
venu@myvenu.com's avatar
venu@myvenu.com committed
4006
  stmt->state= MY_ST_PREPARE;
4007 4008
  mysql->stmts= list_add(mysql->stmts, &stmt->list);
  stmt->list.data= stmt;
4009 4010 4011 4012
  DBUG_PRINT("info", ("Parameter count: %ld", stmt->param_count));
  DBUG_RETURN(stmt);
}

4013 4014 4015 4016 4017 4018 4019
/*
  Get the execute query meta information for non-select 
  statements (on demand).
*/

unsigned int alloc_stmt_fields(MYSQL_STMT *stmt)
{
4020 4021
  MYSQL_FIELD *fields, *field, *end;
  MEM_ROOT *alloc= &stmt->mem_root;
4022 4023 4024
  
  if (!stmt->mysql->field_count)
    return 0;
4025
  
4026 4027
  stmt->field_count= stmt->mysql->field_count;
  
4028 4029 4030 4031 4032 4033 4034
  /*
    Get the field information for non-select statements 
    like SHOW and DESCRIBE commands
  */
  if (!(stmt->fields= (MYSQL_FIELD *) alloc_root(alloc, 
        sizeof(MYSQL_FIELD) * stmt->field_count)) || 
      !(stmt->bind= (MYSQL_BIND *) alloc_root(alloc, 
4035 4036
        sizeof(MYSQL_BIND ) * stmt->field_count)))
    return 0;
4037 4038 4039 4040 4041 4042 4043 4044 4045 4046
  
  for (fields= stmt->mysql->fields, end= fields+stmt->field_count, 
       field= stmt->fields;
       field && fields < end; fields++, field++)
  {
    field->db       = strdup_root(alloc,fields->db);
    field->table    = strdup_root(alloc,fields->table);
    field->org_table= strdup_root(alloc,fields->org_table);
    field->name     = strdup_root(alloc,fields->name);
    field->org_name = strdup_root(alloc,fields->org_name);
4047
    field->charsetnr= fields->charsetnr;
4048 4049 4050 4051 4052 4053 4054
    field->length   = fields->length;
    field->type     = fields->type;
    field->flags    = fields->flags;
    field->decimals = fields->decimals;
    field->def      = fields->def ? strdup_root(alloc,fields->def): 0;
    field->max_length= 0;
  }
4055 4056
  return stmt->field_count;
}
4057 4058 4059

/*
  Returns prepared meta information in the form of resultset
4060
  to client.
4061 4062 4063 4064 4065 4066 4067
*/

MYSQL_RES * STDCALL
mysql_prepare_result(MYSQL_STMT *stmt)
{
  MYSQL_RES *result;
  DBUG_ENTER("mysql_prepare_result");
4068 4069
  
  if (!stmt->field_count || !stmt->fields)
4070 4071 4072 4073
  {
    if (!alloc_stmt_fields(stmt))
      DBUG_RETURN(0);
  }  
4074 4075 4076 4077 4078
  if (!(result=(MYSQL_RES*) my_malloc(sizeof(*result)+
				      sizeof(ulong)*stmt->field_count,
				      MYF(MY_WME | MY_ZEROFILL))))
    return 0;

4079 4080 4081 4082
  result->eof=1;	/* Marker for buffered */
  result->fields=	stmt->fields;
  result->field_count=	stmt->field_count;
  DBUG_RETURN(result);
4083 4084
}

4085 4086 4087 4088 4089 4090 4091 4092 4093 4094 4095 4096 4097 4098 4099 4100 4101 4102 4103 4104 4105
/*
  Returns parameter columns meta information in the form of 
  resultset.
*/

MYSQL_RES * STDCALL
mysql_param_result(MYSQL_STMT *stmt)
{
  DBUG_ENTER("mysql_param_result");
  
  if (!stmt->param_count)
    DBUG_RETURN(0);

  /*
    TODO: Fix this when server sends the information. 
    Till then keep a dummy prototype 
  */
  DBUG_RETURN(0); 
}


4106

4107 4108 4109 4110
/********************************************************************
 Prepare-execute, and param handling
*********************************************************************/

4111 4112
/*
  Store the buffer type
4113 4114
*/

4115
static void store_param_type(NET *net, uint type)
4116
{
4117 4118
  int2store(net->write_pos, type);
  net->write_pos+=2;
4119 4120
}

4121
/*
4122
  Store the length of parameter data
4123
  (Same function as in sql/net_pkg.cc)
4124
*/
4125 4126 4127

char *
net_store_length(char *pkg, ulong length)
4128 4129 4130 4131 4132 4133 4134
{
  uchar *packet=(uchar*) pkg;
  if (length < 251)
  {
    *packet=(uchar) length;
    return (char*) packet+1;
  }
4135 4136 4137 4138 4139 4140 4141 4142 4143 4144 4145 4146 4147 4148 4149 4150
  /* 251 is reserved for NULL */
  if (length < 65536L)
  {
    *packet++=252;
    int2store(packet,(uint) length);
    return (char*) packet+2;
  }
  if (length < 16777216L)
  {
    *packet++=253;
    int3store(packet,(ulong) length);
    return (char*) packet+3;
  }
  *packet++=254;
  int8store(packet, (ulonglong) length);
  return (char*) packet+9;
4151 4152 4153
}


4154 4155
/****************************************************************************
  Functions to store parameter data from a prepared statement.
4156

4157
  All functions has the following characteristics:
4158

4159 4160 4161 4162 4163 4164 4165 4166 4167 4168 4169 4170 4171 4172
  SYNOPSIS
    store_param_xxx()
    net			MySQL NET connection
    param		MySQL bind param

  RETURN VALUES
    0	ok
    1	Error	(Can't alloc net->buffer)
****************************************************************************/


static void store_param_tinyint(NET *net, MYSQL_BIND *param)
{
  *(net->write_pos++)= (uchar) *param->buffer;
4173 4174
}

4175 4176 4177 4178 4179 4180
static void store_param_short(NET *net, MYSQL_BIND *param)
{
  short value= *(short*) param->buffer;
  int2store(net->write_pos,value);
  net->write_pos+=2;
}
4181

4182
static void store_param_int32(NET *net, MYSQL_BIND *param)
4183
{
4184 4185 4186 4187
  int32 value= *(int32*) param->buffer;
  int4store(net->write_pos,value);
  net->write_pos+=4;
}
4188

4189 4190 4191 4192 4193 4194
static void store_param_int64(NET *net, MYSQL_BIND *param)
{
  longlong value= *(longlong*) param->buffer;
  int8store(net->write_pos,value);
  net->write_pos+= 8;
}
4195

4196 4197 4198 4199 4200
static void store_param_float(NET *net, MYSQL_BIND *param)
{
  float value= *(float*) param->buffer;
  float4store(net->write_pos, value);
  net->write_pos+= 4;
4201 4202
}

4203 4204 4205 4206 4207 4208
static void store_param_double(NET *net, MYSQL_BIND *param)
{
  double value= *(double*) param->buffer;
  float8store(net->write_pos, value);
  net->write_pos+= 8;
}
4209

4210 4211 4212 4213 4214 4215 4216 4217 4218 4219 4220 4221 4222 4223 4224 4225 4226 4227 4228 4229 4230 4231 4232 4233 4234 4235 4236 4237 4238 4239 4240 4241 4242 4243 4244 4245 4246 4247 4248 4249 4250 4251 4252 4253 4254 4255 4256 4257 4258 4259 4260 4261 4262 4263 4264 4265 4266 4267 4268 4269 4270 4271 4272 4273 4274
static void store_param_time(NET *net, MYSQL_BIND *param)
{
  MYSQL_TIME *tm= (MYSQL_TIME *) param->buffer;
  char buff[15], *pos;
  uint length;

  pos= buff+1;
  pos[0]= tm->neg ? 1: 0;
  int4store(pos+1, tm->day);
  pos[5]= (uchar) tm->hour;
  pos[6]= (uchar) tm->minute;
  pos[7]= (uchar) tm->second;
  int4store(pos+8, tm->second_part);
  if (tm->second_part)
    length= 11;
  else if (tm->hour || tm->minute || tm->second || tm->day)
    length= 8;
  else
    length= 0;
  buff[0]= (char) length++;  
  memcpy((char *)net->write_pos, buff, length);
  net->write_pos+= length;
}

static void net_store_datetime(NET *net, MYSQL_TIME *tm)
{
  char buff[12], *pos;
  uint length;

  pos= buff+1;

  int2store(pos, tm->year);
  pos[2]= (uchar) tm->month;
  pos[3]= (uchar) tm->day;
  pos[4]= (uchar) tm->hour;
  pos[5]= (uchar) tm->minute;
  pos[6]= (uchar) tm->second;
  int4store(pos+7, tm->second_part);
  if (tm->second_part)
    length= 11;
  else if (tm->hour || tm->minute || tm->second)
    length= 7;
  else if (tm->year || tm->month || tm->day)
    length= 4;
  else
    length= 0;
  buff[0]= (char) length++;  
  memcpy((char *)net->write_pos, buff, length);
  net->write_pos+= length;
}

static void store_param_date(NET *net, MYSQL_BIND *param)
{
  MYSQL_TIME *tm= (MYSQL_TIME *) param->buffer;
  tm->hour= tm->minute= tm->second= 0;
  tm->second_part= 0;
  net_store_datetime(net, tm);
}

static void store_param_datetime(NET *net, MYSQL_BIND *param)
{
  MYSQL_TIME *tm= (MYSQL_TIME *) param->buffer;
  net_store_datetime(net, tm);
}
    
4275
static void store_param_str(NET *net, MYSQL_BIND *param)
4276
{
4277
  ulong length= min(*param->length, param->buffer_length);
4278 4279
  char *to= (char *) net_store_length((char *) net->write_pos, length);
  memcpy(to, param->buffer, length);
4280
  net->write_pos= (uchar*) to+length;
4281 4282
}

4283

4284
/*
4285 4286 4287 4288 4289 4290 4291 4292 4293 4294
  Mark if the parameter is NULL.

  SYNOPSIS
    store_param_null()
    net			MySQL NET connection
    param		MySQL bind param

  DESCRIPTION
    A data package starts with a string of bits where we set a bit
    if a parameter is NULL
4295 4296
*/

4297
static void store_param_null(NET *net, MYSQL_BIND *param)
4298
{
4299
  uint pos= param->param_number;
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
4300
  net->buff[pos/8]|=  (uchar) (1 << (pos & 7));
4301
}
4302 4303 4304 4305


/*
  Set parameter data by reading from input buffers from the
4306
  client application
4307 4308
*/

4309

4310
static my_bool store_param(MYSQL_STMT *stmt, MYSQL_BIND *param)
4311
{
4312 4313 4314
  MYSQL *mysql= stmt->mysql;
  NET	*net  = &mysql->net;
  DBUG_ENTER("store_param");
4315 4316 4317 4318 4319 4320
  DBUG_PRINT("enter",("type: %d, buffer:%lx, length: %lu  is_null: %d",
		      param->buffer_type,
		      param->buffer ? param->buffer : "0", *param->length,
		      *param->is_null));

  if (*param->is_null)
4321 4322
    store_param_null(net, param);
  else
venu@myvenu.com's avatar
venu@myvenu.com committed
4323
  {
4324 4325
    /*
      Param->length should ALWAYS point to the correct length for the type
4326
      Either to the length pointer given by the user or param->buffer_length
4327 4328
    */
    if ((my_realloc_str(net, 9 + *param->length)))
4329 4330
    {
      set_stmt_error(stmt, CR_OUT_OF_MEMORY);
venu@myvenu.com's avatar
venu@myvenu.com committed
4331
      DBUG_RETURN(1);
4332
    }
4333
    (*param->store_param_func)(net, param);
venu@myvenu.com's avatar
venu@myvenu.com committed
4334 4335
  }
  DBUG_RETURN(0);
4336 4337
}

4338

4339 4340 4341 4342
/*
  Send the prepare query to server for execution
*/

4343
static my_bool execute(MYSQL_STMT * stmt, char *packet, ulong length)
4344
{
4345 4346
  MYSQL *mysql= stmt->mysql;
  NET	*net= &mysql->net;
venu@myvenu.com's avatar
venu@myvenu.com committed
4347
  char buff[MYSQL_STMT_HEADER];
4348
  DBUG_ENTER("execute");
4349 4350
  DBUG_PRINT("enter",("packet: %s, length :%d",packet ? packet :" ", length));

4351 4352
  mysql->last_used_con= mysql;
  int4store(buff, stmt->stmt_id);		/* Send stmt id to server */
venu@myvenu.com's avatar
venu@myvenu.com committed
4353
  if (advanced_command(mysql, COM_EXECUTE, buff, MYSQL_STMT_HEADER, packet,
4354
		       length, 1) ||
4355 4356 4357
      mysql_read_query_result(mysql))
  {
    set_stmt_errmsg(stmt, net->last_error, net->last_errno);
4358
    DBUG_RETURN(1);
4359
  }
4360
  stmt->state= MY_ST_EXECUTE;
venu@myvenu.com's avatar
venu@myvenu.com committed
4361
  mysql_free_result(stmt->result);
4362 4363
  stmt->result= (MYSQL_RES *)0;
  stmt->result_buffered= 0;
4364 4365 4366
  DBUG_RETURN(0);
}

4367 4368 4369

/*
  Execute the prepare query
4370 4371
*/

4372
int STDCALL mysql_execute(MYSQL_STMT *stmt)
4373 4374 4375 4376 4377 4378
{
  DBUG_ENTER("mysql_execute");

  if (stmt->state == MY_ST_UNKNOWN)
  {
    set_stmt_error(stmt, CR_NO_PREPARE_STMT);
4379
    DBUG_RETURN(1);
4380 4381 4382
  }
  if (stmt->param_count)
  {
4383 4384
    NET        *net= &stmt->mysql->net;
    MYSQL_BIND *param, *param_end;
4385
    char       *param_data;
venu@myvenu.com's avatar
venu@myvenu.com committed
4386 4387 4388
    ulong length;
    uint null_count;
    my_bool    result;
4389

venu@myvenu.com's avatar
venu@myvenu.com committed
4390 4391
#ifdef CHECK_EXTRA_ARGUMENTS
    if (!stmt->param_buffers)
4392 4393 4394
    {
      /* Parameters exists, but no bound buffers */
      set_stmt_error(stmt, CR_NOT_ALL_PARAMS_BOUND);
4395
      DBUG_RETURN(1);
4396
    }
venu@myvenu.com's avatar
venu@myvenu.com committed
4397
#endif
4398 4399 4400 4401 4402 4403 4404 4405
    net_clear(net);				/* Sets net->write_pos */
    /* Reserve place for null-marker bytes */
    null_count= (stmt->param_count+7) /8;
    bzero((char*) net->write_pos, null_count);
    net->write_pos+= null_count;
    param_end= stmt->params + stmt->param_count;

    /* In case if buffers (type) altered, indicate to server */
venu@myvenu.com's avatar
venu@myvenu.com committed
4406 4407
    *(net->write_pos)++= (uchar) stmt->send_types_to_server;
    if (stmt->send_types_to_server)
4408
    {
4409 4410 4411 4412 4413 4414 4415 4416 4417
      /*
	Store types of parameters in first in first package
	that is sent to the server.
      */
      for (param= stmt->params;	param < param_end ; param++)
	store_param_type(net, (uint) param->buffer_type);
    }

    for (param= stmt->params; param < param_end; param++)
4418
    {
4419 4420 4421
      /* check if mysql_long_data() was used */
      if (param->long_data_used)
	param->long_data_used= 0;	/* Clear for next execute call */
4422
      else if (store_param(stmt, param))
4423
	DBUG_RETURN(1);
4424
    }
4425 4426
    length= (ulong) (net->write_pos - net->buff);
    /* TODO: Look into avoding the following memdup */
4427
    if (!(param_data= my_memdup((const char*) net->buff, length, MYF(0))))
4428 4429 4430
    {
      set_stmt_error(stmt, CR_OUT_OF_MEMORY);
      DBUG_RETURN(1);
4431
    }
4432 4433
    net->write_pos= net->buff;			/* Reset for net_write() */
    result= execute(stmt, param_data, length);
venu@myvenu.com's avatar
venu@myvenu.com committed
4434
    stmt->send_types_to_server=0;
4435
    my_free(param_data, MYF(MY_WME));
4436 4437 4438
    DBUG_RETURN(result);
  }
  DBUG_RETURN((int) execute(stmt,0,0));
4439 4440
}

4441

4442 4443 4444 4445 4446 4447 4448 4449 4450 4451
/*
  Return total parameters count in the statement
*/

ulong STDCALL mysql_param_count(MYSQL_STMT * stmt)
{
  DBUG_ENTER("mysql_param_count");
  DBUG_RETURN(stmt->param_count);
}

4452 4453 4454 4455 4456 4457 4458 4459
/*
  Return total affected rows from the last statement
*/

my_ulonglong STDCALL mysql_stmt_affected_rows(MYSQL_STMT *stmt)
{
  return stmt->mysql->last_used_con->affected_rows;
}
4460

4461 4462 4463 4464

static my_bool int_is_null_true= 1;		/* Used for MYSQL_TYPE_NULL */
static my_bool int_is_null_false= 0;
static my_bool int_is_null_dummy;
4465
static unsigned long param_length_is_dummy;
4466

4467
/*
4468
  Setup the parameter data buffers from application
4469 4470
*/

4471
my_bool STDCALL mysql_bind_param(MYSQL_STMT *stmt, MYSQL_BIND * bind)
4472
{
4473 4474
  uint count=0;
  MYSQL_BIND *param, *end;
4475 4476 4477 4478 4479 4480
  DBUG_ENTER("mysql_bind_param");

#ifdef CHECK_EXTRA_ARGUMENTS
  if (stmt->state == MY_ST_UNKNOWN)
  {
    set_stmt_error(stmt, CR_NO_PREPARE_STMT);
4481
    DBUG_RETURN(1);
4482 4483 4484 4485
  }
  if (!stmt->param_count)
  {
    set_stmt_error(stmt, CR_NO_PARAMETERS_EXISTS);
4486
    DBUG_RETURN(1);
4487 4488 4489
  }
#endif

4490 4491 4492 4493 4494 4495 4496
  /* Allocated on prepare */
  memcpy((char*) stmt->params, (char*) bind,
	 sizeof(MYSQL_BIND) * stmt->param_count);

  for (param= stmt->params, end= param+stmt->param_count;
       param < end ;
       param++)
4497
  {
4498
    param->param_number= count++;
4499 4500
    param->long_data_used= 0;

4501
    /*
4502
      If param->length is not given, change it to point to buffer_length.
4503 4504 4505
      This way we can always use *param->length to get the length of data
    */
    if (!param->length)
4506
      param->length= &param->buffer_length;
peter@mysql.com's avatar
peter@mysql.com committed
4507

4508 4509 4510 4511
    /* If param->is_null is not set, then the value can never be NULL */
    if (!param->is_null)
      param->is_null= &int_is_null_false;

4512 4513
    /* Setup data copy functions for the different supported types */
    switch (param->buffer_type) {
venu@myvenu.com's avatar
venu@myvenu.com committed
4514
    case MYSQL_TYPE_NULL:
4515
      param->is_null= &int_is_null_true;
venu@myvenu.com's avatar
venu@myvenu.com committed
4516
      break;
4517
    case MYSQL_TYPE_TINY:
4518
      /* Force param->length as this is fixed for this type */
4519 4520
      param->length= &param->buffer_length;
      param->buffer_length= 1;
4521 4522 4523
      param->store_param_func= store_param_tinyint;
      break;
    case MYSQL_TYPE_SHORT:
4524 4525
      param->length= &param->buffer_length;
      param->buffer_length= 2;
4526 4527 4528
      param->store_param_func= store_param_short;
      break;
    case MYSQL_TYPE_LONG:
4529 4530
      param->length= &param->buffer_length;
      param->buffer_length= 4;
4531 4532 4533
      param->store_param_func= store_param_int32;
      break;
    case MYSQL_TYPE_LONGLONG:
4534 4535
      param->length= &param->buffer_length;
      param->buffer_length= 8;
4536 4537 4538
      param->store_param_func= store_param_int64;
      break;
    case MYSQL_TYPE_FLOAT:
4539 4540
      param->length= &param->buffer_length;
      param->buffer_length= 4;
4541 4542 4543
      param->store_param_func= store_param_float;
      break;
    case MYSQL_TYPE_DOUBLE:
4544 4545
      param->length= &param->buffer_length;
      param->buffer_length= 8;
4546 4547
      param->store_param_func= store_param_double;
      break;
4548 4549 4550 4551 4552 4553 4554 4555 4556 4557 4558
    case MYSQL_TYPE_TIME:
      /* Buffer length ignored for DATE, TIME and DATETIME */
      param->store_param_func= store_param_time;
      break;
    case MYSQL_TYPE_DATE:
      param->store_param_func= store_param_date;
      break;
    case MYSQL_TYPE_DATETIME:
    case MYSQL_TYPE_TIMESTAMP:
      param->store_param_func= store_param_datetime;
      break;
4559 4560 4561
    case MYSQL_TYPE_TINY_BLOB:
    case MYSQL_TYPE_MEDIUM_BLOB:
    case MYSQL_TYPE_LONG_BLOB:
venu@myvenu.com's avatar
venu@myvenu.com committed
4562
    case MYSQL_TYPE_BLOB:
4563 4564 4565 4566 4567
    case MYSQL_TYPE_VAR_STRING:
    case MYSQL_TYPE_STRING:
      param->store_param_func= store_param_str;
      break;
    default:
4568 4569
      sprintf(stmt->last_error,
	      ER(stmt->last_errno= CR_UNSUPPORTED_PARAM_TYPE),
4570
	      param->buffer_type, count);
4571
      DBUG_RETURN(1);
4572 4573
    }
  }
4574
  /* We have to send/resendtype information to MySQL */
venu@myvenu.com's avatar
venu@myvenu.com committed
4575 4576
  stmt->send_types_to_server= 1;
  stmt->param_buffers= 1;
4577 4578 4579
  DBUG_RETURN(0);
}

4580

4581 4582 4583 4584 4585
/********************************************************************
 Long data implementation
*********************************************************************/

/*
4586 4587 4588 4589 4590 4591 4592 4593
  Send long data in pieces to the server

  SYNOPSIS
    mysql_send_long_data()
    stmt			Statement handler
    param_number		Parameter number (0 - N-1)
    data			Data to send to server
    length			Length of data to send (may be 0)
4594

4595
  RETURN VALUES
4596 4597
    0	ok
    1	error
4598 4599 4600
*/


4601 4602
my_bool STDCALL
mysql_send_long_data(MYSQL_STMT *stmt, uint param_number,
4603
		     const char *data, ulong length)
4604 4605 4606
{
  MYSQL_BIND *param;
  DBUG_ENTER("mysql_send_long_data");
4607
  DBUG_ASSERT(stmt != 0);
4608
  DBUG_PRINT("enter",("param no : %d, data : %lx, length : %ld",
4609
		      param_number, data, length));
4610

4611
  if (param_number >= stmt->param_count)
4612 4613 4614 4615
  {
    set_stmt_error(stmt, CR_INVALID_PARAMETER_NO);
    DBUG_RETURN(1);
  }
4616
  param= stmt->params+param_number;
4617 4618 4619 4620 4621 4622 4623 4624 4625 4626 4627 4628 4629
  if (param->buffer_type < MYSQL_TYPE_TINY_BLOB ||
      param->buffer_type > MYSQL_TYPE_STRING)
  {
    /*
      Long data handling should be used only for string/binary
      types only
    */
    sprintf(stmt->last_error, ER(stmt->last_errno= CR_INVALID_BUFFER_USE),
	    param->param_number);
    DBUG_RETURN(1);
  }
  /* Mark for execute that the result is already sent */
  param->long_data_used= 1;
4630
  if (length)
4631
  {
4632 4633 4634 4635 4636 4637
    MYSQL *mysql= stmt->mysql;
    char   *packet, extra_data[MYSQL_LONG_DATA_HEADER];

    packet= extra_data;
    int4store(packet, stmt->stmt_id);	   packet+=4;
    int2store(packet, param_number);	   packet+=2;
4638

4639 4640 4641 4642 4643 4644
    /*
      Note that we don't get any ok packet from the server in this case
      This is intentional to save bandwidth.
    */
    if (advanced_command(mysql, COM_LONG_DATA, extra_data,
			 MYSQL_LONG_DATA_HEADER, data, length, 1))
4645
    {
4646 4647
      set_stmt_errmsg(stmt,(char *) mysql->net.last_error,
		      mysql->net.last_errno);
4648 4649 4650 4651 4652 4653
      DBUG_RETURN(1);
    }
  }
  DBUG_RETURN(0);
}

4654

4655
/********************************************************************
4656
  Fetch-bind related implementations
4657 4658
*********************************************************************/

venu@myvenu.com's avatar
venu@myvenu.com committed
4659 4660 4661 4662 4663 4664 4665 4666 4667 4668 4669 4670 4671 4672 4673
/****************************************************************************
  Functions to fetch data to application buffers

  All functions has the following characteristics:

  SYNOPSIS
    fetch_result_xxx()
    param   MySQL bind param
    row     Row value

  RETURN VALUES
    0	ok
    1	Error	(Can't alloc net->buffer)
****************************************************************************/

4674
static void set_zero_time(MYSQL_TIME *tm)
4675
{
4676 4677 4678 4679 4680 4681 4682 4683 4684 4685 4686 4687 4688 4689 4690 4691 4692 4693 4694 4695 4696 4697 4698 4699 4700 4701 4702 4703 4704 4705 4706 4707 4708 4709 4710 4711 4712 4713 4714 4715 4716 4717 4718 4719 4720 4721 4722 4723 4724 4725 4726 4727 4728 4729 4730 4731 4732 4733 4734 4735 4736 4737 4738 4739 4740 4741 4742 4743 4744 4745 4746
  tm->year= tm->month= tm->day= 0;
  tm->hour= tm->minute= tm->second= 0;
  tm->second_part= 0;
  tm->neg= (bool)0;
}

/* Read TIME from binary packet and return it to MYSQL_TIME */
static uint read_binary_time(MYSQL_TIME *tm, uchar **pos)
{
  uchar *to;
  uint  length;
 
  if (!(length= net_field_length(pos)))
  {
    set_zero_time(tm);
    return 0;
  }
  
  to= *pos;     
  tm->second_part= (length > 8 ) ? (ulong) sint4korr(to+7): 0;

  tm->day=    (ulong) sint4korr(to+1);
  tm->hour=   (uint) to[5];
  tm->minute= (uint) to[6];
  tm->second= (uint) to[7];

  tm->year= tm->month= 0;
  tm->neg= (bool)to[0];
  return length;
}

/* Read DATETIME from binary packet and return it to MYSQL_TIME */
static uint read_binary_datetime(MYSQL_TIME *tm, uchar **pos)
{
  uchar *to;
  uint  length;
 
  if (!(length= net_field_length(pos)))
  {
    set_zero_time(tm);
    return 0;
  }
  
  to= *pos;     
  tm->second_part= (length > 7 ) ? (ulong) sint4korr(to+7): 0;
    
  if (length > 4)
  {
    tm->hour=   (uint) to[4];
    tm->minute= (uint) to[5];
    tm->second= (uint) to[6];
  }
  else
    tm->hour= tm->minute= tm->second= 0;
    
  tm->year=   (uint) sint2korr(to);
  tm->month=  (uint) to[2];
  tm->day=    (uint) to[3];
  tm->neg=    0;
  return length;
}

/* Read DATE from binary packet and return it to MYSQL_TIME */
static uint read_binary_date(MYSQL_TIME *tm, uchar **pos)
{
  uchar *to;
  uint  length;
 
  if (!(length= net_field_length(pos)))
  {
    set_zero_time(tm);
4747
    return 0;
4748
  }
4749 4750 4751 4752 4753 4754 4755 4756 4757 4758
  
  to= *pos;     
  tm->year =  (uint) sint2korr(to);
  tm->month=  (uint) to[2];
  tm->day= (uint) to[3];

  tm->hour= tm->minute= tm->second= 0;
  tm->second_part= 0;
  tm->neg= 0;
  return length;
4759 4760
}

4761
/* Convert Numeric to buffer types */
4762 4763 4764 4765 4766 4767 4768 4769 4770
static void send_data_long(MYSQL_BIND *param, longlong value)
{  
  char *buffer= param->buffer;
  
  switch(param->buffer_type) {
  case MYSQL_TYPE_TINY:
    *param->buffer= (uchar) value;
    break;
  case MYSQL_TYPE_SHORT:
4771
    int2store(buffer, value);
4772 4773
    break;
  case MYSQL_TYPE_LONG:
4774
    int4store(buffer, value);
4775 4776
    break;
  case MYSQL_TYPE_LONGLONG:
4777
    int8store(buffer, value);
4778 4779 4780 4781 4782 4783 4784 4785 4786 4787 4788 4789 4790 4791 4792
    break;
  case MYSQL_TYPE_FLOAT:
    {
      float data= (float)value;
      float4store(buffer, data);
      break;
    }
  case MYSQL_TYPE_DOUBLE:
    {
      double data= (double)value;
      float8store(buffer, data);
      break;
    }
  default:
    {
4793
      uint length= (uint)(longlong10_to_str(value,buffer,10)-buffer);
4794 4795 4796 4797 4798 4799
      *param->length= length;
      buffer[length]='\0';
    }
  } 
}

4800

4801
/* Convert Double to buffer types */
4802 4803 4804 4805 4806 4807 4808 4809 4810 4811 4812 4813
static void send_data_double(MYSQL_BIND *param, double value)
{  
  char *buffer= param->buffer;

  switch(param->buffer_type) {
  case MYSQL_TYPE_TINY:
    *buffer= (uchar)value;
    break;
  case MYSQL_TYPE_SHORT:
    int2store(buffer, (short)value);
    break;
  case MYSQL_TYPE_LONG:
4814
    int4store(buffer, (long)value);
4815 4816 4817 4818 4819 4820 4821 4822 4823 4824 4825 4826 4827 4828 4829 4830 4831 4832
    break;
  case MYSQL_TYPE_LONGLONG:
    int8store(buffer, (longlong)value);
    break;
  case MYSQL_TYPE_FLOAT:
    {
      float data= (float)value;
      float4store(buffer, data);
      break;
    }
  case MYSQL_TYPE_DOUBLE:
    {
      double data= (double)value;
      float8store(buffer, data);
      break;
    }
  default:
    {
4833
      uint length= my_sprintf(buffer,(buffer,"%g",value));
4834 4835 4836 4837 4838 4839
      *param->length= length;
      buffer[length]='\0';
    }
  } 
}

4840 4841
/* Convert string to buffer types */
static void send_data_str(MYSQL_BIND *param, char *value, uint length)
4842 4843
{  
  char *buffer= param->buffer;
4844
  int err=0;
4845 4846 4847

  switch(param->buffer_type) {
  case MYSQL_TYPE_TINY:
4848
  {
4849
    uchar data= (uchar)my_strntol(&my_charset_latin1,value,length,10,NULL,
4850
				  &err);
4851
    *buffer= data;
4852
    break;
4853
  }
4854 4855
  case MYSQL_TYPE_SHORT:
  {
4856
    short data= (short)my_strntol(&my_charset_latin1,value,length,10,NULL,
4857
				  &err);
4858 4859 4860 4861 4862
    int2store(buffer, data);
    break;
  }
  case MYSQL_TYPE_LONG:
  {
4863
    int32 data= (int32)my_strntol(&my_charset_latin1,value,length,10,NULL,
4864
				  &err);
4865 4866 4867 4868 4869
    int4store(buffer, data);    
    break;
  }
  case MYSQL_TYPE_LONGLONG:
  {
4870
    longlong data= my_strntoll(&my_charset_latin1,value,length,10,NULL,&err);
4871 4872 4873 4874 4875
    int8store(buffer, data);
    break;
  }
  case MYSQL_TYPE_FLOAT:
  {
4876
    float data = (float)my_strntod(&my_charset_latin1,value,length,NULL,&err);
4877 4878 4879 4880 4881
    float4store(buffer, data);
    break;
  }
  case MYSQL_TYPE_DOUBLE:
  {
4882
    double data= my_strntod(&my_charset_latin1,value,length,NULL,&err);
4883 4884 4885 4886
    float8store(buffer, data);
    break;
  }
  default:
4887
    *param->length= length;
4888
    length= min(length, param->buffer_length);
4889
    memcpy(buffer, value, length);
4890 4891
    if (length != param->buffer_length)
      buffer[length]='\0';
4892 4893 4894
  } 
}

4895 4896 4897 4898 4899 4900 4901 4902 4903 4904 4905 4906 4907 4908 4909 4910 4911 4912 4913 4914 4915 4916 4917 4918 4919 4920 4921 4922 4923 4924 4925 4926 4927 4928 4929 4930 4931 4932 4933 4934 4935 4936 4937 4938 4939 4940 4941 4942 4943 4944 4945 4946 4947 4948
static void send_data_time(MYSQL_BIND *param, MYSQL_TIME ltime, 
                           uint length)
{
  switch (param->buffer_type) {

  case MYSQL_TYPE_DATE:
  case MYSQL_TYPE_TIME:
  case MYSQL_TYPE_DATETIME:
  case MYSQL_TYPE_TIMESTAMP:
  {
    MYSQL_TIME *tm= (MYSQL_TIME *)param->buffer;
    
    tm->year= ltime.year;
    tm->month= ltime.month;
    tm->day= ltime.day;

    tm->hour= ltime.hour;
    tm->minute= ltime.minute;
    tm->second= ltime.second;

    tm->second_part= ltime.second_part;
    tm->neg= ltime.neg;
    break;   
  }
  default:
  {
    char buff[25];
    
    if (!length)
      ltime.time_type= MYSQL_TIMESTAMP_NONE;
    switch (ltime.time_type) {
    case MYSQL_TIMESTAMP_DATE:
      length= my_sprintf(buff,(buff, "%04d-%02d-%02d", ltime.year,
                         ltime.month,ltime.day));      
      break;
    case MYSQL_TIMESTAMP_FULL:
      length= my_sprintf(buff,(buff, "%04d-%02d-%02d %02d:%02d:%02d",
	                       ltime.year,ltime.month,ltime.day,
	                       ltime.hour,ltime.minute,ltime.second));
      break;
    case MYSQL_TIMESTAMP_TIME:
      length= my_sprintf(buff, (buff, "%02d:%02d:%02d",
	                 	     ltime.hour,ltime.minute,ltime.second));
      break;
    default:
      length= 0;
      buff[0]='\0';
    }
    send_data_str(param, (char *)buff, length); 
  }
  }
}
                              

4949

4950
/* Fetch data to buffers */
4951 4952
static void fetch_results(MYSQL_BIND *param, uint field_type, uchar **row, 
                          my_bool field_is_unsigned)
4953 4954
{
  ulong length;
4955
  
4956 4957 4958
  switch (field_type) {
  case MYSQL_TYPE_TINY:
  {
4959 4960 4961 4962
    char value= (char) **row;
    longlong data= (field_is_unsigned) ? (longlong) (unsigned char) value:
                                         (longlong) value;
    send_data_long(param,data);
4963
    length= 1;
4964 4965 4966 4967 4968
    break;
  }
  case MYSQL_TYPE_SHORT:
  case MYSQL_TYPE_YEAR:
  {
4969 4970 4971 4972 4973
    short value= sint2korr(*row);
    longlong data= (field_is_unsigned) ? (longlong) (unsigned short) value:
                                         (longlong) value;
    send_data_long(param,data);
    length= 2;    
4974 4975 4976 4977
    break;
  }
  case MYSQL_TYPE_LONG:
  {
4978 4979 4980 4981
    long value= sint4korr(*row);
    longlong data= (field_is_unsigned) ? (longlong) (unsigned long) value:
                                         (longlong) value;
    send_data_long(param,data);
4982
    length= 4;
4983 4984 4985 4986 4987 4988
    break;
  }
  case MYSQL_TYPE_LONGLONG:
  {
    longlong value= (longlong)sint8korr(*row);
    send_data_long(param,value);
4989
    length= 8;
4990 4991 4992 4993 4994 4995
    break;
  }
  case MYSQL_TYPE_FLOAT:
  {
    float value;
    float4get(value,*row);
4996
    send_data_double(param,value);
4997
    length= 4;
4998 4999 5000 5001 5002 5003
    break;
  }
  case MYSQL_TYPE_DOUBLE:
  {
    double value;
    float8get(value,*row);
5004
    send_data_double(param,value);
5005
    length= 8;
5006 5007 5008 5009
    break;
  }
  case MYSQL_TYPE_DATE:
  {
5010 5011 5012 5013 5014
    MYSQL_TIME tm;
 
    length= read_binary_date(&tm,row);
    tm.time_type= MYSQL_TIMESTAMP_DATE;
    send_data_time(param, tm, length);
5015 5016 5017 5018
    break;
  }
  case MYSQL_TYPE_TIME:
  {
5019 5020 5021 5022 5023 5024 5025 5026 5027 5028 5029 5030 5031 5032 5033
    MYSQL_TIME tm;
 
    length= read_binary_time(&tm, row);
    tm.time_type= MYSQL_TIMESTAMP_TIME;
    send_data_time(param, tm, length);
    break;
  }
  case MYSQL_TYPE_DATETIME:
  case MYSQL_TYPE_TIMESTAMP:
  {
    MYSQL_TIME tm;
 
    length= read_binary_datetime(&tm, row);
    tm.time_type= MYSQL_TIMESTAMP_FULL;
    send_data_time(param, tm, length);
5034 5035 5036 5037
    break;
  }
  default:      
    length= net_field_length(row); 
5038
    send_data_str(param,(char*) *row,length);
5039 5040 5041 5042 5043
    break;
  }
  *row+= length;
}

venu@myvenu.com's avatar
venu@myvenu.com committed
5044 5045 5046
static void fetch_result_tinyint(MYSQL_BIND *param, uchar **row)
{
  *param->buffer= (uchar) **row;
5047
  (*row)++;
venu@myvenu.com's avatar
venu@myvenu.com committed
5048 5049 5050 5051
}

static void fetch_result_short(MYSQL_BIND *param, uchar **row)
{
5052 5053 5054
  short value = (short)sint2korr(*row);
  int2store(param->buffer, value);
  *row+= 2;
venu@myvenu.com's avatar
venu@myvenu.com committed
5055 5056 5057 5058
}

static void fetch_result_int32(MYSQL_BIND *param, uchar **row)
{
5059
  int32 value= (int32)sint4korr(*row);
venu@myvenu.com's avatar
venu@myvenu.com committed
5060
  int4store(param->buffer, value);
5061
  *row+= 4;
venu@myvenu.com's avatar
venu@myvenu.com committed
5062 5063 5064
}

static void fetch_result_int64(MYSQL_BIND *param, uchar **row)
5065 5066
{  
  longlong value= (longlong)sint8korr(*row);
venu@myvenu.com's avatar
venu@myvenu.com committed
5067
  int8store(param->buffer, value);
5068
  *row+= 8;
venu@myvenu.com's avatar
venu@myvenu.com committed
5069 5070 5071 5072 5073 5074
}

static void fetch_result_float(MYSQL_BIND *param, uchar **row)
{
  float value;
  float4get(value,*row);
5075
  float4store(param->buffer, value);
5076
  *row+= 4;
venu@myvenu.com's avatar
venu@myvenu.com committed
5077 5078 5079 5080 5081 5082 5083
}

static void fetch_result_double(MYSQL_BIND *param, uchar **row)
{
  double value;
  float8get(value,*row);
  float8store(param->buffer, value);
5084
  *row+= 8;
venu@myvenu.com's avatar
venu@myvenu.com committed
5085 5086
}

5087 5088 5089 5090 5091 5092 5093 5094 5095 5096 5097 5098 5099 5100 5101 5102 5103 5104
static void fetch_result_time(MYSQL_BIND *param, uchar **row)
{
  MYSQL_TIME *tm= (MYSQL_TIME *)param->buffer;
  *row+= read_binary_time(tm, row);
}

static void fetch_result_date(MYSQL_BIND *param, uchar **row)
{
  MYSQL_TIME *tm= (MYSQL_TIME *)param->buffer;
  *row+= read_binary_date(tm, row);
}

static void fetch_result_datetime(MYSQL_BIND *param, uchar **row)
{
  MYSQL_TIME *tm= (MYSQL_TIME *)param->buffer;
  *row+= read_binary_datetime(tm, row);
}

5105

venu@myvenu.com's avatar
venu@myvenu.com committed
5106 5107 5108
static void fetch_result_str(MYSQL_BIND *param, uchar **row)
{
  ulong length= net_field_length(row);
5109 5110
  ulong copy_length= min(length, param->buffer_length);
  memcpy(param->buffer, (char *)*row, copy_length);
5111 5112 5113
  /* Add an end null if there is room in the buffer */
  if (copy_length != param->buffer_length)
    *(param->buffer+copy_length)= '\0';
5114
  *param->length= length;			/* return total length */
5115
  *row+= length;
venu@myvenu.com's avatar
venu@myvenu.com committed
5116 5117
}

5118
/*
5119
  Setup the bind buffers for resultset processing
5120 5121
*/

5122
my_bool STDCALL mysql_bind_result(MYSQL_STMT *stmt, MYSQL_BIND *bind)
5123
{
5124 5125
  MYSQL_BIND *param, *end;
  ulong       bind_count;
5126
  uint        param_count= 0;
5127 5128 5129
  DBUG_ENTER("mysql_bind_result");
  DBUG_ASSERT(stmt != 0);

venu@myvenu.com's avatar
venu@myvenu.com committed
5130
#ifdef CHECK_EXTRA_ARGUMENTS
5131 5132 5133 5134 5135
  if (stmt->state == MY_ST_UNKNOWN)
  {
    set_stmt_error(stmt, CR_NO_PREPARE_STMT);
    DBUG_RETURN(1);
  }
5136 5137 5138
  if (!bind)
  {
    set_stmt_error(stmt, CR_NULL_POINTER);
5139
    DBUG_RETURN(1);
5140
  }
5141
#endif
5142 5143 5144 5145
  if (!(bind_count= stmt->field_count) && 
      !(bind_count= alloc_stmt_fields(stmt)))
    DBUG_RETURN(0);
  
5146 5147
  memcpy((char*) stmt->bind, (char*) bind,
	 sizeof(MYSQL_BIND)*bind_count);
5148

5149
  for (param= stmt->bind, end= param+bind_count; param < end ; param++)
5150
  {
5151 5152 5153 5154 5155 5156 5157
    /*
      Set param->is_null to point to a dummy variable if it's not set.
      This is to make the excute code easier
    */
    if (!param->is_null)
      param->is_null= &int_is_null_dummy;

5158
    if (!param->length)
5159
      param->length= &param_length_is_dummy;
5160

5161
    param->param_number= param_count++;
venu@myvenu.com's avatar
venu@myvenu.com committed
5162 5163 5164 5165
    /* Setup data copy functions for the different supported types */
    switch (param->buffer_type) {
    case MYSQL_TYPE_TINY:
      param->fetch_result= fetch_result_tinyint;
5166
      *param->length= 1;
venu@myvenu.com's avatar
venu@myvenu.com committed
5167 5168 5169
      break;
    case MYSQL_TYPE_SHORT:
      param->fetch_result= fetch_result_short;
5170
      *param->length= 2;
venu@myvenu.com's avatar
venu@myvenu.com committed
5171 5172 5173
      break;
    case MYSQL_TYPE_LONG:
      param->fetch_result= fetch_result_int32;
5174
      *param->length= 4;
venu@myvenu.com's avatar
venu@myvenu.com committed
5175 5176 5177
      break;
    case MYSQL_TYPE_LONGLONG:
      param->fetch_result= fetch_result_int64;
5178
      *param->length= 8;
venu@myvenu.com's avatar
venu@myvenu.com committed
5179 5180 5181
      break;
    case MYSQL_TYPE_FLOAT:
      param->fetch_result= fetch_result_float;
5182
      *param->length= 4;
venu@myvenu.com's avatar
venu@myvenu.com committed
5183 5184 5185
      break;
    case MYSQL_TYPE_DOUBLE:
      param->fetch_result= fetch_result_double;
5186 5187 5188 5189 5190 5191 5192 5193 5194 5195 5196 5197 5198 5199
      *param->length= 8;
      break;
    case MYSQL_TYPE_TIME:
      param->fetch_result= fetch_result_time;
      *param->length= sizeof(MYSQL_TIME);
      break;
    case MYSQL_TYPE_DATE:
      param->fetch_result= fetch_result_date;
      *param->length= sizeof(MYSQL_TIME);
      break;
    case MYSQL_TYPE_DATETIME:
    case MYSQL_TYPE_TIMESTAMP:
      param->fetch_result= fetch_result_datetime;
      *param->length= sizeof(MYSQL_TIME);
venu@myvenu.com's avatar
venu@myvenu.com committed
5200 5201 5202 5203
      break;
    case MYSQL_TYPE_TINY_BLOB:
    case MYSQL_TYPE_MEDIUM_BLOB:
    case MYSQL_TYPE_LONG_BLOB:
5204
    case MYSQL_TYPE_BLOB:
venu@myvenu.com's avatar
venu@myvenu.com committed
5205 5206
    case MYSQL_TYPE_VAR_STRING:
    case MYSQL_TYPE_STRING:
5207
      DBUG_ASSERT(param->buffer_length != 0);
venu@myvenu.com's avatar
venu@myvenu.com committed
5208 5209 5210
      param->fetch_result= fetch_result_str;
      break;
    default:
5211 5212
      sprintf(stmt->last_error,
	      ER(stmt->last_errno= CR_UNSUPPORTED_PARAM_TYPE),
5213
	      param->buffer_type, param_count);
venu@myvenu.com's avatar
venu@myvenu.com committed
5214
      DBUG_RETURN(1);
peter@mysql.com's avatar
peter@mysql.com committed
5215
    }
5216
  }
venu@myvenu.com's avatar
venu@myvenu.com committed
5217
  stmt->res_buffers= 1;
5218 5219 5220 5221
  DBUG_RETURN(0);
}

/*
5222
  Fetch row data to bind buffers
5223 5224
*/

5225
static int stmt_fetch_row(MYSQL_STMT *stmt, uchar *row)
5226
{
5227
  MYSQL_BIND  *bind, *end;
5228
  MYSQL_FIELD *field, *field_end;
5229
  uchar *null_ptr, bit;
5230 5231 5232

  if (!row || !stmt->res_buffers)
    return 0;
5233 5234
  
  null_ptr= row; 
5235 5236
  row+= (stmt->field_count+9)/8;		/* skip null bits */
  bit= 4;					/* first 2 bits are reserved */
5237
  
venu@myvenu.com's avatar
venu@myvenu.com committed
5238
  /* Copy complete row to application buffers */
5239
  for (bind= stmt->bind, end= (MYSQL_BIND *) bind + stmt->field_count, 
5240 5241 5242
       field= stmt->fields, 
       field_end= (MYSQL_FIELD *)stmt->fields+stmt->field_count;
       bind < end && field < field_end;
5243 5244
       bind++, field++)
  {         
5245
    if (*null_ptr & bit)
5246
      *bind->is_null= 1;
5247
    else
5248
    { 
5249
      *bind->is_null= 0;
5250 5251
      if (field->type == bind->buffer_type)
        (*bind->fetch_result)(bind, &row);
5252
      else 
5253 5254 5255 5256
      {
        my_bool field_is_unsigned= (field->flags & UNSIGNED_FLAG) ? 1: 0;
        fetch_results(bind, field->type, &row, field_is_unsigned);
      }
5257
    }
5258
    if (! ((bit<<=1) & 255))
5259
    {
5260
      bit= 1;					/* To next byte */
5261
      null_ptr++;
5262 5263 5264 5265 5266 5267
    }
  }
  return 0;
}

/*
5268
  Fetch and return row data to bound buffers, if any
5269 5270
*/

5271
int STDCALL mysql_fetch(MYSQL_STMT *stmt)
5272
{
venu@myvenu.com's avatar
venu@myvenu.com committed
5273
  MYSQL *mysql= stmt->mysql;
5274
  uchar *row;
5275 5276
  DBUG_ENTER("mysql_fetch");

5277 5278
  row= (uchar *)0;
  if (stmt->result_buffered) /* buffered */
5279
  {
5280 5281 5282 5283 5284 5285 5286 5287
    MYSQL_RES *res;
    
    if (!(res= stmt->result) || !res->data_cursor) 
      goto no_data;
    
    row= (uchar *)res->data_cursor->data;
    res->data_cursor= res->data_cursor->next;
    res->current_row= (MYSQL_ROW)row;    
5288
  }
5289 5290 5291 5292 5293 5294 5295 5296 5297 5298 5299 5300 5301 5302 5303 5304 5305 5306 5307 5308 5309 5310 5311 5312 5313 5314 5315 5316 5317 5318 5319 5320 5321 5322 5323 5324 5325 5326
  else /* un-buffered */
  {
    if (packet_error == net_safe_read(mysql))
    {
      set_stmt_errmsg(stmt,(char *)mysql->net.last_error,
                      mysql->net.last_errno);
      DBUG_RETURN(1);
    }
    if (mysql->net.read_pos[0] == 254)
    {
      mysql->status= MYSQL_STATUS_READY;
      goto no_data;
    }
    row= mysql->net.read_pos+1;
  }
  DBUG_RETURN(stmt_fetch_row(stmt, row));

no_data:
  DBUG_PRINT("info", ("end of data"));    
  DBUG_RETURN(MYSQL_NO_DATA); /* no more data */
}

/* 
  Read all rows of data from server  (binary format)
*/

static MYSQL_DATA *read_binary_rows(MYSQL_STMT *stmt)
{
  ulong      pkt_len;
  uchar      *cp;
  MYSQL      *mysql= stmt->mysql;
  MYSQL_DATA *result;
  MYSQL_ROWS *cur, **prev_ptr;
  NET        *net = &mysql->net;
  DBUG_ENTER("read_binary_rows");
 
  mysql= mysql->last_used_con;
  if ((pkt_len= net_safe_read(mysql)) == packet_error)
5327
  {
5328 5329
    set_stmt_errmsg(stmt,(char *)mysql->net.last_error,
                    mysql->net.last_errno);
5330 5331 5332 5333 5334 5335 5336 5337 5338 5339 5340 5341 5342 5343 5344 5345 5346 5347 5348 5349 5350 5351 5352 5353 5354 5355 5356 5357 5358 5359 5360 5361 5362 5363 5364 5365 5366 5367 5368 5369 5370 5371 5372 5373 5374 5375 5376 5377 5378 5379 5380 5381 5382 5383 5384 5385 5386
    DBUG_RETURN(0);
  }
  if (mysql->net.read_pos[0] == 254) /* end of data */
    return 0;				

  if (!(result=(MYSQL_DATA*) my_malloc(sizeof(MYSQL_DATA),
				       MYF(MY_WME | MY_ZEROFILL))))
  {
    net->last_errno=CR_OUT_OF_MEMORY;
    strmov(net->last_error,ER(net->last_errno));
    DBUG_RETURN(0);
  }
  init_alloc_root(&result->alloc,8192,0);	/* Assume rowlength < 8192 */
  result->alloc.min_malloc= sizeof(MYSQL_ROWS);
  prev_ptr= &result->data;
  result->rows= 0;

  while (*(cp=net->read_pos) != 254 || pkt_len >= 8)
  {
    result->rows++;

    if (!(cur= (MYSQL_ROWS*) alloc_root(&result->alloc,sizeof(MYSQL_ROWS))) ||
	      !(cur->data= ((MYSQL_ROW) alloc_root(&result->alloc, pkt_len))))
    {
      free_rows(result);
      net->last_errno=CR_OUT_OF_MEMORY;
      strmov(net->last_error,ER(net->last_errno));
      DBUG_RETURN(0);
    }
    *prev_ptr= cur;
    prev_ptr= &cur->next;
    memcpy(cur->data, (char*)cp+1, pkt_len-1); 
	  
    if ((pkt_len=net_safe_read(mysql)) == packet_error)
    {
      free_rows(result);
      DBUG_RETURN(0);
    }
  }
  *prev_ptr= 0;
  if (pkt_len > 1)
  {
    mysql->warning_count= uint2korr(cp+1);
    DBUG_PRINT("info",("warning_count:  %ld", mysql->warning_count));
  }
  DBUG_PRINT("exit",("Got %d rows",result->rows));
  DBUG_RETURN(result);
}

/*
  Store or buffer the binary results to stmt
*/

int STDCALL mysql_stmt_store_result(MYSQL_STMT *stmt)
{
  MYSQL *mysql= stmt->mysql;
  MYSQL_RES *result;
5387
  DBUG_ENTER("mysql_stmt_store_result");
5388 5389 5390 5391 5392 5393 5394

  mysql= mysql->last_used_con;

  if (!stmt->field_count)
    DBUG_RETURN(0);
  if (mysql->status != MYSQL_STATUS_GET_RESULT)
  {
5395 5396
    set_stmt_error(stmt, CR_COMMANDS_OUT_OF_SYNC);
    DBUG_RETURN(1);
5397 5398 5399 5400 5401 5402 5403
  }
  mysql->status= MYSQL_STATUS_READY;		/* server is ready */
  if (!(result= (MYSQL_RES*) my_malloc((uint) (sizeof(MYSQL_RES)+
					      sizeof(ulong) *
					      stmt->field_count),
				      MYF(MY_WME | MY_ZEROFILL))))
  {
5404
    set_stmt_error(stmt, CR_OUT_OF_MEMORY);
5405
    DBUG_RETURN(1);
5406
  }
5407 5408 5409 5410 5411 5412 5413 5414 5415 5416 5417 5418
  stmt->result_buffered= 1;
  if (!(result->data= read_binary_rows(stmt)))
  {
    my_free((gptr) result,MYF(0));
    DBUG_RETURN(0);
  }
  mysql->affected_rows= result->row_count= result->data->rows;
  result->data_cursor=	result->data->data;
  result->fields=	stmt->fields;
  result->field_count=	stmt->field_count;
  stmt->result= result;
  DBUG_RETURN(0); /* Data buffered, must be fetched with mysql_fetch() */
5419 5420
}

5421 5422 5423 5424 5425 5426 5427 5428 5429 5430 5431 5432 5433 5434 5435 5436 5437 5438 5439 5440 5441 5442 5443 5444 5445 5446 5447 5448 5449 5450 5451 5452 5453 5454 5455 5456 5457 5458 5459 5460 5461 5462 5463 5464 5465 5466 5467 5468 5469
/*
  Seek to desired row in the statement result set
*/

MYSQL_ROW_OFFSET STDCALL
mysql_stmt_row_seek(MYSQL_STMT *stmt, MYSQL_ROW_OFFSET row)
{
  MYSQL_RES *result;
  DBUG_ENTER("mysql_stmt_row_seek");
  
  if ((result= stmt->result))
  {
    MYSQL_ROW_OFFSET return_value= result->data_cursor;
    result->current_row= 0;
    result->data_cursor= row;
    DBUG_RETURN(return_value);
  }
  
  DBUG_PRINT("exit", ("stmt doesn't contain any resultset"));
  DBUG_RETURN(0);
}

/*
  Return the current statement row cursor position
*/

MYSQL_ROW_OFFSET STDCALL 
mysql_stmt_row_tell(MYSQL_STMT *stmt)
{
  DBUG_ENTER("mysql_stmt_row_tell");
  
  if (stmt->result)
    DBUG_RETURN(stmt->result->data_cursor);
  
  DBUG_PRINT("exit", ("stmt doesn't contain any resultset"));
  DBUG_RETURN(0);
}

/*
  Move the stmt result set data cursor to specified row
*/

void STDCALL
mysql_stmt_data_seek(MYSQL_STMT *stmt, my_ulonglong row)
{
  MYSQL_RES   *result;
  DBUG_ENTER("mysql_stmt_data_seek");
  DBUG_PRINT("enter",("row id to seek: %ld",(long) row));
  
5470
  if ((result= stmt->result))
5471 5472 5473 5474 5475 5476 5477
  {
    MYSQL_ROWS	*tmp= 0;
    if (result->data)
      for (tmp=result->data->data; row-- && tmp ; tmp = tmp->next) ;
    result->current_row= 0;
    result->data_cursor= tmp;
  }
5478 5479 5480 5481 5482 5483 5484 5485 5486 5487 5488 5489 5490 5491 5492 5493 5494
  else
    DBUG_PRINT("exit", ("stmt doesn't contain any resultset"));
}

/*
  Return total rows the current statement result set
*/

my_ulonglong STDCALL mysql_stmt_num_rows(MYSQL_STMT *stmt)
{
  DBUG_ENTER("mysql_stmt_num_rows");
    
  if (stmt->result)
    DBUG_RETURN(stmt->result->row_count);
  
  DBUG_PRINT("exit", ("stmt doesn't contain any resultset"));
  DBUG_RETURN(0);
5495
}
5496 5497

/********************************************************************
5498
 statement error handling and close
5499
*********************************************************************/
5500

5501
/*
5502
  Close the statement handle by freeing all alloced resources
5503

5504 5505 5506 5507 5508 5509 5510 5511 5512
  SYNOPSIS
    mysql_stmt_close()
    stmt	       Statement handle
    skip_list    Flag to indicate delete from list or not
  RETURN VALUES
    0	ok
    1	error
*/
static my_bool stmt_close(MYSQL_STMT *stmt, my_bool skip_list)
5513
{
5514
  MYSQL *mysql;
5515 5516
  DBUG_ENTER("mysql_stmt_close");

5517
  DBUG_ASSERT(stmt != 0);
5518
  
5519 5520 5521 5522 5523
  if (!(mysql= stmt->mysql))
  {
    my_free((gptr) stmt, MYF(MY_WME));
    DBUG_RETURN(0);
  }
5524 5525 5526 5527 5528 5529 5530 5531 5532 5533 5534 5535 5536 5537
  if (mysql->status != MYSQL_STATUS_READY)
  {
    /* Clear the current execution status */
    DBUG_PRINT("warning",("Not all packets read, clearing them"));
    for (;;)
    {
      ulong pkt_len;
      if ((pkt_len= net_safe_read(mysql)) == packet_error)
        break;
      if (pkt_len <= 8 && mysql->net.read_pos[0] == 254)
        break;	
    }
    mysql->status= MYSQL_STATUS_READY;
  }
5538
  if (stmt->state == MY_ST_PREPARE || stmt->state == MY_ST_EXECUTE)
5539 5540 5541
  {
    char buff[4];
    int4store(buff, stmt->stmt_id);
5542 5543 5544 5545 5546 5547
    if (simple_command(mysql, COM_CLOSE_STMT, buff, 4, 1))
    {
      set_stmt_errmsg(stmt, mysql->net.last_error, mysql->net.last_errno);
      stmt->mysql= NULL; /* connection isn't valid anymore */
      DBUG_RETURN(1);
    }
5548
  }
5549 5550 5551 5552 5553 5554 5555
  mysql_free_result(stmt->result);
  free_root(&stmt->mem_root, MYF(0));
  if (!skip_list)
    mysql->stmts= list_delete(mysql->stmts, &stmt->list);
  mysql->status= MYSQL_STATUS_READY;
  my_free((gptr) stmt, MYF(MY_WME));
  DBUG_RETURN(0);
5556 5557
}

5558 5559 5560 5561 5562
my_bool STDCALL mysql_stmt_close(MYSQL_STMT *stmt)
{
  return stmt_close(stmt, 0);
}

5563 5564 5565 5566 5567 5568 5569
/*
  Return statement error code
*/

uint STDCALL mysql_stmt_errno(MYSQL_STMT * stmt)
{
  DBUG_ENTER("mysql_stmt_errno");
5570
  DBUG_RETURN(stmt->last_errno);
5571 5572 5573 5574 5575 5576 5577 5578 5579
}

/*
  Return statement error message
*/

const char *STDCALL mysql_stmt_error(MYSQL_STMT * stmt)
{
  DBUG_ENTER("mysql_stmt_error");
5580
  DBUG_RETURN(stmt->last_error);
5581 5582
}

5583 5584 5585 5586
/********************************************************************
 Transactional APIs
*********************************************************************/

5587 5588 5589 5590
/*
  Commit the current transaction
*/

5591
my_bool STDCALL mysql_commit(MYSQL * mysql)
5592 5593
{
  DBUG_ENTER("mysql_commit");
5594
  DBUG_RETURN((my_bool) mysql_real_query(mysql, "commit", 6));
5595 5596 5597
}

/*
5598
  Rollback the current transaction
5599 5600
*/

5601
my_bool STDCALL mysql_rollback(MYSQL * mysql)
5602 5603
{
  DBUG_ENTER("mysql_rollback");
5604
  DBUG_RETURN((my_bool) mysql_real_query(mysql, "rollback", 8));
5605 5606 5607 5608 5609 5610 5611
}


/*
  Set autocommit to either true or false
*/

5612
my_bool STDCALL mysql_autocommit(MYSQL * mysql, my_bool auto_mode)
5613 5614 5615 5616 5617
{
  DBUG_ENTER("mysql_autocommit");
  DBUG_PRINT("enter", ("mode : %d", auto_mode));

  if (auto_mode) /* set to true */
5618 5619
    DBUG_RETURN((my_bool) mysql_real_query(mysql, "set autocommit=1", 16));
  DBUG_RETURN((my_bool) mysql_real_query(mysql, "set autocommit=0", 16));
5620
}
5621 5622 5623


/********************************************************************
5624
 Multi query execution + SPs APIs
5625 5626 5627 5628 5629 5630 5631 5632 5633
*********************************************************************/

/*
  Returns if there are any more query results exists to be read using 
  mysql_next_result()
*/

my_bool STDCALL mysql_more_results(MYSQL *mysql)
{
5634 5635 5636 5637 5638 5639 5640 5641
  my_bool result;
  DBUG_ENTER("mysql_more_results");
  
  result= (mysql->last_used_con->server_status & SERVER_MORE_RESULTS_EXISTS) ? 
          1: 0;
  
  DBUG_PRINT("exit",("More results exists ? %d", result)); 
  DBUG_RETURN(result);
5642 5643 5644 5645 5646 5647 5648 5649
}

/*
  Reads and returns the next query results
*/

my_bool STDCALL mysql_next_result(MYSQL *mysql)
{
5650
  DBUG_ENTER("mysql_next_result");
5651
  
5652 5653
  mysql->net.last_error[0]= 0;
  mysql->net.last_errno= 0;
5654 5655 5656
  mysql->affected_rows= ~(my_ulonglong) 0;

  if (mysql->last_used_con->server_status & SERVER_MORE_RESULTS_EXISTS)
5657 5658 5659
    DBUG_RETURN(mysql_read_query_result(mysql));
  
  DBUG_RETURN(0);
5660
}