summaryrefslogtreecommitdiff
path: root/mysql-test/t/key.test
Commit message (Collapse)AuthorAgeFilesLines
* Merge mysql.com:/home/my/mysql-4.1monty@mysql.com2006-06-301-0/+1
|\ | | | | | | into mysql.com:/home/my/mysql-5.0
| * Reverted wrong bug fix (Bug#11228)monty@mysql.com2006-06-301-0/+1
| |
* | Merge moonbone.local:/work/tmp_merge-4.1-opt-mysqlevgen@moonbone.local2006-06-231-0/+11
|\ \ | |/ | | | | into moonbone.local:/work/tmp_merge-5.0-opt-mysql
| * Bug#11228: DESC shows arbitrary column as "PRI"bar@mysql.com2006-06-231-0/+11
| | | | | | | | | | | | | | | | | | | | | | An UNIQUE KEY consisting of NOT NULL columns was displayed as PRIMARY KEY in "DESC t1". According to the code, that was intentional behaviour for some reasons unknown to me. This code was written before bitkeeper time, so I cannot check who and why made this. After discussing on dev-public, a decision was made to remove this code
* | After merge fix.ingo@mysql.com2005-08-291-0/+3
| |
* | Merge mysql.com:/home/mydev/mysql-4.1-4100ingo@mysql.com2005-08-291-0/+14
|\ \ | |/ | | | | into mysql.com:/home/mydev/mysql-5.0-5000
| * Bug#12565 - ERROR 1034 when running simple UPDATE or DELETE on large MyISAM ↵ingo@mysql.com2005-08-291-0/+16
| | | | | | | | | | | | | | | | table Changed end-space comparison so that the key is not used past its end. This is due to the new end-space behaviour in 4.1. See also bug 6151 and 9188.
* | Merge mysql.com:/home/my/mysql-4.1monty@mysql.com2005-07-281-0/+2
|\ \ | |/ | | | | into mysql.com:/home/my/mysql-5.0
| * Added end marker for tests to make future merges easiermonty@mysql.com2005-07-281-0/+2
| |
* | Fix reporting of type for unique key on VARCHAR field. (Bug #11227)jimw@mysql.com2005-06-221-0/+16
| |
* | Additional tweak to fix for bug #10543, to prevent a change injimw@mysql.com2005-06-021-0/+13
| | | | | | | | | | behavior when extending fields that were fully part of a multi-part key.
* | mergedserg@serg.mylan2004-11-221-0/+23
|\ \ | |/
| * Bug#6252 - Duplicate columns in keys should failantony@ltantony.rdg.cyberkinetica.homeunix.net2004-11-221-0/+23
| | | | | | | | | | Added check for duplicate column in key Added tests and fixed tests which exploit bug
* | now my_printf_error is not better then my_error, but my_error call is shorterbell@sanja.is.com.ua2004-11-131-1/+1
| | | | | | | | | | used only one implementation of format parser of (printf) fixed multistatement
* | Merge with 4.1 to get in latest bug fixesmonty@mysql.com2004-11-041-1/+2
|\ \ | |/
| * Remove usage of !$ from mysql-testsmonty@mysql.com2004-11-021-1/+2
| | | | | | | | | | | | Added protocol::flush() for easier embedded-server code Increase block allocation variables a bit as they where a bit too small for MySQL 4.1 Added option --silent to client_test
* | merge with 4.1monty@mysql.com2004-10-291-0/+44
|\ \ | |/
| * Fix for bug #6166: index prefix length of 0 not rejectedgluh@gluh.mysql.r18.ru2004-10-261-0/+11
| |
| * Fixed wrong range test code for HEAP tables. This caused a crash when doing ↵monty@mysql.com2004-10-231-0/+11
| | | | | | | | | | | | | | a range test with a key that didn't have lower or upper bound (Bug #6082) More test cases
| * test fixedserg@serg.mylan2004-10-221-0/+3
| |
| * BUG#6151 - myisam index corruption.ingo@mysql.com2004-10-211-0/+19
| | | | | | | | | | | | | | Removed the assumption of a certain key order. Since 4.1, keys are padded with blanks for comparison. Hence, shorter keys sort behind longer keys, if the data bytes have values below BLANK.
* | Removed wrong warnings in test suite (This was because select_insert / ↵monty@mishka.local2004-09-171-1/+5
|/ | | | | | select_create results was not freed. Added thd to openfrm() for initialization of TABLE->in_use. This fixed a bug in BDB handling where table->in_use was used early
* apply UNIQUE constrain correctly for multi-byte charsetsserg@serg.mylan2004-08-131-1/+25
| | | | only MyISAM is fixed
* Fixed wrong key usage which caused wrong result for some "WHERE ↵monty@mysql.com2004-05-061-0/+12
| | | | | | primary_key=constant" queries where MySQL could use 'only index' (Bug #3666) The bug was introduced in a patch in the 4.1.2 source tree.
* Fixed crashing bug with alter table when table was in use (Bug #3643)monty@mysql.com2004-05-051-0/+12
| | | | We didn't use 'only index' for tables of type 'const'. (Bug #3497)
* longer myisam keysserg@serg.mylan2004-02-201-0/+13
|
* WorkLog#1323antony@ltantony.rdg.cyberkinetica.homeunix.net2003-12-101-1/+1
| | | | Deprecate the use of TYPE=... Preferred syntax is ENGINE=
* After merge fixesmonty@mashka.mysql.fi2003-08-191-4/+5
| | | | | Use server character set if --default-character-set is not used Added convert_string() for more efficient alloc+character-set convert of strings
* Merge with 4.0.13monty@narttu.mysql.fi2003-05-191-3/+3
|\
| * Forgot to correct comment in key.test (after fixing bug 390).pem@mysql.com2003-05-131-1/+1
| |
| * Fix of bug 390: primary key now implies (silently) NOT NULL for key fields.pem@mysql.com2003-05-131-2/+2
| |
* | Changed mysql-test to print warnings for not existing table to DROP TABLEmonty@mashka.mysql.fi2003-01-061-1/+3
|/ | | | | | Cleaned up test; Removed wrong DROP TABLE commands and use standard table and database names. changed store_warning() -> push_warning_print()
* New SET syntax & system variables.monty@mashka.mysql.fi2002-07-231-0/+20
| | | | | | | | | | | | | Made a some new buffers thread specific and changeable. Resize of key_buffer. AUTO_COMMIT -> AUTOCOMMIT Fixed mutex bug in DROP DATABASE Fixed bug when using auto_increment as second part of a key where first part could include NULL. Split handler->extra() to extra() and extra_opt() to be able to support thread specific buffers. Don't write message to error log when slave reconnects becasue of timeout. Fixed possible update problem when using DELETE/UPDATE on small tables (In some cases we used index even if table scanning would be better) A lot of minior code cleanups
* Added macros for nice TIMESPEC usage.monty@hundin.mysql.fi2002-01-021-0/+8
| | | | | | | | Fixes for building MySQL with gcc 3.0 Added SIGNED / UNSIGNED casts Fixed core dump bug in net_clear() with libmysqld. Back to using semaphores in query cache. Added 'Null' and 'Index_type' to SHOW INDEX.
* Merged some functions and removed some unused client functions.monty@donna.mysql.fi2001-03-061-0/+16
| | | | | | | | Remember UNION for ALTER TABLE Added test for if we are supporting transactions. Don't allow REPLACE to replace a row when we have generated an auto_increment key Fixed bug when using BLOB keys Fixed bug in SET @variable=user.
* Added support for hex strings to mysqlimportmonty@donna.mysql.com2000-12-281-0/+146
A lot of new tests to mysqltest Fixed bug with BDB tables and autocommit