Assertion `value->year <= 9999' failed in dynamic_column_date_store

[Philip Stoev]

backtrace:

#8 0x00399d98 in __assert_fail () from /lib/libc.so.6
#9 0x08759630 in dynamic_column_date_store (str=0xae89ed04, value=0xae51347c) at ma_dyncol.c:716
#10 0x087598fa in data_store (str=0xae89ed04, value=0xae513478) at ma_dyncol.c:825
#11 0x0875a021 in dynamic_new_column_store (str=0xae89ed04, header_size=3, offset_size=1, column_count=1, not_null_count=1, data_size=3,
    column_numbers=0xae5134b8, values=0xae513478, new_str=1 '\001') at ma_dyncol.c:1070
#12 0x0875a15f in dynamic_column_create_many_internal (str=0xae89ed04, column_count=1, column_numbers=0xae5134b8, values=0xae513478, new_str=1 '\001')
    at ma_dyncol.c:1128
#13 0x0875a1da in dynamic_column_create_many (str=0xae89ed04, column_count=1, column_numbers=0xae5134b8, values=0xae513478) at ma_dyncol.c:1156
#14 0x082208e7 in Item_func_dyncol_create::val_str (this=0xae513228, str=0xae89f100) at item_strfunc.cc:3640
#15 0x081d0de7 in Item::send (this=0xae513228, protocol=0xa1c41e8, buffer=0xae89f100) at item.cc:5783
#16 0x08277910 in select_send::send_data (this=0xae5133c0, items=...) at sql_class.cc:1918
#17 0x083129ae in JOIN::exec (this=0xae521330) at sql_select.cc:1931
#18 0x083150fe in mysql_select (thd=0xa1c3ed8, rref_pointer_array=0xa1c5978, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0,
    having=0x0, proc_param=0x0, select_options=2147764736, result=0xae5133c0, unit=0xa1c55d8, select_lex=0xa1c5874) at sql_select.cc:2701
#19 0x0830d95b in handle_select (thd=0xa1c3ed8, lex=0xa1c557c, result=0xae5133c0, setup_tables_done_option=0) at sql_select.cc:282
#20 0x082aa308 in execute_sqlcom_select (thd=0xa1c3ed8, all_tables=0x0) at sql_parse.cc:5094
#21 0x082a1152 in mysql_execute_command (thd=0xa1c3ed8) at sql_parse.cc:2239
#22 0x082ac8ab in mysql_parse (thd=0xa1c3ed8, rawbuf=0xae512eb0 "SELECT COLUMN_CREATE( 1 , COLUMN_GET( 'a' , 2 AS DATE ) )", length=57,
    found_semicolon=0xae8a0228) at sql_parse.cc:6094
#23 0x0829eddb in dispatch_command (command=COM_QUERY, thd=0xa1c3ed8, packet=0xa21eae9 "", packet_length=57) at sql_parse.cc:1215
#24 0x0829e239 in do_command (thd=0xa1c3ed8) at sql_parse.cc:904
#25 0x0829b2ec in handle_one_connection (arg=0xa1c3ed8) at sql_connect.cc:1154
#26 0x00821919 in start_thread () from /lib/libpthread.so.0
#27 0x00453cce in clone () from /lib/libc.so.6

test case:

SELECT COLUMN_CREATE( 1 , COLUMN_GET( 'a' , 2 AS DATE ) );

[Philip Stoev (pstoev-askmonty)]

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 , 'vuwliqnpkluwlaizqgwmmnibdtbocflfpqxifusfzucaglaejzptamlgqwpzfavbhc...