#284 integer fields allow alphanumeric values at insertion time

[Nihar Ranjan paital]

I found the following statements are executed and observed that int field accepts alphanumeric values.

CSQL>drop table t1;
Statement Executed
CSQL>create table t1(f1 int);
Statement Executed
CSQL>insert into t1 values(1a);
Statement Executed: Rows Affected = 1
CSQL>insert into t1 values(288cde);
Statement Executed: Rows Affected = 1
CSQL>insert into t1 values(288cdef);
Statement Executed: Rows Affected = 1
CSQL>insert into t1 values(7899efabcdefd);
Statement Executed: Rows Affected = 1
CSQL>insert into t1 values(12aghfabc);
[Parser: syntax error] ghfabc
Statement prepare failed with error -19
CSQL>insert into t1 values(a);
[Parser: syntax error] a
Statement prepare failed with error -19
CSQL>insert into t1 values('A');
Statement Executed: Rows Affected = 1
CSQL>insert into t1 values(1.8);
Statement Executed: Rows Affected = 1

When i execute the select query found the sesults defering from inserted values.

CSQL>select * from t2;
---------------------------------------------------------
f1
---------------------------------------------------------

CSQL>select * from t1;
---------------------------------------------------------
f1
---------------------------------------------------------
1
288
288
7899
145525872
1

Another thing i found i.e The int field allows the alphabets from 'a' to 'f' and 'A' to 'F' along with the numeric values. But it does not allow any other alphabets.

The same is happening with all other integral datatype(like tinyint,long,short etc) also.