|Anonymous | Login | Signup for a new account||06-04-2020 05:06 PDT|
|Main | My View | View Issues | Change Log | Docs|
|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|
|Summary||0003246: Can't insert empty string into numeric column in MySQL|
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 (
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.
|We'll be forking the JDBC driver after the 4.0 release.|
|However, I don't think this is something we can modify since the query is just a string to the JDBC driver.|
|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.