diff options
| author | unknown <rburnett@production.mysql.com> | 2006-03-13 14:50:16 +0100 |
|---|---|---|
| committer | unknown <rburnett@production.mysql.com> | 2006-03-13 14:50:16 +0100 |
| commit | 0c63aee7f9a46ca3e12615533677e64dda9819ba (patch) | |
| tree | 3947d40f4f2e5d9995b3a91972988021c1e763c7 /sql/opt_range.cc | |
| parent | 4487b8538f5d611d672fa2e5f1ccd90dfb1ebfcb (diff) | |
| download | mariadb-git-0c63aee7f9a46ca3e12615533677e64dda9819ba.tar.gz | |
Bug # 17173 - Partitions: less than search fails
Bug # 17894 - Comparison with "less than" operator fails with range partition
The problem here was that on queries such as < 3, the range given is NULL < n < 3.
The null part works correctly where the null value is stored in rec[0] and the
field is marked as being null. However, when the 3 is processed, the 3 is places
on rec[0] but the null flag is left uncleared.
partition_range.result:
Results block for bug #17894
partition_range.test:
Test block for bug #17894
partition_list.result:
Results block for bug #17173
partition_list.test:
Test block for bug #17173
opt_range.cc:
call set_notnull to clear any null flag that may have been set
sql/opt_range.cc:
call set_notnull to clear any null flag that may have been set
mysql-test/t/partition_list.test:
Test block for bug #17173
mysql-test/r/partition_list.result:
Results block for bug #17173
mysql-test/t/partition_range.test:
Test block for bug #17894
mysql-test/r/partition_range.result:
Results block for bug #17894
Diffstat (limited to 'sql/opt_range.cc')
| -rw-r--r-- | sql/opt_range.cc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/opt_range.cc b/sql/opt_range.cc index 06ca4958d2c..4e89107d406 100644 --- a/sql/opt_range.cc +++ b/sql/opt_range.cc @@ -2430,6 +2430,7 @@ void store_key_image_to_rec(Field *field, char *ptr, uint len) field->set_null(); return; } + field->set_notnull(); ptr++; } field->set_key_image(ptr, len); |