~drizzle-trunk/drizzle/development : changes

~drizzle-trunk/drizzle/development » Changes from revision 1701.2.2

From Revision 1701.2.2 to 1684

Rev	Summary	Authors	Date
1701.2.2	fix query plan results fro bug lp611379 fix query plan results fro bug lp611379	Stewart Smith	14 years ago
1701.2.1	bug lp:611379 Equivalent queries with Impossible where retur... bug lp:611379 Equivalent queries with Impossible where return different results The following two equivalent queries return different results in maria 5.2 and 5.3 (and identical results in mysql 5.5.5) : SELECT SUM( DISTINCT table1 .`pk` ) FROM B table1 STRAIGHT_JOIN ( BB table2 JOIN CC ON table2 .`col_varchar_key` ) ON table2 .`pk` ; SELECT * FROM ( SELECT SUM( DISTINCT table1 .`pk` ) FROM B table1 STRAIGHT_JOIN ( BB table2 JOIN CC ON table2 .`col_varchar_key` ) ON table2 .`pk` ); MariaDB returns 0 on the second query and NULL on the first, whereas MySQL returns NULL on both. In MariaDB, both EXPLAIN plans agree that "Impossible WHERE noticed after reading const tables" We have some slightly different output in drizzle: main.bug_lp611379 [ fail ] drizzletest: At line 9: query 'explain select * from (select sum(distinct t1.a) from t1,t2 where t1.a=t2.a) as t' failed: 1048: Column 'sum(distinct t1.a)' cannot be null but the fix gets us the correct query results, although with slightly different execution plans. This fix is directly ported from MariaDB.	Stewart Smith	14 years ago
1701	Merge in Stewart's FK work Merge in Stewart's FK work	Brian Aker	14 years ago
1700	Merge from staging. Merge from staging.	Brian Aker	14 years ago
1699	Merge Joe -remove the increment wrapper calls in my_pthread.... Merge Joe -remove the increment wrapper calls in my_pthread.h	lbieber	14 years ago
1698	Merge in Monty. Merge in Monty.	Brian Aker	14 years ago
1697	Merge in heap conversion, and case insensitive patch, and re... Merge in heap conversion, and case insensitive patch, and remove need for M_HASH in session.	Brian Aker	14 years ago
1696	Merge, includes encapsulation of LOCK_xid_cache, and some of... Merge, includes encapsulation of LOCK_xid_cache, and some of the thr derived locks.	Brian Aker	14 years ago
1695	Merge Stewart - recent patch didn't have updated result file... Merge Stewart - recent patch didn't have updated result files for embedded_innodb when the handling of default values was fixed in the table proto Merge Joe Daly - use boost::shared_mutex for locking	lbieber	14 years ago
1694	Merge of Lee. Merge of Lee.	Brian Aker	14 years ago
1693	Rollup of boost mutex, plus fix for unlock(). Rollup of boost mutex, plus fix for unlock().	Brian Aker	14 years ago
1692	Merge Shrews - fix incorrect cast of unsigned to signed Merge Shrews - fix incorrect cast of unsigned to signed	lbieber	14 years ago
1691	Merge Brian - Convert LOCK_global_system_variables to boost Merge Brian - Convert LOCK_global_system_variables to boost	lbieber	14 years ago
1690	Merge VJ changes for transaction log testing and Merge Stewa... Merge VJ changes for transaction log testing and Merge Stewart - valgrind fix for one of the embedded_innodb parameters	lbieber	14 years ago
1689	Merge Build (rollup) Merge Build (rollup)	Brian Aker	14 years ago
1688	Rollup of Embedded, resolve_stack_dump, boost LIB in include... Rollup of Embedded, resolve_stack_dump, boost LIB in include, Archive refactoring.	Brian Aker	14 years ago
1687	Merge Brian - custom lock encapsulation, and myisam lock rem... Merge Brian - custom lock encapsulation, and myisam lock removel code	lbieber	14 years ago
1686	Merge Stewart's branch which now runs all the drizzleslap te... Merge Stewart's branch which now runs all the drizzleslap tests for embedded innodb and Merge Monty's branch which has VJ's branches merged up without the POTFILES.in changes	lbieber	14 years ago
1685	Merge Stewart. Merge Stewart.	Brian Aker	14 years ago
1684	Removes LOCK_system_variables_hash, one goto, drops internal... Removes LOCK_system_variables_hash, one goto, drops internall new for std new (so possible performance regression), fixes bug where Session was not unlocked correctly.	Brian Aker	14 years ago

Older »