[MDEV-2884] LP:778905 - Assertion `value->year <= 9999' failed in dynamic_column_date_store Created: 2011-05-07  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: Philip Stoev (Inactive) Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug778905.xml    

 Description   

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

 Comments   
Comment by Philip Stoev (Inactive) [ 2011-05-07 ]

Re: Assertion `value->year <= 9999' failed in dynamic_column_date_store
DECIMAL is also affected:

mysqld: decimal.c:1459: decimal_bin_size: Assertion `scale >= 0 && precision > 0 && scale <= precision' failed.

  1. 2011-05-07T11:19:31 #8 0x006b0d98 in __assert_fail () from /lib/libc.so.6
  2. 2011-05-07T11:19:31 #9 0x087ba573 in decimal_bin_size (precision=0, scale=0) at decimal.c:1459
  3. 2011-05-07T11:19:31 #10 0x08758cf0 in dynamic_column_value_len (value=0xb6c95dd0) at ma_dyncol.c:334
  4. 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')
  5. 2011-05-07T11:19:31 at ma_dyncol.c:1116
  6. 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
  7. 2011-05-07T11:19:31 #13 0x082208e7 in Item_func_dyncol_create::val_str (this=0xb6c95038, str=0x915d8f50) at item_strfunc.cc:3640
  8. 2011-05-07T11:19:31 #14 0x08220d0f in Item_func_dyncol_add::val_str (this=0xb6c95640, str=0x915d8f50) at item_strfunc.cc:3733
  9. 2011-05-07T11:19:31 #15 0x08220d0f in Item_func_dyncol_add::val_str (this=0xb6c95810, str=0x915d8f50) at item_strfunc.cc:3733
  10. 2011-05-07T11:19:31 #16 0x081d0de7 in Item::send (this=0xb6c95810, protocol=0xa9f7ef8, buffer=0x915d8f50) at item.cc:5783
  11. 2011-05-07T11:19:31 #17 0x08277910 in select_send::send_data (this=0xb6c95ce0, items=...) at sql_class.cc:1918
  12. 2011-05-07T11:19:31 #18 0x08330e0f in end_send (join=0xb6c10ad0, join_tab=0xb6c8d9ac, end_of_records=false) at sql_select.cc:14934
  13. 2011-05-07T11:19:31 #19 0x0832f312 in evaluate_join_record (join=0xb6c10ad0, join_tab=0xb6c8d7c8, error=0) at sql_select.cc:14160
  14. 2011-05-07T11:19:31 #20 0x0832eded in sub_select (join=0xb6c10ad0, join_tab=0xb6c8d7c8, end_of_records=false) at sql_select.cc:14005
  15. 2011-05-07T11:19:31 #21 0x0832e077 in do_select (join=0xb6c10ad0, fields=0xa9f9618, table=0x0, procedure=0x0) at sql_select.cc:13500
  16. 2011-05-07T11:19:31 #22 0x083148e2 in JOIN::exec (this=0xb6c10ad0) at sql_select.cc:2482
  17. 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,
  18. 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
  19. 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
  20. 2011-05-07T11:19:31 #25 0x082aa308 in execute_sqlcom_select (thd=0xa9f7be8, all_tables=0xb6c95a60) at sql_parse.cc:5094
  21. 2011-05-07T11:19:31 #26 0x082a1152 in mysql_execute_command (thd=0xa9f7be8) at sql_parse.cc:2239
  22. 2011-05-07T11:19:31 #27 0x082ac8ab in mysql_parse (thd=0xa9f7be8,
  23. 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
  24. 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
  25. 2011-05-07T11:19:31 #29 0x0829e239 in do_command (thd=0xa9f7be8) at sql_parse.cc:904
  26. 2011-05-07T11:19:31 #30 0x0829b2ec in handle_one_connection (arg=0xa9f7be8) at sql_connect.cc:1154
  27. 2011-05-07T11:19:31 #31 0x00821919 in start_thread () from /lib/libpthread.so.0
  28. 2011-05-07T11:19:31 #32 0x0076acce in clone () from /lib/libc.so.6
  29. 2011-05-07T11:19:31 #5 0x00ff0424 in __kernel_vsyscall ()
Comment by Rasmus Johansson (Inactive) [ 2011-05-11 ]

Launchpad bug id: 778905

Generated at Thu Feb 08 06:44:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.