- 20 Apr, 2006 1 commit
-
-
unknown authored
The SQL standard doesn't allow to use in HAVING clause fields that are not present in GROUP BY clause and not under any aggregate function in the HAVING clause. However, mysql allows using such fields. This extension assume that the non-grouping fields will have the same group-wise values. Otherwise, the result will be unpredictable. This extension allowed in strict MODE_ONLY_FULL_GROUP_BY sql mode results in misunderstanding of HAVING capabilities. The new error message ER_NON_GROUPING_FIELD_USED message is added. It says "non-grouping field '%-.64s' is used in %-.64s clause". This message is supposed to be used for reporting errors when some field is not found in the GROUP BY clause but have to be present there. Use cases for this message are this bug and when a field is present in a SELECT item list not under any aggregate function and there is GROUP BY clause present which doesn't mention that field. It renders the ER_WRONG_FIELD_WITH_GROUP error message obsolete as being more descriptive. The resolve_ref_in_select_and_group() function now reports the ER_NON_GROUPING_FIELD_FOUND error if the strict mode is set and the field for HAVING clause is found in the SELECT item list only. sql/share/errmsg.txt: Added the new ER_NON_GROUPING_FIELD_USED error message for the bug#14169. mysql-test/t/having.test: Added test case for the bug#18739: non-standard HAVING extension was allowed in strict ANSI sql mode. mysql-test/r/having.result: Added test case for the bug#18739: non-standard HAVING extension was allowed in strict ANSI sql mode. sql/sql_select.cc: Added TODO comment to change the ER_WRONG_FIELD_WITH_GROUP to more detailed ER_NON_GROUPING_FIELD_USED message. sql/item.cc: Fixed bug#18739: non-standard HAVING extension was allowed in strict ANSI sql mode. The resolve_ref_in_select_and_group() function now reports the ER_NON_GROUPING_FIELD_FOUND error if the strict MODE_ONLY_FULL_GROUP_BY mode is set and the field for HAVING clause is found in the SELECT item list only.
-
- 11 Apr, 2006 8 commits
-
-
unknown authored
into mysql.com:/usr/home/ram/work/5.0.b14360
-
unknown authored
into mysql.com:/home/alexi/bugs/mysql-5.0-merge sql/sql_insert.cc: Auto merged
-
unknown authored
into mysql.com:/usr/home/ram/work/5.0.b14360
-
unknown authored
mysql-test/r/innodb.result: Fix for bug #14360: Date Between Interval Broken. - test case. mysql-test/t/innodb.test: Fix for bug #14360: Date Between Interval Broken. - test case. sql/item_timefunc.cc: Fix for bug #14360: Date Between Interval Broken. - Item_date_add_interval::eq() introduced. sql/item_timefunc.h: Fix for bug #14360: Date Between Interval Broken. - Item_date_add_interval::eq() introduced.
-
unknown authored
into mysql.com:/home/mydev/mysql-5.0-bug5390
-
unknown authored
Add surrounding braces, move invalidate dictionary_cace to after declaration of variable "table_list"
-
unknown authored
into neptunus.(none):/home/msvensson/mysql/mysql-5.0 mysql-test/mysql-test-run.pl: Auto merged sql/ha_ndbcluster.cc: Auto merged
-
unknown authored
into mysql.com:/home/mydev/mysql-5.0-bug5390
-
- 10 Apr, 2006 20 commits
-
-
unknown authored
into mysql.com:/home/jimw/my/mysql-5.0-clean
-
unknown authored
into mysql.com:/home/jimw/my/mysql-5.0-clean sql/field.cc: Auto merged sql/field.h: Auto merged sql/ha_ndbcluster.cc: Auto merged
-
unknown authored
-
unknown authored
into rurik.mysql.com:/home/igor/dev/mysql-5.0-0
-
unknown authored
into mysql.com:/home/mydev/mysql-5.0-bug5390
-
unknown authored
into mysql.com:/usr/local/mysql/mysql-5.0-tmp
-
unknown authored
into mysql.com:/home/alexi/bugs/mysql-5.0-15868-work
-
unknown authored
-
unknown authored
into mysql.com:/home/jimw/my/mysql-5.0-clean
-
unknown authored
into mysql.com:/usr/local/mysql/mysql-5.0-tmp
-
unknown authored
into mysql.com:/home/mydev/mysql-5.0-bug5390
-
unknown authored
into mysql.com:/usr/local/mysql/mysql-5.0-tmp mysql-test/mysql-test-run.pl: Manual merge
-
unknown authored
into mysql.com:/home/alexi/bugs/mysql-5.0-15868
-
unknown authored
Applied changes due Heikki Tuuri. sql/mysqld.cc: Set innodb_thread_concurrency default value to 8 (Bug#15868). Changes due to Heikki Tuuri.
-
unknown authored
into neptunus.(none):/home/msvensson/mysql/mysql-5.0 libmysql/Makefile.shared: Auto merged
-
unknown authored
- Grab the path from "configure --sysconfdir=<path>" and set it as the first place to look for my.cnf files Do this both in Makefiles for libmysql and mysys - Patch provided by Francesco Riosa. Thank you! libmysql/Makefile.shared: Grab the path from "--sysconfdir=<path>" into the defined variable DEFAULT_SYSYCONFDIR mysys/Makefile.am: Grab the path from "--sysconfdir=<path>" into the defined variable DEFAULT_SYSYCONFDIR mysys/default.c: Use DEFAULT_SYSCONFDIR as first place to look for my.cnf file if "--sysconfdir=<path>" been specified as argument to configure
-
unknown authored
into perch.ndb.mysql.com:/home/jonas/src/mysql-5.0
-
unknown authored
-
unknown authored
into perch.ndb.mysql.com:/home/jonas/src/mysql-5.0 ndb/src/kernel/blocks/dbdih/DbdihMain.cpp: Auto merged
-
unknown authored
into perch.ndb.mysql.com:/home/jonas/src/mysql-5.0
-
- 09 Apr, 2006 4 commits
-
-
unknown authored
into dl145k.mysql.com:/tmp/andrei/5.0.21-bug17284-temp_table
-
unknown authored
into mysql.com:/home/alexi/bugs/mysql-5.0-15758
-
unknown authored
env variable name is fixed. mysql-test/include/get_binlog_dump_thread_id.inc: Fixing to right env $var name. mysql-test/r/rpl_temporary.result: results
-
unknown authored
into mysql.com:/users/lthalmann/bk/mysql-5.0
-
- 08 Apr, 2006 3 commits
-
-
unknown authored
-
unknown authored
The function agg_cmp_type in item_cmpfunc.cc neglected the fact that the first argument in a BETWEEN/IN predicate could be a field of a view. As a result in the case when the retrieved table was hidden by a view over it and the arguments in the BETWEEN/IN predicates are of the date/time type the function did not perform conversion of the constant arguments to the same format as the first field argument. If formats of the arguments differed it caused wrong a evaluation of the predicates. mysql-test/r/view.result: Added a test case for bug #16069. mysql-test/t/view.test: Added a test case for bug #16069.
-
unknown authored
Removing the problematic line from include test file. mysql-test/include/get_binlog_dump_thread_id.inc: replacing replace_result by disable_query_log mysql-test/r/rpl_temporary.result: results
-
- 07 Apr, 2006 4 commits
-
-
unknown authored
into dl145j.mysql.com:/tmp/5.0.21-bug17284-temp_table
-
unknown authored
into rurik.mysql.com:/home/igor/mysql-5.0
-
unknown authored
innobase_query_caching_of_table_permitted()". Applied the patch due to Heikki Tuuri. Also removed superfluous #ifdefs. sql/sql_cache.cc: Applied the patch due to Heikki Tuuri. Query_cache::store_query(): Make InnoDB to release the adaptive hash index latch before MySQL acquires the query cache mutex. sql/sql_class.cc: Removing superfluous #ifdefs (suggested by Sanja, also discussed with Serg). sql/sql_cursor.cc: Removing superfluous #ifdefs (suggested by Sanja, also discussed with Serg).
-
unknown authored
into mysql.com:/M50/mtr-5.0
-