Mantis Bugtracker
  

Viewing Issue Advanced Details Jump to Notes ] View Simple ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0003246 [Quercus] minor always 01-13-09 12:38 01-15-09 13:07
Reporter koreth View Status public  
Assigned To
Priority urgent Resolution open Platform
Status new   OS
Projection none   OS Version
ETA none Fixed in Version Product Version 4.0.0
  Product Build
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
Attached Files

- Relationships

- Notes
(0003728)
nam
01-13-09 16:05

We'll be forking the JDBC driver after the 4.0 release.
 
(0003737)
ferg
01-15-09 13:07

However, I don't think this is something we can modify since the query is just a string to the JDBC driver.
 

- Issue History
Date Modified Username Field Change
01-13-09 12:38 koreth New Issue
01-13-09 16:05 nam Note Added: 0003728
01-15-09 13:07 ferg Note Added: 0003737
01-15-09 13:07 ferg Priority normal => urgent


Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
32 total queries executed.
28 unique queries executed.
Powered by Mantis Bugtracker