"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/r/685803.result" (6 May 2012, 574 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 https://bugs.launchpad.net/drizzle/+bug/685803
    3 When inserting into a bigint column, values > max bigint (64bit signed max)
    4 are accepted, but when the values are in quotes an out of range error is
    5 hit. I would expect out of range for both instances:
    6 */
    7 CREATE TABLE t6 (a BIGINT);
    8 INSERT INTO `t6` VALUES (9223372036854775807),(18446744073709551615);
    9 ERROR 22003: Out of range value for column 'a' at row 2
   10 INSERT INTO `t6` VALUES ('9223372036854775807'),('18446744073709551615');
   11 ERROR 22003: Out of range value for column 'a' at row 2
   12 SELECT a FROM t6;
   13 a
   14 DROP TABLE t6;