| Commit message (Collapse) | Author | Age | Files | Lines |
|---|
| |
|
|
| |
mem_per_row
|
| | |
|
| |
|
|
| |
range for BETWEEN typo fixed
|
| |\
| |
| |
| | |
into mysql.com:/dbdata/psergey/mysql-4.1-heap-bug
|
| | |
| |
| |
| | |
calls, changed ha_heap::records_in_range to use table->rec_per_key.
|
| | |
| |
| |
| | |
KEY::rec_per_key is updated every time 1/HEAP_STATS_UPDATE_THRESHOLD part of table records has been changed.
|
| |/
|
|
| |
Fixed checking of privilege handling in CREATE ... SELECT (Bug #6094)
|
| |
|
|
| |
Fixed bug in end space handle for WHERE text_column="constant"
|
| |
|
|
| |
Bug#4521: unique prefix keys, fix for HEAP HASH and HEAP BTREE case insensitive collations.
|
| |
|
|
|
| |
some reason wasn't included before.
A lot of files cleaned up from #include <assert.h>
|
| |
|
|
| |
(Note: This affects only comments, not variable names.)
|
| |
|
|
|
|
|
|
|
| |
New records_in_range() interface (similar to read_range())
Macros for faster bitmap handling
Simplify read_range() code (#WL1786)
New general key_cmp() function to compare keys
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
HEAP: Copies the key count to a backup variable and sets the key count to zero.
That way, no HEAP function will ever try to touch any index.
Re-enabling is done by copying back the backup variable.
To avoid memory leak at table close, disable deletes all index trees.
Re-enabling must be done with empty indexes and data anyway. Otherwise,
the indexes would need to be repaired, wich HEAP is not capable of.
MyISAM: Only the key_map is cleared and set.
Re-enabling must be done with empty indexes and data. Otherwise, repair needs
to be done which will enable all keys persistently.
The former implementation disabled only non-unique keys and maked this persistent.
The new implementation additionally can disable all keys, but only without
making this persistent. Re-enabling all keys can be done without repair,
if data file and indexes are empty.
|
| |
|
|
|
|
| |
Don't read character set files if we are using only the default charset. In most cases the user will not anymore get a warning about missing character set files
Compare strings with space extend instead of space strip. Now the following comparisons holds: "a" == "a " and "a\t" < "a". (Bug #3152).
Note: Because of the above fix, one has to do a REPAIR on any table that has an ascii character < 32 last in a CHAR/VARCHAR/TEXT columns.
|
| | |
|
| | |
|
| | |
|
| |
|
|
|
|
|
| |
Added more DBUG statements
Ensure that we are comparing end space with BINARY strings
Use 'any_db' instead of '' to mean any database. (For HANDLER command)
Only strip ' ' when comparing CHAR, not other space-like characters (like \t)
|
| |\ |
|
| | |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| | |
when we open the HEAP table for the first time since server restart,
in hp_open(), we set a flag to propagate this info to the handler level
which then writes a DELETE FROM this_heap_table to the binlog.
It is not a perfect solution for the bug, because between the server start and
the first open of the table, the slave still had old data in his table so
a SELECT on the slave may show wrong content. But if there is a --init-file
to populate the HEAP table on master as startup, then this is a safe fix
(I'll put a note about init-file in the HEAP section of the manual).
|
| | | |
|
| | |
| |
| |
| |
| |
| |
| | |
dump on windows)
Signed auto_increment keys for HASH tables (like for MyISAM tables in 4.0)
nitialize system_charset_info() early. Fixes core dump when starting windows service
|
| | |
| |
| |
| | |
Fixed compiler warnings (IRIX C compiler and VC++)
|
| |\ \ |
|
| | | | |
|
| |\ \ \
| |/ /
|/| /
| |/ |
|
| | | |
|
| | |
| |
| |
| | |
columns.
|
| | |
| |
| |
| |
| | |
Use server character set if --default-character-set is not used
Added convert_string() for more efficient alloc+character-set convert of strings
|
| | |
| |
| |
| |
| |
| |
| |
| |
| |
| | |
CREATE TABLE t1 (s1 CHAR(5) CHARACTER SET latin1 COLLATE latin1_german2_ci);
INSERT INTO t1 VALUES ('Ü');
INSERT INTO t1 VALUES ('ue');
SELECT DISTINCT s1 FROM t1;
The above returned two rows in error.
Now it returns one row, in latin1_german2_ci: Ü == ue
|
| | | |
|
| | | |
|
| | |
| |
| |
| | |
Some system_charset_info were removed
|
| | |
| |
| |
| | |
Don't define crc32 if we are not linking with gzip
|
| | |
| |
| |
| | |
Some changes to the prepared statement protocol to make it easier to use and faster.
|
| | |
| |
| |
| | |
Added THD to add_to_xxx_list() functions for faster parsing.
|
| |\ \
| |/ |
|
| | |
| |
| |
| |
| |
| |
| | |
New (simpler) internal timestamp handling.
More debuging to heap tables.
Small cleanups to multi-table-delete
false -> 0 and true -> 1 (We should use TRUE and FALSE)
|
| | |
| |
| |
| |
| | |
(This caused the DISTINCT test to fail)
Removed one inline as this caused compiler problems
|
| | | |
|
| | | |
|
| | | |
|
| |\ \
| |/
|/| |
|
| | |\ |
|
| | | |\ |
|
| | | | | |
|
| | |\ \ \
| | | | |
| | | | |
| | | | | |
into serg.mysql.com:/usr/home/serg/Abk/mysql-4.1
|
| | | | |/
| | |/| |
|
| | |\ \ \
| | |/ / |
|
| | | | | |
|
