summaryrefslogtreecommitdiff
path: root/mysql-test/r/join.result
Commit message (Collapse)AuthorAgeFilesLines
* hang in dummy natural join (no common columns) Bug #4807serg@serg.mylan2004-08-021-0/+6
|
* Language/consistency edits to error messagespaul@ice.snake.net2004-06-151-1/+1
| | | | and affected test results.
* Fix for the bug #2976: NATURAL JOIN produces duplicate columns.ram@gw.mysql.r18.ru2004-03-191-3/+3
| | | | Improvement natural join code in the setup_conds().
* WorkLog#1323antony@ltantony.rdg.cyberkinetica.homeunix.net2003-12-101-6/+6
| | | | Deprecate the use of TYPE=... Preferred syntax is ENGINE=
* Merge with 4.0.14monty@mashka.mysql.fi2003-08-111-3/+1
|\
| * Added thread variable max_seeks_for_keymonty@mashka.mysql.fi2003-06-271-3/+1
| | | | | | | | | | Change optimizer to prefer key lookups before table scan Change table scans to be done after tables with constrains on scanned table
* | Added SQLSTATE to client/server protocolmonty@narttu.mysql.fi2003-06-041-1/+1
| | | | | | | | | | | | | | | | | | | | bmove_allign -> bmove_align Added OLAP function ROLLUP Split mysql_fix_privilege_tables to a script and a .sql data file Added new (MEMROOT*) functions to avoid calling current_thd() when creating some common objects. Added table_alias_charset, for easier --lower-case-table-name handling Better SQL_MODE handling (Setting complex options also sets sub options) New (faster) assembler string functions for x86
* | Merge with 4.0.13monty@narttu.mysql.fi2003-05-191-0/+98
|\ \ | |/
| * Fixed problem when comparing a key for a multi-byte-character set. (bug 152)monty@mashka.mysql.fi2003-04-271-0/+8
| | | | | | | | | | | | | | | | Use 0x.... as strings if 'new' mode. (bug 152) Don't report -max on windows when InnoDB is enabled. (bug 332) Reset current_linfo; This could cause a hang when doing PURGE LOGS. Fix for row numbers in EXPLAIN (bug 322) Fix that USE_FRM works for all table types (bug 97)
| * Merge with 3.23:monty@mashka.mysql.fi2003-04-261-0/+3
| |\ | | | | | | | | | | | | | | | Set innobase_flush_log_at_trx_commit to 1 by default Fix problem with timestamp on 64 bit systems Reserve alarms for up to 10 slave threads
| | * Fixed problem with timestamps in binary log on 64 bit machinesmonty@narttu.mysql.fi2003-04-231-0/+3
| | | | | | | | | | | | Backported fix from 4.1 for bug 212: SELECT query containing a NATURAL JOIN and parentheses in the WHERE clause
| * | Fix for -fbranch-probabilites (bug 268)monty@mashka.mysql.fi2003-04-261-0/+87
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fix for LEFT/RIGHT/MID with multi-byte-character sets (bug 314) Fix for new bison 1.875 max_insert_delayed_threads and delayed_insert_timeout now works as documented (bug 211) Don't show port in SHOW PROCESSLIST for system threads Fix problem with ORDER BY being discarded for some DISTINCT queries (bug 275) Fixed bug with NATURAL LEFT JOIN, NATURAL RIGHT JOIN and RIGHT JOIN when using many joined tables (Bug 212)
* | | Merge with 4.0monty@narttu.mysql.fi2003-03-161-0/+23
|\ \ \ | |/ /
| * | after merge fixesmonty@narttu.mysql.fi2003-03-101-0/+19
| | |
| * | Merge with 3.23 to get fixes for --user and BACKUP TABLEmonty@narttu.mysql.fi2003-03-101-0/+4
| |\ \ | | |/
| | * Fixed an unlikely optimizer bug that casued a core dump in ↵monty@mashka.mysql.fi2003-03-071-0/+4
| | | | | | | | | | | | pt_range.cc::sel_cmp()
| | * Fix for ISNULL()monty@hundin.mysql.fi2002-05-071-0/+3
| | |
| | * Fixed bug in full join with many NULL fields.monty@hundin.mysql.fi2002-02-101-0/+3
| | |
| | * Fixed bug when making a range join based on information from a const table.monty@hundin.mysql.fi2002-01-181-0/+4
| | |
* | | Merge with 4.0 to get fix for MIN/MAXmonty@mashka.mysql.fi2003-02-071-0/+30
|\ \ \ | |/ /
| * | Added START TRANSACTION syntaxmonty@mashka.mysql.fi2003-02-061-0/+30
| | | | | | | | | | | | | | | | | | 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)
* | | Portability fixes (for windows)monty@mashka.mysql.fi2003-01-211-5/+5
|/ / | | | | | | Some changes to the prepared statement protocol to make it easier to use and faster.
* | Fixed bug in LEFT JOIN with impossible ON/WHERE expressionmonty@mashka.mysql.fi2003-01-191-2/+11
| |
* | Fixed some compilation problems in last changesetmonty@hundin.mysql.fi2002-05-161-0/+4
| |
* | Added --user=userid to mysqldmonty@tik.mysql.fi2002-02-131-0/+22
| | | | | | | | | | Fix for ctypes on windows Cleanup max_queries_per_hour
* | Fixes for new getoptmonty@hundin.mysql.fi2002-01-311-1/+71
| | | | | | | | | | | | | | | | | | Bug fix when using --no-deaults Sets ref_length to right value (faster rnd_pos() handling in InnoDB). Fixed problem with multi-table-delete and InnoDB Fixed problem with truncate table, which required a COMMIT before. Fixed multi-table-delete bug with InnoDB. Remove not used index from EXPLAIN
* | Make ft_xxx variables ulong to not break mysqld.cc init of variables.monty@hundin.mysql.fi2001-11-051-1/+1
| | | | | | | | mysqltest: replace_result now also affects error messages
* | Fixes up things after merge from 3.23.44monty@hundin.mysql.fi2001-11-051-1/+12
| | | | | | | | | | Portability fixes. Don't delete temporary tables on FLUSH tables.
* | use local version when doing merge with 3.23.44monty@hundin.mysql.fi2001-11-041-5/+83
|/
* Fixed problem with t1 LEFT_JOIN t2 ... WHERE t2.date_column IS NULL when ↵monty@hundin.mysql.fi2001-11-031-0/+5
| | | | date_column is declared as NOT NULL.
* Fixed bug in counting open files when using many filesmonty@hundin.mysql.fi2001-09-271-0/+2
| | | | Fixed bug in JOIN
* Fix for LOAD DATA FROM MASTER when using tables with checksummonty@hundin.mysql.fi2001-09-181-0/+13
| | | | Fixed some wrong test cases
* Added support for hex strings to mysqlimportmonty@donna.mysql.com2000-12-281-0/+9
A lot of new tests to mysqltest Fixed bug with BDB tables and autocommit