summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/t/innodb_bug54044.test
Commit message (Collapse)AuthorAgeFilesLines
* Merge branch '5.5' into 10.0Sergei Golubchik2018-05-191-10/+0
|\
* \ Merge branch '5.5' into 10.0Sergei Golubchik2016-09-271-2/+4
|\ \ | |/
| * Merge branch 'mysql/5.5' into 5.5Sergei Golubchik2016-09-111-2/+8
| |\ | | | | | | | | | 80% reverted
| | * Bug #23280699: MYSQLD GOT SIGNAL 11 IN IS_NULL ON SELECTSreeharsha Ramanavarapu2016-07-221-6/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FROM I_S Issue: ------ There is a difference in the field type created when the following DDLs are used: 1) CREATE TABLE t0 AS SELECT NULL; 2) CREATE TABLE t0 AS SELECT GREATEST(NULL,NULL); The first statement creates field of type Field_string and the second one creates a field of type Field_null. This creates a problem when the query mentioned in this bug is used. Since the null_ptr is calculated differently for Field_null. Solution: --------- When there is a function returning null in the select list as mentioned above, the field should be of type Field_string. This was fixed in 5.6+ as part of Bug#14021323. This is a backport to mysql-5.5. An incorrect comment in innodb_bug54044.test has been corrected in all versions.
| | * Backport from trunk of:Tor Didriksen2011-08-191-3/+11
| | | | | | | | | | | | Bug#12532830 - SIGFPE OR ASSERTION (PRECISION <= ((9 * 9) - 8*2)) && (DEC <= 30)
| | * Change table name in innodb_bug54044.test to lower case to avoidJimmy Yang2010-06-291-1/+1
| | | | | | | | | | | | platform dependent diffs.
| | * Port fix for bug #54044 from mysql-5.1-security to mysql-trunk-security:Jimmy Yang2010-06-241-0/+11
| | | | | | | | | | | | | | | | | | | | ------------------------------------------------------------ revno: 3438 committer: Jimmy Yang <jimmy.yang@oracle.com> branch nick: mysql-5.1-security timestamp: Thu 2010-06-24 01:20:25 -0700 message: Fix Bug #54044 Create temporary tables and using innodb crashes.
* | MDEV-5787 Server crashes in in row_mysql_convert_row_to_innobase on CREATE ↵Sergei Golubchik2014-03-191-3/+10
| | | | | | | | | | | | .. SELECT XtraDB: don't accept MYSQL_TYPE_NULL as a column type
* | Fixes for innodb suite, merging tests from 5.6.Sergei Golubchik2013-07-151-3/+10
|/ | | | | | | | | | Includes 5.6 changesets for: ***** Fix for BUG#13489996 valgrind:conditional jump or move depends on uninitialised values-field_blob. blob_ptr_size was not initialized properly: remove this variable. ***** Bug#14021323 CRASH IN FIELD::SET_NULL WHEN INSERTING ROWS TO NEW TABLE *****
* allow suite.pm to skip combinations that originate from test/include files.Sergei Golubchik2012-02-071-0/+1
| | | | | | | storage/innobase/handler/handler0alter.cc: for NEWDATE key_type says unsigned, thus col->prtype says unsigned, but field->flags says signed. Use the same flag for value retrieval that was used for value storage.
* mysql-5.5 mergeSergei Golubchik2012-01-161-1/+5
|\
| * Backport from trunk of:Tor Didriksen2011-08-191-3/+11
| | | | | | | | | | Bug#12532830 - SIGFPE OR ASSERTION (PRECISION <= ((9 * 9) - 8*2)) && (DEC <= 30)
* | merge with 5.3Sergei Golubchik2011-10-191-3/+0
|\ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | sql/sql_insert.cc: CREATE ... IF NOT EXISTS may do nothing, but it is still not a failure. don't forget to my_ok it. ****** CREATE ... IF NOT EXISTS may do nothing, but it is still not a failure. don't forget to my_ok it. sql/sql_table.cc: small cleanup ****** small cleanup
| * \ merge with 5.1-microSergei Golubchik2011-06-071-6/+0
| |\ \
| * \ \ Merge with 5.1-microsecondsMichael Widenius2011-05-281-1/+0
| |\ \ \ | | |/ / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | A lot of small fixes and new test cases. client/mysqlbinlog.cc: Cast removed client/mysqltest.cc: Added missing DBUG_RETURN include/my_pthread.h: set_timespec_time_nsec() now only takes one argument mysql-test/t/date_formats.test: Remove --disable_ps_protocl as now also ps supports microseconds mysys/my_uuid.c: Changed to use my_interval_timer() instead of my_getsystime() mysys/waiting_threads.c: Changed to use my_hrtime() sql/field.h: Added bool special_const_compare() for fields that may convert values before compare (like year) sql/field_conv.cc: Added test to get optimal copying of identical temporal values. sql/item.cc: Return that item_int is equal if it's positive, even if unsigned flag is different. Fixed Item_cache_str::save_in_field() to have identical null check as other similar functions Added proper NULL check to Item_cache_int::save_in_field() sql/item_cmpfunc.cc: Don't call convert_constant_item() if there is nothing that is worth converting. Simplified test when years should be converted sql/item_sum.cc: Mark cache values in Item_sum_hybrid as not constants to ensure they are not replaced by other cache values in compare_datetime() sql/item_timefunc.cc: Changed sec_to_time() to take a my_decimal argument to ensure we don't loose any sub seconds. Added Item_temporal_func::get_time() (This simplifies some things) sql/mysql_priv.h: Added Lazy_string_decimal() sql/mysqld.cc: Added my_decimal constants max_seconds_for_time_type, time_second_part_factor sql/table.cc: Changed expr_arena to be of type CONVENTIONAL_EXECUTION to ensure that we don't loose any items that are created by fix_fields() sql/tztime.cc: TIME_to_gmt_sec() now sets *in_dst_time_gap in case of errors This is needed to be able to detect if timestamp is 0 storage/maria/lockman.c: Changed from my_getsystime() to set_timespec_time_nsec() storage/maria/ma_loghandler.c: Changed from my_getsystime() to my_hrtime() storage/maria/ma_recovery.c: Changed from my_getsystime() to mmicrosecond_interval_timer() storage/maria/unittest/trnman-t.c: Changed from my_getsystime() to mmicrosecond_interval_timer() storage/xtradb/handler/ha_innodb.cc: Added support for new time,datetime and timestamp unittest/mysys/thr_template.c: my_getsystime() -> my_interval_timer() unittest/mysys/waiting_threads-t.c: my_getsystime() -> my_interval_timer()
| | * | lp:743017 Diverging results with TIME(3) and ranges depending on the ↵Sergei Golubchik2011-03-291-6/+0
| |/ / | | | | | | | | | | | | | | | | | | execution plan in 5.1-micro rewrite get_innobase_type_from_mysql_type() to use types as reported by the Field objects, instead of relying on ad-hoc assumptions.
| * | Change the table name in innodb_bug54044 to lower case to avoidJimmy Yang2010-06-291-1/+1
| | | | | | | | | | | | | | | platform dependent diffs.
| * | Fix Bug #54044 Create temporary tables and using innodb crashes.Jimmy Yang2010-06-241-0/+11
| /
* | lots of post-merge changesSergei Golubchik2011-04-251-1/+0
|/
* Change table name in innodb_bug54044.test to lower case to avoidJimmy Yang2010-06-291-1/+1
| | | | | platform dependent diffs.
* Port fix for bug #54044 from mysql-5.1-security to mysql-trunk-security:Jimmy Yang2010-06-241-0/+11
------------------------------------------------------------ revno: 3438 committer: Jimmy Yang <jimmy.yang@oracle.com> branch nick: mysql-5.1-security timestamp: Thu 2010-06-24 01:20:25 -0700 message: Fix Bug #54044 Create temporary tables and using innodb crashes.
View Lorry Controller Status