DECIMAL is also affected:
mysqld: decimal.c:1459: decimal_bin_size: Assertion `scale >= 0 && precision > 0 && scale <= precision' failed.
# 2011-05-07T11:19:31 #8 0x006b0d98 in __assert_fail () from /lib/libc.so.6 # 2011-05-07T11:19:31 #9 0x087ba573 in decimal_bin_size (precision=0, scale=0) at decimal.c:1459 # 2011-05-07T11:19:31 #10 0x08758cf0 in dynamic_column_value_len (value=0xb6c95dd0) at ma_dyncol.c:334 # 2011-05-07T11:19:31 #11 0x0875a0e3 in dynamic_column_create_many_internal (str=0x915d8a94, column_count=2, column_numbers=0xb6c95e48, values=0xb6c95dd0, new_str=1 '\001') # 2011-05-07T11:19:31 at ma_dyncol.c:1116 # 2011-05-07T11:19:31 #12 0x0875a1da in dynamic_column_create_many (str=0x915d8a94, column_count=2, column_numbers=0xb6c95e48, values=0xb6c95dd0) at ma_dyncol.c:1156 # 2011-05-07T11:19:31 #13 0x082208e7 in Item_func_dyncol_create::val_str (this=0xb6c95038, str=0x915d8f50) at item_strfunc.cc:3640 # 2011-05-07T11:19:31 #14 0x08220d0f in Item_func_dyncol_add::val_str (this=0xb6c95640, str=0x915d8f50) at item_strfunc.cc:3733 # 2011-05-07T11:19:31 #15 0x08220d0f in Item_func_dyncol_add::val_str (this=0xb6c95810, str=0x915d8f50) at item_strfunc.cc:3733 # 2011-05-07T11:19:31 #16 0x081d0de7 in Item::send (this=0xb6c95810, protocol=0xa9f7ef8, buffer=0x915d8f50) at item.cc:5783 # 2011-05-07T11:19:31 #17 0x08277910 in select_send::send_data (this=0xb6c95ce0, items=...) at sql_class.cc:1918 # 2011-05-07T11:19:31 #18 0x08330e0f in end_send (join=0xb6c10ad0, join_tab=0xb6c8d9ac, end_of_records=false) at sql_select.cc:14934 # 2011-05-07T11:19:31 #19 0x0832f312 in evaluate_join_record (join=0xb6c10ad0, join_tab=0xb6c8d7c8, error=0) at sql_select.cc:14160 # 2011-05-07T11:19:31 #20 0x0832eded in sub_select (join=0xb6c10ad0, join_tab=0xb6c8d7c8, end_of_records=false) at sql_select.cc:14005 # 2011-05-07T11:19:31 #21 0x0832e077 in do_select (join=0xb6c10ad0, fields=0xa9f9618, table=0x0, procedure=0x0) at sql_select.cc:13500 # 2011-05-07T11:19:31 #22 0x083148e2 in JOIN::exec (this=0xb6c10ad0) at sql_select.cc:2482 # 2011-05-07T11:19:31 #23 0x083150fe in mysql_select (thd=0xa9f7be8, rref_pointer_array=0xa9f9688, tables=0xb6c95a60, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, # 2011-05-07T11:19:31 group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xb6c95ce0, unit=0xa9f92e8, select_lex=0xa9f9584) at sql_select.cc:2701 # 2011-05-07T11:19:31 #24 0x0830d95b in handle_select (thd=0xa9f7be8, lex=0xa9f928c, result=0xb6c95ce0, setup_tables_done_option=0) at sql_select.cc:282 # 2011-05-07T11:19:31 #25 0x082aa308 in execute_sqlcom_select (thd=0xa9f7be8, all_tables=0xb6c95a60) at sql_parse.cc:5094 # 2011-05-07T11:19:31 #26 0x082a1152 in mysql_execute_command (thd=0xa9f7be8) at sql_parse.cc:2239 # 2011-05-07T11:19:31 #27 0x082ac8ab in mysql_parse (thd=0xa9f7be8, # 2011-05-07T11:19:31 rawbuf=0xb6c93ee0 "SELECT COLUMN_DELETE( COLUMN_ADD( COLUMN_CREATE( 12 , COLUMN_GET( COLUMN_ADD( `col_blob_key` , 238 , 7 AS INTEGER , 163 , 'k' AS DECIMAL , 172 , COLUMN_GET( `col_blob_key` , 133 AS INTEGER ) ) , 9 AS DECIMAL( 5 ) ) , 6 , 'u' AS DATETIME ) , 205 , 'vuwliqnpkluwlaizqgwmmnibdtbocflfpqxifusfzucaglaejzptamlgqwpzfavbhcrgbxsxpdrqavttjqmhzwbmihuxjroqmvhuhvlhcmkvajfmqyeuhljesnpqlugmltmgbbdbcamfsfqkstjpsxxlqekimptsfvqetpcztmpaaxcfftfdoljrxllkumvaaotyojfhfsztmjgyhtchvpzeydpuagsgxclzoaiycqpyfpygnxcavbgpuexceaywrqkereqycjobzyjghfnbrxursxmrxbvcgtindhfjcmieoloduhpdhwikafsorkymhtpzpgwnljiehjggrecupholtruimnwxvqjstxluhsqoggimeblnptkgcxqgntuatqqckrekmvfyhhotcgwhbmqdsbbylifzaghjpyswbeyqacxtejduuafjppgmdsdgmthaygcmrbpysvgsnnbkvpbqmzrmnhmcarjjoqzoixdm' , 160 , 'b' AS DECIMAL( 7 , 2 ) ) , 9 ) FROM `table0_myisam_int_autoinc`", length=814, found_semicolon=0x915da228) at sql_parse.cc:6094 # 2011-05-07T11:19:31 #28 0x0829eddb in dispatch_command (command=COM_QUERY, thd=0xa9f7be8, packet=0xa9fa0b9 "", packet_length=814) at sql_parse.cc:1215 # 2011-05-07T11:19:31 #29 0x0829e239 in do_command (thd=0xa9f7be8) at sql_parse.cc:904 # 2011-05-07T11:19:31 #30 0x0829b2ec in handle_one_connection (arg=0xa9f7be8) at sql_connect.cc:1154 # 2011-05-07T11:19:31 #31 0x00821919 in start_thread () from /lib/libpthread.so.0 # 2011-05-07T11:19:31 #32 0x0076acce in clone () from /lib/libc.so.6 # 2011-05-07T11:19:31 #5 0x00ff0424 in __kernel_vsyscall ()
DECIMAL is also affected:
mysqld: decimal.c:1459: decimal_bin_size: Assertion `scale >= 0 && precision > 0 && scale <= precision' failed.
# 2011-05-07T11:19:31 #8 0x006b0d98 in __assert_fail () from /lib/libc.so.6 column_ value_len (value=0xb6c95dd0) at ma_dyncol.c:334 column_ create_ many_internal (str=0x915d8a94, column_count=2, column_ numbers= 0xb6c95e48, values=0xb6c95dd0, new_str=1 '\001') column_ create_ many (str=0x915d8a94, column_count=2, column_ numbers= 0xb6c95e48, values=0xb6c95dd0) at ma_dyncol.c:1156 dyncol_ create: :val_str (this=0xb6c95038, str=0x915d8f50) at item_strfunc. cc:3640 dyncol_ add::val_ str (this=0xb6c95640, str=0x915d8f50) at item_strfunc. cc:3733 dyncol_ add::val_ str (this=0xb6c95810, str=0x915d8f50) at item_strfunc. cc:3733 send::send_ data (this=0xb6c95ce0, items=...) at sql_class.cc:1918 0xb6c8d9ac, end_of_ records= false) at sql_select.cc:14934 join_record (join=0xb6c10ad0, join_tab= 0xb6c8d7c8, error=0) at sql_select.cc:14160 0xb6c8d7c8, end_of_ records= false) at sql_select.cc:14005 array=0xa9f9688 , tables=0xb6c95a60, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, options= 2147764736, result=0xb6c95ce0, unit=0xa9f92e8, select_ lex=0xa9f9584) at sql_select.cc:2701 done_option= 0) at sql_select.cc:282 sqlcom_ select (thd=0xa9f7be8, all_tables= 0xb6c95a60) at sql_parse.cc:5094 command (thd=0xa9f7be8) at sql_parse.cc:2239 izqgwmmnibdtboc flfpqxifusfzuca glaejzptamlgqwp zfavbhcrgbxsxpd rqavttjqmhzwbmi huxjroqmvhuhvlh cmkvajfmqyeuhlj esnpqlugmltmgbb dbcamfsfqkstjps xxlqekimptsfvqe tpcztmpaaxcfftf doljrxllkumvaao tyojfhfsztmjgyh tchvpzeydpuagsg xclzoaiycqpyfpy gnxcavbgpuexcea ywrqkereqycjobz yjghfnbrxursxmr xbvcgtindhfjcmi eoloduhpdhwikaf sorkymhtpzpgwnl jiehjggrecuphol truimnwxvqjstxl uhsqoggimeblnpt kgcxqgntuatqqck rekmvfyhhotcgwh bmqdsbbylifzagh jpyswbeyqacxtej duuafjppgmdsdgm thaygcmrbpysvgs nnbkvpbqmzrmnhm carjjoqzoixdm' , 160 , 'b' AS DECIMAL( 7 , 2 ) ) , 9 ) FROM `table0_ myisam_ int_autoinc` ", length=814, found_semicolon =0x915da228) at sql_parse.cc:6094 one_connection (arg=0xa9f7be8) at sql_connect.cc:1154 .so.0
# 2011-05-07T11:19:31 #9 0x087ba573 in decimal_bin_size (precision=0, scale=0) at decimal.c:1459
# 2011-05-07T11:19:31 #10 0x08758cf0 in dynamic_
# 2011-05-07T11:19:31 #11 0x0875a0e3 in dynamic_
# 2011-05-07T11:19:31 at ma_dyncol.c:1116
# 2011-05-07T11:19:31 #12 0x0875a1da in dynamic_
# 2011-05-07T11:19:31 #13 0x082208e7 in Item_func_
# 2011-05-07T11:19:31 #14 0x08220d0f in Item_func_
# 2011-05-07T11:19:31 #15 0x08220d0f in Item_func_
# 2011-05-07T11:19:31 #16 0x081d0de7 in Item::send (this=0xb6c95810, protocol=0xa9f7ef8, buffer=0x915d8f50) at item.cc:5783
# 2011-05-07T11:19:31 #17 0x08277910 in select_
# 2011-05-07T11:19:31 #18 0x08330e0f in end_send (join=0xb6c10ad0, join_tab=
# 2011-05-07T11:19:31 #19 0x0832f312 in evaluate_
# 2011-05-07T11:19:31 #20 0x0832eded in sub_select (join=0xb6c10ad0, join_tab=
# 2011-05-07T11:19:31 #21 0x0832e077 in do_select (join=0xb6c10ad0, fields=0xa9f9618, table=0x0, procedure=0x0) at sql_select.cc:13500
# 2011-05-07T11:19:31 #22 0x083148e2 in JOIN::exec (this=0xb6c10ad0) at sql_select.cc:2482
# 2011-05-07T11:19:31 #23 0x083150fe in mysql_select (thd=0xa9f7be8, rref_pointer_
# 2011-05-07T11:19:31 group=0x0, having=0x0, proc_param=0x0, select_
# 2011-05-07T11:19:31 #24 0x0830d95b in handle_select (thd=0xa9f7be8, lex=0xa9f928c, result=0xb6c95ce0, setup_tables_
# 2011-05-07T11:19:31 #25 0x082aa308 in execute_
# 2011-05-07T11:19:31 #26 0x082a1152 in mysql_execute_
# 2011-05-07T11:19:31 #27 0x082ac8ab in mysql_parse (thd=0xa9f7be8,
# 2011-05-07T11:19:31 rawbuf=0xb6c93ee0 "SELECT COLUMN_DELETE( COLUMN_ADD( COLUMN_CREATE( 12 , COLUMN_GET( COLUMN_ADD( `col_blob_key` , 238 , 7 AS INTEGER , 163 , 'k' AS DECIMAL , 172 , COLUMN_GET( `col_blob_key` , 133 AS INTEGER ) ) , 9 AS DECIMAL( 5 ) ) , 6 , 'u' AS DATETIME ) , 205 , 'vuwliqnpkluwla
# 2011-05-07T11:19:31 #28 0x0829eddb in dispatch_command (command=COM_QUERY, thd=0xa9f7be8, packet=0xa9fa0b9 "", packet_length=814) at sql_parse.cc:1215
# 2011-05-07T11:19:31 #29 0x0829e239 in do_command (thd=0xa9f7be8) at sql_parse.cc:904
# 2011-05-07T11:19:31 #30 0x0829b2ec in handle_
# 2011-05-07T11:19:31 #31 0x00821919 in start_thread () from /lib/libpthread
# 2011-05-07T11:19:31 #32 0x0076acce in clone () from /lib/libc.so.6
# 2011-05-07T11:19:31 #5 0x00ff0424 in __kernel_vsyscall ()