Bug #18140 | Server crash with function, procedure and partitions | ||
---|---|---|---|
Submitted: | 10 Mar 2006 17:45 | Modified: | 13 Apr 2006 1:57 |
Reporter: | Andrey Hristov | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: Partitions | Severity: | S3 (Non-critical) |
Version: | 5.1. | OS: | Linux (Linux) |
Assigned to: | MySQL Verification Team | CPU Architecture: | Any |
[10 Mar 2006 17:45]
Andrey Hristov
[13 Mar 2006 1:57]
MySQL Verification Team
Hi, I was unable to repeat with latest source: miguel@hegel:~/dbs/mysql-5.1-new> bk changes | head ChangeSet@1.2165, 2006-03-11 21:34:49+01:00, jonas@perch.ndb.mysql.com ndb - Dont put object file in list of SOURCES...causing really weird make dist problem ChangeSet@1.2162.1.1, 2006-03-11 19:13:31+01:00, kent@mysql.com dict0dict.h, dict0dict.c, ha_innodb.cc: Make inline dict_table_is_comp() visible to ha_innodb.c as innodb_dict_table_is_comp() miguel@hegel:~/dbs/5.1> bin/mysqladmin -uroot create db28 miguel@hegel:~/dbs/5.1> bin/mysql -uroot db28 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 5.1.8-beta-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> DELIMITER // mysql> CREATE TABLE t9 (s1 int)// Query OK, 0 rows affected (0.02 sec) mysql> mysql> CREATE FUNCTION `partition_exists`(p_p_name varchar(64)) -> RETURNS int(11) -> return (select count(*) from information_schema.partitions -> where partition_name = p_p_name) // Query OK, 0 rows affected (0.03 sec) mysql> mysql> CREATE PROCEDURE p9 () -> begin -> declare continue handler for sqlexception insert into t9 values -> (partiton_exists('p2')); -> insert into t9 values (partition_exists('p1')); -> end// Query OK, 0 rows affected (0.00 sec) mysql> mysql> call p9()// Query OK, 1 row affected, 1 warning (0.27 sec) mysql> show warnings // +---------+------+----------------------------------------------------+ | Level | Code | Message | +---------+------+----------------------------------------------------+ | Warning | 1264 | Out of range value for column 'NODEGROUP' at row 1 | +---------+------+----------------------------------------------------+ 1 row in set (0.00 sec)
[13 Apr 2006 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".