- 10 Aug, 2006 1 commit
-
-
gkodinov/kgeorge@macbook.gmz authored
Treat queries with no FROM and aggregate functions as normal queries, so the aggregate function get correctly calculated as if there is 1 row. This means that they will be considered to have one row, so COUNT(*) will return 1 instead of 0. Other aggregates will behave in compatible manner.
-
- 02 Aug, 2006 1 commit
-
-
evgen@moonbone.local authored
into moonbone.local:/work/tmp_merge-4.1-opt-mysql
-
- 29 Jul, 2006 2 commits
-
-
into mysql.com:/Users/kent/mysql/bk/mysql-4.1
-
Corrected typo
-
- 28 Jul, 2006 4 commits
-
-
into mysql.com:/Users/kent/mysql/bk/mysql-4.1
-
Man page for mysqld command move to section 8 (bug#21220)
-
Man page for "mysqld" command move to section 8 (bug#21220)
-
Man page for "mysqld" command move to section 8 (bug#21220)
-
- 27 Jul, 2006 1 commit
-
-
gkodinov/kgeorge@rakia.(none) authored
into rakia.(none):/home/kgeorge/mysql/autopush/B20792-4.1-opt
-
- 26 Jul, 2006 5 commits
-
-
gkodinov/kgeorge@rakia.(none) authored
into rakia.(none):/home/kgeorge/mysql/autopush/B20792-4.1-opt
-
gkodinov/kgeorge@macbook.gmz authored
When processing aggregate functions all tables values are reset to NULLs at the end of each group. When doing that if there are no rows found for a group the const tables must not be reset as they are not recalculated by do_select()/sub_select() for each group.
-
gkodinov/kgeorge@rakia.(none) authored
into rakia.(none):/home/kgeorge/mysql/autopush/B21019-4.1-opt
-
kroki/tomash@moonlight.intranet authored
Too many cursors (more than 1024) could lead to memory corruption. This affects both, stored routines and C API cursors, and the threshold is per-server, not per-connection. Similarly, the corruption could happen when the server was under heavy load (executing more than 1024 simultaneous complex queries), and this is the reason why this bug is fixed in 4.1, which doesn't support cursors. The corruption was caused by a bug in the temporary tables code, when an attempt to create a table could lead to a write beyond allocated space. Note, that only internal tables were affected (the tables created internally by the server to resolve the query), not tables created with CREATE TEMPORARY TABLE. Another pre-condition for the bug is TRUE value of --temp-pool startup option, which, however, is a default. The cause of a bug was that random memory was overwritten in bitmap_set_next() due to out-of-bound memory access.
-
gkodinov/kgeorge@macbook.gmz authored
When optimizing conditions like 'a = <some_val> OR a IS NULL' so that they're united into a single condition on the key and checked together the server must check which value is the NULL value in a correct way : not only using ->is_null but also check if the expression doesn't depend on any tables referenced in the current statement. This additional check must be performed because that optimization takes place before the actual execution of the statement, so if the field was initialized to NULL from a previous statement the optimization would be applied incorrectly.
-
- 25 Jul, 2006 2 commits
-
-
timour/tkatchaounov@lamia.home authored
into lamia.home:/home/tkatchaounov/autopush/4.1-bug-20954
-
timour/timka@lamia.home authored
The problem was in that opt_sum_query() replaced MIN/MAX functions with the corresponding constant found in a key, but due to imprecise representation of float numbers, when evaluating the where clause, this comparison failed. When MIN/MAX optimization detects that all tables can be removed, also remove all conjuncts in a where clause that refer to these tables. As a result of this fix, these conditions are not evaluated twice, and in the case of float number comparisons we do not discard result rows due to imprecise float representation. As a side-effect this fix also corrects an unnoticed problem in bug 12882.
-
- 24 Jul, 2006 5 commits
-
-
joerg@trift2. authored
into trift2.:/M41/push-4.1
-
joerg@trift2. authored
into trift2.:/M41/push-4.1
-
msvensson@neptunus.(none) authored
- Send confusing output to /dev/null
-
into mysql.com:/Users/kent/mysql/bk/mysql-4.1-new
-
Filter out strange control characters, messes up logs
-
- 23 Jul, 2006 1 commit
-
-
into mysql.com:/usr/home/ram/work/4.1.b16327
-
- 21 Jul, 2006 1 commit
-
-
sergefp@mysql.com authored
-
- 20 Jul, 2006 2 commits
-
-
sergefp@mysql.com authored
Add implementations of Item_func_{nop,not}_all::neg_transformer
-
holyfoot/hf@mysql.com/deer.(none) authored
into mysql.com:/home/hf/work/mysql-4.1.19983
-
- 19 Jul, 2006 3 commits
-
-
igor@olga.mysql.com authored
for class Item_func_trim. For 4.1 it caused wrong output for EXPLAIN EXTENDED commands if expressions with the TRIM function of two arguments were used. For 5.0 it caused an error message when trying to select from a view with the TRIM function of two arguments. This unexpected error message was due to the fact that the print method for the class Item_func_trim was inherited from the class Item_func. Yet the TRIM function does not take a list of its arguments. Rather it takes the arguments in the form: [{BOTH | LEADING | TRAILING} [remstr] FROM] str) | [remstr FROM] str
-
msvensson@neptunus.(none) authored
- backport patch from 5.0 - "table" can be NULL in temporary fields used for type conversion
-
Added new "mysql_explain_log" man page Added missing install of "myisam_ftdump" man page Added missing install of "mysqlman" man page
-
- 18 Jul, 2006 3 commits
-
-
evgen@moonbone.local authored
into moonbone.local:/work/tmp_merge-4.1-opt-mysql
-
evgen@moonbone.local authored
into moonbone.local:/work/tmp_merge-4.1-opt-mysql
-
Please use "ul" when merging this changeset to 5.0.
-
- 17 Jul, 2006 2 commits
-
-
joerg@trift2. authored
1) When initializing a boolean variable, do not use string representations '"false"' and '"true"' but rather the boolean values 'false' and 'true'. 2) Add the module to the various Windows description files.
-
joerg@trift2. authored
In 5.0, this is already solved, so that is a null-merge ("ul").
-
- 15 Jul, 2006 1 commit
-
-
pekka@orca.ndb.mysql.com authored
into orca.ndb.mysql.com:/space_old/pekka/ndb/version/my41-1.2461
-
- 14 Jul, 2006 5 commits
-
-
kent@mysql.com/g4-2.local authored
Command "ndb_mgm" is an optional tool, and should only be in "ndb-tools" package (bug#21058)
-
joerg@trift2. authored
-
into mysql.com:/usr/home/ram/work/4.1.b15195
-
to avoid the potential security problem. (see bug #15195: Security Breach with MERGE table)
-
gkodinov/kgeorge@rakia.(none) authored
into rakia.(none):/home/kgeorge/mysql/autopush/B17212-4.1-opt
-
- 13 Jul, 2006 1 commit
-
-
holyfoot/hf@mysql.com/deer.(none) authored
into mysql.com:/home/hf/work/mysql-4.1.16017
-