12
12
You should have received a copy of the GNU General Public License
13
13
along with this program; if not, write to the Free Software
14
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */
14
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */
16
16
/* The hash functions used for saveing keys */
18
#include "heap_priv.h"
20
#include "drizzled/charset_info.h"
21
#include <drizzled/util/test.h>
28
using namespace drizzled;
31
static uint32_t hp_hashnr(register HP_KEYDEF *keydef, register const unsigned char *key);
32
static int hp_key_cmp(HP_KEYDEF *keydef, const unsigned char *rec, const unsigned char *key);
19
#include <mystrings/m_ctype.h>
24
Find out how many rows there is in the given range
27
hp_rb_records_in_range()
30
min_key Min key. Is = 0 if no min range
31
max_key Max key. Is = 0 if no max range
34
min_key.flag can have one of the following values:
35
HA_READ_KEY_EXACT Include the key in the range
36
HA_READ_AFTER_KEY Don't include key in range
38
max_key.flag can have one of the following values:
39
HA_READ_BEFORE_KEY Don't include key in range
40
HA_READ_AFTER_KEY Include all 'end_key' values in the range
43
HA_POS_ERROR Something is wrong with the index tree.
44
0 There is no matching keys in the given range
45
number > 0 There is approximately 'number' matching rows in
49
ha_rows hp_rb_records_in_range(HP_INFO *info, int inx, key_range *min_key,
52
ha_rows start_pos, end_pos;
53
HP_KEYDEF *keyinfo= info->s->keydef + inx;
54
TREE *rb_tree = &keyinfo->rb_tree;
55
heap_rb_param custom_arg;
58
custom_arg.keyseg= keyinfo->seg;
59
custom_arg.search_flag= SEARCH_FIND | SEARCH_SAME;
62
custom_arg.key_length= hp_rb_pack_key(keyinfo, (uchar*) info->recbuf,
63
(uchar*) min_key->key,
64
min_key->keypart_map);
65
start_pos= tree_record_pos(rb_tree, info->recbuf, min_key->flag,
75
custom_arg.key_length= hp_rb_pack_key(keyinfo, (uchar*) info->recbuf,
76
(uchar*) max_key->key,
77
max_key->keypart_map);
78
end_pos= tree_record_pos(rb_tree, info->recbuf, max_key->flag,
83
end_pos= rb_tree->elements_in_tree + (ha_rows)1;
86
if (start_pos == HA_POS_ERROR || end_pos == HA_POS_ERROR)
88
return(end_pos < start_pos ? (ha_rows) 0 :
89
(end_pos == start_pos ? (ha_rows) 1 : end_pos - start_pos));
35
93
/* Search after a record based on a key */
36
94
/* Sets info->current_ptr to found record */
37
95
/* next_flag: Search=0, next=1, prev =2, same =3 */
39
unsigned char *hp_search(HP_INFO *info, HP_KEYDEF *keyinfo, const unsigned char *key,
97
uchar *hp_search(HP_INFO *info, HP_KEYDEF *keyinfo, const uchar *key,
42
100
register HASH_INFO *pos,*prev_ptr;
44
uint32_t old_nextflag;
45
HP_SHARE *share=info->getShare();
103
HP_SHARE *share=info->s;
46
104
old_nextflag=nextflag;
253
313
if (seg->type == HA_KEYTYPE_TEXT)
255
315
const CHARSET_INFO * const cs= seg->charset;
256
uint32_t char_length= seg->length;
316
uint char_length= seg->length;
257
317
if (cs->mbmaxlen > 1)
259
319
char_length= my_charpos(cs, pos, pos + char_length,
260
320
char_length / cs->mbmaxlen);
261
set_if_smaller(char_length, (uint32_t)seg->length); /* QQ: ok to remove? */
321
set_if_smaller(char_length, seg->length); /* QQ: ok to remove? */
263
323
cs->coll->hash_sort(cs, pos, char_length, &nr, &nr2);
265
325
else if (seg->type == HA_KEYTYPE_VARTEXT1) /* Any VARCHAR segments */
267
327
const CHARSET_INFO * const cs= seg->charset;
268
uint32_t pack_length= seg->bit_start;
269
uint32_t length= (pack_length == 1 ? (uint) *(unsigned char*) pos : uint2korr(pos));
328
uint pack_length= seg->bit_start;
329
uint length= (pack_length == 1 ? (uint) *(uchar*) pos : uint2korr(pos));
270
330
if (cs->mbmaxlen > 1)
272
uint32_t char_length;
273
333
char_length= my_charpos(cs, pos + pack_length,
274
334
pos + pack_length + length,
275
335
seg->length/cs->mbmaxlen);
355
* Fowler/Noll/Vo hash
357
* The basis of the hash algorithm was taken from an idea sent by email to the
358
* IEEE Posix P1003.2 mailing list from Phong Vo (kpv@research.att.com) and
359
* Glenn Fowler (gsf@research.att.com). Landon Curt Noll (chongo@toad.com)
360
* later improved on their algorithm.
362
* The magic is in the interesting relationship between the special prime
363
* 16777619 (2^24 + 403) and 2^32 and 2^8.
365
* This hash produces the fewest collisions of any function that we've seen so
366
* far, and works well on both numbers and strings.
369
uint32_t hp_hashnr(register HP_KEYDEF *keydef, register const uchar *key)
372
Note, if a key consists of a combination of numeric and
373
a text columns, it most likely won't work well.
374
Making text columns work with NEW_HASH_FUNCTION
375
needs also changes in strings/ctype-xxx.c.
377
uint32_t nr= 1, nr2= 4;
378
HA_KEYSEG *seg,*endseg;
380
for (seg=keydef->seg,endseg=seg+keydef->keysegs ; seg < endseg ; seg++)
382
uchar *pos=(uchar*) key;
390
/* Add key pack length (2) to key for VARCHAR segments */
391
if (seg->type == HA_KEYTYPE_VARTEXT1)
397
if (seg->type == HA_KEYTYPE_TEXT)
399
seg->charset->coll->hash_sort(seg->charset, pos, ((uchar*)key)-pos,
402
else if (seg->type == HA_KEYTYPE_VARTEXT1) /* Any VARCHAR segments */
404
uint pack_length= 2; /* Key packing is constant */
405
uint length= uint2korr(pos);
406
seg->charset->coll->hash_sort(seg->charset, pos+pack_length, length,
412
for ( ; pos < (uchar*) key ; pos++)
422
/* Calc hashvalue for a key in a record */
424
uint32_t hp_rec_hashnr(register HP_KEYDEF *keydef, register const uchar *rec)
426
uint32_t nr= 1, nr2= 4;
427
HA_KEYSEG *seg,*endseg;
429
for (seg=keydef->seg,endseg=seg+keydef->keysegs ; seg < endseg ; seg++)
431
uchar *pos=(uchar*) rec+seg->start;
434
if (rec[seg->null_pos] & seg->null_bit)
440
if (seg->type == HA_KEYTYPE_TEXT)
442
uint char_length= seg->length; /* TODO: fix to use my_charpos() */
443
seg->charset->coll->hash_sort(seg->charset, pos, char_length,
446
else if (seg->type == HA_KEYTYPE_VARTEXT1) /* Any VARCHAR segments */
448
uint pack_length= seg->bit_start;
449
uint length= (pack_length == 1 ? (uint) *(uchar*) pos : uint2korr(pos));
450
seg->charset->coll->hash_sort(seg->charset, pos+pack_length,
455
uchar *end= pos+seg->length;
456
for ( ; pos < end ; pos++)
293
470
Compare keys for two records. Returns 0 if they are identical
327
504
if (seg->type == HA_KEYTYPE_TEXT)
329
506
const CHARSET_INFO * const cs= seg->charset;
330
uint32_t char_length1;
331
uint32_t char_length2;
332
unsigned char *pos1= (unsigned char*)rec1 + seg->start;
333
unsigned char *pos2= (unsigned char*)rec2 + seg->start;
509
uchar *pos1= (uchar*)rec1 + seg->start;
510
uchar *pos2= (uchar*)rec2 + seg->start;
334
511
if (cs->mbmaxlen > 1)
336
uint32_t char_length= seg->length / cs->mbmaxlen;
513
uint char_length= seg->length / cs->mbmaxlen;
337
514
char_length1= my_charpos(cs, pos1, pos1 + seg->length, char_length);
338
set_if_smaller(char_length1, (uint32_t)seg->length);
515
set_if_smaller(char_length1, seg->length);
339
516
char_length2= my_charpos(cs, pos2, pos2 + seg->length, char_length);
340
set_if_smaller(char_length2, (uint32_t)seg->length);
517
set_if_smaller(char_length2, seg->length);
420
597
if (seg->type == HA_KEYTYPE_TEXT)
422
599
const CHARSET_INFO * const cs= seg->charset;
423
uint32_t char_length_key;
424
uint32_t char_length_rec;
425
unsigned char *pos= (unsigned char*) rec + seg->start;
600
uint char_length_key;
601
uint char_length_rec;
602
uchar *pos= (uchar*) rec + seg->start;
426
603
if (cs->mbmaxlen > 1)
428
uint32_t char_length= seg->length / cs->mbmaxlen;
605
uint char_length= seg->length / cs->mbmaxlen;
429
606
char_length_key= my_charpos(cs, key, key + seg->length, char_length);
430
set_if_smaller(char_length_key, (uint32_t)seg->length);
607
set_if_smaller(char_length_key, seg->length);
431
608
char_length_rec= my_charpos(cs, pos, pos + seg->length, char_length);
432
set_if_smaller(char_length_rec, (uint32_t)seg->length);
609
set_if_smaller(char_length_rec, seg->length);
436
613
char_length_key= seg->length;
437
614
char_length_rec= seg->length;
440
617
if (seg->charset->coll->strnncollsp(seg->charset,
441
(unsigned char*) pos, char_length_rec,
442
(unsigned char*) key, char_length_key, 0))
618
(uchar*) pos, char_length_rec,
619
(uchar*) key, char_length_key, 0))
445
622
else if (seg->type == HA_KEYTYPE_VARTEXT1) /* Any VARCHAR segments */
447
unsigned char *pos= (unsigned char*) rec + seg->start;
624
uchar *pos= (uchar*) rec + seg->start;
448
625
const CHARSET_INFO * const cs= seg->charset;
449
uint32_t pack_length= seg->bit_start;
450
uint32_t char_length_rec= (pack_length == 1 ? (uint) *(unsigned char*) pos :
626
uint pack_length= seg->bit_start;
627
uint char_length_rec= (pack_length == 1 ? (uint) *(uchar*) pos :
452
629
/* Key segments are always packed with 2 bytes */
453
uint32_t char_length_key= uint2korr(key);
630
uint char_length_key= uint2korr(key);
454
631
pos+= pack_length;
455
632
key+= 2; /* skip key pack length */
456
633
if (cs->mbmaxlen > 1)
458
uint32_t char_length1, char_length2;
459
char_length1= char_length2= seg->length / cs->mbmaxlen;
635
uint char_length1, char_length2;
636
char_length1= char_length2= seg->length / cs->mbmaxlen;
460
637
char_length1= my_charpos(cs, key, key + char_length_key, char_length1);
461
638
set_if_smaller(char_length_key, char_length1);
462
639
char_length2= my_charpos(cs, pos, pos + char_length_rec, char_length2);
481
658
/* Copy a key from a record to a keybuffer */
483
void hp_make_key(HP_KEYDEF *keydef, unsigned char *key, const unsigned char *rec)
660
void hp_make_key(HP_KEYDEF *keydef, uchar *key, const uchar *rec)
485
662
HA_KEYSEG *seg,*endseg;
487
664
for (seg=keydef->seg,endseg=seg+keydef->keysegs ; seg < endseg ; seg++)
489
666
const CHARSET_INFO * const cs= seg->charset;
490
uint32_t char_length= seg->length;
491
unsigned char *pos= (unsigned char*) rec + seg->start;
667
uint char_length= seg->length;
668
uchar *pos= (uchar*) rec + seg->start;
492
669
if (seg->null_bit)
493
670
*key++= test(rec[seg->null_pos] & seg->null_bit);
494
671
if (cs->mbmaxlen > 1)
496
673
char_length= my_charpos(cs, pos, pos + seg->length,
497
674
char_length / cs->mbmaxlen);
498
set_if_smaller(char_length, (uint32_t)seg->length); /* QQ: ok to remove? */
675
set_if_smaller(char_length, seg->length); /* QQ: ok to remove? */
500
677
if (seg->type == HA_KEYTYPE_VARTEXT1)
501
678
char_length+= seg->bit_start; /* Copy also length */
511
688
set_if_smaller(char_length,length); \
692
uint hp_rb_make_key(HP_KEYDEF *keydef, uchar *key,
693
const uchar *rec, uchar *recpos)
695
uchar *start_key= key;
696
HA_KEYSEG *seg, *endseg;
698
for (seg= keydef->seg, endseg= seg + keydef->keysegs; seg < endseg; seg++)
703
if (!(*key++= 1 - test(rec[seg->null_pos] & seg->null_bit)))
706
if (seg->flag & HA_SWAP_KEY)
708
uint length= seg->length;
709
uchar *pos= (uchar*) rec + seg->start;
712
if (seg->type == HA_KEYTYPE_FLOAT)
718
/* Replace NAN with zero */
719
memset(key, 0, length);
724
else if (seg->type == HA_KEYTYPE_DOUBLE)
730
memset(key, 0, length);
744
if (seg->flag & HA_VAR_LENGTH_PART)
746
uchar *pos= (uchar*) rec + seg->start;
747
uint length= seg->length;
748
uint pack_length= seg->bit_start;
749
uint tmp_length= (pack_length == 1 ? (uint) *(uchar*) pos :
751
const CHARSET_INFO * const cs= seg->charset;
752
char_length= length/cs->mbmaxlen;
754
pos+= pack_length; /* Skip VARCHAR length */
755
set_if_smaller(length,tmp_length);
756
FIX_LENGTH(cs, pos, length, char_length);
757
store_key_length_inc(key,char_length);
758
memcpy(key,pos,(size_t) char_length);
763
char_length= seg->length;
764
if (seg->charset->mbmaxlen > 1)
766
char_length= my_charpos(seg->charset,
767
rec + seg->start, rec + seg->start + char_length,
768
char_length / seg->charset->mbmaxlen);
769
set_if_smaller(char_length, seg->length); /* QQ: ok to remove? */
770
if (char_length < seg->length)
771
seg->charset->cset->fill(seg->charset, (char*) key + char_length,
772
seg->length - char_length, ' ');
774
memcpy(key, rec + seg->start, (size_t) char_length);
777
memcpy(key, &recpos, sizeof(uchar*));
778
return (uint) (key - start_key);
782
uint hp_rb_pack_key(HP_KEYDEF *keydef, uchar *key, const uchar *old,
783
key_part_map keypart_map)
785
HA_KEYSEG *seg, *endseg;
786
uchar *start_key= key;
788
for (seg= keydef->seg, endseg= seg + keydef->keysegs;
789
seg < endseg && keypart_map; old+= seg->length, seg++)
795
if (!(*key++= (char) 1 - *old++))
798
if (seg->flag & HA_SWAP_KEY)
800
uint length= seg->length;
801
uchar *pos= (uchar*) old + length;
809
if (seg->flag & (HA_VAR_LENGTH_PART | HA_BLOB_PART))
811
/* Length of key-part used with heap_rkey() always 2 */
812
uint tmp_length=uint2korr(old);
813
uint length= seg->length;
814
const CHARSET_INFO * const cs= seg->charset;
815
char_length= length/cs->mbmaxlen;
818
set_if_smaller(length,tmp_length); /* Safety */
819
FIX_LENGTH(cs, old, length, char_length);
820
store_key_length_inc(key,char_length);
821
memcpy(key, old,(size_t) char_length);
825
char_length= seg->length;
826
if (seg->charset->mbmaxlen > 1)
828
char_length= my_charpos(seg->charset, old, old+char_length,
829
char_length / seg->charset->mbmaxlen);
830
set_if_smaller(char_length, seg->length); /* QQ: ok to remove? */
831
if (char_length < seg->length)
832
seg->charset->cset->fill(seg->charset, (char*) key + char_length,
833
seg->length - char_length, ' ');
835
memcpy(key, old, (size_t) char_length);
838
return (uint) (key - start_key);
842
uint hp_rb_key_length(HP_KEYDEF *keydef,
843
const uchar *key __attribute__((unused)))
845
return keydef->length;
849
uint hp_rb_null_key_length(HP_KEYDEF *keydef, const uchar *key)
851
const uchar *start_key= key;
852
HA_KEYSEG *seg, *endseg;
854
for (seg= keydef->seg, endseg= seg + keydef->keysegs; seg < endseg; seg++)
856
if (seg->null_bit && !*key++)
860
return (uint) (key - start_key);
864
uint hp_rb_var_key_length(HP_KEYDEF *keydef, const uchar *key)
866
const uchar *start_key= key;
867
HA_KEYSEG *seg, *endseg;
869
for (seg= keydef->seg, endseg= seg + keydef->keysegs; seg < endseg; seg++)
871
uint length= seg->length;
872
if (seg->null_bit && !*key++)
874
if (seg->flag & (HA_VAR_LENGTH_PART | HA_BLOB_PART))
876
get_key_length(length, key);
880
return (uint) (key - start_key);
515
885
Test if any of the key parts are NULL.
547
void heap_update_auto_increment(HP_INFO *info, const unsigned char *record)
917
void heap_update_auto_increment(HP_INFO *info, const uchar *record)
549
919
uint64_t value= 0; /* Store unsigned values here */
550
920
int64_t s_value= 0; /* Store signed values here */
552
HA_KEYSEG *keyseg= info->getShare()->keydef[info->getShare()->auto_key - 1].seg;
553
const unsigned char *key= (unsigned char*) record + keyseg->start;
922
HA_KEYSEG *keyseg= info->s->keydef[info->s->auto_key - 1].seg;
923
const uchar *key= (uchar*) record + keyseg->start;
555
switch (info->getShare()->auto_key_type) {
925
switch (info->s->auto_key_type) {
926
case HA_KEYTYPE_INT8:
927
s_value= (int64_t) *(char*)key;
556
929
case HA_KEYTYPE_BINARY:
557
value=(uint64_t) *(unsigned char*) key;
930
value=(uint64_t) *(uchar*) key;
932
case HA_KEYTYPE_SHORT_INT:
933
s_value= (int64_t) sint2korr(key);
935
case HA_KEYTYPE_USHORT_INT:
936
value=(uint64_t) uint2korr(key);
559
938
case HA_KEYTYPE_LONG_INT:
560
939
s_value= (int64_t) sint4korr(key);