summaryrefslogtreecommitdiff
path: root/mysql-test/t/order_by.test
Commit message (Collapse)AuthorAgeFilesLines
* Merge mysql.com:/home/jonas/src/mysql-4.1joreland@mysql.com2005-01-271-0/+10
|\ | | | | | | into mysql.com:/home/jonas/src/mysql-5.0
| * order_by.result, order_by.test:igor@rurik.mysql.com2005-01-251-0/+10
| | | | | | | | Added test case for bug #7672 that existed only in 4.0.
| * Fix for BUG#7331.timour@mysql.com2005-01-061-0/+34
| | | | | | | | | | | | | | | | | | | | | | | | | | The problem was that when a QUICK_SELECT access method is chosen, test_if_skip_sort_order() discovered that the index being used by the quick select will not deliver tuples in sorted order. In this case test_if_skip_sort_order() tried to change the index used by the quick select, but it didn't properly set the other members of the quick select, and especially the range flags of the ranges in QUICK_SELECT::ranges. The fix re-invokes the function SQL_SELECT::test_quick_select to correctly create a valid QUICK_SELECT object.
* | Fix for BUG#7331 merged manually from 4.1.timour@mysql.com2005-01-171-0/+33
| |
* | order by group_funcserg@serg.mylan2004-11-251-0/+6
|/
* Final solution for bug# 4302 "Ambiguos order by when renamed column isdlenev@brandersnatch.localdomain2004-09-301-2/+3
| | | | | | | identical to another in result" According to SQL standard queries like "select t1.a as col from t1, t2 order by a" should return an error if both tables contain field a.
* A fix (Bug #5428 small max_sort_length crash server).ram@gw.mysql.r18.ru2004-09-071-0/+13
|
* Fix for bug#4302 "ambiguos order by when renamed column is identical to ↵dlenev@brandersnatch.localdomain2004-08-201-2/+43
| | | | | | | | another in result" When in find_item_in_list() we are looking for item we should take into account unaliased names of the fields but only if item with such aliased name is not found. Also we should ignore aliases when looking for fully specified field.
* bad old merge fixedserg@serg.mylan2004-05-151-0/+10
|
* Fix to get correct metadata when using temporary tables to create result. ↵monty@mysql.com2004-03-301-1/+1
| | | | (Bug #2654)
* false/true -> FALSE/TRUEmonty@mysql.com2004-03-301-1/+1
| | | | Fixes after last merge
* Merge with 4.0 to get lastest bug fixesmonty@mysql.com2004-03-291-0/+17
|\
| * order_by.result:Sinisa@sinisa.nasamreza.org2004-03-261-1/+12
| | | | | | | | | | | | | | | | result of the test case for FORCE INDEX on ORDER BY order_by.test: test case for FORCE INDEX on ORDER BY sql_select.cc: Changing behaviour that MySQL server takes FORCE INDEX clause into account when optimising ORDER BY clause
* | Added test case for the bug #3155: strange results with index (x, y) ... ↵ram@gw.mysql.r18.ru2004-03-171-0/+25
| | | | | | | | | | | | WHERE x=val_1 AND y>=val_2 ORDER BY pk; (thankee Monty)
* | fix for the bug #2419: order by ignores rows.ram@gw.mysql.r18.ru2004-01-311-0/+12
| | | | | | | | | | null_ref_key moved to TABLE_REF. new null range created if necessary.
* | Portability fixes found during 5.0 test compilationmonty@mysql.com2003-12-211-0/+8
| | | | | | | | | | | | Fixed bug in ORDER BY on a small column (Bug #2147) Fixed error from pthread_mutex_destroy() when one had wrong errmsg file
* | WorkLog#1323antony@ltantony.rdg.cyberkinetica.homeunix.net2003-12-101-4/+4
| | | | | | | | Deprecate the use of TYPE=... Preferred syntax is ENGINE=
* | mergedserg@serg.mylan2003-11-281-0/+8
|\ \ | |/
| * bug #1945. item(expression)->name=0, crash in find_item_in_listserg@serg.mylan2003-11-281-0/+8
| |
* | After merge fixesmonty@mashka.mysql.fi2003-05-211-1/+1
| | | | | | | | Added initialization of all important global variables
* | Merge with 4.0.13monty@narttu.mysql.fi2003-05-191-1/+13
|\ \ | |/
| * filesort.cc, order_by.result:igor@hundin.mysql.fi2003-04-261-0/+14
| | | | | | | | | | | | Fixed bug 263 order_by.test: Fixed bug 263
* | Merge with 4.0.13monty@mashka.mysql.fi2003-03-261-1/+1
|\ \ | |/
| * Changed some tests to pass with new auto_increment handling,jani@hynda.(none)2003-03-221-1/+1
| | | | | | | | e.g. default value is not accepted with auto_increment anymore.
* | Merge with 4.0 to get fix for MIN/MAXmonty@mashka.mysql.fi2003-02-071-1/+2
|\ \ | |/
| * Added START TRANSACTION syntaxmonty@mashka.mysql.fi2003-02-061-1/+2
| | | | | | | | | | | | Added ALL as parameter option for all group functions. Make join handling uniform. This allows us to use ',', JOIN and INNER JOIN the same way. Sort NULL last if DESC is used (ANSI SQL 99 requirement)
* | fixed order_by test to make it repeatableram@mysql.r18.ru2003-01-091-5/+5
| |
* | Merge rkalimullin@work.mysql.com:/home/bk/mysql-4.1ram@mysql.r18.ru2003-01-081-0/+21
|\ \ | | | | | | | | | into mysql.r18.ru:/usr/home/ram/work/mysql-4.1
| * | Optimization of key usage (ORDER BY) (SCRUM)ram@mysql.r18.ru2003-01-041-0/+21
| |/
* | Changed mysql-test to print warnings for not existing table to DROP TABLEmonty@mashka.mysql.fi2003-01-061-1/+2
|/ | | | | | Cleaned up test; Removed wrong DROP TABLE commands and use standard table and database names. changed store_warning() -> push_warning_print()
* Fix of newly introduced bug in ORDER BY when one has a constant in the ↵monty@hundin.mysql.fi2002-09-241-0/+38
| | | | select list.
* mergedsasha@mysql.sashanet.com2001-08-091-0/+38
|\
| * Fixed optimizer bug in ORDER BY where some ORDER BY parts where ignored.monty@tik.mysql.fi2001-07-301-5/+47
| | | | | | | | Extended default arguments to be up to 4095 characters
* | Fix ORDER BY ... DESC optimizationmonty@hundin.mysql.fi2001-06-291-8/+35
| |
* | Implement ORDER BY DESC optimization, which reads values in descendingtim@white.box2001-06-281-0/+22
|/ | | | order directly from the index instead of using a filesort.
* untested changes to close socket on slave stop for OS's that do notsasha@mysql.sashanet.com2001-03-121-0/+40
| | | | | | interrupt I/O after thr_alarm_kill() test case for order by desc coredump
* Fixed gethostname_r tests to be more portablemonty@donna.mysql.com2001-01-011-1/+1
|
* Added support for hex strings to mysqlimportmonty@donna.mysql.com2000-12-281-0/+167
A lot of new tests to mysqltest Fixed bug with BDB tables and autocommit
View Lorry Controller Status