Mantis Bugtracker

Viewing Issue Simple Details Jump to Notes ] View Advanced ] 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  
Status new   Product Version 4.0.0
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

  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.
Additional Information
Attached Files

- Relationships

- Notes
01-13-09 16:05

We'll be forking the JDBC driver after the 4.0 release.
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