"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/t/685803.test" (6 May 2012, 532 Bytes) of package /linux/misc/old/drizzle-7.1.36-stable.tar.gz:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 /*
    2 
    3 https://bugs.launchpad.net/drizzle/+bug/685803
    4 
    5 When inserting into a bigint column, values > max bigint (64bit signed max)
    6 are accepted, but when the values are in quotes an out of range error is
    7 hit. I would expect out of range for both instances:
    8 
    9 */
   10 
   11 CREATE TABLE t6 (a BIGINT);
   12 --error ER_WARN_DATA_OUT_OF_RANGE
   13 INSERT INTO `t6` VALUES (9223372036854775807),(18446744073709551615);
   14 --error ER_WARN_DATA_OUT_OF_RANGE
   15 INSERT INTO `t6` VALUES ('9223372036854775807'),('18446744073709551615');
   16 SELECT a FROM t6;
   17 DROP TABLE t6;