diff options
| author | unknown <magnus@neptunus.(none)> | 2004-10-07 11:57:48 +0200 |
|---|---|---|
| committer | unknown <magnus@neptunus.(none)> | 2004-10-07 11:57:48 +0200 |
| commit | 77a56a6a9ffb39837e5e8a062ffd9fe3b12e9523 (patch) | |
| tree | 033dcc041f691f7844a4cb0480bc71445eae8d27 /mysql-test/r/ndb_index_ordered.result | |
| parent | a4475441c46e0f45ec8f8974ff14c17f827bd1de (diff) | |
| download | mariadb-git-77a56a6a9ffb39837e5e8a062ffd9fe3b12e9523.tar.gz | |
Initialise "sorted" variable in constructor of QUICK_SELECT. The variable is set to 1 in test_if_skip_sort_order if we decide to optimize "order by" by uinsg index_read.
mysql-test/r/ndb_index_ordered.result:
Another test to check the use of "sorted" in combination with reset_bounds()
mysql-test/t/ndb_index_ordered.test:
Another test to check the use of "sorted" in combination with reset_bounds()
sql/ha_ndbcluster.cc:
Check that sorted is set to 0 or 1.
sql/opt_range.cc:
Initialise the sorted variable to zero QUICK_SELECT constructor.
Diffstat (limited to 'mysql-test/r/ndb_index_ordered.result')
| -rw-r--r-- | mysql-test/r/ndb_index_ordered.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_index_ordered.result b/mysql-test/r/ndb_index_ordered.result index e0c486ee2c5..2910161eb74 100644 --- a/mysql-test/r/ndb_index_ordered.result +++ b/mysql-test/r/ndb_index_ordered.result @@ -45,6 +45,16 @@ a b c 2 3 5 3 4 6 4 5 8 +select a, b, c from t1 where a!=2 and c=6; +a b c +3 4 6 +select a, b, c from t1 where a!=2 order by a; +a b c +1 2 3 +3 4 6 +4 5 8 +5 6 2 +6 7 2 update t1 set c = 3 where b = 3; select * from t1 order by a; a b c |