"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/r/676770.result" (6 May 2012, 2521 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 DROP TABLE IF EXISTS t1;
    2 CREATE TABLE t1 (
    3 `col_int` int,
    4 pk integer auto_increment,
    5 `col_char_10` char(10),
    6 `col_enum_not_null` enum ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') not null,
    7 `col_char_1024` char(1024),
    8 `col_char_1024_key` char(1024),
    9 `col_bigint_not_null_key` bigint not null,
   10 `col_text_key` text,
   11 `col_char_1024_not_null` char(1024) not null,
   12 `col_enum_key` enum ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
   13 `col_int_not_null` int not null,
   14 `col_bigint_not_null` bigint not null,
   15 `col_text` text,
   16 `col_enum` enum ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
   17 `col_char_10_not_null` char(10) not null,
   18 `col_enum_not_null_key` enum ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') not null,
   19 `col_text_not_null_key` text not null,
   20 `col_char_1024_not_null_key` char(1024) not null,
   21 `col_text_not_null` text not null,
   22 `col_int_key` int,
   23 `col_char_10_key` char(10),
   24 `col_int_not_null_key` int not null,
   25 `col_bigint_key` bigint,
   26 `col_bigint` bigint,
   27 `col_char_10_not_null_key` char(10) not null,
   28 /*Indices*/
   29 primary key (pk),
   30 key (`col_char_1024_key` ),
   31 key (`col_bigint_not_null_key` ),
   32 key (`col_text_key` (255)),
   33 key (`col_enum_key` ),
   34 key (`col_enum_not_null_key` ),
   35 key (`col_text_not_null_key` (255)),
   36 key (`col_char_1024_not_null_key` ),
   37 key (`col_int_key` ),
   38 key (`col_char_10_key` ),
   39 key (`col_int_not_null_key` ),
   40 key (`col_bigint_key` ),
   41 key (`col_char_10_not_null_key` )) ;
   42 Warnings:
   43 Warning	1071	Specified key was too long; max key length is 1023 bytes
   44 Warning	1071	Specified key was too long; max key length is 1023 bytes
   45 START TRANSACTION;
   46 DELETE FROM t1
   47 WHERE `col_enum_key` = 923074560
   48 ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,
   49 `col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,
   50 `col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,
   51 `col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,
   52 `col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,
   53 `col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,
   54 `col_text_not_null_key`,`pk` LIMIT 1;
   55 ERROR HY000: Received an invalid enum value '923074560'.
   56 SELECT LOAD_FILE('DTR_VARDIR/tmp/enum_errlog.tmp');
   57 LOAD_FILE('DTR_VARDIR/tmp/enum_errlog.tmp')
   58 NULL
   59 
   60 
   61 COMMIT;
   62 DROP TABLE t1;