- 16 Jun, 2005 1 commit
-
-
unknown authored
Exclude the query that generates warning from PS tests, due to extra warning under PS.
-
- 15 Jun, 2005 7 commits
-
-
unknown authored
into rurik.mysql.com:/home/igor/dev/mysql-5.0-0 sql/sql_select.cc: Auto merged
-
unknown authored
into poseidon.ndb.mysql.com:/home/tomas/mysql-5.0
-
unknown authored
-
unknown authored
Added a test case for bug #11285. sql_select.cc: Fixed bug #11285. The problem occurred with Item_equal in an 'on expression' that was evaluated to false. sql/sql_select.cc: Fixed bug #11285. The problem occurred with Item_equal in an 'on expression' that was evaluated to false. mysql-test/t/join_outer.test: Added a test case for bug #11285. mysql-test/r/join_outer.result: Added a test case for bug #11285.
-
unknown authored
into mysql.com:/home/timka/mysql/src/5.0-dbg
-
unknown authored
-
unknown authored
When the GROUP BY clause contains a column reference that can be resolved to both an aliased column in the SELECT list, and to a column in the FROM clause, the group column is resolved to the column in the FROM clause (for ANSI conformance). However, it may be so that the user's intent is just the other way around, and he/she gets the query results grouped by a completely different column than expexted. This patch adds a warning in such cases that tells the user that there is potential ambiguity in the group column. sql/sql_select.cc - Added a warning when a GROUP column is ambiguous due to that there is a column reference with the same name both in the SELECT and FROM clauses. In this case we resolve to the column in FROM clause and warn the user of a possible ambiguity. - More extensive comments. - Changed the function to return bool instead of int (as in other places). mysql-test/t/group_by.test Added test for BUG#11211. mysql-test/r/group_by.result Added test for BUG#11211. mysql-test/r/group_by.result: Import patch 11211.diff mysql-test/t/group_by.test: Import patch 11211.diff sql/sql_select.cc: Import patch 11211.diff BitKeeper/etc/ignore: Added ndb/src/dummy.cpp to the ignore list mysql-test/r/alias.result: Added warning for potentially ambiguous column. mysql-test/r/having.result: Added warning for potentially ambiguous column.
-
- 14 Jun, 2005 20 commits
-
-
unknown authored
into mysql.com:/home/cps/mysql/trees/mysql-5.0
-
unknown authored
sql/item.h: revrited as recursive sql/sql_select.cc: real_type is virtual tests/mysql_client_test.c: check results abd delete views
-
unknown authored
into sanja.is.com.ua:/home/bell/mysql/bk/work-bug3-5.0
-
unknown authored
into moonbone.local:/work/mysql-5.0-bug-11111
-
unknown authored
Wrong method for creating temporary field was choosen, which results in sending int field with int header but lonlong data. Test case is added to mysql_client_test.c because client library is required to test the bug. tests/mysql_client_test.c: Test case for bug#11111 "fetch from view returns wrong data" sql/sql_select.cc: Fix bug #11111 "fetch from view returns wrong data" sql/item.h: Fix bug #11111 "fetch from view returns wrong data"
-
unknown authored
-
unknown authored
mysql-test/r/query_cache.result: testing cursors in SP with QC testing suspicious but working using selects in function with QC mysql-test/t/query_cache.test: testing cursors in SP with QC testing suspicious but working using selects in function with QC sql/sp_head.h: method for prohibiting of QC using SP query sql/sp_rcontext.cc: prohibit opening Query cache for SP cursors sql/sp_rcontext.h: constructor moved to .cc file to be able to use methods from lex_keeper
-
unknown authored
sql/item.cc: it's safer not to reassign arg member
-
unknown authored
server-tools/instance-manager/commands.cc: Send an empty string in the option_value column, if no option value is given
-
unknown authored
into deer.(none):/home/hf/work/mysql-5.0.clean
-
unknown authored
mysql-test/r/func_default.result: test result fixed mysql-test/t/func_default.test: test case fixed
-
unknown authored
mysql-test/t/func_default.test: test result fixed sql/item.cc: code simplified using real_item() method, error returning added
-
unknown authored
into mysql.com:/home/timka/mysql/src/5.0-bug-11044
-
unknown authored
into neptunus.(none):/home/msvensson/mysql/mysql-5.0-tmp
-
unknown authored
into mysql.com:/home/timka/mysql/src/5.0-bug-11044
-
unknown authored
The problem was that when there was no MIN or MAX function, after finding the group prefix based on the DISTINCT or GROUP BY attributes we did not search further for a key in the group that satisfies the equi-join conditions on attributes that follow the group attributes. Thus we ended up with the wrong rows, and subsequent calls to select_cond->val_int() in evaluate_join_record() were filtering those rows. Hence - the query result set was empty. The problem occured both for GROUP BY queries without MIN/MAX and for queries with DISTINCT (which were internally executed as GROUP BY queries). mysql-test/r/group_min_max.result: Added test result for BUG#11044. Notice that the group by query is equivalent to the distinct query and both are executed via the same algorithm. mysql-test/t/group_min_max.test: Added test for BUG#11044. Notice that the group by query is equivalent to the distinct query and both are executed via the same algorithm. sql/opt_range.cc: * Use the extended prefix in QUICK_GROUP_MIN_MAX_SELECT::get_next() to find keys that satisfy equality conditions in the case when there is no MIN or MAX function. * Corrected some method comments. * Corrected debug printout of cost information.
-
unknown authored
into mysql.com:/usr/home/ram/work/mysql-5.0
-
unknown authored
sql/item_func.cc: a fix (#11235: Expression with IFNULL yields 18 where 1 is correct). We should pass res end pointer to the strtoll10().
-
unknown authored
into rurik.mysql.com:/home/igor/mysql-5.0 mysql-test/r/func_if.result: Auto merged mysql-test/t/func_if.test: Auto merged sql/item_cmpfunc.cc: Auto merged
-
unknown authored
-
- 13 Jun, 2005 12 commits
-
-
unknown authored
BitKeeper/etc/logging_ok: auto-union ndb/src/kernel/blocks/dbtc/DbtcMain.cpp: Auto merged sql/item_cmpfunc.cc: Auto merged
-
unknown authored
into dl145c.mysql.com:/home/ndbdev/tomas/mysql-4.1
-
unknown authored
sql/item_cmpfunc.cc: Auto merged mysql-test/r/func_if.result: Manual merge.
-
unknown authored
into dl145c.mysql.com:/home/ndbdev/tomas/mysql-4.1 BitKeeper/etc/logging_ok: auto-union
-
unknown authored
Correction for test case of bug #11142. mysql-test/t/func_if.test: Correction for test case of bug #11142. mysql-test/r/func_if.result: Correction for test case of bug #11142.
-
unknown authored
Added a test case for bug #11142. item_cmpfunc.cc: Fixed bug #11142. Implementation of Item_func_nullif::is_null was corrected. sql/item_cmpfunc.cc: Fixed bug #11142. Implementation of Item_func_nullif::is_null was corrected. mysql-test/t/func_if.test: Added a test case for bug #11142. mysql-test/r/func_if.result: Added a test case for bug #11142.
-
unknown authored
Logging to logging@openlogging.org accepted DbtcMain.cpp, testTimeout.cpp: Bug #11290 TransactionInactiveTimeout = 0 does not result in infinite timeout ndb/test/ndbapi/testTimeout.cpp: Bug #11290 TransactionInactiveTimeout = 0 does not result in infinite timeout ndb/src/kernel/blocks/dbtc/DbtcMain.cpp: Bug #11290 TransactionInactiveTimeout = 0 does not result in infinite timeout BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
-
unknown authored
into igor-inspiron.creware.com:/home/igor/mysql-5.0
-
unknown authored
into igor-inspiron.creware.com:/home/igor/dev/mysql-4.1-0
-
unknown authored
Add a patch by Georg Richter to remove compiler warnings on 64-bit Windows sql/ha_innodb.cc: Add a patch by Georg Richter to remove compiler warnings on 64-bit Windows
-
unknown authored
into mysql.com:/home/svoj/devel/yassl-mysql-5.0
-
unknown authored
into igor-inspiron.creware.com:/home/igor/dev/mysql-5.0-0 BitKeeper/etc/logging_ok: auto-union mysql-test/r/ctype_utf8.result: Auto merged sql/sql_select.cc: Auto merged
-