MySQL Bugs: #19832: query crashes the server

Bug #19832	query crashes the server
Submitted:	15 May 2006 22:05	Modified:	24 May 2006 20:45
Reporter:	[ name withheld ]	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.21/5.0BK/5.1BK	OS:	Linux (Linux)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
In preparation for migrating away from Oracle 8, I did lots of testing with MySQL 5.0.18 and 5.0.19 -- but when I moved to 5.0.21, my queries started crashing the server.

How to repeat:
create table z (x date); 

select date_sub(x, interval (weekday(x)%7) day) from z group by date_sub(x, interval (weekday(x)%7) day);

Thank you for the bug report.

miguel@hegel:~/dbs/5.1> bin/mysqladmin -uroot create dh
miguel@hegel:~/dbs/5.1> bin/mysql -uroot dh
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.1.11-beta-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table z (x date); 
Query OK, 0 rows affected (0.01 sec)

mysql> select date_sub(x, interval (weekday(x)%7) day) from z group by date_sub(x,
    -> interval (weekday(x)%7) day);
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> 

Version: '5.1.11-beta-debug'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
[New Thread 1118682032 (LWP 5913)]
[Thread 1118682032 (zombie) exited]
[New Thread 1118682032 (LWP 5915)]
mysqld: item_func.cc:758: virtual longlong Item_func_numhybrid::val_int(): Assertion `fixed == 1' failed.

Program received signal SIGABRT, Aborted.
[Switching to Thread 1118682032 (LWP 5915)]
0xffffe410 in __kernel_vsyscall ()
(gdb) quit

miguel@hegel:~/dbs/5.0> bin/mysqladmin -uroot create dh
miguel@hegel:~/dbs/5.0> bin/mysql -uroot dh
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.0.22-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table z (x date); 
Query OK, 0 rows affected (0.01 sec)

mysql> 
mysql> select date_sub(x, interval (weekday(x)%7) day) from z group by date_sub(x,
    -> interval (weekday(x)%7) day);
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> 

060515 19:23:22 [Note] /home/miguel/dbs/5.0/libexec/mysqld: ready for connections.
Version: '5.0.22-debug'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
[New Thread 1131862960 (LWP 5932)]
[Thread 1131862960 (zombie) exited]
[New Thread 1131862960 (LWP 5934)]
mysqld: item_func.cc:756: virtual longlong Item_func_numhybrid::val_int(): Assertion `fixed == 1' failed.

Program received signal SIGABRT, Aborted.
[Switching to Thread 1131862960 (LWP 5934)]
0xffffe410 in __kernel_vsyscall ()
(gdb) quit

miguel@hegel:~/dbs/4.1> bin/mysqladmin -uroot create dh
miguel@hegel:~/dbs/4.1> bin/mysql -uroot dh
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.1.19-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table z (x date); 
Query OK, 0 rows affected (0.02 sec)

mysql> 
mysql> select date_sub(x, interval (weekday(x)%7) day) from z group by date_sub(x,
    -> interval (weekday(x)%7) day);
Empty set (0.01 sec)

mysql>

I tried 5.0.20, and it worked so it's something from 20 -> 21 recently.

This is a duplicate of BUG#19490.