On Tue, Jul 29, 2014 at 1:32 AM, Isaac Bennetch bennetch@gmail.com wrote:
Hi,
On 7/28/14, 1:30 PM, Chirayu Chiripal wrote:
Hi,
My GSoC task for this week is "Improved notification when attempting to insert invalid data". I would like to know at which places validation is required to be done?
The idea here is basically that if a user attempts to insert data that will be truncated that we'll warn them. Some of this has already been implemented (for instance, try to insert the text "foo" to a column of type INT(10); the field turns red indicating a problem).
This can be enhanced, though, for instance the following scenarios do not warn correctly:
- Insert 999 to a TINYINT
- Insert 99999999999 to an INT
For integer types we can change our current input type="text" to input type="number" and specify a min and max value using attributes. Or, we still have to add a min and max value attribute and use Javascript/Jquery to validate the field when it loses focus or at keyup event.