ha_ndbcluster.cc 121 KB
Newer Older
unknown's avatar
unknown committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
/* Copyright (C) 2000-2003 MySQL AB

  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,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  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 
*/

/*
  This file defines the NDB Cluster handler: the interface between MySQL and
  NDB Cluster
*/

#ifdef __GNUC__
#pragma implementation                          // gcc: Class implementation
#endif

#include "mysql_priv.h"

#ifdef HAVE_NDBCLUSTER_DB
#include <my_dir.h>
#include "ha_ndbcluster.h"
#include <ndbapi/NdbApi.hpp>
#include <ndbapi/NdbScanFilter.hpp>

// Default value for parallelism
static const int parallelism= 240;

38 39
// Default value for max number of transactions
// createable against NDB from this handler
40 41
static const int max_transactions= 256;

42
// connectstring to cluster if given by mysqld
unknown's avatar
unknown committed
43
const char *ndbcluster_connectstring= 0;
44

45 46
static const char *ha_ndb_ext=".ndb";

unknown's avatar
unknown committed
47
#define NDB_HIDDEN_PRIMARY_KEY_LENGTH 8
48

unknown's avatar
unknown committed
49 50

#define ERR_PRINT(err) \
51
  DBUG_PRINT("error", ("%d  message: %s", err.code, err.message))
unknown's avatar
unknown committed
52 53 54 55 56 57 58 59 60

#define ERR_RETURN(err)		         \
{				         \
  ERR_PRINT(err);		         \
  DBUG_RETURN(ndb_to_mysql_error(&err)); \
}

// Typedefs for long names
typedef NdbDictionary::Column NDBCOL;
unknown's avatar
unknown committed
61
typedef NdbDictionary::Table NDBTAB;
unknown's avatar
unknown committed
62 63 64
typedef NdbDictionary::Index  NDBINDEX;
typedef NdbDictionary::Dictionary  NDBDICT;

unknown's avatar
unknown committed
65
bool ndbcluster_inited= FALSE;
unknown's avatar
unknown committed
66

67
static Ndb* g_ndb= NULL;
68
static Ndb_cluster_connection* g_ndb_cluster_connection= NULL;
69

unknown's avatar
unknown committed
70 71 72 73 74 75 76 77 78 79 80 81 82 83 84
// Handler synchronization
pthread_mutex_t ndbcluster_mutex;

// Table lock handling
static HASH ndbcluster_open_tables;

static byte *ndbcluster_get_key(NDB_SHARE *share,uint *length,
                                my_bool not_used __attribute__((unused)));
static NDB_SHARE *get_share(const char *table_name);
static void free_share(NDB_SHARE *share);

static int packfrm(const void *data, uint len, const void **pack_data, uint *pack_len);
static int unpackfrm(const void **data, uint *len,
		     const void* pack_data);

unknown's avatar
unknown committed
85
static int ndb_get_table_statistics(Ndb*, const char *, 
86 87
				    Uint64* rows, Uint64* commits);

unknown's avatar
unknown committed
88

89 90 91 92 93 94
/*
  Dummy buffer to read zero pack_length fields
  which are mapped to 1 char
*/
static byte dummy_buf[1];

unknown's avatar
unknown committed
95 96 97 98 99 100 101 102
/*
  Error handling functions
*/

struct err_code_mapping
{
  int ndb_err;
  int my_err;
103
  int show_warning;
unknown's avatar
unknown committed
104 105 106 107
};

static const err_code_mapping err_map[]= 
{
108 109
  { 626, HA_ERR_KEY_NOT_FOUND, 0 },
  { 630, HA_ERR_FOUND_DUPP_KEY, 0 },
unknown's avatar
unknown committed
110
  { 893, HA_ERR_FOUND_DUPP_KEY, 0 },
111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132
  { 721, HA_ERR_TABLE_EXIST, 1 },
  { 4244, HA_ERR_TABLE_EXIST, 1 },

  { 709, HA_ERR_NO_SUCH_TABLE, 1 },
  { 284, HA_ERR_NO_SUCH_TABLE, 1 },

  { 266, HA_ERR_LOCK_WAIT_TIMEOUT, 1 },
  { 274, HA_ERR_LOCK_WAIT_TIMEOUT, 1 },
  { 296, HA_ERR_LOCK_WAIT_TIMEOUT, 1 },
  { 297, HA_ERR_LOCK_WAIT_TIMEOUT, 1 },
  { 237, HA_ERR_LOCK_WAIT_TIMEOUT, 1 },

  { 623, HA_ERR_RECORD_FILE_FULL, 1 },
  { 624, HA_ERR_RECORD_FILE_FULL, 1 },
  { 625, HA_ERR_RECORD_FILE_FULL, 1 },
  { 826, HA_ERR_RECORD_FILE_FULL, 1 },
  { 827, HA_ERR_RECORD_FILE_FULL, 1 },
  { 832, HA_ERR_RECORD_FILE_FULL, 1 },

  { 0, 1, 0 },

  { -1, -1, 1 }
unknown's avatar
unknown committed
133 134 135 136 137 138
};


static int ndb_to_mysql_error(const NdbError *err)
{
  uint i;
139 140
  for (i=0; err_map[i].ndb_err != err->code && err_map[i].my_err != -1; i++);
  if (err_map[i].show_warning)
unknown's avatar
unknown committed
141
  {
142 143 144 145
    // Push the NDB error message as warning
    push_warning_printf(current_thd, MYSQL_ERROR::WARN_LEVEL_ERROR,
			ER_GET_ERRMSG, ER(ER_GET_ERRMSG),
			err->code, err->message, "NDB");
unknown's avatar
unknown committed
146
  }
147 148
  if (err_map[i].my_err == -1)
    return err->code;
unknown's avatar
unknown committed
149 150 151 152
  return err_map[i].my_err;
}


unknown's avatar
unknown committed
153 154 155 156 157

inline
int execute_no_commit(ha_ndbcluster *h, NdbConnection *trans)
{
  int m_batch_execute= 0;
unknown's avatar
unknown committed
158 159
#ifdef NOT_USED
  if (m_batch_execute)
unknown's avatar
unknown committed
160
    return 0;
unknown's avatar
unknown committed
161
#endif
162
  return trans->execute(NoCommit,AbortOnError,h->m_force_send);
unknown's avatar
unknown committed
163 164 165 166 167 168
}

inline
int execute_commit(ha_ndbcluster *h, NdbConnection *trans)
{
  int m_batch_execute= 0;
unknown's avatar
unknown committed
169 170
#ifdef NOT_USED
  if (m_batch_execute)
unknown's avatar
unknown committed
171
    return 0;
unknown's avatar
unknown committed
172
#endif
173 174 175 176 177 178 179 180 181 182 183 184
  return trans->execute(Commit,AbortOnError,h->m_force_send);
}

inline
int execute_commit(THD *thd, NdbConnection *trans)
{
  int m_batch_execute= 0;
#ifdef NOT_USED
  if (m_batch_execute)
    return 0;
#endif
  return trans->execute(Commit,AbortOnError,thd->variables.ndb_force_send);
unknown's avatar
unknown committed
185 186 187 188 189 190
}

inline
int execute_no_commit_ie(ha_ndbcluster *h, NdbConnection *trans)
{
  int m_batch_execute= 0;
unknown's avatar
unknown committed
191 192
#ifdef NOT_USED
  if (m_batch_execute)
unknown's avatar
unknown committed
193
    return 0;
unknown's avatar
unknown committed
194
#endif
195
  return trans->execute(NoCommit,IgnoreError,h->m_force_send);
unknown's avatar
unknown committed
196 197
}

198 199 200 201 202 203
/*
  Place holder for ha_ndbcluster thread specific data
*/

Thd_ndb::Thd_ndb()
{
204
  ndb= new Ndb(g_ndb_cluster_connection, "");
205 206
  lock_count= 0;
  count= 0;
207
  error= 0;
208 209 210 211
}

Thd_ndb::~Thd_ndb()
{
212 213
  if (ndb)
    delete ndb;
214 215 216 217 218 219 220 221
}

/*
 * manage uncommitted insert/deletes during transactio to get records correct
 */

struct Ndb_table_local_info {
  int no_uncommitted_rows_count;
222
  ulong last_count;
223 224 225
  ha_rows records;
};

unknown's avatar
unknown committed
226 227 228 229 230 231 232 233 234 235
void ha_ndbcluster::set_rec_per_key()
{
  DBUG_ENTER("ha_ndbcluster::get_status_const");
  for (uint i=0 ; i < table->keys ; i++)
  {
    table->key_info[i].rec_per_key[table->key_info[i].key_parts-1]= 1;
  }
  DBUG_VOID_RETURN;
}

236 237
void ha_ndbcluster::records_update()
{
238 239
  if (m_ha_not_exact_count)
    return;
240 241 242 243 244
  DBUG_ENTER("ha_ndbcluster::records_update");
  struct Ndb_table_local_info *info= (struct Ndb_table_local_info *)m_table_info;
  DBUG_PRINT("info", ("id=%d, no_uncommitted_rows_count=%d",
		      ((const NDBTAB *)m_table)->getTableId(),
		      info->no_uncommitted_rows_count));
245
  //  if (info->records == ~(ha_rows)0)
246 247 248 249 250 251
  {
    Uint64 rows;
    if(ndb_get_table_statistics(m_ndb, m_tabname, &rows, 0) == 0){
      info->records= rows;
    }
  }
252 253 254 255 256
  {
    THD *thd= current_thd;
    if (((Thd_ndb*)(thd->transaction.thd_ndb))->error)
      info->no_uncommitted_rows_count= 0;
  }
257 258 259 260
  records= info->records+ info->no_uncommitted_rows_count;
  DBUG_VOID_RETURN;
}

261 262
void ha_ndbcluster::no_uncommitted_rows_execute_failure()
{
263 264
  if (m_ha_not_exact_count)
    return;
265
  DBUG_ENTER("ha_ndbcluster::no_uncommitted_rows_execute_failure");
266 267
  THD *thd= current_thd;
  ((Thd_ndb*)(thd->transaction.thd_ndb))->error= 1;
268 269 270
  DBUG_VOID_RETURN;
}

271 272
void ha_ndbcluster::no_uncommitted_rows_init(THD *thd)
{
273 274
  if (m_ha_not_exact_count)
    return;
275 276 277
  DBUG_ENTER("ha_ndbcluster::no_uncommitted_rows_init");
  struct Ndb_table_local_info *info= (struct Ndb_table_local_info *)m_table_info;
  Thd_ndb *thd_ndb= (Thd_ndb *)thd->transaction.thd_ndb;
278
  if (info->last_count != thd_ndb->count)
279
  {
280
    info->last_count = thd_ndb->count;
281 282 283 284 285 286 287 288 289 290 291
    info->no_uncommitted_rows_count= 0;
    info->records= ~(ha_rows)0;
    DBUG_PRINT("info", ("id=%d, no_uncommitted_rows_count=%d",
			((const NDBTAB *)m_table)->getTableId(),
			info->no_uncommitted_rows_count));
  }
  DBUG_VOID_RETURN;
}

void ha_ndbcluster::no_uncommitted_rows_update(int c)
{
292 293
  if (m_ha_not_exact_count)
    return;
294
  DBUG_ENTER("ha_ndbcluster::no_uncommitted_rows_update");
unknown's avatar
unknown committed
295 296
  struct Ndb_table_local_info *info=
    (struct Ndb_table_local_info *)m_table_info;
297 298 299 300 301 302 303 304 305
  info->no_uncommitted_rows_count+= c;
  DBUG_PRINT("info", ("id=%d, no_uncommitted_rows_count=%d",
		      ((const NDBTAB *)m_table)->getTableId(),
		      info->no_uncommitted_rows_count));
  DBUG_VOID_RETURN;
}

void ha_ndbcluster::no_uncommitted_rows_reset(THD *thd)
{
306 307
  if (m_ha_not_exact_count)
    return;
308 309
  DBUG_ENTER("ha_ndbcluster::no_uncommitted_rows_reset");
  ((Thd_ndb*)(thd->transaction.thd_ndb))->count++;
310
  ((Thd_ndb*)(thd->transaction.thd_ndb))->error= 0;
311 312 313
  DBUG_VOID_RETURN;
}

unknown's avatar
unknown committed
314 315 316 317 318 319 320 321
/*
  Take care of the error that occured in NDB
  
  RETURN
    0	No error
    #   The mapped error code
*/

322

unknown's avatar
unknown committed
323 324
int ha_ndbcluster::ndb_err(NdbConnection *trans)
{
325
  int res;
unknown's avatar
unknown committed
326 327 328 329 330 331 332 333 334 335
  const NdbError err= trans->getNdbError();
  DBUG_ENTER("ndb_err");
  
  ERR_PRINT(err);
  switch (err.classification) {
  case NdbError::SchemaError:
  {
    NDBDICT *dict= m_ndb->getDictionary();
    DBUG_PRINT("info", ("invalidateTable %s", m_tabname));
    dict->invalidateTable(m_tabname);
336
    table->version=0L;			/* Free when thread is ready */
unknown's avatar
unknown committed
337 338 339 340 341
    break;
  }
  default:
    break;
  }
342 343 344 345
  res= ndb_to_mysql_error(&err);
  DBUG_PRINT("info", ("transformed ndbcluster error %d to mysql error %d", 
		      err.code, res));
  if (res == HA_ERR_FOUND_DUPP_KEY)
346
    m_dupkey= table->primary_key;
347 348
  
  DBUG_RETURN(res);
unknown's avatar
unknown committed
349 350 351
}


352
/*
353
  Override the default get_error_message in order to add the 
354 355 356
  error message of NDB 
 */

357 358
bool ha_ndbcluster::get_error_message(int error, 
				      String *buf)
359
{
360
  DBUG_ENTER("ha_ndbcluster::get_error_message");
361
  DBUG_PRINT("enter", ("error: %d", error));
unknown's avatar
unknown committed
362 363

  Ndb *ndb= ((Thd_ndb*)current_thd->transaction.thd_ndb)->ndb;
364
  if (!ndb)
unknown's avatar
unknown committed
365
    DBUG_RETURN(FALSE);
366

367
  const NdbError err= ndb->getNdbError(error);
368 369 370 371
  bool temporary= err.status==NdbError::TemporaryError;
  buf->set(err.message, strlen(err.message), &my_charset_bin);
  DBUG_PRINT("exit", ("message: %s, temporary: %d", buf->ptr(), temporary));
  DBUG_RETURN(temporary);
372 373 374
}


unknown's avatar
unknown committed
375 376
/*
  Check if type is supported by NDB.
377 378
  TODO Use this once in open(), not in every operation

unknown's avatar
unknown committed
379 380 381 382 383
*/

static inline bool ndb_supported_type(enum_field_types type)
{
  switch (type) {
unknown's avatar
unknown committed
384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405
  case MYSQL_TYPE_DECIMAL:    
  case MYSQL_TYPE_TINY:        
  case MYSQL_TYPE_SHORT:
  case MYSQL_TYPE_LONG:
  case MYSQL_TYPE_INT24:       
  case MYSQL_TYPE_LONGLONG:
  case MYSQL_TYPE_FLOAT:
  case MYSQL_TYPE_DOUBLE:
  case MYSQL_TYPE_TIMESTAMP:
  case MYSQL_TYPE_DATETIME:    
  case MYSQL_TYPE_DATE:
  case MYSQL_TYPE_NEWDATE:
  case MYSQL_TYPE_TIME:        
  case MYSQL_TYPE_YEAR:        
  case MYSQL_TYPE_STRING:      
  case MYSQL_TYPE_VAR_STRING:
  case MYSQL_TYPE_TINY_BLOB:
  case MYSQL_TYPE_BLOB:    
  case MYSQL_TYPE_MEDIUM_BLOB:   
  case MYSQL_TYPE_LONG_BLOB:  
  case MYSQL_TYPE_ENUM:
  case MYSQL_TYPE_SET:         
unknown's avatar
unknown committed
406
    return TRUE;
unknown's avatar
unknown committed
407 408
  case MYSQL_TYPE_NULL:   
  case MYSQL_TYPE_GEOMETRY:
unknown's avatar
unknown committed
409
    break;
unknown's avatar
unknown committed
410
  }
unknown's avatar
unknown committed
411
  return FALSE;
unknown's avatar
unknown committed
412 413 414
}


unknown's avatar
unknown committed
415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441
/*
  Instruct NDB to set the value of the hidden primary key
*/

bool ha_ndbcluster::set_hidden_key(NdbOperation *ndb_op,
				   uint fieldnr, const byte *field_ptr)
{
  DBUG_ENTER("set_hidden_key");
  DBUG_RETURN(ndb_op->equal(fieldnr, (char*)field_ptr,
			    NDB_HIDDEN_PRIMARY_KEY_LENGTH) != 0);
}


/*
  Instruct NDB to set the value of one primary key attribute
*/

int ha_ndbcluster::set_ndb_key(NdbOperation *ndb_op, Field *field,
                               uint fieldnr, const byte *field_ptr)
{
  uint32 pack_len= field->pack_length();
  DBUG_ENTER("set_ndb_key");
  DBUG_PRINT("enter", ("%d: %s, ndb_type: %u, len=%d", 
                       fieldnr, field->field_name, field->type(),
                       pack_len));
  DBUG_DUMP("key", (char*)field_ptr, pack_len);
  
unknown's avatar
unknown committed
442 443 444 445 446
  if (ndb_supported_type(field->type()))
  {
    if (! (field->flags & BLOB_FLAG))
      // Common implementation for most field types
      DBUG_RETURN(ndb_op->equal(fieldnr, (char*) field_ptr, pack_len) != 0);
unknown's avatar
unknown committed
447
  }
unknown's avatar
unknown committed
448 449 450
  // Unhandled field types
  DBUG_PRINT("error", ("Field type %d not supported", field->type()));
  DBUG_RETURN(2);
unknown's avatar
unknown committed
451 452 453 454 455 456 457 458
}


/*
 Instruct NDB to set the value of one attribute
*/

int ha_ndbcluster::set_ndb_value(NdbOperation *ndb_op, Field *field, 
459
                                 uint fieldnr, bool *set_blob_value)
unknown's avatar
unknown committed
460 461 462 463 464 465 466 467
{
  const byte* field_ptr= field->ptr;
  uint32 pack_len=  field->pack_length();
  DBUG_ENTER("set_ndb_value");
  DBUG_PRINT("enter", ("%d: %s, type: %u, len=%d, is_null=%s", 
                       fieldnr, field->field_name, field->type(), 
                       pack_len, field->is_null()?"Y":"N"));
  DBUG_DUMP("value", (char*) field_ptr, pack_len);
unknown's avatar
unknown committed
468 469

  if (ndb_supported_type(field->type()))
unknown's avatar
unknown committed
470
  {
471 472 473 474 475 476 477
    // ndb currently does not support size 0
    const byte *empty_field= "";
    if (pack_len == 0)
    {
      pack_len= 1;
      field_ptr= empty_field;
    }
unknown's avatar
unknown committed
478 479 480 481 482 483 484 485 486 487
    if (! (field->flags & BLOB_FLAG))
    {
      if (field->is_null())
        // Set value to NULL
        DBUG_RETURN((ndb_op->setValue(fieldnr, (char*)NULL, pack_len) != 0));
      // Common implementation for most field types
      DBUG_RETURN(ndb_op->setValue(fieldnr, (char*)field_ptr, pack_len) != 0);
    }

    // Blob type
488
    NdbBlob *ndb_blob= ndb_op->getBlobHandle(fieldnr);
unknown's avatar
unknown committed
489 490 491 492 493 494 495 496 497 498 499 500
    if (ndb_blob != NULL)
    {
      if (field->is_null())
        DBUG_RETURN(ndb_blob->setNull() != 0);

      Field_blob *field_blob= (Field_blob*)field;

      // Get length and pointer to data
      uint32 blob_len= field_blob->get_length(field_ptr);
      char* blob_ptr= NULL;
      field_blob->get_ptr(&blob_ptr);

501 502 503
      // Looks like NULL ptr signals length 0 blob
      if (blob_ptr == NULL) {
        DBUG_ASSERT(blob_len == 0);
504
        blob_ptr= (char*)"";
505
      }
unknown's avatar
unknown committed
506 507 508 509 510

      DBUG_PRINT("value", ("set blob ptr=%x len=%u",
                           (unsigned)blob_ptr, blob_len));
      DBUG_DUMP("value", (char*)blob_ptr, min(blob_len, 26));

511
      if (set_blob_value)
unknown's avatar
unknown committed
512
	*set_blob_value= TRUE;
unknown's avatar
unknown committed
513 514 515 516
      // No callback needed to write value
      DBUG_RETURN(ndb_blob->setValue(blob_ptr, blob_len) != 0);
    }
    DBUG_RETURN(1);
unknown's avatar
unknown committed
517
  }
unknown's avatar
unknown committed
518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535
  // Unhandled field types
  DBUG_PRINT("error", ("Field type %d not supported", field->type()));
  DBUG_RETURN(2);
}


/*
  Callback to read all blob values.
  - not done in unpack_record because unpack_record is valid
    after execute(Commit) but reading blobs is not
  - may only generate read operations; they have to be executed
    somewhere before the data is available
  - due to single buffer for all blobs, we let the last blob
    process all blobs (last so that all are active)
  - null bit is still set in unpack_record
  - TODO allocate blob part aligned buffers
*/

unknown's avatar
unknown committed
536
NdbBlob::ActiveHook g_get_ndb_blobs_value;
unknown's avatar
unknown committed
537

unknown's avatar
unknown committed
538
int g_get_ndb_blobs_value(NdbBlob *ndb_blob, void *arg)
unknown's avatar
unknown committed
539
{
unknown's avatar
unknown committed
540
  DBUG_ENTER("g_get_ndb_blobs_value");
unknown's avatar
unknown committed
541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572
  if (ndb_blob->blobsNextBlob() != NULL)
    DBUG_RETURN(0);
  ha_ndbcluster *ha= (ha_ndbcluster *)arg;
  DBUG_RETURN(ha->get_ndb_blobs_value(ndb_blob));
}

int ha_ndbcluster::get_ndb_blobs_value(NdbBlob *last_ndb_blob)
{
  DBUG_ENTER("get_ndb_blobs_value");

  // Field has no field number so cannot use TABLE blob_field
  // Loop twice, first only counting total buffer size
  for (int loop= 0; loop <= 1; loop++)
  {
    uint32 offset= 0;
    for (uint i= 0; i < table->fields; i++)
    {
      Field *field= table->field[i];
      NdbValue value= m_value[i];
      if (value.ptr != NULL && (field->flags & BLOB_FLAG))
      {
        Field_blob *field_blob= (Field_blob *)field;
        NdbBlob *ndb_blob= value.blob;
        Uint64 blob_len= 0;
        if (ndb_blob->getLength(blob_len) != 0)
          DBUG_RETURN(-1);
        // Align to Uint64
        uint32 blob_size= blob_len;
        if (blob_size % 8 != 0)
          blob_size+= 8 - blob_size % 8;
        if (loop == 1)
        {
573
          char *buf= m_blobs_buffer + offset;
unknown's avatar
unknown committed
574 575 576 577 578 579 580 581 582 583 584
          uint32 len= 0xffffffff;  // Max uint32
          DBUG_PRINT("value", ("read blob ptr=%x len=%u",
                               (uint)buf, (uint)blob_len));
          if (ndb_blob->readData(buf, len) != 0)
            DBUG_RETURN(-1);
          DBUG_ASSERT(len == blob_len);
          field_blob->set_ptr(len, buf);
        }
        offset+= blob_size;
      }
    }
585
    if (loop == 0 && offset > m_blobs_buffer_size)
unknown's avatar
unknown committed
586
    {
587 588
      my_free(m_blobs_buffer, MYF(MY_ALLOW_ZERO_PTR));
      m_blobs_buffer_size= 0;
unknown's avatar
unknown committed
589
      DBUG_PRINT("value", ("allocate blobs buffer size %u", offset));
590 591
      m_blobs_buffer= my_malloc(offset, MYF(MY_WME));
      if (m_blobs_buffer == NULL)
unknown's avatar
unknown committed
592
        DBUG_RETURN(-1);
593
      m_blobs_buffer_size= offset;
unknown's avatar
unknown committed
594
    }
unknown's avatar
unknown committed
595
  }
unknown's avatar
unknown committed
596
  DBUG_RETURN(0);
unknown's avatar
unknown committed
597 598 599 600 601
}


/*
  Instruct NDB to fetch one field
unknown's avatar
unknown committed
602 603
  - data is read directly into buffer provided by field
    if field is NULL, data is read into memory provided by NDBAPI
unknown's avatar
unknown committed
604 605
*/

unknown's avatar
unknown committed
606
int ha_ndbcluster::get_ndb_value(NdbOperation *ndb_op, Field *field,
unknown's avatar
unknown committed
607
                                 uint fieldnr, byte* buf)
unknown's avatar
unknown committed
608 609
{
  DBUG_ENTER("get_ndb_value");
unknown's avatar
unknown committed
610 611 612 613 614
  DBUG_PRINT("enter", ("fieldnr: %d flags: %o", fieldnr,
                       (int)(field != NULL ? field->flags : 0)));

  if (field != NULL)
  {
unknown's avatar
unknown committed
615
    DBUG_ASSERT(buf);
unknown's avatar
unknown committed
616 617 618 619
    if (ndb_supported_type(field->type()))
    {
      DBUG_ASSERT(field->ptr != NULL);
      if (! (field->flags & BLOB_FLAG))
unknown's avatar
unknown committed
620
      {	
621 622 623 624 625
	byte *field_buf;
	if (field->pack_length() != 0)
	  field_buf= buf + (field->ptr - table->record[0]);
	else
	  field_buf= dummy_buf;
unknown's avatar
unknown committed
626 627
        m_value[fieldnr].rec= ndb_op->getValue(fieldnr, 
					       field_buf);
unknown's avatar
unknown committed
628 629 630 631 632 633 634 635 636 637
        DBUG_RETURN(m_value[fieldnr].rec == NULL);
      }

      // Blob type
      NdbBlob *ndb_blob= ndb_op->getBlobHandle(fieldnr);
      m_value[fieldnr].blob= ndb_blob;
      if (ndb_blob != NULL)
      {
        // Set callback
        void *arg= (void *)this;
unknown's avatar
unknown committed
638
        DBUG_RETURN(ndb_blob->setActiveHook(g_get_ndb_blobs_value, arg) != 0);
unknown's avatar
unknown committed
639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658
      }
      DBUG_RETURN(1);
    }
    // Unhandled field types
    DBUG_PRINT("error", ("Field type %d not supported", field->type()));
    DBUG_RETURN(2);
  }

  // Used for hidden key only
  m_value[fieldnr].rec= ndb_op->getValue(fieldnr, NULL);
  DBUG_RETURN(m_value[fieldnr].rec == NULL);
}


/*
  Check if any set or get of blob value in current query.
*/
bool ha_ndbcluster::uses_blob_value(bool all_fields)
{
  if (table->blob_fields == 0)
unknown's avatar
unknown committed
659
    return FALSE;
unknown's avatar
unknown committed
660
  if (all_fields)
unknown's avatar
unknown committed
661
    return TRUE;
unknown's avatar
unknown committed
662 663 664
  {
    uint no_fields= table->fields;
    int i;
unknown's avatar
unknown committed
665
    THD *thd= table->in_use;
unknown's avatar
unknown committed
666 667 668 669 670 671
    // They always put blobs at the end..
    for (i= no_fields - 1; i >= 0; i--)
    {
      Field *field= table->field[i];
      if (thd->query_id == field->query_id)
      {
unknown's avatar
unknown committed
672
        return TRUE;
unknown's avatar
unknown committed
673 674 675
      }
    }
  }
unknown's avatar
unknown committed
676
  return FALSE;
unknown's avatar
unknown committed
677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694
}


/*
  Get metadata for this table from NDB 

  IMPLEMENTATION
    - save the NdbDictionary::Table for easy access
    - check that frm-file on disk is equal to frm-file
      of table accessed in NDB
    - build a list of the indexes for the table
*/

int ha_ndbcluster::get_metadata(const char *path)
{
  NDBDICT *dict= m_ndb->getDictionary();
  const NDBTAB *tab;
  int error;
unknown's avatar
unknown committed
695
  bool invalidating_ndb_table= FALSE;
696

unknown's avatar
unknown committed
697 698 699
  DBUG_ENTER("get_metadata");
  DBUG_PRINT("enter", ("m_tabname: %s, path: %s", m_tabname, path));

700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717
  do {
    const void *data, *pack_data;
    uint length, pack_length;

    if (!(tab= dict->getTable(m_tabname)))
      ERR_RETURN(dict->getNdbError());
    DBUG_PRINT("info", ("Table schema version: %d", tab->getObjectVersion()));
    /*
      Compare FrmData in NDB with frm file from disk.
    */
    error= 0;
    if (readfrm(path, &data, &length) ||
	packfrm(data, length, &pack_data, &pack_length))
    {
      my_free((char*)data, MYF(MY_ALLOW_ZERO_PTR));
      my_free((char*)pack_data, MYF(MY_ALLOW_ZERO_PTR));
      DBUG_RETURN(1);
    }
unknown's avatar
unknown committed
718
    
719 720 721 722 723 724 725
    if ((pack_length != tab->getFrmLength()) || 
	(memcmp(pack_data, tab->getFrmData(), pack_length)))
    {
      if (!invalidating_ndb_table)
      {
	DBUG_PRINT("info", ("Invalidating table"));
	dict->invalidateTable(m_tabname);
unknown's avatar
unknown committed
726
	invalidating_ndb_table= TRUE;
727 728 729 730 731 732 733 734 735
      }
      else
      {
	DBUG_PRINT("error", 
		   ("metadata, pack_length: %d getFrmLength: %d memcmp: %d", 
		    pack_length, tab->getFrmLength(),
		    memcmp(pack_data, tab->getFrmData(), pack_length)));      
	DBUG_DUMP("pack_data", (char*)pack_data, pack_length);
	DBUG_DUMP("frm", (char*)tab->getFrmData(), tab->getFrmLength());
unknown's avatar
unknown committed
736
	error= 3;
unknown's avatar
unknown committed
737
	invalidating_ndb_table= FALSE;
738 739 740 741
      }
    }
    else
    {
unknown's avatar
unknown committed
742
      invalidating_ndb_table= FALSE;
743 744 745 746 747
    }
    my_free((char*)data, MYF(0));
    my_free((char*)pack_data, MYF(0));
  } while (invalidating_ndb_table);

unknown's avatar
unknown committed
748 749 750
  if (error)
    DBUG_RETURN(error);

unknown's avatar
unknown committed
751 752
  m_table= NULL;
  m_table_info= NULL;
unknown's avatar
unknown committed
753
  
unknown's avatar
unknown committed
754
  DBUG_RETURN(build_index_list(table, ILBP_OPEN));  
755
}
unknown's avatar
unknown committed
756

unknown's avatar
unknown committed
757

unknown's avatar
unknown committed
758
int ha_ndbcluster::build_index_list(TABLE *tab, enum ILBP phase)
759
{
760
  uint i;
unknown's avatar
unknown committed
761
  int error= 0;
762 763
  const char *name, *index_name;
  char unique_index_name[FN_LEN];
764
  static const char* unique_suffix= "$unique";
unknown's avatar
unknown committed
765 766 767 768
  KEY* key_info= tab->key_info;
  const char **key_name= tab->keynames.type_names;
  NdbDictionary::Dictionary *dict= m_ndb->getDictionary();
  DBUG_ENTER("build_index_list");
769
  
unknown's avatar
unknown committed
770
  // Save information about all known indexes
unknown's avatar
unknown committed
771
  for (i= 0; i < tab->keys; i++, key_info++, key_name++)
772
  {
unknown's avatar
unknown committed
773
    index_name= *key_name;
774
    NDB_INDEX_TYPE idx_type= get_index_type_from_table(i);
775
    m_index[i].type= idx_type;
776
    if (idx_type == UNIQUE_ORDERED_INDEX || idx_type == UNIQUE_INDEX)
777
    {
778 779 780
      strxnmov(unique_index_name, FN_LEN, index_name, unique_suffix, NullS);
      DBUG_PRINT("info", ("Created unique index name \'%s\' for index %d",
			  unique_index_name, i));
781
    }
unknown's avatar
unknown committed
782 783 784
    // Create secondary indexes if in create phase
    if (phase == ILBP_CREATE)
    {
785 786
      DBUG_PRINT("info", ("Creating index %u: %s", i, index_name));      
      switch (idx_type){
unknown's avatar
unknown committed
787 788 789 790 791 792 793 794 795
	
      case PRIMARY_KEY_INDEX:
	// Do nothing, already created
	break;
      case PRIMARY_KEY_ORDERED_INDEX:
	error= create_ordered_index(index_name, key_info);
	break;
      case UNIQUE_ORDERED_INDEX:
	if (!(error= create_ordered_index(index_name, key_info)))
796
	  error= create_unique_index(unique_index_name, key_info);
unknown's avatar
unknown committed
797 798
	break;
      case UNIQUE_INDEX:
799 800
	if (!(error= check_index_fields_not_null(i)))
	  error= create_unique_index(unique_index_name, key_info);
unknown's avatar
unknown committed
801 802 803 804 805
	break;
      case ORDERED_INDEX:
	error= create_ordered_index(index_name, key_info);
	break;
      default:
unknown's avatar
unknown committed
806
	DBUG_ASSERT(FALSE);
unknown's avatar
unknown committed
807 808 809 810 811 812 813 814 815 816
	break;
      }
      if (error)
      {
	DBUG_PRINT("error", ("Failed to create index %u", i));
	drop_table();
	break;
      }
    }
    // Add handles to index objects
817
    if (idx_type != PRIMARY_KEY_INDEX && idx_type != UNIQUE_INDEX)
818
    {
819
      DBUG_PRINT("info", ("Get handle to index %s", index_name));
unknown's avatar
unknown committed
820
      const NDBINDEX *index= dict->getIndex(index_name, m_tabname);
821
      if (!index) DBUG_RETURN(1);
unknown's avatar
unknown committed
822
      m_index[i].index= (void *) index;
823
    }
824
    if (idx_type == UNIQUE_ORDERED_INDEX || idx_type == UNIQUE_INDEX)
825
    {
826 827
      DBUG_PRINT("info", ("Get handle to unique_index %s", unique_index_name));
      const NDBINDEX *index= dict->getIndex(unique_index_name, m_tabname);
828
      if (!index) DBUG_RETURN(1);
unknown's avatar
unknown committed
829
      m_index[i].unique_index= (void *) index;
830 831
    }      
  }
unknown's avatar
unknown committed
832 833
  
  DBUG_RETURN(error);
834 835
}

836

unknown's avatar
unknown committed
837 838 839 840
/*
  Decode the type of an index from information 
  provided in table object
*/
841
NDB_INDEX_TYPE ha_ndbcluster::get_index_type_from_table(uint inx) const
unknown's avatar
unknown committed
842
{
843 844 845
  bool is_hash_index=  (table->key_info[inx].algorithm == HA_KEY_ALG_HASH);
  if (inx == table->primary_key)
    return is_hash_index ? PRIMARY_KEY_INDEX : PRIMARY_KEY_ORDERED_INDEX;
unknown's avatar
unknown committed
846
  else
847 848
    return ((table->key_info[inx].flags & HA_NOSAME) ? 
	    (is_hash_index ? UNIQUE_INDEX : UNIQUE_ORDERED_INDEX) :
unknown's avatar
unknown committed
849 850
	    ORDERED_INDEX);
} 
851

852 853 854 855 856 857 858 859 860 861 862 863 864 865 866 867 868 869 870 871
int ha_ndbcluster::check_index_fields_not_null(uint inx)
{
  KEY* key_info= table->key_info + inx;
  KEY_PART_INFO* key_part= key_info->key_part;
  KEY_PART_INFO* end= key_part+key_info->key_parts;
  DBUG_ENTER("check_index_fields_not_null");
  
  for (; key_part != end; key_part++) 
    {
      Field* field= key_part->field;
      if (field->maybe_null())
      {
	my_printf_error(ER_NULL_COLUMN_IN_INDEX,ER(ER_NULL_COLUMN_IN_INDEX),
			MYF(0),field->field_name);
	DBUG_RETURN(ER_NULL_COLUMN_IN_INDEX);
      }
    }
  
  DBUG_RETURN(0);
}
unknown's avatar
unknown committed
872 873 874

void ha_ndbcluster::release_metadata()
{
875
  uint i;
876

unknown's avatar
unknown committed
877 878 879 880
  DBUG_ENTER("release_metadata");
  DBUG_PRINT("enter", ("m_tabname: %s", m_tabname));

  m_table= NULL;
unknown's avatar
unknown committed
881
  m_table_info= NULL;
unknown's avatar
unknown committed
882

883
  // Release index list 
884 885
  for (i= 0; i < MAX_KEY; i++)
  {
886 887
    m_index[i].unique_index= NULL;      
    m_index[i].index= NULL;      
888 889
  }

unknown's avatar
unknown committed
890 891 892
  DBUG_VOID_RETURN;
}

unknown's avatar
unknown committed
893
int ha_ndbcluster::get_ndb_lock_type(enum thr_lock_type type)
894
{
895
  if (type >= TL_WRITE_ALLOW_WRITE)
unknown's avatar
unknown committed
896
    return NdbOperation::LM_Exclusive;
897
  else if (uses_blob_value(m_retrieve_all_fields))
898
    return NdbOperation::LM_Read;
unknown's avatar
unknown committed
899
  else
unknown's avatar
unknown committed
900
    return NdbOperation::LM_CommittedRead;
901 902
}

unknown's avatar
unknown committed
903 904 905 906 907 908
static const ulong index_type_flags[]=
{
  /* UNDEFINED_INDEX */
  0,                         

  /* PRIMARY_KEY_INDEX */
909
  HA_ONLY_WHOLE_INDEX, 
910 911

  /* PRIMARY_KEY_ORDERED_INDEX */
912
  /* 
unknown's avatar
unknown committed
913
     Enable HA_KEYREAD_ONLY when "sorted" indexes are supported, 
914 915 916
     thus ORDERD BY clauses can be optimized by reading directly 
     through the index.
  */
unknown's avatar
unknown committed
917
  // HA_KEYREAD_ONLY | 
unknown's avatar
unknown committed
918 919 920
  HA_READ_NEXT |
  HA_READ_RANGE |
  HA_READ_ORDER,
unknown's avatar
unknown committed
921 922

  /* UNIQUE_INDEX */
923
  HA_ONLY_WHOLE_INDEX,
unknown's avatar
unknown committed
924

925
  /* UNIQUE_ORDERED_INDEX */
unknown's avatar
unknown committed
926 927 928
  HA_READ_NEXT |
  HA_READ_RANGE |
  HA_READ_ORDER,
929

unknown's avatar
unknown committed
930
  /* ORDERED_INDEX */
unknown's avatar
unknown committed
931 932 933
  HA_READ_NEXT |
  HA_READ_RANGE |
  HA_READ_ORDER
unknown's avatar
unknown committed
934 935 936 937 938 939 940
};

static const int index_flags_size= sizeof(index_type_flags)/sizeof(ulong);

inline NDB_INDEX_TYPE ha_ndbcluster::get_index_type(uint idx_no) const
{
  DBUG_ASSERT(idx_no < MAX_KEY);
941
  return m_index[idx_no].type;
unknown's avatar
unknown committed
942 943 944 945 946 947 948 949 950 951
}


/*
  Get the flags for an index

  RETURN
    flags depending on the type of the index.
*/

952 953
inline ulong ha_ndbcluster::index_flags(uint idx_no, uint part,
                                        bool all_parts) const 
unknown's avatar
unknown committed
954 955
{ 
  DBUG_ENTER("index_flags");
956
  DBUG_PRINT("info", ("idx_no: %d", idx_no));
unknown's avatar
unknown committed
957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980
  DBUG_ASSERT(get_index_type_from_table(idx_no) < index_flags_size);
  DBUG_RETURN(index_type_flags[get_index_type_from_table(idx_no)]);
}


int ha_ndbcluster::set_primary_key(NdbOperation *op, const byte *key)
{
  KEY* key_info= table->key_info + table->primary_key;
  KEY_PART_INFO* key_part= key_info->key_part;
  KEY_PART_INFO* end= key_part+key_info->key_parts;
  DBUG_ENTER("set_primary_key");

  for (; key_part != end; key_part++) 
  {
    Field* field= key_part->field;
    if (set_ndb_key(op, field, 
		    key_part->fieldnr-1, key))
      ERR_RETURN(op->getNdbError());
    key += key_part->length;
  }
  DBUG_RETURN(0);
}


981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998
int ha_ndbcluster::set_primary_key_from_old_data(NdbOperation *op, const byte *old_data)
{
  KEY* key_info= table->key_info + table->primary_key;
  KEY_PART_INFO* key_part= key_info->key_part;
  KEY_PART_INFO* end= key_part+key_info->key_parts;
  DBUG_ENTER("set_primary_key_from_old_data");

  for (; key_part != end; key_part++) 
  {
    Field* field= key_part->field;
    if (set_ndb_key(op, field, 
		    key_part->fieldnr-1, old_data+key_part->offset))
      ERR_RETURN(op->getNdbError());
  }
  DBUG_RETURN(0);
}


unknown's avatar
unknown committed
999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020
int ha_ndbcluster::set_primary_key(NdbOperation *op)
{
  DBUG_ENTER("set_primary_key");
  KEY* key_info= table->key_info + table->primary_key;
  KEY_PART_INFO* key_part= key_info->key_part;
  KEY_PART_INFO* end= key_part+key_info->key_parts;

  for (; key_part != end; key_part++) 
  {
    Field* field= key_part->field;
    if (set_ndb_key(op, field, 
                    key_part->fieldnr-1, field->ptr))
      ERR_RETURN(op->getNdbError());
  }
  DBUG_RETURN(0);
}


/*
  Read one record from NDB using primary key
*/

1021
int ha_ndbcluster::pk_read(const byte *key, uint key_len, byte *buf) 
unknown's avatar
unknown committed
1022 1023 1024 1025 1026 1027 1028 1029 1030
{
  uint no_fields= table->fields, i;
  NdbConnection *trans= m_active_trans;
  NdbOperation *op;
  THD *thd= current_thd;
  DBUG_ENTER("pk_read");
  DBUG_PRINT("enter", ("key_len: %u", key_len));
  DBUG_DUMP("key", (char*)key, key_len);

1031 1032
  NdbOperation::LockMode lm=
    (NdbOperation::LockMode)get_ndb_lock_type(m_lock.type);
unknown's avatar
unknown committed
1033
  if (!(op= trans->getNdbOperation((const NDBTAB *) m_table)) || 
1034
      op->readTuple(lm) != 0)
1035
    ERR_RETURN(trans->getNdbError());
unknown's avatar
unknown committed
1036 1037 1038 1039 1040 1041 1042

  if (table->primary_key == MAX_KEY) 
  {
    // This table has no primary key, use "hidden" primary key
    DBUG_PRINT("info", ("Using hidden key"));
    DBUG_DUMP("key", (char*)key, 8);    
    if (set_hidden_key(op, no_fields, key))
1043 1044
      ERR_RETURN(trans->getNdbError());

unknown's avatar
unknown committed
1045
    // Read key at the same time, for future reference
unknown's avatar
unknown committed
1046
    if (get_ndb_value(op, NULL, no_fields, NULL))
1047
      ERR_RETURN(trans->getNdbError());
unknown's avatar
unknown committed
1048 1049 1050 1051 1052 1053 1054 1055
  } 
  else 
  {
    int res;
    if ((res= set_primary_key(op, key)))
      return res;
  }
  
1056
  // Read all wanted non-key field(s) unless HA_EXTRA_RETRIEVE_ALL_COLS
unknown's avatar
unknown committed
1057 1058 1059
  for (i= 0; i < no_fields; i++) 
  {
    Field *field= table->field[i];
1060
    if ((thd->query_id == field->query_id) ||
1061 1062
	m_retrieve_all_fields ||
	(field->flags & PRI_KEY_FLAG) && m_retrieve_primary_key)
unknown's avatar
unknown committed
1063
    {
unknown's avatar
unknown committed
1064
      if (get_ndb_value(op, field, i, buf))
1065
	ERR_RETURN(trans->getNdbError());
unknown's avatar
unknown committed
1066 1067 1068 1069
    }
    else
    {
      // Attribute was not to be read
unknown's avatar
unknown committed
1070
      m_value[i].ptr= NULL;
unknown's avatar
unknown committed
1071 1072 1073
    }
  }
  
unknown's avatar
unknown committed
1074
  if (execute_no_commit_ie(this,trans) != 0) 
unknown's avatar
unknown committed
1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086
  {
    table->status= STATUS_NOT_FOUND;
    DBUG_RETURN(ndb_err(trans));
  }

  // The value have now been fetched from NDB  
  unpack_record(buf);
  table->status= 0;     
  DBUG_RETURN(0);
}


1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098
/*
  Read one complementing record from NDB using primary key from old_data
*/

int ha_ndbcluster::complemented_pk_read(const byte *old_data, byte *new_data)
{
  uint no_fields= table->fields, i;
  NdbConnection *trans= m_active_trans;
  NdbOperation *op;
  THD *thd= current_thd;
  DBUG_ENTER("complemented_pk_read");

1099
  if (m_retrieve_all_fields)
1100 1101 1102
    // We have allready retrieved all fields, nothing to complement
    DBUG_RETURN(0);

1103 1104
  NdbOperation::LockMode lm=
    (NdbOperation::LockMode)get_ndb_lock_type(m_lock.type);
unknown's avatar
unknown committed
1105
  if (!(op= trans->getNdbOperation((const NDBTAB *) m_table)) || 
1106
      op->readTuple(lm) != 0)
1107
    ERR_RETURN(trans->getNdbError());
1108 1109

    int res;
1110
    if ((res= set_primary_key_from_old_data(op, old_data)))
1111
      ERR_RETURN(trans->getNdbError());
1112 1113 1114 1115 1116 1117 1118 1119
    
  // Read all unreferenced non-key field(s)
  for (i= 0; i < no_fields; i++) 
  {
    Field *field= table->field[i];
    if (!(field->flags & PRI_KEY_FLAG) &&
	(thd->query_id != field->query_id))
    {
unknown's avatar
unknown committed
1120
      if (get_ndb_value(op, field, i, new_data))
1121
	ERR_RETURN(trans->getNdbError());
1122 1123 1124
    }
  }
  
unknown's avatar
unknown committed
1125
  if (execute_no_commit(this,trans) != 0) 
1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136
  {
    table->status= STATUS_NOT_FOUND;
    DBUG_RETURN(ndb_err(trans));
  }

  // The value have now been fetched from NDB  
  unpack_record(new_data);
  table->status= 0;     
  DBUG_RETURN(0);
}

1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164
/*
  Peek to check if a particular row already exists
*/

int ha_ndbcluster::peek_row()
{
  NdbConnection *trans= m_active_trans;
  NdbOperation *op;
  THD *thd= current_thd;
  DBUG_ENTER("peek_row");
                                                                                
  NdbOperation::LockMode lm=
    (NdbOperation::LockMode)get_ndb_lock_type(m_lock.type);
  if (!(op= trans->getNdbOperation((const NDBTAB *) m_table)) ||
      op->readTuple(lm) != 0)
    ERR_RETURN(trans->getNdbError());
                                                                                
  int res;
  if ((res= set_primary_key(op)))
    ERR_RETURN(trans->getNdbError());
                                                                                
  if (execute_no_commit_ie(this,trans) != 0)
    {
      table->status= STATUS_NOT_FOUND;
      DBUG_RETURN(ndb_err(trans));
    }                                                                                
  DBUG_RETURN(0);
}
1165

unknown's avatar
unknown committed
1166 1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183
/*
  Read one record from NDB using unique secondary index
*/

int ha_ndbcluster::unique_index_read(const byte *key,
				     uint key_len, byte *buf)
{
  NdbConnection *trans= m_active_trans;
  NdbIndexOperation *op;
  THD *thd= current_thd;
  byte *key_ptr;
  KEY* key_info;
  KEY_PART_INFO *key_part, *end;
  uint i;
  DBUG_ENTER("unique_index_read");
  DBUG_PRINT("enter", ("key_len: %u, index: %u", key_len, active_index));
  DBUG_DUMP("key", (char*)key, key_len);
  
1184 1185
  NdbOperation::LockMode lm=
    (NdbOperation::LockMode)get_ndb_lock_type(m_lock.type);
1186 1187
  if (!(op= trans->getNdbIndexOperation((NDBINDEX *) 
					m_index[active_index].unique_index, 
unknown's avatar
unknown committed
1188
                                        (const NDBTAB *) m_table)) ||
1189
      op->readTuple(lm) != 0)
unknown's avatar
unknown committed
1190 1191 1192 1193 1194 1195 1196 1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207 1208 1209
    ERR_RETURN(trans->getNdbError());
  
  // Set secondary index key(s)
  key_ptr= (byte *) key;
  key_info= table->key_info + active_index;
  DBUG_ASSERT(key_info->key_length == key_len);
  end= (key_part= key_info->key_part) + key_info->key_parts;

  for (i= 0; key_part != end; key_part++, i++) 
  {
    if (set_ndb_key(op, key_part->field, i, key_ptr))
      ERR_RETURN(trans->getNdbError());
    key_ptr+= key_part->length;
  }

  // Get non-index attribute(s)
  for (i= 0; i < table->fields; i++) 
  {
    Field *field= table->field[i];
    if ((thd->query_id == field->query_id) ||
1210
        (field->flags & PRI_KEY_FLAG)) // && m_retrieve_primary_key ??
unknown's avatar
unknown committed
1211
    {
unknown's avatar
unknown committed
1212
      if (get_ndb_value(op, field, i, buf))
unknown's avatar
unknown committed
1213 1214 1215 1216 1217
        ERR_RETURN(op->getNdbError());
    }
    else
    {
      // Attribute was not to be read
unknown's avatar
unknown committed
1218
      m_value[i].ptr= NULL;
unknown's avatar
unknown committed
1219 1220 1221
    }
  }

unknown's avatar
unknown committed
1222
  if (execute_no_commit_ie(this,trans) != 0) 
unknown's avatar
unknown committed
1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233
  {
    table->status= STATUS_NOT_FOUND;
    DBUG_RETURN(ndb_err(trans));
  }
  // The value have now been fetched from NDB
  unpack_record(buf);
  table->status= 0;
  DBUG_RETURN(0);
}

/*
1234 1235 1236 1237 1238 1239 1240 1241
  Get the next record of a started scan. Try to fetch
  it locally from NdbApi cached records if possible, 
  otherwise ask NDB for more.

  NOTE
  If this is a update/delete make sure to not contact 
  NDB before any pending ops have been sent to NDB.

unknown's avatar
unknown committed
1242 1243 1244 1245
*/

inline int ha_ndbcluster::next_result(byte *buf)
{  
1246
  int check;
unknown's avatar
unknown committed
1247 1248 1249
  NdbConnection *trans= m_active_trans;
  NdbResultSet *cursor= m_active_cursor; 
  DBUG_ENTER("next_result");
1250 1251 1252 1253 1254 1255 1256 1257

  if (!cursor)
    DBUG_RETURN(HA_ERR_END_OF_FILE);
    
  /* 
     If this an update or delete, call nextResult with false
     to process any records already cached in NdbApi
  */
1258
  bool contact_ndb= m_lock.type < TL_WRITE_ALLOW_WRITE;
1259 1260
  do {
    DBUG_PRINT("info", ("Call nextResult, contact_ndb: %d", contact_ndb));
unknown's avatar
unknown committed
1261 1262 1263
    /*
      We can only handle one tuple with blobs at a time.
    */
1264
    if (m_ops_pending && m_blobs_pending)
unknown's avatar
unknown committed
1265
    {
unknown's avatar
unknown committed
1266
      if (execute_no_commit(this,trans) != 0)
1267
	DBUG_RETURN(ndb_err(trans));
1268 1269
      m_ops_pending= 0;
      m_blobs_pending= FALSE;
unknown's avatar
unknown committed
1270
    }
1271 1272 1273 1274 1275
    check= cursor->nextResult(contact_ndb);
    if (check == 0)
    {
      // One more record found
      DBUG_PRINT("info", ("One more record found"));    
unknown's avatar
unknown committed
1276

1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290
      unpack_record(buf);
      table->status= 0;
      DBUG_RETURN(0);
    } 
    else if (check == 1 || check == 2)
    {
      // 1: No more records
      // 2: No more cached records

      /*
	Before fetching more rows and releasing lock(s),
	all pending update or delete operations should 
	be sent to NDB
      */
1291 1292
      DBUG_PRINT("info", ("ops_pending: %d", m_ops_pending));    
      if (m_ops_pending)
1293
      {
1294 1295
	//	if (current_thd->transaction.on)
	if (m_transaction_on)
1296 1297 1298 1299 1300 1301 1302 1303
	{
	  if (execute_no_commit(this,trans) != 0)
	    DBUG_RETURN(ndb_err(trans));
	}
	else
	{
	  if  (execute_commit(this,trans) != 0)
	    DBUG_RETURN(ndb_err(trans));
unknown's avatar
unknown committed
1304 1305
	  int res= trans->restart();
	  DBUG_ASSERT(res == 0);
1306
	}
1307
	m_ops_pending= 0;
1308
      }
1309 1310 1311 1312 1313
      
      contact_ndb= (check == 2);
    }
  } while (check == 2);
    
unknown's avatar
unknown committed
1314
  table->status= STATUS_NOT_FOUND;
1315 1316
  if (check == -1)
    DBUG_RETURN(ndb_err(trans));
unknown's avatar
unknown committed
1317 1318 1319 1320 1321 1322

  // No more records
  DBUG_PRINT("info", ("No more records"));
  DBUG_RETURN(HA_ERR_END_OF_FILE);
}

1323
/*
1324
  Set bounds for ordered index scan.
1325 1326
*/

unknown's avatar
unknown committed
1327
int ha_ndbcluster::set_bounds(NdbIndexScanOperation *op,
1328
			      const key_range *keys[2])
1329
{
1330 1331 1332 1333
  const KEY *const key_info= table->key_info + active_index;
  const uint key_parts= key_info->key_parts;
  uint key_tot_len[2];
  uint tot_len;
1334
  uint i, j;
1335 1336

  DBUG_ENTER("set_bounds");
1337
  DBUG_PRINT("info", ("key_parts=%d", key_parts));
1338

1339
  for (j= 0; j <= 1; j++)
1340
  {
1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353
    const key_range *key= keys[j];
    if (key != NULL)
    {
      // for key->flag see ha_rkey_function
      DBUG_PRINT("info", ("key %d length=%d flag=%d",
                          j, key->length, key->flag));
      key_tot_len[j]= key->length;
    }
    else
    {
      DBUG_PRINT("info", ("key %d not present", j));
      key_tot_len[j]= 0;
    }
1354
  }
1355
  tot_len= 0;
1356

1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 1380 1381 1382 1383
  for (i= 0; i < key_parts; i++)
  {
    KEY_PART_INFO *key_part= &key_info->key_part[i];
    Field *field= key_part->field;
    uint part_len= key_part->length;
    uint part_store_len= key_part->store_length;
    // Info about each key part
    struct part_st {
      bool part_last;
      const key_range *key;
      const byte *part_ptr;
      bool part_null;
      int bound_type;
      const char* bound_ptr;
    };
    struct part_st part[2];

    for (j= 0; j <= 1; j++)
    {
      struct part_st &p = part[j];
      p.key= NULL;
      p.bound_type= -1;
      if (tot_len < key_tot_len[j])
      {
        p.part_last= (tot_len + part_store_len >= key_tot_len[j]);
        p.key= keys[j];
        p.part_ptr= &p.key->key[tot_len];
unknown's avatar
unknown committed
1384
        p.part_null= key_part->null_bit && *p.part_ptr;
1385
        p.bound_ptr= (const char *)
unknown's avatar
unknown committed
1386
          p.part_null ? 0 : key_part->null_bit ? p.part_ptr + 1 : p.part_ptr;
1387 1388 1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423

        if (j == 0)
        {
          switch (p.key->flag)
          {
            case HA_READ_KEY_EXACT:
              p.bound_type= NdbIndexScanOperation::BoundEQ;
              break;
            case HA_READ_KEY_OR_NEXT:
              p.bound_type= NdbIndexScanOperation::BoundLE;
              break;
            case HA_READ_AFTER_KEY:
              if (! p.part_last)
                p.bound_type= NdbIndexScanOperation::BoundLE;
              else
                p.bound_type= NdbIndexScanOperation::BoundLT;
              break;
            default:
              break;
          }
        }
        if (j == 1) {
          switch (p.key->flag)
          {
            case HA_READ_BEFORE_KEY:
              if (! p.part_last)
                p.bound_type= NdbIndexScanOperation::BoundGE;
              else
                p.bound_type= NdbIndexScanOperation::BoundGT;
              break;
            case HA_READ_AFTER_KEY:     // weird
              p.bound_type= NdbIndexScanOperation::BoundGE;
              break;
            default:
              break;
          }
        }
1424

1425 1426 1427 1428 1429 1430 1431 1432 1433
        if (p.bound_type == -1)
        {
          DBUG_PRINT("error", ("key %d unknown flag %d", j, p.key->flag));
          DBUG_ASSERT(false);
          // Stop setting bounds but continue with what we have
          DBUG_RETURN(0);
        }
      }
    }
1434

1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451
    // Seen with e.g. b = 1 and c > 1
    if (part[0].bound_type == NdbIndexScanOperation::BoundLE &&
        part[1].bound_type == NdbIndexScanOperation::BoundGE &&
        memcmp(part[0].part_ptr, part[1].part_ptr, part_store_len) == 0)
    {
      DBUG_PRINT("info", ("replace LE/GE pair by EQ"));
      part[0].bound_type= NdbIndexScanOperation::BoundEQ;
      part[1].bound_type= -1;
    }
    // Not seen but was in previous version
    if (part[0].bound_type == NdbIndexScanOperation::BoundEQ &&
        part[1].bound_type == NdbIndexScanOperation::BoundGE &&
        memcmp(part[0].part_ptr, part[1].part_ptr, part_store_len) == 0)
    {
      DBUG_PRINT("info", ("remove GE from EQ/GE pair"));
      part[1].bound_type= -1;
    }
1452

1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464
    for (j= 0; j <= 1; j++)
    {
      struct part_st &p = part[j];
      // Set bound if not done with this key
      if (p.key != NULL)
      {
        DBUG_PRINT("info", ("key %d:%d offset=%d length=%d last=%d bound=%d",
                            j, i, tot_len, part_len, p.part_last, p.bound_type));
        DBUG_DUMP("info", (const char*)p.part_ptr, part_store_len);

        // Set bound if not cancelled via type -1
        if (p.bound_type != -1)
1465 1466 1467 1468 1469
	{
	  char truncated_field_name[NDB_MAX_ATTR_NAME_SIZE];
	  strnmov(truncated_field_name,field->field_name,sizeof(truncated_field_name));
	  truncated_field_name[sizeof(truncated_field_name)-1]= '\0';
          if (op->setBound(truncated_field_name, p.bound_type, p.bound_ptr))
1470
            ERR_RETURN(op->getNdbError());
1471
	}
1472 1473 1474 1475
      }
    }

    tot_len+= part_store_len;
1476
  }
1477
  DBUG_RETURN(0);
1478
}
1479

unknown's avatar
unknown committed
1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494
inline 
int ha_ndbcluster::define_read_attrs(byte* buf, NdbOperation* op)
{
  uint i;
  THD *thd= current_thd;
  NdbConnection *trans= m_active_trans;

  DBUG_ENTER("define_read_attrs");  

  // Define attributes to read
  for (i= 0; i < table->fields; i++) 
  {
    Field *field= table->field[i];
    if ((thd->query_id == field->query_id) ||
	(field->flags & PRI_KEY_FLAG) || 
1495
	m_retrieve_all_fields)
unknown's avatar
unknown committed
1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525
    {      
      if (get_ndb_value(op, field, i, buf))
	ERR_RETURN(op->getNdbError());
    } 
    else 
    {
      m_value[i].ptr= NULL;
    }
  }
    
  if (table->primary_key == MAX_KEY) 
  {
    DBUG_PRINT("info", ("Getting hidden key"));
    // Scanning table with no primary key
    int hidden_no= table->fields;      
#ifndef DBUG_OFF
    const NDBTAB *tab= (const NDBTAB *) m_table;    
    if (!tab->getColumn(hidden_no))
      DBUG_RETURN(1);
#endif
    if (get_ndb_value(op, NULL, hidden_no, NULL))
      ERR_RETURN(op->getNdbError());
  }

  if (execute_no_commit(this,trans) != 0)
    DBUG_RETURN(ndb_err(trans));
  DBUG_PRINT("exit", ("Scan started successfully"));
  DBUG_RETURN(next_result(buf));
} 

unknown's avatar
unknown committed
1526
/*
1527
  Start ordered index scan in NDB
unknown's avatar
unknown committed
1528 1529
*/

1530 1531 1532
int ha_ndbcluster::ordered_index_scan(const key_range *start_key,
				      const key_range *end_key,
				      bool sorted, byte* buf)
unknown's avatar
unknown committed
1533
{  
unknown's avatar
unknown committed
1534
  bool restart;
unknown's avatar
unknown committed
1535
  NdbConnection *trans= m_active_trans;
1536
  NdbResultSet *cursor;
unknown's avatar
unknown committed
1537
  NdbIndexScanOperation *op;
1538

unknown's avatar
unknown committed
1539
  DBUG_ENTER("ordered_index_scan");
1540
  DBUG_PRINT("enter", ("index: %u, sorted: %d", active_index, sorted));  
unknown's avatar
unknown committed
1541
  DBUG_PRINT("enter", ("Starting new ordered scan on %s", m_tabname));
1542

1543 1544
  // Check that sorted seems to be initialised
  DBUG_ASSERT(sorted == 0 || sorted == 1);
unknown's avatar
unknown committed
1545
  
1546
  if (m_active_cursor == 0)
unknown's avatar
unknown committed
1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566
  {
    restart= false;
    NdbOperation::LockMode lm=
      (NdbOperation::LockMode)get_ndb_lock_type(m_lock.type);
    if (!(op= trans->getNdbIndexScanOperation((NDBINDEX *)
					      m_index[active_index].index, 
					      (const NDBTAB *) m_table)) ||
	!(cursor= op->readTuples(lm, 0, parallelism, sorted)))
      ERR_RETURN(trans->getNdbError());
    m_active_cursor= cursor;
  } else {
    restart= true;
    op= (NdbIndexScanOperation*)m_active_cursor->getOperation();
    
    DBUG_ASSERT(op->getSorted() == sorted);
    DBUG_ASSERT(op->getLockMode() == 
		(NdbOperation::LockMode)get_ndb_lock_type(m_lock.type));
    if(op->reset_bounds())
      DBUG_RETURN(ndb_err(m_active_trans));
  }
1567

1568
  {
1569 1570 1571 1572
    const key_range *keys[2]= { start_key, end_key };
    int ret= set_bounds(op, keys);
    if (ret)
      DBUG_RETURN(ret);
1573
  }
1574 1575

  if (!restart)
unknown's avatar
unknown committed
1576 1577 1578 1579 1580 1581 1582 1583 1584 1585
  {
    DBUG_RETURN(define_read_attrs(buf, op));
  }
  else
  {
    if (execute_no_commit(this,trans) != 0)
      DBUG_RETURN(ndb_err(trans));
    
    DBUG_RETURN(next_result(buf));
  }
unknown's avatar
unknown committed
1586 1587 1588
} 

/*
1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599
  Start a filtered scan in NDB.

  NOTE
  This function is here as an example of how to start a
  filtered scan. It should be possible to replace full_table_scan 
  with this function and make a best effort attempt 
  at filtering out the irrelevant data by converting the "items" 
  into interpreted instructions.
  This would speed up table scans where there is a limiting WHERE clause
  that doesn't match any index in the table.

unknown's avatar
unknown committed
1600 1601 1602 1603 1604 1605 1606
 */

int ha_ndbcluster::filtered_scan(const byte *key, uint key_len, 
				 byte *buf,
				 enum ha_rkey_function find_flag)
{  
  NdbConnection *trans= m_active_trans;
1607 1608
  NdbResultSet *cursor;
  NdbScanOperation *op;
unknown's avatar
unknown committed
1609 1610 1611 1612 1613 1614 1615

  DBUG_ENTER("filtered_scan");
  DBUG_PRINT("enter", ("key_len: %u, index: %u", 
                       key_len, active_index));
  DBUG_DUMP("key", (char*)key, key_len);  
  DBUG_PRINT("info", ("Starting a new filtered scan on %s",
		      m_tabname));
1616

1617 1618 1619 1620
  NdbOperation::LockMode lm=
    (NdbOperation::LockMode)get_ndb_lock_type(m_lock.type);
  if (!(op= trans->getNdbScanOperation((const NDBTAB *) m_table)) ||
      !(cursor= op->readTuples(lm, 0, parallelism)))
unknown's avatar
unknown committed
1621 1622
    ERR_RETURN(trans->getNdbError());
  m_active_cursor= cursor;
unknown's avatar
unknown committed
1623
  
unknown's avatar
unknown committed
1624 1625 1626 1627 1628 1629 1630 1631 1632 1633 1634 1635 1636 1637 1638
  {
    // Start scan filter
    NdbScanFilter sf(op);
    sf.begin();
      
    // Set filter using the supplied key data
    byte *key_ptr= (byte *) key;    
    uint tot_len= 0;
    KEY* key_info= table->key_info + active_index;
    for (uint k= 0; k < key_info->key_parts; k++) 
    {
      KEY_PART_INFO* key_part= key_info->key_part+k;
      Field* field= key_part->field;
      uint ndb_fieldnr= key_part->fieldnr-1;
      DBUG_PRINT("key_part", ("fieldnr: %d", ndb_fieldnr));
1639
      //const NDBCOL *col= ((const NDBTAB *) m_table)->getColumn(ndb_fieldnr);
unknown's avatar
unknown committed
1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668
      uint32 field_len=  field->pack_length();
      DBUG_DUMP("key", (char*)key, field_len);
	
      DBUG_PRINT("info", ("Column %s, type: %d, len: %d", 
			  field->field_name, field->real_type(), field_len));
	
      // Define scan filter
      if (field->real_type() == MYSQL_TYPE_STRING)
	sf.eq(ndb_fieldnr, key_ptr, field_len);
      else 
      {
	if (field_len == 8)
	  sf.eq(ndb_fieldnr, (Uint64)*key_ptr);
	else if (field_len <= 4)
	  sf.eq(ndb_fieldnr, (Uint32)*key_ptr);
	else 
	  DBUG_RETURN(1);
      }
	
      key_ptr += field_len;
      tot_len += field_len;
	
      if (tot_len >= key_len)
	break;
    }
    // End scan filter
    sf.end();
  }

1669
  DBUG_RETURN(define_read_attrs(buf, op));
unknown's avatar
unknown committed
1670 1671 1672 1673
} 


/*
1674
  Start full table scan in NDB
unknown's avatar
unknown committed
1675 1676 1677 1678 1679 1680 1681
 */

int ha_ndbcluster::full_table_scan(byte *buf)
{
  uint i;
  NdbResultSet *cursor;
  NdbScanOperation *op;
1682
  NdbConnection *trans= m_active_trans;
unknown's avatar
unknown committed
1683 1684 1685 1686

  DBUG_ENTER("full_table_scan");  
  DBUG_PRINT("enter", ("Starting new scan on %s", m_tabname));

1687 1688 1689 1690
  NdbOperation::LockMode lm=
    (NdbOperation::LockMode)get_ndb_lock_type(m_lock.type);
  if (!(op=trans->getNdbScanOperation((const NDBTAB *) m_table)) ||
      !(cursor= op->readTuples(lm, 0, parallelism)))
unknown's avatar
unknown committed
1691 1692
    ERR_RETURN(trans->getNdbError());
  m_active_cursor= cursor;
1693 1694 1695
  DBUG_RETURN(define_read_attrs(buf, op));
}

unknown's avatar
unknown committed
1696 1697 1698 1699 1700
/*
  Insert one record into NDB
*/
int ha_ndbcluster::write_row(byte *record)
{
unknown's avatar
unknown committed
1701
  bool has_auto_increment;
unknown's avatar
unknown committed
1702 1703 1704 1705 1706
  uint i;
  NdbConnection *trans= m_active_trans;
  NdbOperation *op;
  int res;
  DBUG_ENTER("write_row");
1707

1708
  if(m_ignore_dup_key && table->primary_key != MAX_KEY)
1709
  {
1710 1711 1712 1713 1714 1715 1716 1717 1718
    int peek_res= peek_row();
    
    if (!peek_res) 
    {
      m_dupkey= table->primary_key;
      DBUG_RETURN(HA_ERR_FOUND_DUPP_KEY);
    }
    if (peek_res != HA_ERR_KEY_NOT_FOUND)
      DBUG_RETURN(peek_res);
1719
  }
unknown's avatar
unknown committed
1720 1721
  
  statistic_increment(ha_write_count,&LOCK_status);
unknown's avatar
unknown committed
1722 1723
  if (table->timestamp_field_type & TIMESTAMP_AUTO_SET_ON_INSERT)
    table->timestamp_field->set_time();
1724
  has_auto_increment= (table->next_number_field && record == table->record[0]);
unknown's avatar
unknown committed
1725

unknown's avatar
unknown committed
1726
  if (!(op= trans->getNdbOperation((const NDBTAB *) m_table)))
unknown's avatar
unknown committed
1727 1728 1729 1730 1731 1732 1733 1734 1735
    ERR_RETURN(trans->getNdbError());

  res= (m_use_write) ? op->writeTuple() :op->insertTuple(); 
  if (res != 0)
    ERR_RETURN(trans->getNdbError());  
 
  if (table->primary_key == MAX_KEY) 
  {
    // Table has hidden primary key
unknown's avatar
unknown committed
1736
    Uint64 auto_value= m_ndb->getAutoIncrementValue((const NDBTAB *) m_table);
unknown's avatar
unknown committed
1737 1738 1739 1740 1741 1742
    if (set_hidden_key(op, table->fields, (const byte*)&auto_value))
      ERR_RETURN(op->getNdbError());
  } 
  else 
  {
    int res;
1743

1744 1745
    if (has_auto_increment) 
    {
1746
      m_skip_auto_increment= FALSE;
1747
      update_auto_increment();
1748
      m_skip_auto_increment= !auto_increment_column_changed;
1749
    }
1750

unknown's avatar
unknown committed
1751 1752 1753 1754 1755
    if ((res= set_primary_key(op)))
      return res;
  }

  // Set non-key attribute(s)
unknown's avatar
unknown committed
1756
  bool set_blob_value= FALSE;
unknown's avatar
unknown committed
1757 1758 1759 1760
  for (i= 0; i < table->fields; i++) 
  {
    Field *field= table->field[i];
    if (!(field->flags & PRI_KEY_FLAG) &&
1761
	set_ndb_value(op, field, i, &set_blob_value))
1762
    {
1763
      m_skip_auto_increment= TRUE;
unknown's avatar
unknown committed
1764
      ERR_RETURN(op->getNdbError());
1765
    }
unknown's avatar
unknown committed
1766 1767 1768 1769 1770 1771 1772 1773 1774
  }

  /*
    Execute write operation
    NOTE When doing inserts with many values in 
    each INSERT statement it should not be necessary
    to NoCommit the transaction between each row.
    Find out how this is detected!
  */
1775
  m_rows_inserted++;
1776
  no_uncommitted_rows_update(1);
1777 1778 1779
  m_bulk_insert_not_flushed= TRUE;
  if ((m_rows_to_insert == 1) || 
      ((m_rows_inserted % m_bulk_insert_rows) == 0) ||
1780
      set_blob_value)
1781
  {
1782
    THD *thd= current_thd;
1783 1784 1785
    // Send rows to NDB
    DBUG_PRINT("info", ("Sending inserts to NDB, "\
			"rows_inserted:%d, bulk_insert_rows: %d", 
1786
			(int)m_rows_inserted, (int)m_bulk_insert_rows));
1787

1788
    m_bulk_insert_not_flushed= FALSE;
1789 1790
    //    if (thd->transaction.on)
    if (m_transaction_on)
1791
    {
unknown's avatar
unknown committed
1792
      if (execute_no_commit(this,trans) != 0)
1793
      {
1794
	m_skip_auto_increment= TRUE;
1795
	no_uncommitted_rows_execute_failure();
1796 1797
	DBUG_RETURN(ndb_err(trans));
      }
1798 1799
    }
    else
1800
    {
unknown's avatar
unknown committed
1801
      if (execute_commit(this,trans) != 0)
1802
      {
1803
	m_skip_auto_increment= TRUE;
1804
	no_uncommitted_rows_execute_failure();
1805
	DBUG_RETURN(ndb_err(trans));
1806
      }
unknown's avatar
unknown committed
1807 1808
      int res= trans->restart();
      DBUG_ASSERT(res == 0);
1809
    }
1810
  }
1811
  if ((has_auto_increment) && (m_skip_auto_increment))
unknown's avatar
unknown committed
1812
  {
1813
    Uint64 next_val= (Uint64) table->next_number_field->val_int() + 1;
unknown's avatar
unknown committed
1814
    DBUG_PRINT("info", 
1815 1816
	       ("Trying to set next auto increment value to %lu",
                (ulong) next_val));
unknown's avatar
unknown committed
1817
    if (m_ndb->setAutoIncrementValue((const NDBTAB *) m_table, next_val, TRUE))
unknown's avatar
unknown committed
1818 1819
      DBUG_PRINT("info", 
		 ("Setting next auto increment value to %u", next_val));  
1820
  }
1821
  m_skip_auto_increment= TRUE;
1822

unknown's avatar
unknown committed
1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868
  DBUG_RETURN(0);
}


/* Compare if a key in a row has changed */

int ha_ndbcluster::key_cmp(uint keynr, const byte * old_row,
			   const byte * new_row)
{
  KEY_PART_INFO *key_part=table->key_info[keynr].key_part;
  KEY_PART_INFO *end=key_part+table->key_info[keynr].key_parts;

  for (; key_part != end ; key_part++)
  {
    if (key_part->null_bit)
    {
      if ((old_row[key_part->null_offset] & key_part->null_bit) !=
	  (new_row[key_part->null_offset] & key_part->null_bit))
	return 1;
    }
    if (key_part->key_part_flag & (HA_BLOB_PART | HA_VAR_LENGTH))
    {

      if (key_part->field->cmp_binary((char*) (old_row + key_part->offset),
				      (char*) (new_row + key_part->offset),
				      (ulong) key_part->length))
	return 1;
    }
    else
    {
      if (memcmp(old_row+key_part->offset, new_row+key_part->offset,
		 key_part->length))
	return 1;
    }
  }
  return 0;
}

/*
  Update one record in NDB using primary key
*/

int ha_ndbcluster::update_row(const byte *old_data, byte *new_data)
{
  THD *thd= current_thd;
  NdbConnection *trans= m_active_trans;
1869
  NdbResultSet* cursor= m_active_cursor;
unknown's avatar
unknown committed
1870 1871 1872 1873 1874
  NdbOperation *op;
  uint i;
  DBUG_ENTER("update_row");
  
  statistic_increment(ha_update_count,&LOCK_status);
unknown's avatar
unknown committed
1875 1876 1877
  if (table->timestamp_field_type & TIMESTAMP_AUTO_SET_ON_UPDATE)
    table->timestamp_field->set_time();

1878
  /* Check for update of primary key for special handling */  
1879 1880
  if ((table->primary_key != MAX_KEY) &&
      (key_cmp(table->primary_key, old_data, new_data)))
1881
  {
1882
    int read_res, insert_res, delete_res;
1883

1884
    DBUG_PRINT("info", ("primary key update, doing pk read+insert+delete"));
1885
    // Get all old fields, since we optimize away fields not in query
1886
    read_res= complemented_pk_read(old_data, new_data);
1887 1888 1889 1890 1891 1892
    if (read_res)
    {
      DBUG_PRINT("info", ("pk read failed"));
      DBUG_RETURN(read_res);
    }
    // Insert new row
1893 1894
    insert_res= write_row(new_data);
    if (insert_res)
1895 1896 1897 1898
    {
      DBUG_PRINT("info", ("insert failed"));
      DBUG_RETURN(insert_res);
    }
1899 1900
    // Delete old row
    DBUG_PRINT("info", ("insert succeded"));
1901
    m_primary_key_update= TRUE;
1902
    delete_res= delete_row(old_data);
1903
    m_primary_key_update= FALSE;
1904 1905 1906 1907 1908 1909 1910 1911
    if (delete_res)
    {
      DBUG_PRINT("info", ("delete failed"));
      // Undo write_row(new_data)
      DBUG_RETURN(delete_row(new_data));
    }     
    DBUG_PRINT("info", ("insert+delete succeeded"));
    DBUG_RETURN(0);
1912
  }
1913

1914
  if (cursor)
unknown's avatar
unknown committed
1915
  {
1916 1917 1918 1919 1920 1921 1922 1923 1924 1925
    /*
      We are scanning records and want to update the record
      that was just found, call updateTuple on the cursor 
      to take over the lock to a new update operation
      And thus setting the primary key of the record from 
      the active record in cursor
    */
    DBUG_PRINT("info", ("Calling updateTuple on cursor"));
    if (!(op= cursor->updateTuple()))
      ERR_RETURN(trans->getNdbError());
1926
    m_ops_pending++;
unknown's avatar
unknown committed
1927
    if (uses_blob_value(FALSE))
1928
      m_blobs_pending= TRUE;
1929 1930 1931
  }
  else
  {  
unknown's avatar
unknown committed
1932
    if (!(op= trans->getNdbOperation((const NDBTAB *) m_table)) ||
1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943
	op->updateTuple() != 0)
      ERR_RETURN(trans->getNdbError());  
    
    if (table->primary_key == MAX_KEY) 
    {
      // This table has no primary key, use "hidden" primary key
      DBUG_PRINT("info", ("Using hidden key"));
      
      // Require that the PK for this record has previously been 
      // read into m_value
      uint no_fields= table->fields;
unknown's avatar
unknown committed
1944
      NdbRecAttr* rec= m_value[no_fields].rec;
1945 1946 1947 1948 1949 1950 1951 1952 1953
      DBUG_ASSERT(rec);
      DBUG_DUMP("key", (char*)rec->aRef(), NDB_HIDDEN_PRIMARY_KEY_LENGTH);
      
      if (set_hidden_key(op, no_fields, rec->aRef()))
	ERR_RETURN(op->getNdbError());
    } 
    else 
    {
      int res;
1954
      if ((res= set_primary_key_from_old_data(op, old_data)))
1955 1956
	DBUG_RETURN(res);
    }
unknown's avatar
unknown committed
1957 1958 1959 1960 1961 1962
  }

  // Set non-key attribute(s)
  for (i= 0; i < table->fields; i++) 
  {
    Field *field= table->field[i];
1963
    if (((thd->query_id == field->query_id) || m_retrieve_all_fields) &&
unknown's avatar
unknown committed
1964 1965 1966 1967
        (!(field->flags & PRI_KEY_FLAG)) &&
	set_ndb_value(op, field, i))
      ERR_RETURN(op->getNdbError());
  }
1968

unknown's avatar
unknown committed
1969
  // Execute update operation
unknown's avatar
unknown committed
1970
  if (!cursor && execute_no_commit(this,trans) != 0) {
1971
    no_uncommitted_rows_execute_failure();
unknown's avatar
unknown committed
1972
    DBUG_RETURN(ndb_err(trans));
1973
  }
unknown's avatar
unknown committed
1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985
  
  DBUG_RETURN(0);
}


/*
  Delete one record from NDB, using primary key 
*/

int ha_ndbcluster::delete_row(const byte *record)
{
  NdbConnection *trans= m_active_trans;
1986
  NdbResultSet* cursor= m_active_cursor;
unknown's avatar
unknown committed
1987 1988 1989 1990 1991
  NdbOperation *op;
  DBUG_ENTER("delete_row");

  statistic_increment(ha_delete_count,&LOCK_status);

1992
  if (cursor)
unknown's avatar
unknown committed
1993
  {
1994
    /*
1995
      We are scanning records and want to delete the record
1996
      that was just found, call deleteTuple on the cursor 
1997
      to take over the lock to a new delete operation
1998 1999 2000 2001 2002 2003
      And thus setting the primary key of the record from 
      the active record in cursor
    */
    DBUG_PRINT("info", ("Calling deleteTuple on cursor"));
    if (cursor->deleteTuple() != 0)
      ERR_RETURN(trans->getNdbError());     
2004
    m_ops_pending++;
unknown's avatar
unknown committed
2005

2006 2007
    no_uncommitted_rows_update(-1);

2008 2009 2010 2011
    // If deleting from cursor, NoCommit will be handled in next_result
    DBUG_RETURN(0);
  }
  else
unknown's avatar
unknown committed
2012
  {
2013
    
unknown's avatar
unknown committed
2014
    if (!(op=trans->getNdbOperation((const NDBTAB *) m_table)) || 
2015 2016 2017
	op->deleteTuple() != 0)
      ERR_RETURN(trans->getNdbError());
    
2018 2019
    no_uncommitted_rows_update(-1);
    
2020 2021 2022 2023 2024
    if (table->primary_key == MAX_KEY) 
    {
      // This table has no primary key, use "hidden" primary key
      DBUG_PRINT("info", ("Using hidden key"));
      uint no_fields= table->fields;
unknown's avatar
unknown committed
2025
      NdbRecAttr* rec= m_value[no_fields].rec;
2026 2027 2028 2029 2030 2031 2032 2033
      DBUG_ASSERT(rec != NULL);
      
      if (set_hidden_key(op, no_fields, rec->aRef()))
	ERR_RETURN(op->getNdbError());
    } 
    else 
    {
      int res;
2034 2035 2036 2037
      if ((res= (m_primary_key_update ?
		 set_primary_key_from_old_data(op, record)
		 : set_primary_key(op))))
	  return res;  
2038
    }
unknown's avatar
unknown committed
2039
  }
2040
  
unknown's avatar
unknown committed
2041
  // Execute delete operation
unknown's avatar
unknown committed
2042
  if (execute_no_commit(this,trans) != 0) {
2043
    no_uncommitted_rows_execute_failure();
unknown's avatar
unknown committed
2044
    DBUG_RETURN(ndb_err(trans));
2045
  }
unknown's avatar
unknown committed
2046 2047
  DBUG_RETURN(0);
}
2048
  
unknown's avatar
unknown committed
2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066
/*
  Unpack a record read from NDB 

  SYNOPSIS
    unpack_record()
    buf			Buffer to store read row

  NOTE
    The data for each row is read directly into the
    destination buffer. This function is primarily 
    called in order to check if any fields should be 
    set to null.
*/

void ha_ndbcluster::unpack_record(byte* buf)
{
  uint row_offset= (uint) (buf - table->record[0]);
  Field **field, **end;
unknown's avatar
unknown committed
2067
  NdbValue *value= m_value;
unknown's avatar
unknown committed
2068 2069 2070 2071 2072 2073 2074 2075
  DBUG_ENTER("unpack_record");
  
  // Set null flag(s)
  bzero(buf, table->null_bytes);
  for (field= table->field, end= field+table->fields;
       field < end;
       field++, value++)
  {
unknown's avatar
unknown committed
2076 2077 2078 2079 2080 2081 2082 2083 2084 2085
    if ((*value).ptr)
    {
      if (! ((*field)->flags & BLOB_FLAG))
      {
        if ((*value).rec->isNULL())
         (*field)->set_null(row_offset);
      }
      else
      {
        NdbBlob* ndb_blob= (*value).blob;
unknown's avatar
unknown committed
2086
        bool isNull= TRUE;
unknown's avatar
unknown committed
2087 2088 2089 2090 2091 2092
        int ret= ndb_blob->getNull(isNull);
        DBUG_ASSERT(ret == 0);
        if (isNull)
         (*field)->set_null(row_offset);
      }
    }
unknown's avatar
unknown committed
2093 2094 2095 2096 2097 2098 2099 2100
  }

#ifndef DBUG_OFF
  // Read and print all values that was fetched
  if (table->primary_key == MAX_KEY)
  {
    // Table with hidden primary key
    int hidden_no= table->fields;
unknown's avatar
unknown committed
2101
    const NDBTAB *tab= (const NDBTAB *) m_table;
unknown's avatar
unknown committed
2102
    const NDBCOL *hidden_col= tab->getColumn(hidden_no);
unknown's avatar
unknown committed
2103
    NdbRecAttr* rec= m_value[hidden_no].rec;
unknown's avatar
unknown committed
2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118
    DBUG_ASSERT(rec);
    DBUG_PRINT("hidden", ("%d: %s \"%llu\"", hidden_no, 
                          hidden_col->getName(), rec->u_64_value()));
  } 
  print_results();
#endif
  DBUG_VOID_RETURN;
}

/*
  Utility function to print/dump the fetched field
 */

void ha_ndbcluster::print_results()
{
unknown's avatar
unknown committed
2119
  const NDBTAB *tab= (const NDBTAB*) m_table;
unknown's avatar
unknown committed
2120 2121 2122 2123 2124 2125 2126 2127 2128 2129
  DBUG_ENTER("print_results");

#ifndef DBUG_OFF
  if (!_db_on_)
    DBUG_VOID_RETURN;
  
  for (uint f=0; f<table->fields;f++)
  {
    Field *field;
    const NDBCOL *col;
unknown's avatar
unknown committed
2130
    NdbValue value;
unknown's avatar
unknown committed
2131

unknown's avatar
unknown committed
2132
    if (!(value= m_value[f]).ptr)
unknown's avatar
unknown committed
2133 2134 2135 2136 2137 2138 2139 2140
    {
      fprintf(DBUG_FILE, "Field %d was not read\n", f);
      continue;
    }
    field= table->field[f];
    DBUG_DUMP("field->ptr", (char*)field->ptr, field->pack_length());
    col= tab->getColumn(f);
    fprintf(DBUG_FILE, "%d: %s\t", f, col->getName());
unknown's avatar
unknown committed
2141 2142 2143

    NdbBlob *ndb_blob= NULL;
    if (! (field->flags & BLOB_FLAG))
unknown's avatar
unknown committed
2144
    {
unknown's avatar
unknown committed
2145 2146 2147 2148 2149 2150 2151 2152 2153
      if (value.rec->isNULL())
      {
        fprintf(DBUG_FILE, "NULL\n");
        continue;
      }
    }
    else
    {
      ndb_blob= value.blob;
unknown's avatar
unknown committed
2154
      bool isNull= TRUE;
unknown's avatar
unknown committed
2155 2156 2157 2158 2159
      ndb_blob->getNull(isNull);
      if (isNull) {
        fprintf(DBUG_FILE, "NULL\n");
        continue;
      }
unknown's avatar
unknown committed
2160 2161 2162 2163 2164 2165 2166 2167 2168 2169 2170 2171 2172 2173 2174 2175 2176 2177 2178 2179 2180 2181 2182 2183 2184 2185 2186 2187 2188 2189 2190 2191 2192 2193 2194 2195 2196 2197 2198 2199 2200 2201 2202 2203 2204 2205 2206 2207 2208 2209 2210 2211 2212 2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227 2228 2229 2230
    }

    switch (col->getType()) {
    case NdbDictionary::Column::Tinyint: {
      char value= *field->ptr;
      fprintf(DBUG_FILE, "Tinyint\t%d", value);
      break;
    }
    case NdbDictionary::Column::Tinyunsigned: {
      unsigned char value= *field->ptr;
      fprintf(DBUG_FILE, "Tinyunsigned\t%u", value);
      break;
    }
    case NdbDictionary::Column::Smallint: {
      short value= *field->ptr;
      fprintf(DBUG_FILE, "Smallint\t%d", value);
      break;
    }
    case NdbDictionary::Column::Smallunsigned: {
      unsigned short value= *field->ptr;
      fprintf(DBUG_FILE, "Smallunsigned\t%u", value);
      break;
    }
    case NdbDictionary::Column::Mediumint: {
      byte value[3];
      memcpy(value, field->ptr, 3);
      fprintf(DBUG_FILE, "Mediumint\t%d,%d,%d", value[0], value[1], value[2]);
      break;
    }
    case NdbDictionary::Column::Mediumunsigned: {
      byte value[3];
      memcpy(value, field->ptr, 3);
      fprintf(DBUG_FILE, "Mediumunsigned\t%u,%u,%u", value[0], value[1], value[2]);
      break;
    }
    case NdbDictionary::Column::Int: {
      fprintf(DBUG_FILE, "Int\t%lld", field->val_int());
      break;
    }
    case NdbDictionary::Column::Unsigned: {
      Uint32 value= (Uint32) *field->ptr;
      fprintf(DBUG_FILE, "Unsigned\t%u", value);
      break;
    }
    case NdbDictionary::Column::Bigint: {
      Int64 value= (Int64) *field->ptr;
      fprintf(DBUG_FILE, "Bigint\t%lld", value);
      break;
    }
    case NdbDictionary::Column::Bigunsigned: {
      Uint64 value= (Uint64) *field->ptr;
      fprintf(DBUG_FILE, "Bigunsigned\t%llu", value);
      break;
    }
    case NdbDictionary::Column::Float: {
      float value= (float) *field->ptr;
      fprintf(DBUG_FILE, "Float\t%f", value);
      break;
    }
    case NdbDictionary::Column::Double: {
      double value= (double) *field->ptr;
      fprintf(DBUG_FILE, "Double\t%f", value);
      break;
    }
    case NdbDictionary::Column::Decimal: {
      char *value= field->ptr;

      fprintf(DBUG_FILE, "Decimal\t'%-*s'", field->pack_length(), value);
      break;
    }
    case NdbDictionary::Column::Char:{
2231 2232
      const char *value= (char *) field->ptr;
      fprintf(DBUG_FILE, "Char\t'%.*s'", field->pack_length(), value);
unknown's avatar
unknown committed
2233 2234 2235 2236 2237
      break;
    }
    case NdbDictionary::Column::Varchar:
    case NdbDictionary::Column::Binary:
    case NdbDictionary::Column::Varbinary: {
2238 2239
      const char *value= (char *) field->ptr;
      fprintf(DBUG_FILE, "Var\t'%.*s'", field->pack_length(), value);
unknown's avatar
unknown committed
2240 2241 2242 2243 2244 2245 2246 2247 2248 2249 2250 2251
      break;
    }
    case NdbDictionary::Column::Datetime: {
      Uint64 value= (Uint64) *field->ptr;
      fprintf(DBUG_FILE, "Datetime\t%llu", value);
      break;
    }
    case NdbDictionary::Column::Timespec: {
      Uint64 value= (Uint64) *field->ptr;
      fprintf(DBUG_FILE, "Timespec\t%llu", value);
      break;
    }
unknown's avatar
unknown committed
2252 2253 2254 2255 2256 2257 2258 2259 2260 2261 2262 2263 2264 2265 2266
    case NdbDictionary::Column::Blob: {
      Uint64 len= 0;
      ndb_blob->getLength(len);
      fprintf(DBUG_FILE, "Blob\t[len=%u]", (unsigned)len);
      break;
    }
    case NdbDictionary::Column::Text: {
      Uint64 len= 0;
      ndb_blob->getLength(len);
      fprintf(DBUG_FILE, "Text\t[len=%u]", (unsigned)len);
      break;
    }
    case NdbDictionary::Column::Undefined:
      fprintf(DBUG_FILE, "Unknown type: %d", col->getType());
      break;
unknown's avatar
unknown committed
2267 2268 2269 2270 2271 2272 2273 2274 2275 2276 2277 2278 2279 2280 2281 2282 2283 2284 2285 2286
    }
    fprintf(DBUG_FILE, "\n");
    
  }
#endif
  DBUG_VOID_RETURN;
}


int ha_ndbcluster::index_init(uint index)
{
  DBUG_ENTER("index_init");
  DBUG_PRINT("enter", ("index: %u", index));
  DBUG_RETURN(handler::index_init(index));
}


int ha_ndbcluster::index_end()
{
  DBUG_ENTER("index_end");
2287
  DBUG_RETURN(close_scan());
unknown's avatar
unknown committed
2288 2289 2290 2291
}


int ha_ndbcluster::index_read(byte *buf,
2292 2293
			      const byte *key, uint key_len, 
			      enum ha_rkey_function find_flag)
unknown's avatar
unknown committed
2294 2295 2296 2297 2298
{
  DBUG_ENTER("index_read");
  DBUG_PRINT("enter", ("active_index: %u, key_len: %u, find_flag: %d", 
                       active_index, key_len, find_flag));

unknown's avatar
unknown committed
2299 2300 2301 2302 2303 2304 2305 2306 2307 2308 2309 2310 2311 2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323 2324 2325 2326 2327 2328
  int error;
  ndb_index_type type = get_index_type(active_index);
  const KEY* key_info = table->key_info+active_index;
  switch (type){
  case PRIMARY_KEY_ORDERED_INDEX:
  case PRIMARY_KEY_INDEX:
    if (find_flag == HA_READ_KEY_EXACT && key_info->key_length == key_len)
    {
      DBUG_RETURN(pk_read(key, key_len, buf));
    }
    else if (type == PRIMARY_KEY_INDEX)
    {
      DBUG_RETURN(1);
    }
    break;
  case UNIQUE_ORDERED_INDEX:
  case UNIQUE_INDEX:
    if (find_flag == HA_READ_KEY_EXACT && key_info->key_length == key_len)
    {
      DBUG_RETURN(unique_index_read(key, key_len, buf));
    }
    else if (type == UNIQUE_INDEX)
    {
      DBUG_RETURN(1);
    }
    break;
  case ORDERED_INDEX:
    break;
  default:
  case UNDEFINED_INDEX:
unknown's avatar
unknown committed
2329
    DBUG_ASSERT(FALSE);
2330
    DBUG_RETURN(1);
unknown's avatar
unknown committed
2331 2332 2333
    break;
  }
  
2334
  key_range start_key;
unknown's avatar
unknown committed
2335 2336 2337
  start_key.key = key;
  start_key.length = key_len;
  start_key.flag = find_flag;
unknown's avatar
unknown committed
2338
  error= ordered_index_scan(&start_key, 0, TRUE, buf);  
unknown's avatar
unknown committed
2339
  DBUG_RETURN(error == HA_ERR_END_OF_FILE ? HA_ERR_KEY_NOT_FOUND : error);
unknown's avatar
unknown committed
2340 2341 2342 2343 2344 2345 2346 2347 2348 2349 2350 2351 2352 2353 2354 2355 2356 2357 2358
}


int ha_ndbcluster::index_read_idx(byte *buf, uint index_no, 
			      const byte *key, uint key_len, 
			      enum ha_rkey_function find_flag)
{
  statistic_increment(ha_read_key_count,&LOCK_status);
  DBUG_ENTER("index_read_idx");
  DBUG_PRINT("enter", ("index_no: %u, key_len: %u", index_no, key_len));  
  index_init(index_no);  
  DBUG_RETURN(index_read(buf, key, key_len, find_flag));
}


int ha_ndbcluster::index_next(byte *buf)
{
  DBUG_ENTER("index_next");

2359
  int error= 1;
unknown's avatar
unknown committed
2360
  statistic_increment(ha_read_next_count,&LOCK_status);
2361
  DBUG_RETURN(next_result(buf));
unknown's avatar
unknown committed
2362 2363 2364 2365 2366 2367 2368 2369 2370 2371 2372 2373 2374 2375 2376
}


int ha_ndbcluster::index_prev(byte *buf)
{
  DBUG_ENTER("index_prev");
  statistic_increment(ha_read_prev_count,&LOCK_status);
  DBUG_RETURN(1);
}


int ha_ndbcluster::index_first(byte *buf)
{
  DBUG_ENTER("index_first");
  statistic_increment(ha_read_first_count,&LOCK_status);
unknown's avatar
unknown committed
2377 2378 2379
  // Start the ordered index scan and fetch the first row

  // Only HA_READ_ORDER indexes get called by index_first
unknown's avatar
unknown committed
2380
  DBUG_RETURN(ordered_index_scan(0, 0, TRUE, buf));
unknown's avatar
unknown committed
2381 2382 2383 2384 2385 2386 2387
}


int ha_ndbcluster::index_last(byte *buf)
{
  DBUG_ENTER("index_last");
  statistic_increment(ha_read_last_count,&LOCK_status);
unknown's avatar
unknown committed
2388
  int res;
unknown's avatar
unknown committed
2389
  if((res= ordered_index_scan(0, 0, TRUE, buf)) == 0){
unknown's avatar
unknown committed
2390
    NdbResultSet *cursor= m_active_cursor; 
unknown's avatar
unknown committed
2391
    while((res= cursor->nextResult(TRUE)) == 0);
unknown's avatar
unknown committed
2392 2393 2394 2395 2396 2397
    if(res == 1){
      unpack_record(buf);
      table->status= 0;     
      DBUG_RETURN(0);
    }
  }
unknown's avatar
unknown committed
2398
  DBUG_RETURN(res);
unknown's avatar
unknown committed
2399 2400 2401
}


2402 2403 2404 2405 2406 2407 2408 2409 2410
inline
int ha_ndbcluster::read_range_first_to_buf(const key_range *start_key,
					   const key_range *end_key,
					   bool eq_range, bool sorted,
					   byte* buf)
{
  KEY* key_info;
  int error= 1; 
  DBUG_ENTER("ha_ndbcluster::read_range_first_to_buf");
2411
  DBUG_PRINT("info", ("eq_range: %d, sorted: %d", eq_range, sorted));
2412

2413
  switch (get_index_type(active_index)){
2414
  case PRIMARY_KEY_ORDERED_INDEX:
2415
  case PRIMARY_KEY_INDEX:
2416 2417 2418 2419
    key_info= table->key_info + active_index;
    if (start_key && 
	start_key->length == key_info->key_length &&
	start_key->flag == HA_READ_KEY_EXACT)
2420 2421 2422 2423
    {
      error= pk_read(start_key->key, start_key->length, buf);      
      DBUG_RETURN(error == HA_ERR_KEY_NOT_FOUND ? HA_ERR_END_OF_FILE : error);
    }
2424
    break;
2425
  case UNIQUE_ORDERED_INDEX:
2426
  case UNIQUE_INDEX:
2427 2428 2429 2430
    key_info= table->key_info + active_index;
    if (start_key && 
	start_key->length == key_info->key_length &&
	start_key->flag == HA_READ_KEY_EXACT)
2431 2432 2433 2434
    {
      error= unique_index_read(start_key->key, start_key->length, buf);
      DBUG_RETURN(error == HA_ERR_KEY_NOT_FOUND ? HA_ERR_END_OF_FILE : error);
    }
2435 2436 2437 2438
    break;
  default:
    break;
  }
2439 2440

  // Start the ordered index scan and fetch the first row
unknown's avatar
unknown committed
2441
  error= ordered_index_scan(start_key, end_key, sorted, buf);
2442 2443 2444
  DBUG_RETURN(error);
}

2445

unknown's avatar
unknown committed
2446 2447 2448 2449 2450 2451 2452 2453 2454 2455 2456 2457 2458 2459
int ha_ndbcluster::read_range_first(const key_range *start_key,
				    const key_range *end_key,
				    bool eq_range, bool sorted)
{
  byte* buf= table->record[0];
  DBUG_ENTER("ha_ndbcluster::read_range_first");
  
  DBUG_RETURN(read_range_first_to_buf(start_key,
				      end_key,
				      eq_range, 
				      sorted,
				      buf));
}

2460
int ha_ndbcluster::read_range_next()
2461 2462 2463 2464 2465 2466
{
  DBUG_ENTER("ha_ndbcluster::read_range_next");
  DBUG_RETURN(next_result(table->record[0]));
}


unknown's avatar
unknown committed
2467 2468 2469 2470 2471
int ha_ndbcluster::rnd_init(bool scan)
{
  NdbResultSet *cursor= m_active_cursor;
  DBUG_ENTER("rnd_init");
  DBUG_PRINT("enter", ("scan: %d", scan));
2472
  // Check if scan is to be restarted
unknown's avatar
unknown committed
2473 2474 2475 2476
  if (cursor)
  {
    if (!scan)
      DBUG_RETURN(1);
unknown's avatar
unknown committed
2477 2478
    int res= cursor->restart();
    DBUG_ASSERT(res == 0);
unknown's avatar
unknown committed
2479
  }
unknown's avatar
unknown committed
2480 2481 2482 2483
  index_init(table->primary_key);
  DBUG_RETURN(0);
}

2484 2485 2486
int ha_ndbcluster::close_scan()
{
  NdbResultSet *cursor= m_active_cursor;
unknown's avatar
unknown committed
2487
  NdbConnection *trans= m_active_trans;
2488 2489 2490 2491 2492
  DBUG_ENTER("close_scan");

  if (!cursor)
    DBUG_RETURN(1);

unknown's avatar
unknown committed
2493
  
2494
  if (m_ops_pending)
unknown's avatar
unknown committed
2495 2496 2497 2498 2499
  {
    /*
      Take over any pending transactions to the 
      deleteing/updating transaction before closing the scan    
    */
2500
    DBUG_PRINT("info", ("ops_pending: %d", m_ops_pending));    
unknown's avatar
unknown committed
2501
    if (execute_no_commit(this,trans) != 0) {
2502
      no_uncommitted_rows_execute_failure();
unknown's avatar
unknown committed
2503
      DBUG_RETURN(ndb_err(trans));
2504
    }
2505
    m_ops_pending= 0;
unknown's avatar
unknown committed
2506 2507
  }
  
2508 2509
  cursor->close();
  m_active_cursor= NULL;
unknown's avatar
unknown committed
2510
  DBUG_RETURN(0);
2511
}
unknown's avatar
unknown committed
2512 2513 2514 2515

int ha_ndbcluster::rnd_end()
{
  DBUG_ENTER("rnd_end");
2516
  DBUG_RETURN(close_scan());
unknown's avatar
unknown committed
2517 2518 2519 2520 2521 2522 2523
}


int ha_ndbcluster::rnd_next(byte *buf)
{
  DBUG_ENTER("rnd_next");
  statistic_increment(ha_read_rnd_next_count, &LOCK_status);
2524

unknown's avatar
unknown committed
2525
  if (!m_active_cursor)
2526 2527
    DBUG_RETURN(full_table_scan(buf));
  DBUG_RETURN(next_result(buf));
unknown's avatar
unknown committed
2528 2529 2530 2531 2532 2533 2534 2535 2536 2537 2538 2539 2540 2541 2542 2543 2544 2545 2546 2547 2548 2549 2550 2551 2552 2553 2554 2555 2556 2557 2558 2559 2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 2571 2572 2573 2574 2575 2576 2577 2578 2579 2580 2581 2582 2583 2584 2585 2586 2587 2588
}


/*
  An "interesting" record has been found and it's pk 
  retrieved by calling position
  Now it's time to read the record from db once 
  again
*/

int ha_ndbcluster::rnd_pos(byte *buf, byte *pos)
{
  DBUG_ENTER("rnd_pos");
  statistic_increment(ha_read_rnd_count,&LOCK_status);
  // The primary key for the record is stored in pos
  // Perform a pk_read using primary key "index"
  DBUG_RETURN(pk_read(pos, ref_length, buf));  
}


/*
  Store the primary key of this record in ref 
  variable, so that the row can be retrieved again later
  using "reference" in rnd_pos
*/

void ha_ndbcluster::position(const byte *record)
{
  KEY *key_info;
  KEY_PART_INFO *key_part;
  KEY_PART_INFO *end;
  byte *buff;
  DBUG_ENTER("position");

  if (table->primary_key != MAX_KEY) 
  {
    key_info= table->key_info + table->primary_key;
    key_part= key_info->key_part;
    end= key_part + key_info->key_parts;
    buff= ref;
    
    for (; key_part != end; key_part++) 
    {
      if (key_part->null_bit) {
        /* Store 0 if the key part is a NULL part */      
        if (record[key_part->null_offset]
            & key_part->null_bit) {
          *buff++= 1;
          continue;
        }      
        *buff++= 0;
      }
      memcpy(buff, record + key_part->offset, key_part->length);
      buff += key_part->length;
    }
  } 
  else 
  {
    // No primary key, get hidden key
    DBUG_PRINT("info", ("Getting hidden key"));
    int hidden_no= table->fields;
unknown's avatar
unknown committed
2589
    NdbRecAttr* rec= m_value[hidden_no].rec;
unknown's avatar
unknown committed
2590
    const NDBTAB *tab= (const NDBTAB *) m_table;  
unknown's avatar
unknown committed
2591 2592 2593 2594 2595 2596 2597 2598 2599 2600 2601 2602 2603 2604 2605 2606 2607 2608 2609 2610 2611 2612 2613 2614 2615
    const NDBCOL *hidden_col= tab->getColumn(hidden_no);
    DBUG_ASSERT(hidden_col->getPrimaryKey() && 
                hidden_col->getAutoIncrement() &&
                rec != NULL && 
                ref_length == NDB_HIDDEN_PRIMARY_KEY_LENGTH);
    memcpy(ref, (const void*)rec->aRef(), ref_length);
  }
  
  DBUG_DUMP("ref", (char*)ref, ref_length);
  DBUG_VOID_RETURN;
}


void ha_ndbcluster::info(uint flag)
{
  DBUG_ENTER("info");
  DBUG_PRINT("enter", ("flag: %d", flag));
  
  if (flag & HA_STATUS_POS)
    DBUG_PRINT("info", ("HA_STATUS_POS"));
  if (flag & HA_STATUS_NO_LOCK)
    DBUG_PRINT("info", ("HA_STATUS_NO_LOCK"));
  if (flag & HA_STATUS_TIME)
    DBUG_PRINT("info", ("HA_STATUS_TIME"));
  if (flag & HA_STATUS_VARIABLE)
2616
  {
unknown's avatar
unknown committed
2617
    DBUG_PRINT("info", ("HA_STATUS_VARIABLE"));
2618 2619
    if (m_table_info)
    {
2620 2621 2622 2623
      if (m_ha_not_exact_count)
	records= 100;
      else
	records_update();
2624 2625 2626
    }
    else
    {
2627 2628 2629 2630
      Uint64 rows= 100;
      if (current_thd->variables.ndb_use_exact_count)
	ndb_get_table_statistics(m_ndb, m_tabname, &rows, 0);
      records= rows;
2631
    }
2632
  }
unknown's avatar
unknown committed
2633 2634 2635 2636 2637
  if (flag & HA_STATUS_CONST)
  {
    DBUG_PRINT("info", ("HA_STATUS_CONST"));
    set_rec_per_key();
  }
unknown's avatar
unknown committed
2638
  if (flag & HA_STATUS_ERRKEY)
2639
  {
unknown's avatar
unknown committed
2640
    DBUG_PRINT("info", ("HA_STATUS_ERRKEY"));
2641
    errkey= m_dupkey;
2642
  }
unknown's avatar
unknown committed
2643 2644 2645 2646 2647 2648 2649 2650 2651 2652 2653 2654 2655 2656 2657 2658 2659 2660 2661 2662 2663 2664 2665 2666 2667 2668 2669 2670 2671 2672 2673 2674 2675 2676 2677 2678 2679 2680 2681 2682 2683 2684 2685 2686 2687 2688 2689 2690 2691 2692 2693 2694 2695 2696 2697 2698 2699 2700 2701 2702 2703 2704 2705 2706 2707 2708 2709 2710 2711 2712 2713 2714 2715 2716 2717 2718 2719 2720 2721 2722 2723 2724 2725 2726 2727 2728 2729
  if (flag & HA_STATUS_AUTO)
    DBUG_PRINT("info", ("HA_STATUS_AUTO"));
  DBUG_VOID_RETURN;
}


int ha_ndbcluster::extra(enum ha_extra_function operation)
{
  DBUG_ENTER("extra");
  switch (operation) {
  case HA_EXTRA_NORMAL:              /* Optimize for space (def) */
    DBUG_PRINT("info", ("HA_EXTRA_NORMAL"));
    break;
  case HA_EXTRA_QUICK:                 /* Optimize for speed */
    DBUG_PRINT("info", ("HA_EXTRA_QUICK"));
    break;
  case HA_EXTRA_RESET:                 /* Reset database to after open */
    DBUG_PRINT("info", ("HA_EXTRA_RESET"));
    break;
  case HA_EXTRA_CACHE:                 /* Cash record in HA_rrnd() */
    DBUG_PRINT("info", ("HA_EXTRA_CACHE"));
    break;
  case HA_EXTRA_NO_CACHE:              /* End cacheing of records (def) */
    DBUG_PRINT("info", ("HA_EXTRA_NO_CACHE"));
    break;
  case HA_EXTRA_NO_READCHECK:          /* No readcheck on update */
    DBUG_PRINT("info", ("HA_EXTRA_NO_READCHECK"));
    break;
  case HA_EXTRA_READCHECK:             /* Use readcheck (def) */
    DBUG_PRINT("info", ("HA_EXTRA_READCHECK"));
    break;
  case HA_EXTRA_KEYREAD:               /* Read only key to database */
    DBUG_PRINT("info", ("HA_EXTRA_KEYREAD"));
    break;
  case HA_EXTRA_NO_KEYREAD:            /* Normal read of records (def) */
    DBUG_PRINT("info", ("HA_EXTRA_NO_KEYREAD"));
    break;
  case HA_EXTRA_NO_USER_CHANGE:        /* No user is allowed to write */
    DBUG_PRINT("info", ("HA_EXTRA_NO_USER_CHANGE"));
    break;
  case HA_EXTRA_KEY_CACHE:
    DBUG_PRINT("info", ("HA_EXTRA_KEY_CACHE"));
    break;
  case HA_EXTRA_NO_KEY_CACHE:
    DBUG_PRINT("info", ("HA_EXTRA_NO_KEY_CACHE"));
    break;
  case HA_EXTRA_WAIT_LOCK:            /* Wait until file is avalably (def) */
    DBUG_PRINT("info", ("HA_EXTRA_WAIT_LOCK"));
    break;
  case HA_EXTRA_NO_WAIT_LOCK:         /* If file is locked, return quickly */
    DBUG_PRINT("info", ("HA_EXTRA_NO_WAIT_LOCK"));
    break;
  case HA_EXTRA_WRITE_CACHE:           /* Use write cache in ha_write() */
    DBUG_PRINT("info", ("HA_EXTRA_WRITE_CACHE"));
    break;
  case HA_EXTRA_FLUSH_CACHE:           /* flush write_record_cache */
    DBUG_PRINT("info", ("HA_EXTRA_FLUSH_CACHE"));
    break;
  case HA_EXTRA_NO_KEYS:               /* Remove all update of keys */
    DBUG_PRINT("info", ("HA_EXTRA_NO_KEYS"));
    break;
  case HA_EXTRA_KEYREAD_CHANGE_POS:         /* Keyread, but change pos */
    DBUG_PRINT("info", ("HA_EXTRA_KEYREAD_CHANGE_POS")); /* xxxxchk -r must be used */
    break;                                  
  case HA_EXTRA_REMEMBER_POS:          /* Remember pos for next/prev */
    DBUG_PRINT("info", ("HA_EXTRA_REMEMBER_POS"));
    break;
  case HA_EXTRA_RESTORE_POS:
    DBUG_PRINT("info", ("HA_EXTRA_RESTORE_POS"));
    break;
  case HA_EXTRA_REINIT_CACHE:          /* init cache from current record */
    DBUG_PRINT("info", ("HA_EXTRA_REINIT_CACHE"));
    break;
  case HA_EXTRA_FORCE_REOPEN:          /* Datafile have changed on disk */
    DBUG_PRINT("info", ("HA_EXTRA_FORCE_REOPEN"));
    break;
  case HA_EXTRA_FLUSH:                 /* Flush tables to disk */
    DBUG_PRINT("info", ("HA_EXTRA_FLUSH"));
    break;
  case HA_EXTRA_NO_ROWS:               /* Don't write rows */
    DBUG_PRINT("info", ("HA_EXTRA_NO_ROWS"));
    break;
  case HA_EXTRA_RESET_STATE:           /* Reset positions */
    DBUG_PRINT("info", ("HA_EXTRA_RESET_STATE"));
    break;
  case HA_EXTRA_IGNORE_DUP_KEY:       /* Dup keys don't rollback everything*/
    DBUG_PRINT("info", ("HA_EXTRA_IGNORE_DUP_KEY"));
2730 2731 2732 2733 2734 2735
    if (current_thd->lex->sql_command == SQLCOM_REPLACE)
    {
      DBUG_PRINT("info", ("Turning ON use of write instead of insert"));
      m_use_write= TRUE;
    } else 
    {
2736 2737
      DBUG_PRINT("info", ("Ignoring duplicate key"));
      m_ignore_dup_key= TRUE;
2738
    }
unknown's avatar
unknown committed
2739 2740 2741 2742
    break;
  case HA_EXTRA_NO_IGNORE_DUP_KEY:
    DBUG_PRINT("info", ("HA_EXTRA_NO_IGNORE_DUP_KEY"));
    DBUG_PRINT("info", ("Turning OFF use of write instead of insert"));
unknown's avatar
unknown committed
2743
    m_use_write= FALSE;
2744
    m_ignore_dup_key= FALSE;
unknown's avatar
unknown committed
2745 2746 2747 2748 2749
    break;
  case HA_EXTRA_RETRIEVE_ALL_COLS:    /* Retrieve all columns, not just those
					 where field->query_id is the same as
					 the current query id */
    DBUG_PRINT("info", ("HA_EXTRA_RETRIEVE_ALL_COLS"));
2750
    m_retrieve_all_fields= TRUE;
unknown's avatar
unknown committed
2751 2752 2753 2754 2755 2756 2757 2758 2759 2760 2761 2762
    break;
  case HA_EXTRA_PREPARE_FOR_DELETE:
    DBUG_PRINT("info", ("HA_EXTRA_PREPARE_FOR_DELETE"));
    break;
  case HA_EXTRA_PREPARE_FOR_UPDATE:     /* Remove read cache if problems */
    DBUG_PRINT("info", ("HA_EXTRA_PREPARE_FOR_UPDATE"));
    break;
  case HA_EXTRA_PRELOAD_BUFFER_SIZE: 
    DBUG_PRINT("info", ("HA_EXTRA_PRELOAD_BUFFER_SIZE"));
    break;
  case HA_EXTRA_RETRIEVE_PRIMARY_KEY: 
    DBUG_PRINT("info", ("HA_EXTRA_RETRIEVE_PRIMARY_KEY"));
2763
    m_retrieve_primary_key= TRUE;
unknown's avatar
unknown committed
2764 2765 2766 2767 2768 2769 2770 2771 2772 2773 2774 2775 2776
    break;
  case HA_EXTRA_CHANGE_KEY_TO_UNIQUE: 
    DBUG_PRINT("info", ("HA_EXTRA_CHANGE_KEY_TO_UNIQUE"));
    break;
  case HA_EXTRA_CHANGE_KEY_TO_DUP: 
    DBUG_PRINT("info", ("HA_EXTRA_CHANGE_KEY_TO_DUP"));
    break;

  }
  
  DBUG_RETURN(0);
}

2777 2778 2779 2780 2781 2782 2783 2784 2785 2786 2787 2788 2789
/* 
   Start of an insert, remember number of rows to be inserted, it will
   be used in write_row and get_autoincrement to send an optimal number
   of rows in each roundtrip to the server

   SYNOPSIS
   rows     number of rows to insert, 0 if unknown

*/

void ha_ndbcluster::start_bulk_insert(ha_rows rows)
{
  int bytes, batch;
unknown's avatar
unknown committed
2790
  const NDBTAB *tab= (const NDBTAB *) m_table;    
2791 2792

  DBUG_ENTER("start_bulk_insert");
unknown's avatar
unknown committed
2793
  DBUG_PRINT("enter", ("rows: %d", (int)rows));
2794
  
2795 2796
  m_rows_inserted= 0;
  m_rows_to_insert= rows; 
2797 2798 2799 2800 2801 2802 2803 2804

  /* 
    Calculate how many rows that should be inserted
    per roundtrip to NDB. This is done in order to minimize the 
    number of roundtrips as much as possible. However performance will 
    degrade if too many bytes are inserted, thus it's limited by this 
    calculation.   
  */
2805
  const int bytesperbatch= 8192;
2806
  bytes= 12 + tab->getRowSizeInBytes() + 4 * tab->getNoOfColumns();
2807
  batch= bytesperbatch/bytes;
2808 2809
  batch= batch == 0 ? 1 : batch;
  DBUG_PRINT("info", ("batch: %d, bytes: %d", batch, bytes));
2810
  m_bulk_insert_rows= batch;
2811 2812 2813 2814 2815 2816 2817 2818 2819

  DBUG_VOID_RETURN;
}

/*
  End of an insert
 */
int ha_ndbcluster::end_bulk_insert()
{
2820 2821
  int error= 0;

2822
  DBUG_ENTER("end_bulk_insert");
2823
  // Check if last inserts need to be flushed
2824
  if (m_bulk_insert_not_flushed)
2825 2826 2827 2828 2829
  {
    NdbConnection *trans= m_active_trans;
    // Send rows to NDB
    DBUG_PRINT("info", ("Sending inserts to NDB, "\
                        "rows_inserted:%d, bulk_insert_rows: %d", 
2830 2831
                        m_rows_inserted, m_bulk_insert_rows)); 
    m_bulk_insert_not_flushed= FALSE;
unknown's avatar
unknown committed
2832
    if (execute_no_commit(this,trans) != 0) {
2833
      no_uncommitted_rows_execute_failure();
2834
      my_errno= error= ndb_err(trans);
2835
    }
2836 2837
  }

2838 2839
  m_rows_inserted= 0;
  m_rows_to_insert= 1;
2840
  DBUG_RETURN(error);
2841 2842
}

unknown's avatar
unknown committed
2843 2844 2845 2846

int ha_ndbcluster::extra_opt(enum ha_extra_function operation, ulong cache_size)
{
  DBUG_ENTER("extra_opt");
unknown's avatar
unknown committed
2847
  DBUG_PRINT("enter", ("cache_size: %lu", cache_size));
unknown's avatar
unknown committed
2848 2849 2850 2851 2852 2853 2854 2855 2856 2857 2858 2859 2860
  DBUG_RETURN(extra(operation));
}


int ha_ndbcluster::reset()
{
  DBUG_ENTER("reset");
  // Reset what?
  DBUG_RETURN(1);
}


const char **ha_ndbcluster::bas_ext() const
2861
{ static const char *ext[]= { ha_ndb_ext, NullS }; return ext; }
unknown's avatar
unknown committed
2862 2863 2864 2865 2866 2867 2868 2869 2870 2871


/*
  How many seeks it will take to read through the table
  This is to be comparable to the number returned by records_in_range so
  that we can decide if we should scan the table or use keys.
*/

double ha_ndbcluster::scan_time()
{
unknown's avatar
unknown committed
2872 2873 2874 2875 2876
  DBUG_ENTER("ha_ndbcluster::scan_time()");
  double res= rows2double(records*1000);
  DBUG_PRINT("exit", ("table: %s value: %f", 
		      m_tabname, res));
  DBUG_RETURN(res);
unknown's avatar
unknown committed
2877 2878 2879 2880 2881 2882 2883 2884 2885 2886
}


THR_LOCK_DATA **ha_ndbcluster::store_lock(THD *thd,
                                          THR_LOCK_DATA **to,
                                          enum thr_lock_type lock_type)
{
  DBUG_ENTER("store_lock");
  if (lock_type != TL_IGNORE && m_lock.type == TL_UNLOCK) 
  {
unknown's avatar
unknown committed
2887

unknown's avatar
unknown committed
2888 2889 2890
    /* If we are not doing a LOCK TABLE, then allow multiple
       writers */
    
2891 2892 2893
    /* Since NDB does not currently have table locks
       this is treated as a ordinary lock */

unknown's avatar
unknown committed
2894
    if ((lock_type >= TL_WRITE_ALLOW_WRITE &&
unknown's avatar
unknown committed
2895 2896 2897 2898 2899 2900 2901 2902 2903 2904 2905 2906 2907 2908 2909
         lock_type <= TL_WRITE) && !thd->in_lock_tables)      
      lock_type= TL_WRITE_ALLOW_WRITE;
    
    /* In queries of type INSERT INTO t1 SELECT ... FROM t2 ...
       MySQL would use the lock TL_READ_NO_INSERT on t2, and that
       would conflict with TL_WRITE_ALLOW_WRITE, blocking all inserts
       to t2. Convert the lock to a normal read lock to allow
       concurrent inserts to t2. */
    
    if (lock_type == TL_READ_NO_INSERT && !thd->in_lock_tables)
      lock_type= TL_READ;
    
    m_lock.type=lock_type;
  }
  *to++= &m_lock;
2910 2911

  DBUG_PRINT("exit", ("lock_type: %d", lock_type));
unknown's avatar
unknown committed
2912 2913 2914 2915 2916 2917 2918 2919 2920 2921 2922 2923 2924 2925 2926 2927 2928 2929 2930 2931 2932 2933 2934 2935 2936 2937 2938 2939 2940 2941 2942 2943 2944 2945 2946 2947 2948 2949 2950 2951 2952 2953 2954
  
  DBUG_RETURN(to);
}

#ifndef DBUG_OFF
#define PRINT_OPTION_FLAGS(t) { \
      if (t->options & OPTION_NOT_AUTOCOMMIT) \
        DBUG_PRINT("thd->options", ("OPTION_NOT_AUTOCOMMIT")); \
      if (t->options & OPTION_BEGIN) \
        DBUG_PRINT("thd->options", ("OPTION_BEGIN")); \
      if (t->options & OPTION_TABLE_LOCK) \
        DBUG_PRINT("thd->options", ("OPTION_TABLE_LOCK")); \
}
#else
#define PRINT_OPTION_FLAGS(t)
#endif


/*
  As MySQL will execute an external lock for every new table it uses
  we can use this to start the transactions.
  If we are in auto_commit mode we just need to start a transaction
  for the statement, this will be stored in transaction.stmt.
  If not, we have to start a master transaction if there doesn't exist
  one from before, this will be stored in transaction.all
 
  When a table lock is held one transaction will be started which holds
  the table lock and for each statement a hupp transaction will be started  
 */

int ha_ndbcluster::external_lock(THD *thd, int lock_type)
{
  int error=0;
  NdbConnection* trans= NULL;

  DBUG_ENTER("external_lock");
  /*
    Check that this handler instance has a connection
    set up to the Ndb object of thd
   */
  if (check_ndb_connection())
    DBUG_RETURN(1);
 
2955 2956 2957 2958 2959
  Thd_ndb *thd_ndb= (Thd_ndb*)thd->transaction.thd_ndb;

  DBUG_PRINT("enter", ("transaction.thd_ndb->lock_count: %d", 
                       thd_ndb->lock_count));

unknown's avatar
unknown committed
2960 2961
  if (lock_type != F_UNLCK)
  {
2962
    DBUG_PRINT("info", ("lock_type != F_UNLCK"));
2963
    if (!thd_ndb->lock_count++)
unknown's avatar
unknown committed
2964 2965 2966 2967 2968 2969 2970 2971 2972 2973 2974 2975
    {
      PRINT_OPTION_FLAGS(thd);

      if (!(thd->options & (OPTION_NOT_AUTOCOMMIT | OPTION_BEGIN | OPTION_TABLE_LOCK))) 
      {
        // Autocommit transaction
        DBUG_ASSERT(!thd->transaction.stmt.ndb_tid);
        DBUG_PRINT("trans",("Starting transaction stmt"));      

        trans= m_ndb->startTransaction();
        if (trans == NULL)
          ERR_RETURN(m_ndb->getNdbError());
2976
	no_uncommitted_rows_reset(thd);
unknown's avatar
unknown committed
2977 2978 2979 2980 2981 2982 2983 2984 2985 2986 2987 2988 2989
        thd->transaction.stmt.ndb_tid= trans;
      } 
      else 
      { 
        if (!thd->transaction.all.ndb_tid)
	{
          // Not autocommit transaction
          // A "master" transaction ha not been started yet
          DBUG_PRINT("trans",("starting transaction, all"));
          
          trans= m_ndb->startTransaction();
          if (trans == NULL)
            ERR_RETURN(m_ndb->getNdbError());
2990
	  no_uncommitted_rows_reset(thd);
unknown's avatar
unknown committed
2991 2992 2993 2994 2995 2996 2997 2998 2999 3000 3001 3002 3003 3004 3005 3006 3007 3008 3009 3010 3011 3012 3013 3014 3015 3016 3017 3018 3019

          /*
            If this is the start of a LOCK TABLE, a table look 
            should be taken on the table in NDB
           
            Check if it should be read or write lock
           */
          if (thd->options & (OPTION_TABLE_LOCK))
	  {
            //lockThisTable();
            DBUG_PRINT("info", ("Locking the table..." ));
          }

          thd->transaction.all.ndb_tid= trans; 
        }
      }
    }
    /*
      This is the place to make sure this handler instance
      has a started transaction.
     
      The transaction is started by the first handler on which 
      MySQL Server calls external lock
     
      Other handlers in the same stmt or transaction should use 
      the same NDB transaction. This is done by setting up the m_active_trans
      pointer to point to the NDB transaction. 
     */

3020 3021 3022 3023 3024 3025 3026 3027 3028
    // store thread specific data first to set the right context
    m_force_send=          thd->variables.ndb_force_send;
    m_ha_not_exact_count= !thd->variables.ndb_use_exact_count;
    m_autoincrement_prefetch= thd->variables.ndb_autoincrement_prefetch_sz;
    if (!thd->transaction.on)
      m_transaction_on= FALSE;
    else
      m_transaction_on= thd->variables.ndb_use_transactions;

unknown's avatar
unknown committed
3029 3030 3031 3032
    m_active_trans= thd->transaction.all.ndb_tid ? 
      (NdbConnection*)thd->transaction.all.ndb_tid:
      (NdbConnection*)thd->transaction.stmt.ndb_tid;
    DBUG_ASSERT(m_active_trans);
3033
    // Start of transaction
3034
    m_retrieve_all_fields= FALSE;
3035
    m_retrieve_primary_key= FALSE;
3036
    m_ops_pending= 0;    
3037 3038 3039 3040 3041 3042 3043 3044 3045 3046
    {
      NDBDICT *dict= m_ndb->getDictionary();
      const NDBTAB *tab;
      void *tab_info;
      if (!(tab= dict->getTable(m_tabname, &tab_info)))
	ERR_RETURN(dict->getNdbError());
      DBUG_PRINT("info", ("Table schema version: %d", tab->getObjectVersion()));
      m_table= (void *)tab;
      m_table_info= tab_info;
    }
3047
    no_uncommitted_rows_init(thd);
unknown's avatar
unknown committed
3048 3049 3050
  } 
  else 
  {
3051
    DBUG_PRINT("info", ("lock_type == F_UNLCK"));
3052
    if (!--thd_ndb->lock_count)
unknown's avatar
unknown committed
3053 3054 3055 3056 3057 3058 3059 3060 3061 3062 3063 3064 3065 3066 3067 3068
    {
      DBUG_PRINT("trans", ("Last external_lock"));
      PRINT_OPTION_FLAGS(thd);

      if (thd->transaction.stmt.ndb_tid)
      {
        /*
          Unlock is done without a transaction commit / rollback.
          This happens if the thread didn't update any rows
          We must in this case close the transaction to release resources
        */
        DBUG_PRINT("trans",("ending non-updating transaction"));
        m_ndb->closeTransaction(m_active_trans);
        thd->transaction.stmt.ndb_tid= 0;
      }
    }
unknown's avatar
unknown committed
3069 3070
    m_table= NULL;
    m_table_info= NULL;
3071 3072 3073 3074 3075 3076 3077 3078 3079
    /*
      This is the place to make sure this handler instance
      no longer are connected to the active transaction.

      And since the handler is no longer part of the transaction 
      it can't have open cursors, ops or blobs pending.
    */
    m_active_trans= NULL;    

3080 3081
    if (m_active_cursor)
      DBUG_PRINT("warning", ("m_active_cursor != NULL"));
3082 3083
    m_active_cursor= NULL;

3084
    if (m_blobs_pending)
3085
      DBUG_PRINT("warning", ("blobs_pending != 0"));
3086
    m_blobs_pending= 0;
3087
    
3088
    if (m_ops_pending)
3089
      DBUG_PRINT("warning", ("ops_pending != 0L"));
3090
    m_ops_pending= 0;
unknown's avatar
unknown committed
3091 3092 3093 3094 3095 3096 3097 3098
  }
  DBUG_RETURN(error);
}

/*
  When using LOCK TABLE's external_lock is only called when the actual
  TABLE LOCK is done.
  Under LOCK TABLES, each used tables will force a call to start_stmt.
unknown's avatar
unknown committed
3099 3100
  Ndb doesn't currently support table locks, and will do ordinary
  startTransaction for each transaction/statement.
unknown's avatar
unknown committed
3101 3102 3103 3104 3105 3106 3107 3108 3109 3110 3111 3112 3113 3114
*/

int ha_ndbcluster::start_stmt(THD *thd)
{
  int error=0;
  DBUG_ENTER("start_stmt");
  PRINT_OPTION_FLAGS(thd);

  NdbConnection *trans= (NdbConnection*)thd->transaction.stmt.ndb_tid;
  if (!trans){
    DBUG_PRINT("trans",("Starting transaction stmt"));  
    
    NdbConnection *tablock_trans= 
      (NdbConnection*)thd->transaction.all.ndb_tid;
unknown's avatar
unknown committed
3115
    DBUG_PRINT("info", ("tablock_trans: %x", (uint)tablock_trans));
unknown's avatar
unknown committed
3116 3117 3118
    DBUG_ASSERT(tablock_trans);
//    trans= m_ndb->hupp(tablock_trans);
    trans= m_ndb->startTransaction();
unknown's avatar
unknown committed
3119 3120
    if (trans == NULL)
      ERR_RETURN(m_ndb->getNdbError());
3121
    no_uncommitted_rows_reset(thd);
unknown's avatar
unknown committed
3122 3123 3124
    thd->transaction.stmt.ndb_tid= trans;
  }
  m_active_trans= trans;
3125

3126
  // Start of statement
3127
  m_retrieve_all_fields= FALSE;
3128
  m_retrieve_primary_key= FALSE;
3129
  m_ops_pending= 0;    
unknown's avatar
unknown committed
3130 3131 3132 3133 3134 3135 3136 3137 3138 3139 3140 3141
  
  DBUG_RETURN(error);
}


/*
  Commit a transaction started in NDB 
 */

int ndbcluster_commit(THD *thd, void *ndb_transaction)
{
  int res= 0;
3142
  Ndb *ndb= ((Thd_ndb*)thd->transaction.thd_ndb)->ndb;
unknown's avatar
unknown committed
3143 3144 3145 3146 3147 3148 3149 3150
  NdbConnection *trans= (NdbConnection*)ndb_transaction;

  DBUG_ENTER("ndbcluster_commit");
  DBUG_PRINT("transaction",("%s",
                            trans == thd->transaction.stmt.ndb_tid ? 
                            "stmt" : "all"));
  DBUG_ASSERT(ndb && trans);

3151
  if (execute_commit(thd,trans) != 0)
unknown's avatar
unknown committed
3152 3153
  {
    const NdbError err= trans->getNdbError();
3154
    const NdbOperation *error_op= trans->getNdbErrorOperation();
unknown's avatar
unknown committed
3155 3156
    ERR_PRINT(err);     
    res= ndb_to_mysql_error(&err);
3157
    if (res != -1) 
3158
      ndbcluster_print_error(res, error_op);
unknown's avatar
unknown committed
3159
  }
3160
  ndb->closeTransaction(trans);
unknown's avatar
unknown committed
3161 3162 3163 3164 3165 3166 3167 3168 3169 3170 3171
  DBUG_RETURN(res);
}


/*
  Rollback a transaction started in NDB
 */

int ndbcluster_rollback(THD *thd, void *ndb_transaction)
{
  int res= 0;
3172
  Ndb *ndb= ((Thd_ndb*)thd->transaction.thd_ndb)->ndb;
unknown's avatar
unknown committed
3173 3174 3175 3176 3177 3178 3179 3180 3181 3182 3183
  NdbConnection *trans= (NdbConnection*)ndb_transaction;

  DBUG_ENTER("ndbcluster_rollback");
  DBUG_PRINT("transaction",("%s",
                            trans == thd->transaction.stmt.ndb_tid ? 
                            "stmt" : "all"));
  DBUG_ASSERT(ndb && trans);

  if (trans->execute(Rollback) != 0)
  {
    const NdbError err= trans->getNdbError();
3184
    const NdbOperation *error_op= trans->getNdbErrorOperation();
unknown's avatar
unknown committed
3185 3186
    ERR_PRINT(err);     
    res= ndb_to_mysql_error(&err);
3187 3188
    if (res != -1) 
      ndbcluster_print_error(res, error_op);
unknown's avatar
unknown committed
3189 3190 3191 3192 3193 3194 3195
  }
  ndb->closeTransaction(trans);
  DBUG_RETURN(0);
}


/*
unknown's avatar
unknown committed
3196 3197 3198
  Define NDB column based on Field.
  Returns 0 or mysql error code.
  Not member of ha_ndbcluster because NDBCOL cannot be declared.
unknown's avatar
unknown committed
3199 3200
 */

unknown's avatar
unknown committed
3201 3202 3203
static int create_ndb_column(NDBCOL &col,
                             Field *field,
                             HA_CREATE_INFO *info)
unknown's avatar
unknown committed
3204
{
unknown's avatar
unknown committed
3205
  // Set name
3206 3207 3208 3209 3210 3211
  {
    char truncated_field_name[NDB_MAX_ATTR_NAME_SIZE];
    strnmov(truncated_field_name,field->field_name,sizeof(truncated_field_name));
    truncated_field_name[sizeof(truncated_field_name)-1]= '\0';
    col.setName(truncated_field_name);
  }
unknown's avatar
unknown committed
3212 3213
  // Get char set
  CHARSET_INFO *cs= field->charset();
unknown's avatar
unknown committed
3214 3215 3216 3217
  // Set type and sizes
  const enum enum_field_types mysql_type= field->real_type();
  switch (mysql_type) {
  // Numeric types
unknown's avatar
unknown committed
3218
  case MYSQL_TYPE_DECIMAL:    
unknown's avatar
unknown committed
3219 3220 3221
    col.setType(NDBCOL::Char);
    col.setLength(field->pack_length());
    break;
unknown's avatar
unknown committed
3222
  case MYSQL_TYPE_TINY:        
unknown's avatar
unknown committed
3223 3224 3225 3226 3227 3228
    if (field->flags & UNSIGNED_FLAG)
      col.setType(NDBCOL::Tinyunsigned);
    else
      col.setType(NDBCOL::Tinyint);
    col.setLength(1);
    break;
unknown's avatar
unknown committed
3229
  case MYSQL_TYPE_SHORT:
unknown's avatar
unknown committed
3230 3231 3232 3233 3234 3235
    if (field->flags & UNSIGNED_FLAG)
      col.setType(NDBCOL::Smallunsigned);
    else
      col.setType(NDBCOL::Smallint);
    col.setLength(1);
    break;
unknown's avatar
unknown committed
3236
  case MYSQL_TYPE_LONG:
unknown's avatar
unknown committed
3237 3238 3239 3240 3241 3242
    if (field->flags & UNSIGNED_FLAG)
      col.setType(NDBCOL::Unsigned);
    else
      col.setType(NDBCOL::Int);
    col.setLength(1);
    break;
unknown's avatar
unknown committed
3243
  case MYSQL_TYPE_INT24:       
unknown's avatar
unknown committed
3244 3245 3246 3247 3248 3249 3250 3251 3252 3253 3254 3255
    if (field->flags & UNSIGNED_FLAG)
      col.setType(NDBCOL::Mediumunsigned);
    else
      col.setType(NDBCOL::Mediumint);
    col.setLength(1);
    break;
  case MYSQL_TYPE_LONGLONG:
    if (field->flags & UNSIGNED_FLAG)
      col.setType(NDBCOL::Bigunsigned);
    else
      col.setType(NDBCOL::Bigint);
    col.setLength(1);
unknown's avatar
unknown committed
3256 3257
    break;
  case MYSQL_TYPE_FLOAT:
unknown's avatar
unknown committed
3258 3259 3260
    col.setType(NDBCOL::Float);
    col.setLength(1);
    break;
unknown's avatar
unknown committed
3261
  case MYSQL_TYPE_DOUBLE:
unknown's avatar
unknown committed
3262 3263 3264 3265 3266 3267 3268 3269 3270 3271 3272 3273 3274 3275 3276 3277 3278 3279 3280 3281 3282 3283 3284
    col.setType(NDBCOL::Double);
    col.setLength(1);
    break;
  // Date types
  case MYSQL_TYPE_TIMESTAMP:
    col.setType(NDBCOL::Unsigned);
    col.setLength(1);
    break;
  case MYSQL_TYPE_DATETIME:    
    col.setType(NDBCOL::Datetime);
    col.setLength(1);
    break;
  case MYSQL_TYPE_DATE:
  case MYSQL_TYPE_NEWDATE:
  case MYSQL_TYPE_TIME:        
  case MYSQL_TYPE_YEAR:        
    col.setType(NDBCOL::Char);
    col.setLength(field->pack_length());
    break;
  // Char types
  case MYSQL_TYPE_STRING:      
    if (field->flags & BINARY_FLAG)
      col.setType(NDBCOL::Binary);
unknown's avatar
unknown committed
3285
    else {
unknown's avatar
unknown committed
3286
      col.setType(NDBCOL::Char);
unknown's avatar
unknown committed
3287 3288
      col.setCharset(cs);
    }
3289 3290 3291 3292
    if (field->pack_length() == 0)
      col.setLength(1); // currently ndb does not support size 0
    else
      col.setLength(field->pack_length());
unknown's avatar
unknown committed
3293 3294 3295 3296
    break;
  case MYSQL_TYPE_VAR_STRING:
    if (field->flags & BINARY_FLAG)
      col.setType(NDBCOL::Varbinary);
unknown's avatar
unknown committed
3297
    else {
unknown's avatar
unknown committed
3298
      col.setType(NDBCOL::Varchar);
unknown's avatar
unknown committed
3299 3300
      col.setCharset(cs);
    }
unknown's avatar
unknown committed
3301 3302 3303 3304 3305 3306 3307
    col.setLength(field->pack_length());
    break;
  // Blob types (all come in as MYSQL_TYPE_BLOB)
  mysql_type_tiny_blob:
  case MYSQL_TYPE_TINY_BLOB:
    if (field->flags & BINARY_FLAG)
      col.setType(NDBCOL::Blob);
unknown's avatar
unknown committed
3308
    else {
unknown's avatar
unknown committed
3309
      col.setType(NDBCOL::Text);
unknown's avatar
unknown committed
3310 3311
      col.setCharset(cs);
    }
unknown's avatar
unknown committed
3312 3313 3314 3315 3316 3317 3318 3319 3320
    col.setInlineSize(256);
    // No parts
    col.setPartSize(0);
    col.setStripeSize(0);
    break;
  mysql_type_blob:
  case MYSQL_TYPE_BLOB:    
    if (field->flags & BINARY_FLAG)
      col.setType(NDBCOL::Blob);
unknown's avatar
unknown committed
3321
    else {
unknown's avatar
unknown committed
3322
      col.setType(NDBCOL::Text);
unknown's avatar
unknown committed
3323 3324
      col.setCharset(cs);
    }
unknown's avatar
unknown committed
3325 3326 3327 3328 3329 3330 3331 3332 3333 3334 3335 3336 3337 3338 3339 3340 3341 3342
    // Use "<=" even if "<" is the exact condition
    if (field->max_length() <= (1 << 8))
      goto mysql_type_tiny_blob;
    else if (field->max_length() <= (1 << 16))
    {
      col.setInlineSize(256);
      col.setPartSize(2000);
      col.setStripeSize(16);
    }
    else if (field->max_length() <= (1 << 24))
      goto mysql_type_medium_blob;
    else
      goto mysql_type_long_blob;
    break;
  mysql_type_medium_blob:
  case MYSQL_TYPE_MEDIUM_BLOB:   
    if (field->flags & BINARY_FLAG)
      col.setType(NDBCOL::Blob);
unknown's avatar
unknown committed
3343
    else {
unknown's avatar
unknown committed
3344
      col.setType(NDBCOL::Text);
unknown's avatar
unknown committed
3345 3346
      col.setCharset(cs);
    }
unknown's avatar
unknown committed
3347 3348 3349 3350 3351 3352 3353 3354
    col.setInlineSize(256);
    col.setPartSize(4000);
    col.setStripeSize(8);
    break;
  mysql_type_long_blob:
  case MYSQL_TYPE_LONG_BLOB:  
    if (field->flags & BINARY_FLAG)
      col.setType(NDBCOL::Blob);
unknown's avatar
unknown committed
3355
    else {
unknown's avatar
unknown committed
3356
      col.setType(NDBCOL::Text);
unknown's avatar
unknown committed
3357 3358
      col.setCharset(cs);
    }
unknown's avatar
unknown committed
3359 3360 3361 3362 3363 3364 3365 3366 3367 3368 3369 3370 3371 3372 3373 3374 3375 3376 3377
    col.setInlineSize(256);
    col.setPartSize(8000);
    col.setStripeSize(4);
    break;
  // Other types
  case MYSQL_TYPE_ENUM:
    col.setType(NDBCOL::Char);
    col.setLength(field->pack_length());
    break;
  case MYSQL_TYPE_SET:         
    col.setType(NDBCOL::Char);
    col.setLength(field->pack_length());
    break;
  case MYSQL_TYPE_NULL:        
  case MYSQL_TYPE_GEOMETRY:
    goto mysql_type_unsupported;
  mysql_type_unsupported:
  default:
    return HA_ERR_UNSUPPORTED;
unknown's avatar
unknown committed
3378
  }
unknown's avatar
unknown committed
3379 3380 3381 3382 3383 3384 3385 3386
  // Set nullable and pk
  col.setNullable(field->maybe_null());
  col.setPrimaryKey(field->flags & PRI_KEY_FLAG);
  // Set autoincrement
  if (field->flags & AUTO_INCREMENT_FLAG) 
  {
    col.setAutoIncrement(TRUE);
    ulonglong value= info->auto_increment_value ?
3387
      info->auto_increment_value : (ulonglong) 1;
unknown's avatar
unknown committed
3388 3389
    DBUG_PRINT("info", ("Autoincrement key, initial: %llu", value));
    col.setAutoIncrementInitialValue(value);
unknown's avatar
unknown committed
3390
  }
unknown's avatar
unknown committed
3391
  else
unknown's avatar
unknown committed
3392
    col.setAutoIncrement(FALSE);
unknown's avatar
unknown committed
3393
  return 0;
unknown's avatar
unknown committed
3394 3395 3396 3397 3398 3399 3400 3401 3402 3403 3404 3405
}

/*
  Create a table in NDB Cluster
 */

int ha_ndbcluster::create(const char *name, 
			  TABLE *form, 
			  HA_CREATE_INFO *info)
{
  NDBTAB tab;
  NDBCOL col;
unknown's avatar
unknown committed
3406
  uint pack_length, length, i, pk_length= 0;
unknown's avatar
unknown committed
3407
  const void *data, *pack_data;
3408
  const char **key_names= form->keynames.type_names;
unknown's avatar
unknown committed
3409
  char name2[FN_HEADLEN];
3410
  bool create_from_engine= (info->table_options & HA_CREATE_FROM_ENGINE);
unknown's avatar
unknown committed
3411 3412 3413 3414 3415
   
  DBUG_ENTER("create");
  DBUG_PRINT("enter", ("name: %s", name));
  fn_format(name2, name, "", "",2);       // Remove the .frm extension
  set_dbname(name2);
3416 3417 3418 3419 3420 3421 3422 3423 3424 3425 3426 3427
  set_tabname(name2);    

  if (create_from_engine)
  {
    /*
      Table alreay exists in NDB and frm file has been created by 
      caller.
      Do Ndb specific stuff, such as create a .ndb file
    */
    my_errno= write_ndb_file();
    DBUG_RETURN(my_errno);
  }
unknown's avatar
unknown committed
3428 3429 3430 3431 3432 3433 3434 3435 3436 3437 3438 3439 3440 3441 3442 3443 3444 3445 3446 3447 3448 3449

  DBUG_PRINT("table", ("name: %s", m_tabname));  
  tab.setName(m_tabname);
  tab.setLogging(!(info->options & HA_LEX_CREATE_TMP_TABLE));    
   
  // Save frm data for this table
  if (readfrm(name, &data, &length))
    DBUG_RETURN(1);
  if (packfrm(data, length, &pack_data, &pack_length))
    DBUG_RETURN(2);
  
  DBUG_PRINT("info", ("setFrm data=%x, len=%d", pack_data, pack_length));
  tab.setFrm(pack_data, pack_length);      
  my_free((char*)data, MYF(0));
  my_free((char*)pack_data, MYF(0));
  
  for (i= 0; i < form->fields; i++) 
  {
    Field *field= form->field[i];
    DBUG_PRINT("info", ("name: %s, type: %u, pack_length: %d", 
                        field->field_name, field->real_type(),
			field->pack_length()));
3450
    if ((my_errno= create_ndb_column(col, field, info)))
unknown's avatar
unknown committed
3451
      DBUG_RETURN(my_errno);
unknown's avatar
unknown committed
3452
    tab.addColumn(col);
unknown's avatar
unknown committed
3453 3454
    if(col.getPrimaryKey())
      pk_length += (field->pack_length() + 3) / 4;
unknown's avatar
unknown committed
3455 3456 3457 3458 3459 3460 3461 3462 3463
  }
  
  // No primary key, create shadow key as 64 bit, auto increment  
  if (form->primary_key == MAX_KEY) 
  {
    DBUG_PRINT("info", ("Generating shadow key"));
    col.setName("$PK");
    col.setType(NdbDictionary::Column::Bigunsigned);
    col.setLength(1);
unknown's avatar
unknown committed
3464
    col.setNullable(FALSE);
unknown's avatar
unknown committed
3465 3466 3467
    col.setPrimaryKey(TRUE);
    col.setAutoIncrement(TRUE);
    tab.addColumn(col);
unknown's avatar
unknown committed
3468 3469 3470 3471 3472 3473 3474 3475 3476 3477 3478 3479 3480 3481 3482 3483 3484 3485 3486 3487 3488 3489 3490 3491 3492 3493 3494 3495 3496 3497 3498 3499 3500
    pk_length += 2;
  }
  
  // Make sure that blob tables don't have to big part size
  for (i= 0; i < form->fields; i++) 
  {
    /**
     * The extra +7 concists
     * 2 - words from pk in blob table
     * 5 - from extra words added by tup/dict??
     */
    switch (form->field[i]->real_type()) {
    case MYSQL_TYPE_BLOB:    
    case MYSQL_TYPE_MEDIUM_BLOB:   
    case MYSQL_TYPE_LONG_BLOB: 
    {
      NdbDictionary::Column * col = tab.getColumn(i);
      int size = pk_length + (col->getPartSize()+3)/4 + 7;
      if(size > NDB_MAX_TUPLE_SIZE_IN_WORDS && 
	 (pk_length+7) < NDB_MAX_TUPLE_SIZE_IN_WORDS)
      {
	size = NDB_MAX_TUPLE_SIZE_IN_WORDS - pk_length - 7;
	col->setPartSize(4*size);
      }
      /**
       * If size > NDB_MAX and pk_length+7 >= NDB_MAX
       *   then the table can't be created anyway, so skip
       *   changing part size, and have error later
       */ 
    }
    default:
      break;
    }
unknown's avatar
unknown committed
3501 3502
  }
  
3503
  if ((my_errno= check_ndb_connection()))
unknown's avatar
unknown committed
3504 3505 3506 3507
    DBUG_RETURN(my_errno);
  
  // Create the table in NDB     
  NDBDICT *dict= m_ndb->getDictionary();
3508
  if (dict->createTable(tab) != 0) 
unknown's avatar
unknown committed
3509 3510 3511 3512 3513 3514 3515 3516
  {
    const NdbError err= dict->getNdbError();
    ERR_PRINT(err);
    my_errno= ndb_to_mysql_error(&err);
    DBUG_RETURN(my_errno);
  }
  DBUG_PRINT("info", ("Table %s/%s created successfully", 
                      m_dbname, m_tabname));
3517

unknown's avatar
unknown committed
3518 3519
  // Create secondary indexes
  my_errno= build_index_list(form, ILBP_CREATE);
3520

3521 3522 3523
  if (!my_errno)
    my_errno= write_ndb_file();

unknown's avatar
unknown committed
3524 3525 3526 3527
  DBUG_RETURN(my_errno);
}


3528 3529 3530 3531
int ha_ndbcluster::create_ordered_index(const char *name, 
					KEY *key_info)
{
  DBUG_ENTER("create_ordered_index");
unknown's avatar
unknown committed
3532
  DBUG_RETURN(create_index(name, key_info, FALSE));
3533 3534 3535 3536 3537 3538
}

int ha_ndbcluster::create_unique_index(const char *name, 
				       KEY *key_info)
{

3539
  DBUG_ENTER("create_unique_index");
unknown's avatar
unknown committed
3540
  DBUG_RETURN(create_index(name, key_info, TRUE));
3541 3542 3543
}


unknown's avatar
unknown committed
3544 3545 3546 3547 3548
/*
  Create an index in NDB Cluster
 */

int ha_ndbcluster::create_index(const char *name, 
3549 3550 3551
				KEY *key_info,
				bool unique)
{
unknown's avatar
unknown committed
3552 3553 3554 3555 3556 3557
  NdbDictionary::Dictionary *dict= m_ndb->getDictionary();
  KEY_PART_INFO *key_part= key_info->key_part;
  KEY_PART_INFO *end= key_part + key_info->key_parts;
  
  DBUG_ENTER("create_index");
  DBUG_PRINT("enter", ("name: %s ", name));
3558

unknown's avatar
unknown committed
3559
  NdbDictionary::Index ndb_index(name);
3560
  if (unique)
unknown's avatar
unknown committed
3561 3562 3563 3564 3565
    ndb_index.setType(NdbDictionary::Index::UniqueHashIndex);
  else 
  {
    ndb_index.setType(NdbDictionary::Index::OrderedIndex);
    // TODO Only temporary ordered indexes supported
unknown's avatar
unknown committed
3566
    ndb_index.setLogging(FALSE); 
unknown's avatar
unknown committed
3567 3568 3569 3570 3571 3572 3573
  }
  ndb_index.setTable(m_tabname);

  for (; key_part != end; key_part++) 
  {
    Field *field= key_part->field;
    DBUG_PRINT("info", ("attr: %s", field->field_name));
3574 3575 3576 3577 3578 3579
    {
      char truncated_field_name[NDB_MAX_ATTR_NAME_SIZE];
      strnmov(truncated_field_name,field->field_name,sizeof(truncated_field_name));
      truncated_field_name[sizeof(truncated_field_name)-1]= '\0';
      ndb_index.addColumnName(truncated_field_name);
    }
unknown's avatar
unknown committed
3580 3581 3582 3583 3584 3585 3586 3587 3588 3589 3590 3591 3592 3593 3594 3595 3596 3597 3598 3599 3600 3601 3602 3603
  }
  
  if (dict->createIndex(ndb_index))
    ERR_RETURN(dict->getNdbError());

  // Success
  DBUG_PRINT("info", ("Created index %s", name));
  DBUG_RETURN(0);  
}


/*
  Rename a table in NDB Cluster
*/

int ha_ndbcluster::rename_table(const char *from, const char *to)
{
  char new_tabname[FN_HEADLEN];

  DBUG_ENTER("ha_ndbcluster::rename_table");
  set_dbname(from);
  set_tabname(from);
  set_tabname(to, new_tabname);

3604 3605 3606
  if (check_ndb_connection())
    DBUG_RETURN(my_errno= HA_ERR_NO_CONNECTION);

unknown's avatar
unknown committed
3607 3608 3609

  int result= alter_table_name(m_tabname, new_tabname);
  if (result == 0)
3610
  {
unknown's avatar
unknown committed
3611
    set_tabname(to);
3612 3613
    handler::rename_table(from, to);
  }
unknown's avatar
unknown committed
3614 3615 3616 3617 3618 3619 3620 3621 3622 3623 3624 3625 3626 3627 3628 3629 3630 3631 3632 3633 3634 3635 3636 3637 3638
  
  DBUG_RETURN(result);
}


/*
  Rename a table in NDB Cluster using alter table
 */

int ha_ndbcluster::alter_table_name(const char *from, const char *to)
{
  NDBDICT *dict= m_ndb->getDictionary();
  const NDBTAB *orig_tab;
  DBUG_ENTER("alter_table_name_table");
  DBUG_PRINT("enter", ("Renaming %s to %s", from, to));

  if (!(orig_tab= dict->getTable(from)))
    ERR_RETURN(dict->getNdbError());
      
  NdbDictionary::Table copy_tab= dict->getTableForAlteration(from);
  copy_tab.setName(to);
  if (dict->alterTable(copy_tab) != 0)
    ERR_RETURN(dict->getNdbError());

  m_table= NULL;
unknown's avatar
unknown committed
3639
  m_table_info= NULL;
unknown's avatar
unknown committed
3640 3641 3642 3643 3644 3645 3646 3647 3648 3649 3650 3651 3652 3653 3654 3655 3656 3657
                                                                             
  DBUG_RETURN(0);
}


/*
  Delete a table from NDB Cluster
 */

int ha_ndbcluster::delete_table(const char *name)
{
  DBUG_ENTER("delete_table");
  DBUG_PRINT("enter", ("name: %s", name));
  set_dbname(name);
  set_tabname(name);
  
  if (check_ndb_connection())
    DBUG_RETURN(HA_ERR_NO_CONNECTION);
3658 3659

  handler::delete_table(name);
unknown's avatar
unknown committed
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
  DBUG_RETURN(drop_table());
}


/*
  Drop a table in NDB Cluster
 */

int ha_ndbcluster::drop_table()
{
  NdbDictionary::Dictionary *dict= m_ndb->getDictionary();

  DBUG_ENTER("drop_table");
  DBUG_PRINT("enter", ("Deleting %s", m_tabname));
  
  if (dict->dropTable(m_tabname)) 
  {
    const NdbError err= dict->getNdbError();
    if (err.code == 709)
      ; // 709: No such table existed
    else 
      ERR_RETURN(dict->getNdbError());
  }  
  release_metadata();
  DBUG_RETURN(0);
}


/*
  Drop a database in NDB Cluster
 */

int ndbcluster_drop_database(const char *path)
{
  DBUG_ENTER("ndbcluster_drop_database");
  // TODO drop all tables for this database
  DBUG_RETURN(1);
}


longlong ha_ndbcluster::get_auto_increment()
3701
{  
unknown's avatar
unknown committed
3702 3703
  DBUG_ENTER("get_auto_increment");
  DBUG_PRINT("enter", ("m_tabname: %s", m_tabname));
3704
  int cache_size= 
3705
    (m_rows_to_insert - m_rows_inserted < m_autoincrement_prefetch) ?
3706
    m_rows_to_insert - m_rows_inserted 
3707
    : (m_rows_to_insert > m_autoincrement_prefetch) ? 
3708
    m_rows_to_insert 
3709
    : m_autoincrement_prefetch;
3710
  Uint64 auto_value= 
3711
    (m_skip_auto_increment) ? 
unknown's avatar
unknown committed
3712 3713
    m_ndb->readAutoIncrementValue((const NDBTAB *) m_table)
    : m_ndb->getAutoIncrementValue((const NDBTAB *) m_table, cache_size);
unknown's avatar
unknown committed
3714
  DBUG_RETURN((longlong)auto_value);
unknown's avatar
unknown committed
3715 3716 3717 3718 3719 3720 3721 3722 3723 3724 3725 3726 3727
}


/*
  Constructor for the NDB Cluster table handler 
 */

ha_ndbcluster::ha_ndbcluster(TABLE *table_arg):
  handler(table_arg),
  m_active_trans(NULL),
  m_active_cursor(NULL),
  m_ndb(NULL),
  m_table(NULL),
3728
  m_table_info(NULL),
unknown's avatar
unknown committed
3729
  m_table_flags(HA_REC_NOT_IN_SEQ |
unknown's avatar
unknown committed
3730
		HA_NULL_IN_KEY |
3731 3732
		HA_AUTO_PART_KEY |
		HA_NO_PREFIX_CHAR_KEYS),
3733
  m_share(0),
unknown's avatar
unknown committed
3734
  m_use_write(FALSE),
3735
  m_ignore_dup_key(FALSE),
3736 3737
  m_primary_key_update(FALSE),
  m_retrieve_all_fields(FALSE),
3738
  m_retrieve_primary_key(FALSE),
3739 3740 3741 3742 3743 3744 3745 3746 3747
  m_rows_to_insert(1),
  m_rows_inserted(0),
  m_bulk_insert_rows(1024),
  m_bulk_insert_not_flushed(FALSE),
  m_ops_pending(0),
  m_skip_auto_increment(TRUE),
  m_blobs_pending(0),
  m_blobs_buffer(0),
  m_blobs_buffer_size(0),
3748 3749 3750 3751 3752
  m_dupkey((uint) -1),
  m_ha_not_exact_count(FALSE),
  m_force_send(TRUE),
  m_autoincrement_prefetch(32),
  m_transaction_on(TRUE)
unknown's avatar
unknown committed
3753
{ 
3754 3755
  int i;
  
unknown's avatar
unknown committed
3756 3757 3758 3759 3760
  DBUG_ENTER("ha_ndbcluster");

  m_tabname[0]= '\0';
  m_dbname[0]= '\0';

3761
  records= ~(ha_rows)0; // uninitialized
unknown's avatar
unknown committed
3762 3763
  block_size= 1024;

3764 3765
  for (i= 0; i < MAX_KEY; i++)
  {
3766 3767 3768
    m_index[i].type= UNDEFINED_INDEX;   
    m_index[i].unique_index= NULL;      
    m_index[i].index= NULL;      
3769 3770
  }

unknown's avatar
unknown committed
3771 3772 3773 3774 3775 3776 3777 3778 3779 3780 3781 3782
  DBUG_VOID_RETURN;
}


/*
  Destructor for NDB Cluster table handler
 */

ha_ndbcluster::~ha_ndbcluster() 
{
  DBUG_ENTER("~ha_ndbcluster");

3783 3784
  if (m_share)
    free_share(m_share);
unknown's avatar
unknown committed
3785
  release_metadata();
3786 3787
  my_free(m_blobs_buffer, MYF(MY_ALLOW_ZERO_PTR));
  m_blobs_buffer= 0;
unknown's avatar
unknown committed
3788 3789

  // Check for open cursor/transaction
3790 3791
  if (m_active_cursor) {
  }
unknown's avatar
unknown committed
3792
  DBUG_ASSERT(m_active_cursor == NULL);
3793 3794
  if (m_active_trans) {
  }
unknown's avatar
unknown committed
3795 3796 3797 3798 3799 3800 3801 3802 3803 3804 3805 3806 3807 3808
  DBUG_ASSERT(m_active_trans == NULL);

  DBUG_VOID_RETURN;
}


/*
  Open a table for further use
  - fetch metadata for this table from NDB
  - check that table exists
*/

int ha_ndbcluster::open(const char *name, int mode, uint test_if_locked)
{
unknown's avatar
unknown committed
3809
  int res;
unknown's avatar
unknown committed
3810 3811 3812 3813 3814 3815 3816 3817 3818 3819 3820 3821 3822 3823 3824 3825 3826 3827 3828 3829 3830 3831
  KEY *key;
  DBUG_ENTER("open");
  DBUG_PRINT("enter", ("name: %s mode: %d test_if_locked: %d",
                       name, mode, test_if_locked));
  
  // Setup ref_length to make room for the whole 
  // primary key to be written in the ref variable
  
  if (table->primary_key != MAX_KEY) 
  {
    key= table->key_info+table->primary_key;
    ref_length= key->key_length;
    DBUG_PRINT("info", (" ref_length: %d", ref_length));
  }
  // Init table lock structure 
  if (!(m_share=get_share(name)))
    DBUG_RETURN(1);
  thr_lock_data_init(&m_share->lock,&m_lock,(void*) 0);
  
  set_dbname(name);
  set_tabname(name);
  
3832 3833
  if (check_ndb_connection()) {
    free_share(m_share); m_share= 0;
unknown's avatar
unknown committed
3834
    DBUG_RETURN(HA_ERR_NO_CONNECTION);
3835
  }
3836
  
unknown's avatar
unknown committed
3837 3838 3839 3840 3841
  res= get_metadata(name);
  if (!res)
    info(HA_STATUS_VARIABLE | HA_STATUS_CONST);

  DBUG_RETURN(res);
unknown's avatar
unknown committed
3842 3843 3844 3845 3846 3847 3848 3849 3850 3851 3852
}


/*
  Close the table
  - release resources setup by open()
 */

int ha_ndbcluster::close(void)
{
  DBUG_ENTER("close");  
3853
  free_share(m_share); m_share= 0;
unknown's avatar
unknown committed
3854 3855 3856 3857 3858 3859
  release_metadata();
  m_ndb= NULL;
  DBUG_RETURN(0);
}


3860
Thd_ndb* ha_ndbcluster::seize_thd_ndb()
unknown's avatar
unknown committed
3861
{
3862 3863
  Thd_ndb *thd_ndb;
  DBUG_ENTER("seize_thd_ndb");
unknown's avatar
unknown committed
3864

3865 3866 3867
  thd_ndb= new Thd_ndb();
  thd_ndb->ndb->getDictionary()->set_local_table_data_size(sizeof(Ndb_table_local_info));
  if (thd_ndb->ndb->init(max_transactions) != 0)
unknown's avatar
unknown committed
3868
  {
3869
    ERR_PRINT(thd_ndb->ndb->getNdbError());
unknown's avatar
unknown committed
3870 3871 3872 3873 3874 3875
    /*
      TODO 
      Alt.1 If init fails because to many allocated Ndb 
      wait on condition for a Ndb object to be released.
      Alt.2 Seize/release from pool, wait until next release 
    */
3876 3877
    delete thd_ndb;
    thd_ndb= NULL;
unknown's avatar
unknown committed
3878
  }
3879
  DBUG_RETURN(thd_ndb);
unknown's avatar
unknown committed
3880 3881 3882
}


3883
void ha_ndbcluster::release_thd_ndb(Thd_ndb* thd_ndb)
unknown's avatar
unknown committed
3884
{
3885 3886
  DBUG_ENTER("release_thd_ndb");
  delete thd_ndb;
unknown's avatar
unknown committed
3887 3888 3889 3890 3891
  DBUG_VOID_RETURN;
}


/*
unknown's avatar
unknown committed
3892
  If this thread already has a Thd_ndb object allocated
unknown's avatar
unknown committed
3893
  in current THD, reuse it. Otherwise
unknown's avatar
unknown committed
3894
  seize a Thd_ndb object, assign it to current THD and use it.
unknown's avatar
unknown committed
3895 3896 3897
 
*/

3898
Ndb* check_ndb_in_thd(THD* thd)
unknown's avatar
unknown committed
3899
{
3900
  DBUG_ENTER("check_ndb_in_thd");
3901
  Thd_ndb *thd_ndb= (Thd_ndb*)thd->transaction.thd_ndb;
unknown's avatar
unknown committed
3902
  
3903
  if (!thd_ndb)
unknown's avatar
unknown committed
3904
  {
unknown's avatar
unknown committed
3905
    if (!(thd_ndb= ha_ndbcluster::seize_thd_ndb()))
3906
      DBUG_RETURN(NULL);
3907
    thd->transaction.thd_ndb= thd_ndb;
unknown's avatar
unknown committed
3908
  }
unknown's avatar
unknown committed
3909
  DBUG_RETURN(thd_ndb->ndb);
3910 3911
}

unknown's avatar
unknown committed
3912

3913 3914 3915 3916 3917
int ha_ndbcluster::check_ndb_connection()
{
  THD* thd= current_thd;
  DBUG_ENTER("check_ndb_connection");
  
unknown's avatar
unknown committed
3918
  if (!(m_ndb= check_ndb_in_thd(thd)))
3919
    DBUG_RETURN(HA_ERR_NO_CONNECTION);
unknown's avatar
unknown committed
3920 3921 3922 3923
  m_ndb->setDatabaseName(m_dbname);
  DBUG_RETURN(0);
}

unknown's avatar
unknown committed
3924

unknown's avatar
unknown committed
3925 3926
void ndbcluster_close_connection(THD *thd)
{
3927
  Thd_ndb *thd_ndb= (Thd_ndb*)thd->transaction.thd_ndb;
unknown's avatar
unknown committed
3928
  DBUG_ENTER("ndbcluster_close_connection");
3929 3930
  if (thd_ndb)
  {
3931
    ha_ndbcluster::release_thd_ndb(thd_ndb);
3932 3933
    thd->transaction.thd_ndb= NULL;
  }
unknown's avatar
unknown committed
3934 3935 3936 3937 3938 3939 3940 3941
  DBUG_VOID_RETURN;
}


/*
  Try to discover one table from NDB
 */

3942
int ndbcluster_discover(THD* thd, const char *db, const char *name,
unknown's avatar
unknown committed
3943 3944 3945 3946 3947
			const void** frmblob, uint* frmlen)
{
  uint len;
  const void* data;
  const NDBTAB* tab;
3948
  Ndb* ndb;
unknown's avatar
unknown committed
3949
  DBUG_ENTER("ndbcluster_discover");
3950
  DBUG_PRINT("enter", ("db: %s, name: %s", db, name)); 
unknown's avatar
unknown committed
3951

3952 3953 3954
  if (!(ndb= check_ndb_in_thd(thd)))
    DBUG_RETURN(HA_ERR_NO_CONNECTION);  
  ndb->setDatabaseName(db);
3955

3956
  NDBDICT* dict= ndb->getDictionary();
unknown's avatar
unknown committed
3957
  dict->set_local_table_data_size(sizeof(Ndb_table_local_info));
3958 3959 3960 3961 3962 3963 3964
  dict->invalidateTable(name);
  if (!(tab= dict->getTable(name)))
  {    
    const NdbError err= dict->getNdbError();
    if (err.code == 709)
      DBUG_RETURN(1);
    ERR_RETURN(err);
unknown's avatar
unknown committed
3965 3966 3967 3968 3969 3970 3971 3972 3973 3974 3975 3976 3977 3978 3979 3980 3981 3982 3983 3984 3985 3986
  }
  
  DBUG_PRINT("info", ("Found table %s", tab->getName()));
  
  len= tab->getFrmLength();  
  if (len == 0 || tab->getFrmData() == NULL)
  {
    DBUG_PRINT("No frm data found",
               ("Table is probably created via NdbApi")); 
    DBUG_RETURN(2);
  }
  
  if (unpackfrm(&data, &len, tab->getFrmData()))
    DBUG_RETURN(3);

  *frmlen= len;
  *frmblob= data;
  
  DBUG_RETURN(0);
}

/*
3987 3988 3989
  Check if a table exists in NDB
   
 */
unknown's avatar
unknown committed
3990

3991 3992 3993 3994 3995 3996 3997 3998 3999 4000 4001 4002 4003 4004
int ndbcluster_table_exists(THD* thd, const char *db, const char *name)
{
  uint len;
  const void* data;
  const NDBTAB* tab;
  Ndb* ndb;
  DBUG_ENTER("ndbcluster_table_exists");
  DBUG_PRINT("enter", ("db: %s, name: %s", db, name)); 

  if (!(ndb= check_ndb_in_thd(thd)))
    DBUG_RETURN(HA_ERR_NO_CONNECTION);  
  ndb->setDatabaseName(db);

  NDBDICT* dict= ndb->getDictionary();
unknown's avatar
unknown committed
4005
  dict->set_local_table_data_size(sizeof(Ndb_table_local_info));
4006 4007 4008 4009 4010 4011 4012 4013 4014 4015 4016 4017 4018 4019
  dict->invalidateTable(name);
  if (!(tab= dict->getTable(name)))
  {    
    const NdbError err= dict->getNdbError();
    if (err.code == 709)
      DBUG_RETURN(0);
    ERR_RETURN(err);
  }
  
  DBUG_PRINT("info", ("Found table %s", tab->getName()));
  DBUG_RETURN(1);
}


unknown's avatar
unknown committed
4020

unknown's avatar
unknown committed
4021 4022
extern "C" byte* tables_get_key(const char *entry, uint *length,
				my_bool not_used __attribute__((unused)))
4023 4024 4025 4026 4027 4028 4029
{
  *length= strlen(entry);
  return (byte*) entry;
}


int ndbcluster_find_files(THD *thd,const char *db,const char *path,
unknown's avatar
unknown committed
4030
			  const char *wild, bool dir, List<char> *files)
unknown's avatar
unknown committed
4031
{
4032 4033 4034
  DBUG_ENTER("ndbcluster_find_files");
  DBUG_PRINT("enter", ("db: %s", db));
  { // extra bracket to avoid gcc 2.95.3 warning
unknown's avatar
unknown committed
4035
  uint i;
4036
  Ndb* ndb;
4037
  char name[FN_REFLEN];
unknown's avatar
unknown committed
4038
  HASH ndb_tables, ok_tables;
unknown's avatar
unknown committed
4039
  NdbDictionary::Dictionary::List list;
4040 4041 4042 4043

  if (!(ndb= check_ndb_in_thd(thd)))
    DBUG_RETURN(HA_ERR_NO_CONNECTION);

4044
  if (dir)
unknown's avatar
unknown committed
4045
    DBUG_RETURN(0); // Discover of databases not yet supported
4046

unknown's avatar
unknown committed
4047
  // List tables in NDB
4048
  NDBDICT *dict= ndb->getDictionary();
unknown's avatar
unknown committed
4049 4050
  if (dict->listObjects(list, 
			NdbDictionary::Object::UserTable) != 0)
unknown's avatar
unknown committed
4051
    ERR_RETURN(dict->getNdbError());
4052

unknown's avatar
unknown committed
4053 4054 4055 4056 4057 4058 4059 4060 4061 4062 4063 4064 4065 4066 4067
  if (hash_init(&ndb_tables, system_charset_info,list.count,0,0,
		(hash_get_key)tables_get_key,0,0))
  {
    DBUG_PRINT("error", ("Failed to init HASH ndb_tables"));
    DBUG_RETURN(-1);
  }

  if (hash_init(&ok_tables, system_charset_info,32,0,0,
		(hash_get_key)tables_get_key,0,0))
  {
    DBUG_PRINT("error", ("Failed to init HASH ok_tables"));
    hash_free(&ndb_tables);
    DBUG_RETURN(-1);
  }  

unknown's avatar
unknown committed
4068 4069 4070
  for (i= 0 ; i < list.count ; i++)
  {
    NdbDictionary::Dictionary::List::Element& t= list.elements[i];
unknown's avatar
unknown committed
4071
    DBUG_PRINT("info", ("Found %s/%s in NDB", t.database, t.name));     
unknown's avatar
unknown committed
4072

4073 4074 4075 4076
    // Add only tables that belongs to db
    if (my_strcasecmp(system_charset_info, t.database, db))
      continue;

unknown's avatar
unknown committed
4077
    // Apply wildcard to list of tables in NDB
4078
    if (wild)
4079
    {
4080 4081 4082 4083 4084 4085 4086 4087
      if (lower_case_table_names)
      {
	if (wild_case_compare(files_charset_info, t.name, wild))
	  continue;
      }
      else if (wild_compare(t.name,wild,0))
	continue;
    }
unknown's avatar
unknown committed
4088 4089
    DBUG_PRINT("info", ("Inserting %s into ndb_tables hash", t.name));     
    my_hash_insert(&ndb_tables, (byte*)thd->strdup(t.name));
unknown's avatar
unknown committed
4090 4091
  }

unknown's avatar
unknown committed
4092 4093 4094 4095 4096 4097 4098 4099 4100 4101 4102 4103 4104 4105 4106
  char *file_name;
  List_iterator<char> it(*files);
  List<char> delete_list;
  while ((file_name=it++))
  {
    DBUG_PRINT("info", ("%s", file_name));     
    if (hash_search(&ndb_tables, file_name, strlen(file_name)))
    {
      DBUG_PRINT("info", ("%s existed in NDB _and_ on disk ", file_name));
      // File existed in NDB and as frm file, put in ok_tables list
      my_hash_insert(&ok_tables, (byte*)file_name);
      continue;
    }
    
    // File is not in NDB, check for .ndb file with this name
4107
    (void)strxnmov(name, FN_REFLEN, 
unknown's avatar
unknown committed
4108 4109
		   mysql_data_home,"/",db,"/",file_name,ha_ndb_ext,NullS);
    DBUG_PRINT("info", ("Check access for %s", name));
4110
    if (access(name, F_OK))
unknown's avatar
unknown committed
4111 4112 4113 4114
    {
      DBUG_PRINT("info", ("%s did not exist on disk", name));     
      // .ndb file did not exist on disk, another table type
      continue;
4115
    }
4116

unknown's avatar
unknown committed
4117 4118 4119 4120 4121 4122 4123 4124 4125 4126 4127
    DBUG_PRINT("info", ("%s existed on disk", name));     
    // The .ndb file exists on disk, but it's not in list of tables in ndb
    // Verify that handler agrees table is gone.
    if (ndbcluster_table_exists(thd, db, file_name) == 0)    
    {
      DBUG_PRINT("info", ("NDB says %s does not exists", file_name));     
      it.remove();
      // Put in list of tables to remove from disk
      delete_list.push_back(thd->strdup(file_name));
    }
  }
4128

unknown's avatar
unknown committed
4129 4130 4131 4132
  // Check for new files to discover
  DBUG_PRINT("info", ("Checking for new files to discover"));       
  List<char> create_list;
  for (i= 0 ; i < ndb_tables.records ; i++)
4133
  {
unknown's avatar
unknown committed
4134 4135
    file_name= hash_element(&ndb_tables, i);
    if (!hash_search(&ok_tables, file_name, strlen(file_name)))
4136
    {
unknown's avatar
unknown committed
4137 4138 4139 4140 4141 4142
      DBUG_PRINT("info", ("%s must be discovered", file_name));       
      // File is in list of ndb tables and not in ok_tables
      // This table need to be created
      create_list.push_back(thd->strdup(file_name));
    }
  }
4143

unknown's avatar
unknown committed
4144 4145
  // Lock mutex before deleting and creating frm files
  pthread_mutex_lock(&LOCK_open);
4146

unknown's avatar
unknown committed
4147 4148 4149 4150 4151 4152 4153 4154 4155 4156 4157
  if (!global_read_lock)
  {
    // Delete old files
    List_iterator_fast<char> it3(delete_list);
    while ((file_name=it3++))
    {  
      DBUG_PRINT("info", ("Remove table %s/%s",db, file_name ));
      // Delete the table and all related files
      TABLE_LIST table_list;
      bzero((char*) &table_list,sizeof(table_list));
      table_list.db= (char*) db;
4158
      table_list.alias=table_list.real_name=(char*)file_name;
unknown's avatar
unknown committed
4159
      (void)mysql_rm_table_part2(thd, &table_list, 
unknown's avatar
unknown committed
4160 4161 4162
				 /* if_exists */ TRUE, 
				 /* drop_temporary */ FALSE, 
				 /* dont_log_query*/ TRUE);
4163 4164 4165
    }
  }

unknown's avatar
unknown committed
4166 4167 4168 4169 4170
  // Create new files
  List_iterator_fast<char> it2(create_list);
  while ((file_name=it2++))
  {  
    DBUG_PRINT("info", ("Table %s need discovery", name));
unknown's avatar
unknown committed
4171
    if (ha_create_table_from_engine(thd, db, file_name, TRUE) == 0)
4172
      files->push_back(thd->strdup(file_name)); 
unknown's avatar
unknown committed
4173 4174 4175 4176 4177
  }

  pthread_mutex_unlock(&LOCK_open);      
  
  hash_free(&ok_tables);
4178
  hash_free(&ndb_tables);
4179
  } // extra bracket to avoid gcc 2.95.3 warning
4180
  DBUG_RETURN(0);    
unknown's avatar
unknown committed
4181 4182 4183 4184 4185 4186 4187 4188 4189 4190
}


/*
  Initialise all gloal variables before creating 
  a NDB Cluster table handler
 */

bool ndbcluster_init()
{
unknown's avatar
unknown committed
4191
  int res;
unknown's avatar
unknown committed
4192
  DBUG_ENTER("ndbcluster_init");
4193
  // Set connectstring if specified
unknown's avatar
unknown committed
4194
  if (ndbcluster_connectstring != 0)
4195
    DBUG_PRINT("connectstring", ("%s", ndbcluster_connectstring));     
4196 4197 4198 4199 4200
  if ((g_ndb_cluster_connection=
       new Ndb_cluster_connection(ndbcluster_connectstring)) == 0)
  {
    DBUG_PRINT("error",("Ndb_cluster_connection(%s)",ndbcluster_connectstring));
    DBUG_RETURN(TRUE);
4201
  }
unknown's avatar
unknown committed
4202

4203 4204
  // Create a Ndb object to open the connection  to NDB
  g_ndb= new Ndb(g_ndb_cluster_connection, "sys");
4205
  g_ndb->getDictionary()->set_local_table_data_size(sizeof(Ndb_table_local_info));
4206
  if (g_ndb->init() != 0)
unknown's avatar
unknown committed
4207 4208
  {
    ERR_PRINT (g_ndb->getNdbError());
4209
    DBUG_RETURN(TRUE);
unknown's avatar
unknown committed
4210
  }
unknown's avatar
unknown committed
4211 4212 4213 4214 4215

  if ((res= g_ndb_cluster_connection->connect(1)) == 0)
  {
    g_ndb->waitUntilReady(10);
  } 
unknown's avatar
unknown committed
4216
  else if(res == 1)
unknown's avatar
unknown committed
4217
  {
unknown's avatar
unknown committed
4218 4219 4220 4221
    if (g_ndb_cluster_connection->start_connect_thread()) {
      DBUG_PRINT("error", ("g_ndb_cluster_connection->start_connect_thread()"));
      DBUG_RETURN(TRUE);
    }
unknown's avatar
unknown committed
4222
  }
unknown's avatar
unknown committed
4223
  else
unknown's avatar
unknown committed
4224 4225 4226 4227 4228 4229
  {
    DBUG_ASSERT(res == -1);
    DBUG_PRINT("error", ("permanent error"));
    DBUG_RETURN(TRUE);
  }
  
unknown's avatar
unknown committed
4230 4231 4232
  (void) hash_init(&ndbcluster_open_tables,system_charset_info,32,0,0,
                   (hash_get_key) ndbcluster_get_key,0,0);
  pthread_mutex_init(&ndbcluster_mutex,MY_MUTEX_INIT_FAST);
4233

unknown's avatar
unknown committed
4234 4235
  ndbcluster_inited= 1;
#ifdef USE_DISCOVER_ON_STARTUP
unknown's avatar
unknown committed
4236
  if (ndb_discover_tables() != 0)
unknown's avatar
unknown committed
4237 4238
    DBUG_RETURN(TRUE);    
#endif
unknown's avatar
unknown committed
4239
  DBUG_RETURN(FALSE);
unknown's avatar
unknown committed
4240 4241 4242 4243 4244 4245 4246 4247 4248 4249 4250 4251
}


/*
  End use of the NDB Cluster table handler
  - free all global variables allocated by 
    ndcluster_init()
*/

bool ndbcluster_end()
{
  DBUG_ENTER("ndbcluster_end");
unknown's avatar
unknown committed
4252 4253
  if(g_ndb)
    delete g_ndb;
unknown's avatar
unknown committed
4254
  g_ndb= NULL;
4255 4256 4257
  if (g_ndb_cluster_connection)
    delete g_ndb_cluster_connection;
  g_ndb_cluster_connection= NULL;
unknown's avatar
unknown committed
4258 4259 4260 4261 4262 4263 4264 4265
  if (!ndbcluster_inited)
    DBUG_RETURN(0);
  hash_free(&ndbcluster_open_tables);
  pthread_mutex_destroy(&ndbcluster_mutex);
  ndbcluster_inited= 0;
  DBUG_RETURN(0);
}

4266 4267 4268 4269 4270
/*
  Static error print function called from
  static handler method ndbcluster_commit
  and ndbcluster_rollback
*/
4271 4272

void ndbcluster_print_error(int error, const NdbOperation *error_op)
4273
{
4274 4275
  DBUG_ENTER("ndbcluster_print_error");
  TABLE tab;
4276 4277
  const char *tab_name= (error_op) ? error_op->getTableName() : "";
  tab.table_name= (char *) tab_name;
4278
  ha_ndbcluster error_handler(&tab);
4279
  tab.file= &error_handler;
4280
  error_handler.print_error(error, MYF(0));
unknown's avatar
unknown committed
4281
  DBUG_VOID_RETURN;
4282
}
unknown's avatar
unknown committed
4283 4284 4285 4286 4287 4288 4289 4290 4291 4292 4293 4294 4295 4296 4297 4298 4299 4300 4301 4302 4303 4304 4305

/*
  Set m_tabname from full pathname to table file 
 */

void ha_ndbcluster::set_tabname(const char *path_name)
{
  char *end, *ptr;
  
  /* Scan name from the end */
  end= strend(path_name)-1;
  ptr= end;
  while (ptr >= path_name && *ptr != '\\' && *ptr != '/') {
    ptr--;
  }
  uint name_len= end - ptr;
  memcpy(m_tabname, ptr + 1, end - ptr);
  m_tabname[name_len]= '\0';
#ifdef __WIN__
  /* Put to lower case */
  ptr= m_tabname;
  
  while (*ptr != '\0') {
4306
    *ptr= tolower(*ptr);
unknown's avatar
unknown committed
4307 4308 4309 4310 4311 4312 4313 4314 4315 4316 4317 4318 4319 4320 4321
    ptr++;
  }
#endif
}

/**
 * Set a given location from full pathname to table file
 *
 */
void
ha_ndbcluster::set_tabname(const char *path_name, char * tabname)
{
  char *end, *ptr;
  
  /* Scan name from the end */
4322 4323
  end= strend(path_name)-1;
  ptr= end;
unknown's avatar
unknown committed
4324 4325 4326
  while (ptr >= path_name && *ptr != '\\' && *ptr != '/') {
    ptr--;
  }
4327
  uint name_len= end - ptr;
unknown's avatar
unknown committed
4328
  memcpy(tabname, ptr + 1, end - ptr);
4329
  tabname[name_len]= '\0';
unknown's avatar
unknown committed
4330 4331
#ifdef __WIN__
  /* Put to lower case */
4332
  ptr= tabname;
unknown's avatar
unknown committed
4333 4334 4335 4336 4337 4338 4339 4340 4341 4342 4343 4344 4345 4346 4347 4348 4349 4350 4351 4352 4353 4354 4355 4356 4357 4358 4359 4360 4361 4362 4363 4364 4365 4366 4367 4368 4369 4370 4371 4372 4373 4374 4375 4376 4377
  
  while (*ptr != '\0') {
    *ptr= tolower(*ptr);
    ptr++;
  }
#endif
}


/*
  Set m_dbname from full pathname to table file
 
 */

void ha_ndbcluster::set_dbname(const char *path_name)
{
  char *end, *ptr;
  
  /* Scan name from the end */
  ptr= strend(path_name)-1;
  while (ptr >= path_name && *ptr != '\\' && *ptr != '/') {
    ptr--;
  }
  ptr--;
  end= ptr;
  while (ptr >= path_name && *ptr != '\\' && *ptr != '/') {
    ptr--;
  }
  uint name_len= end - ptr;
  memcpy(m_dbname, ptr + 1, name_len);
  m_dbname[name_len]= '\0';
#ifdef __WIN__
  /* Put to lower case */
  
  ptr= m_dbname;
  
  while (*ptr != '\0') {
    *ptr= tolower(*ptr);
    ptr++;
  }
#endif
}


ha_rows 
unknown's avatar
unknown committed
4378 4379 4380 4381
ha_ndbcluster::records_in_range(uint inx, key_range *min_key,
                                key_range *max_key)
{
  KEY *key_info= table->key_info + inx;
unknown's avatar
unknown committed
4382
  uint key_length= key_info->key_length;
4383
  NDB_INDEX_TYPE idx_type= get_index_type(inx);  
unknown's avatar
unknown committed
4384 4385

  DBUG_ENTER("records_in_range");
4386 4387 4388 4389 4390 4391 4392 4393 4394 4395 4396 4397 4398 4399
  // Prevent partial read of hash indexes by returning HA_POS_ERROR
  if ((idx_type == UNIQUE_INDEX || idx_type == PRIMARY_KEY_INDEX) &&
      ((min_key && min_key->length < key_length) ||
       (max_key && max_key->length < key_length)))
    DBUG_RETURN(HA_POS_ERROR);
  
  // Read from hash index with full key
  // This is a "const" table which returns only one record!      
  if ((idx_type != ORDERED_INDEX) &&
      ((min_key && min_key->length == key_length) || 
       (max_key && max_key->length == key_length)))
    DBUG_RETURN(1);
  
  DBUG_RETURN(10); /* Good guess when you don't know anything */
unknown's avatar
unknown committed
4400 4401
}

4402 4403 4404 4405 4406 4407 4408 4409 4410 4411 4412 4413 4414 4415 4416 4417 4418 4419 4420 4421 4422 4423 4424 4425 4426 4427 4428 4429 4430 4431 4432 4433 4434 4435 4436 4437 4438 4439 4440 4441 4442 4443 4444 4445 4446 4447 4448 4449 4450 4451 4452 4453 4454 4455 4456 4457
ulong ha_ndbcluster::table_flags(void) const
{
  if (m_ha_not_exact_count)
    return m_table_flags | HA_NOT_EXACT_COUNT;
  else
    return m_table_flags;
}
const char * ha_ndbcluster::table_type() const 
{
  return("ndbcluster");
}
uint ha_ndbcluster::max_supported_record_length() const
{ 
  return NDB_MAX_TUPLE_SIZE;
}
uint ha_ndbcluster::max_supported_keys() const
{
  return MAX_KEY;
}
uint ha_ndbcluster::max_supported_key_parts() const 
{
  return NDB_MAX_NO_OF_ATTRIBUTES_IN_KEY;
}
uint ha_ndbcluster::max_supported_key_length() const
{
  return NDB_MAX_KEY_SIZE;
}
bool ha_ndbcluster::low_byte_first() const
{ 
#ifdef WORDS_BIGENDIAN
  return FALSE;
#else
  return TRUE;
#endif
}
bool ha_ndbcluster::has_transactions()
{
  return TRUE;
}
const char* ha_ndbcluster::index_type(uint key_number)
{
  switch (get_index_type(key_number)) {
  case ORDERED_INDEX:
  case UNIQUE_ORDERED_INDEX:
  case PRIMARY_KEY_ORDERED_INDEX:
    return "BTREE";
  case UNIQUE_INDEX:
  case PRIMARY_KEY_INDEX:
  default:
    return "HASH";
  }
}
uint8 ha_ndbcluster::table_cache_type()
{
  return HA_CACHE_TBL_NOCACHE;
}
unknown's avatar
unknown committed
4458 4459 4460 4461 4462 4463 4464 4465 4466 4467 4468 4469 4470 4471 4472 4473 4474 4475 4476 4477 4478 4479 4480 4481 4482 4483 4484 4485 4486 4487 4488 4489 4490 4491 4492 4493 4494 4495 4496 4497 4498 4499 4500 4501 4502 4503 4504 4505 4506 4507 4508 4509 4510 4511 4512 4513 4514 4515 4516 4517 4518 4519 4520 4521 4522 4523 4524 4525 4526 4527 4528 4529 4530 4531 4532 4533 4534 4535 4536 4537 4538 4539 4540 4541 4542 4543 4544 4545 4546 4547 4548

/*
  Handling the shared NDB_SHARE structure that is needed to 
  provide table locking.
  It's also used for sharing data with other NDB handlers
  in the same MySQL Server. There is currently not much
  data we want to or can share.
 */

static byte* ndbcluster_get_key(NDB_SHARE *share,uint *length,
				my_bool not_used __attribute__((unused)))
{
  *length=share->table_name_length;
  return (byte*) share->table_name;
}

static NDB_SHARE* get_share(const char *table_name)
{
  NDB_SHARE *share;
  pthread_mutex_lock(&ndbcluster_mutex);
  uint length=(uint) strlen(table_name);
  if (!(share=(NDB_SHARE*) hash_search(&ndbcluster_open_tables,
                                       (byte*) table_name,
                                       length)))
  {
    if ((share=(NDB_SHARE *) my_malloc(sizeof(*share)+length+1,
                                       MYF(MY_WME | MY_ZEROFILL))))
    {
      share->table_name_length=length;
      share->table_name=(char*) (share+1);
      strmov(share->table_name,table_name);
      if (my_hash_insert(&ndbcluster_open_tables, (byte*) share))
      {
        pthread_mutex_unlock(&ndbcluster_mutex);
        my_free((gptr) share,0);
        return 0;
      }
      thr_lock_init(&share->lock);
      pthread_mutex_init(&share->mutex,MY_MUTEX_INIT_FAST);
    }
  }
  share->use_count++;
  pthread_mutex_unlock(&ndbcluster_mutex);
  return share;
}


static void free_share(NDB_SHARE *share)
{
  pthread_mutex_lock(&ndbcluster_mutex);
  if (!--share->use_count)
  {
    hash_delete(&ndbcluster_open_tables, (byte*) share);
    thr_lock_delete(&share->lock);
    pthread_mutex_destroy(&share->mutex);
    my_free((gptr) share, MYF(0));
  }
  pthread_mutex_unlock(&ndbcluster_mutex);
}



/*
  Internal representation of the frm blob
   
*/

struct frm_blob_struct 
{
  struct frm_blob_header 
  {
    uint ver;      // Version of header
    uint orglen;   // Original length of compressed data
    uint complen;  // Compressed length of data, 0=uncompressed
  } head;
  char data[1];  
};



static int packfrm(const void *data, uint len, 
		   const void **pack_data, uint *pack_len)
{
  int error;
  ulong org_len, comp_len;
  uint blob_len;
  frm_blob_struct* blob;
  DBUG_ENTER("packfrm");
  DBUG_PRINT("enter", ("data: %x, len: %d", data, len));
  
  error= 1;
4549
  org_len= len;
unknown's avatar
unknown committed
4550 4551 4552 4553 4554 4555 4556 4557 4558 4559 4560 4561 4562 4563 4564 4565 4566 4567 4568
  if (my_compress((byte*)data, &org_len, &comp_len))
    goto err;
  
  DBUG_PRINT("info", ("org_len: %d, comp_len: %d", org_len, comp_len));
  DBUG_DUMP("compressed", (char*)data, org_len);
  
  error= 2;
  blob_len= sizeof(frm_blob_struct::frm_blob_header)+org_len;
  if (!(blob= (frm_blob_struct*) my_malloc(blob_len,MYF(MY_WME))))
    goto err;
  
  // Store compressed blob in machine independent format
  int4store((char*)(&blob->head.ver), 1);
  int4store((char*)(&blob->head.orglen), comp_len);
  int4store((char*)(&blob->head.complen), org_len);
  
  // Copy frm data into blob, already in machine independent format
  memcpy(blob->data, data, org_len);  
  
4569 4570 4571
  *pack_data= blob;
  *pack_len= blob_len;
  error= 0;
unknown's avatar
unknown committed
4572 4573 4574 4575 4576 4577 4578 4579 4580 4581 4582
  
  DBUG_PRINT("exit", ("pack_data: %x, pack_len: %d", *pack_data, *pack_len));
err:
  DBUG_RETURN(error);
  
}


static int unpackfrm(const void **unpack_data, uint *unpack_len,
		    const void *pack_data)
{
4583
   const frm_blob_struct *blob= (frm_blob_struct*)pack_data;
unknown's avatar
unknown committed
4584 4585 4586 4587 4588 4589 4590 4591 4592 4593 4594 4595 4596 4597 4598
   byte *data;
   ulong complen, orglen, ver;
   DBUG_ENTER("unpackfrm");
   DBUG_PRINT("enter", ("pack_data: %x", pack_data));

   complen=	uint4korr((char*)&blob->head.complen);
   orglen=	uint4korr((char*)&blob->head.orglen);
   ver=		uint4korr((char*)&blob->head.ver);
 
   DBUG_PRINT("blob",("ver: %d complen: %d orglen: %d",
 		     ver,complen,orglen));
   DBUG_DUMP("blob->data", (char*) blob->data, complen);
 
   if (ver != 1)
     DBUG_RETURN(1);
4599
   if (!(data= my_malloc(max(orglen, complen), MYF(MY_WME))))
unknown's avatar
unknown committed
4600 4601 4602 4603 4604 4605 4606 4607 4608
     DBUG_RETURN(2);
   memcpy(data, blob->data, complen);
 
   if (my_uncompress(data, &complen, &orglen))
   {
     my_free((char*)data, MYF(0));
     DBUG_RETURN(3);
   }

4609 4610
   *unpack_data= data;
   *unpack_len= complen;
unknown's avatar
unknown committed
4611 4612 4613 4614 4615

   DBUG_PRINT("exit", ("frmdata: %x, len: %d", *unpack_data, *unpack_len));

   DBUG_RETURN(0);
}
unknown's avatar
unknown committed
4616 4617 4618 4619 4620 4621 4622 4623 4624 4625 4626 4627 4628 4629 4630 4631 4632 4633 4634

static 
int
ndb_get_table_statistics(Ndb* ndb, const char * table, 
			 Uint64* row_count, Uint64* commit_count)
{
  DBUG_ENTER("ndb_get_table_statistics");
  DBUG_PRINT("enter", ("table: %s", table));
  
  do 
  {
    NdbConnection* pTrans= ndb->startTransaction();
    if (pTrans == NULL)
      break;
    
    NdbScanOperation* pOp= pTrans->getNdbScanOperation(table);
    if (pOp == NULL)
      break;
    
unknown's avatar
unknown committed
4635
    NdbResultSet* rs= pOp->readTuples(NdbOperation::LM_CommittedRead); 
unknown's avatar
unknown committed
4636 4637 4638 4639 4640 4641 4642 4643 4644 4645 4646 4647 4648 4649 4650 4651 4652
    if (rs == 0)
      break;
    
    int check= pOp->interpret_exit_last_row();
    if (check == -1)
      break;
    
    Uint64 rows, commits;
    pOp->getValue(NdbDictionary::Column::ROW_COUNT, (char*)&rows);
    pOp->getValue(NdbDictionary::Column::COMMIT_COUNT, (char*)&commits);
    
    check= pTrans->execute(NoCommit);
    if (check == -1)
      break;
    
    Uint64 sum_rows= 0;
    Uint64 sum_commits= 0;
unknown's avatar
unknown committed
4653
    while((check= rs->nextResult(TRUE)) == 0)
unknown's avatar
unknown committed
4654 4655 4656 4657 4658 4659 4660 4661 4662 4663 4664 4665 4666 4667 4668 4669 4670 4671 4672 4673 4674
    {
      sum_rows+= rows;
      sum_commits+= commits;
    }
    
    if (check == -1)
      break;

    ndb->closeTransaction(pTrans);
    if(row_count)
      * row_count= sum_rows;
    if(commit_count)
      * commit_count= sum_commits;
    DBUG_PRINT("exit", ("records: %u commits: %u", sum_rows, sum_commits));
    DBUG_RETURN(0);
  } while(0);

  DBUG_PRINT("exit", ("failed"));
  DBUG_RETURN(-1);
}

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
/*
  Create a .ndb file to serve as a placeholder indicating 
  that the table with this name is a ndb table
*/

int ha_ndbcluster::write_ndb_file()
{
  File file;
  bool error=1;
  char path[FN_REFLEN];
  
  DBUG_ENTER("write_ndb_file");
  DBUG_PRINT("enter", ("db: %s, name: %s", m_dbname, m_tabname));

  (void)strxnmov(path, FN_REFLEN, 
		 mysql_data_home,"/",m_dbname,"/",m_tabname,ha_ndb_ext,NullS);

  if ((file=my_create(path, CREATE_MODE,O_RDWR | O_TRUNC,MYF(MY_WME))) >= 0)
  {
    // It's an empty file
    error=0;
    my_close(file,MYF(0));
  }
  DBUG_RETURN(error);
}

unknown's avatar
unknown committed
4701
#endif /* HAVE_NDBCLUSTER_DB */