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 ()