18
18
Single table and multi table updates of tables.
19
Multi-table updates were introduced by Sinisa & Monty
23
#include <drizzled/sql_select.h>
24
#include <drizzled/error.h>
25
#include <drizzled/probes.h>
26
#include <drizzled/sql_base.h>
27
#include <drizzled/field/epoch.h>
28
#include <drizzled/sql_parse.h>
29
#include <drizzled/optimizer/range.h>
30
#include <drizzled/records.h>
31
#include <drizzled/internal/my_sys.h>
32
#include <drizzled/internal/iocache.h>
33
#include <drizzled/transaction_services.h>
34
#include <drizzled/filesort.h>
35
#include <drizzled/plugin/storage_engine.h>
22
#include "drizzled/sql_select.h"
23
#include "drizzled/error.h"
24
#include "drizzled/probes.h"
25
#include "drizzled/sql_base.h"
26
#include "drizzled/field/epoch.h"
27
#include "drizzled/sql_parse.h"
28
#include "drizzled/optimizer/range.h"
29
#include "drizzled/records.h"
30
#include "drizzled/internal/my_sys.h"
31
#include "drizzled/internal/iocache.h"
32
#include "drizzled/transaction_services.h"
33
#include "drizzled/filesort.h"
37
35
#include <boost/dynamic_bitset.hpp>
132
int update_query(Session *session, TableList *table_list,
130
int mysql_update(Session *session, TableList *table_list,
133
131
List<Item> &fields, List<Item> &values, COND *conds,
134
132
uint32_t order_num, Order *order,
135
133
ha_rows limit, enum enum_duplicates,
138
136
bool using_limit= limit != HA_POS_ERROR;
139
137
bool used_key_is_modified;
140
138
bool transactional_table;
142
140
uint used_index= MAX_KEY, dup_key_found;
143
141
bool need_sort= true;
144
142
ha_rows updated, found;
165
163
table->covering_keys= table->getShare()->keys_in_use;
166
164
table->quick_keys.reset();
168
if (prepare_update(session, table_list, &conds, order_num, order))
166
if (mysql_prepare_update(session, table_list, &conds, order_num, order))
170
168
DRIZZLE_UPDATE_DONE(1, 0, 0);
208
206
fix_inner_refs(session, all_fields, select_lex, select_lex->ref_pointer_array))
210
208
DRIZZLE_UPDATE_DONE(1, 0, 0);
249
247
session->main_da.reset_diagnostics_area();
250
248
free_underlaid_joins(session, select_lex);
251
if (error || session->is_error())
253
251
DRIZZLE_UPDATE_DONE(1, 0, 0);
365
364
if (used_index == MAX_KEY || (select && select->quick))
367
if ((error= info.init_read_record(session, table, select, 0, true)))
366
info.init_read_record(session, table, select, 0, true);
372
if ((error= info.init_read_record_idx(session, table, 1, used_index)))
370
info.init_read_record_idx(session, table, 1, used_index);
376
373
session->set_proc_info("Searching rows for update");
408
405
/* Change select to use tempfile */
411
safe_delete(select->quick);
408
delete select->quick;
412
409
if (select->free_cond)
413
410
delete select->cond;
418
select= new optimizer::SqlSelect();
416
select= new optimizer::SqlSelect;
419
417
select->head=table;
421
419
if (tempfile.reinit_io_cache(internal::READ_CACHE,0L,0,0))
435
433
if (select && select->quick && select->quick->reset())
437
435
table->cursor->try_semi_consistent_read(1);
438
if ((error= info.init_read_record(session, table, select, 0, true)))
436
info.init_read_record(session, table, select, 0, true);
443
438
updated= found= 0;
454
449
session->set_proc_info("Updating");
456
451
transactional_table= table->cursor->has_transactions();
457
session->setAbortOnWarning(test(!ignore));
452
session->abort_on_warning= test(!ignore);
460
455
Assure that we can use position()
578
573
session->main_da.reset_diagnostics_area();
579
session->my_ok((ulong) session->rowCount(), found, id, buff);
580
session->status_var.updated_row_count+= session->rowCount();
574
session->my_ok((ulong) session->row_count_func, found, id, buff);
575
session->status_var.updated_row_count+= session->row_count_func;
582
577
session->count_cuted_fields= CHECK_FIELD_ERROR_FOR_NULL; /* calc cuted fields */
583
session->setAbortOnWarning(false);
578
session->abort_on_warning= 0;
584
579
DRIZZLE_UPDATE_DONE((error >= 0 || session->is_error()), found, updated);
585
580
return ((error >= 0 || session->is_error()) ? 1 : 0);
589
table->print_error(error,MYF(0));
592
584
free_underlaid_joins(session, select_lex);
593
585
if (table->key_read)
595
587
table->key_read=0;
596
588
table->cursor->extra(HA_EXTRA_NO_KEYREAD);
598
session->setAbortOnWarning(false);
590
session->abort_on_warning= 0;
600
592
DRIZZLE_UPDATE_DONE(1, 0, 0);
619
bool prepare_update(Session *session, TableList *table_list,
611
bool mysql_prepare_update(Session *session, TableList *table_list,
620
612
Item **conds, uint32_t order_num, Order *order)
622
614
List<Item> all_fields;
623
Select_Lex *select_lex= &session->getLex()->select_lex;
615
Select_Lex *select_lex= &session->lex->select_lex;
625
session->getLex()->allow_sum_func= 0;
617
session->lex->allow_sum_func= 0;
627
619
if (setup_tables_and_check_access(session, &select_lex->context,
628
620
&select_lex->top_join_list,