Bug #34776 Assertion failed:scale >=0 && precision>0&& scale<=precisiondecimal.c line 1462

• Submitted: 23 Feb 2008 11:47
• Modified: 18 Mar 2010 10:01
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Can't repeat
• Category: MySQL Server: Data Types
• Severity: S2 (Serious)
• Version: 5.0.62-debug, 5.0.66a-debug,5.1.23-debug
• OS: Any
• CPU Architecture: Any
• Tags: assertion, decimal

[23 Feb 2008 11:47] Shane Bester

Description:
this is a followup to bug #31471 and maybe bug #30782

Assertion failed: scale >= 0 && precision > 0 && scale <= precision, file decimal.c, line 1462

mysqld.exe!_NMSG_WRITE
mysqld.exe!abort
mysqld.exe!_wassert
mysqld.exe!decimal_bin_size
mysqld.exe!my_decimal_get_binary_size
mysqld.exe!Field_new_decimal::Field_new_decimal
mysqld.exe!create_tmp_field_from_item
mysqld.exe!create_tmp_field
mysqld.exe!create_tmp_table
mysqld.exe!JOIN::optimize
mysqld.exe!mysql_select
mysqld.exe!handle_select
mysqld.exe!execute_sqlcom_select
mysqld.exe!mysql_execute_command
mysqld.exe!mysql_parse
mysqld.exe!dispatch_command
mysqld.exe!do_command
mysqld.exe!handle_one_connection
mysqld.exe!pthread_start
mysqld.exe!_callthreadstart
mysqld.exe!_threadstart

How to repeat:
drop table if exists `t1`;
create table `t1`(`a` datetime)engine=myisam;
insert into `t1` values (),();
select ceiling(convert(linestringfromtext(`a`),unsigned)) from `t1` group by 1;

[23 Feb 2008 15:00] Valeriy Kravchuk

Verified with 5.1.23-debug.

[23 Feb 2008 15:00] MySQL Verification Team

it's a debug assertion, so you have to use debug binary ..

[18 Mar 2010 10:01] MySQL Verification Team

can't repeat this on 5.0.90-debug, 5.6.99-m4-debug or 5.1.45-debug