0003246: Can't insert empty string into numeric column in MySQL

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

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

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[^]

32 total queries executed.
28 unique queries executed.