~drizzle-trunk/drizzle/development : changes

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

From Revision 873.1.8 to 862

Rev	Summary	Authors	Date
873.1.8	Fixes Arg_comparator::can_compare_as_dates to never, ever al... Fixes Arg_comparator::can_compare_as_dates to never, ever allow bad input data in comparisons. No more implicit conversions from bad datetimes are allowed. We throw an error on bad input always. In addition, fixes the Field_date class's store() methods for integer types and corrects test cases that were allowing bad input.	Jay Pipes	15 years ago
873.1.7	Fixes Field_datetime::store(NUMBER) to throw an error when i... Fixes Field_datetime::store(NUMBER) to throw an error when invalid date time numbers are passed through. This fix illuminated a bug in the optimizer, where the following: CREATE TABLE t1 (d datetime NOT NULL); SELECT * FROM t1 WHERE d IS NULL; was producing an incorrect query plan. The reason is because the optimizer was incorrectly reducing an Item_func_isnull to an Item_int with a value of 0. In MySQL, the optimizer compares datetimes as integers, and just in the optimizer, ignores bad datetimes so that it can do this comparison. Unfortunately for MySQL, what this means is that the optimizer cannot optimize away the above IS NULL condition because it converts the NULL to a 0000-00-00 00:00:00. Drizzle's optimizer now shows an impossible WHERE reduction in the explain output for the above query, which is optimal. Also fixed an assert that was occurring in mysql_alter_table because that function called fix_fields() which ignores data truncation errors improperly and mysql_alter_table ignores the errors as well, which led to an assertion failure in Diagnostics_area::send_ok_status() because mysql_alter_table() assumes that all errors would be logged as only warnings from Field::store(). Also contained in this patch is corrections for invalid numeric datetime input for all test cases affected.	Jay Pipes	15 years ago
873.1.6	More shadowing fixes. Good buddy Solaris is fixing improper More shadowing fixes. Good buddy Solaris is fixing improper virtuality in subclasses. Nice. :)	Jay Pipes	15 years ago
873.1.5	Additional fixes for shadowing warnings on Solaris. Apply v... Additional fixes for shadowing warnings on Solaris. Apply virtual overloads on operators in Temporal subclasses.	Jay Pipes	15 years ago
873.1.4	Solaris integer truncation fixes - Thanks to MontyT for the ... Solaris integer truncation fixes - Thanks to MontyT for the warning output.. :)	Jay Pipes	15 years ago
873.1.3	Fixed PCRE header and include order. Fixed PCRE header and include order.	Jay Pipes	15 years ago
873.1.2	Fixed Field_datetime to never accept any bad datetimes as a ... Fixed Field_datetime to never accept any bad datetimes as a string. This broke dozen or so test cases of course, which are riddled with 0000-00-00 00:00:00 crap. Also, probably against my better judgment, I added the ability to match a string in the following datetime expression: YY-MM-DD HH:mm:SS I say against my better judgment because it looks similar to the ISO 8601:1988 standard format specifier, but is NOT since ISO always expects a 4-digit year. But, to be compatible with MySQL...	Jay Pipes	15 years ago
873.1.1	Fixes the Field_date class to not allow any invalid input at Fixes the Field_date class to not allow any invalid input at any time. This, quite expectedly, broken about 20 test cases, so this patches up those cases as well.	Jay Pipes	15 years ago
873	Solaris performanc fix. Solaris performanc fix.	Brian Aker	15 years ago
872	Remove thr_alarm Remove thr_alarm	Brian Aker	15 years ago
871	Merge Monty Merge Monty	Brian Aker	15 years ago
870	Merging Stewart. Merging Stewart.	Brian Aker	15 years ago
869	Fix concurrency issue (remove dead variables) Fix concurrency issue (remove dead variables)	Brian Aker	15 years ago
868	Adding Multi-threaded Scheduler into the system. Adding Multi-threaded Scheduler into the system.	Brian Aker	15 years ago
867	Remove dead options. Remove dead options.	Brian Aker	15 years ago
866	Remove un-needed depth (real simple.. working on adding back... Remove un-needed depth (real simple.. working on adding back other scheduler).	Brian Aker	15 years ago
865	Mrge from Monty Mrge from Monty	Brian Aker	15 years ago
864	Merge Stewart. Merge Stewart.	Brian Aker	15 years ago
863	Fix for weird lock/unlock on broadcast. Fix for weird lock/unlock on broadcast.	Brian Aker	15 years ago
862	Remove charset directory code. Remove charset directory code.	Brian Aker	15 years ago

Older »