|
Mantis - Quercus
|
|||||
| Viewing Issue Advanced Details | |||||
|
|
|||||
| ID: | Category: | Severity: | Reproducibility: | Date Submitted: | Last Update: |
| 3246 | minor | always | 01-13-09 12:38 | 01-15-09 13:07 | |
|
|
|||||
| Reporter: | koreth | Platform: | |||
| Assigned To: | OS: | ||||
| Priority: | urgent | OS Version: | |||
| Status: | new | Product Version: | 4.0.0 | ||
| Product Build: | Resolution: | open | |||
| Projection: | none | ||||
| ETA: | none | Fixed in Version: | |||
|
|
|||||
| Summary: | 0003246: Can't insert empty string into numeric column in MySQL | ||||
| Description: |
This is really a JDBC driver issue, but it is a behavior difference from normal PHP and its MySQL interface, so: If you have a table like CREATE TABLE stuff ( thing TINYINT(4) ); MySQL will let you do INSERT INTO stuff (thing) VALUES (''); and it turns the empty string into NULL internally. If you try that under Quercus, you get "Incorrect integer value: '' for column 'thing'" and the query fails. This is something the application shouldn't be doing in the first place and I am cleaning it up in our PHP code as I come across it, so this is not terribly high-priority. But there do seem to be a number of instances where we're doing this (usually thanks to building up queries programmatically) and it would be swell if it just worked under Quercus. |
||||
| Steps To Reproduce: | |||||
| Additional Information: | |||||
| Relationships | |||||
| Attached Files: | |||||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||