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.