Bug #44609 | perfix arrangement throw error | ||
---|---|---|---|
Submitted: | 1 May 2009 15:25 | Modified: | 1 Jun 2009 18:58 |
Reporter: | Yochai Akoka | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.1.30 | OS: | Windows (Vista) |
Assigned to: | CPU Architecture: | Any | |
Tags: | clause, INTEGER, Perfix |
[1 May 2009 15:25]
Yochai Akoka
[1 May 2009 18:58]
Valeriy Kravchuk
Thank you for the problem report. Please, send complete test case, with exact CREATE TABLE and INSERT statements. I don't see any problem with my 5.1.34: valeriy-kravchuks-macbook-pro:5.1 openxs$ bin/mysql -uroot test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.34-debug Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create table tint(c1 int); Query OK, 0 rows affected (0.06 sec) mysql> insert into `tint`(`c1`) values ('5'); Query OK, 1 row affected (0.00 sec) mysql> insert into tint(c1) values ('5'); Query OK, 1 row affected (0.00 sec) Why do you think it should not work? String '5' is just converted into number, 5, implicitly.
[1 Jun 2009 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".