"Fossies" - the Fresh Open Source Software Archive

Member "drizzle-7.1.36-stable/tests/suite/regression/t/676770.test" (6 May 2012, 2744 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 --disable_warnings
    2 DROP TABLE IF EXISTS t1;
    3 --enable_warnings
    4 
    5 CREATE TABLE t1 (
    6 `col_int` int,
    7 pk integer auto_increment,
    8 `col_char_10` char(10),
    9 `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,
   10 `col_char_1024` char(1024),
   11 `col_char_1024_key` char(1024),
   12 `col_bigint_not_null_key` bigint not null,
   13 `col_text_key` text,
   14 `col_char_1024_not_null` char(1024) not null,
   15 `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'),
   16 `col_int_not_null` int not null,
   17 `col_bigint_not_null` bigint not null,
   18 `col_text` text,
   19 `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'),
   20 `col_char_10_not_null` char(10) not null,
   21 `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,
   22 `col_text_not_null_key` text not null,
   23 `col_char_1024_not_null_key` char(1024) not null,
   24 `col_text_not_null` text not null,
   25 `col_int_key` int,
   26 `col_char_10_key` char(10),
   27 `col_int_not_null_key` int not null,
   28 `col_bigint_key` bigint,
   29 `col_bigint` bigint,
   30 `col_char_10_not_null_key` char(10) not null,
   31 /*Indices*/
   32 primary key (pk),
   33 key (`col_char_1024_key` ),
   34 key (`col_bigint_not_null_key` ),
   35 key (`col_text_key` (255)),
   36 key (`col_enum_key` ),
   37 key (`col_enum_not_null_key` ),
   38 key (`col_text_not_null_key` (255)),
   39 key (`col_char_1024_not_null_key` ),
   40 key (`col_int_key` ),
   41 key (`col_char_10_key` ),
   42 key (`col_int_not_null_key` ),
   43 key (`col_bigint_key` ),
   44 key (`col_char_10_not_null_key` )) ;
   45 
   46 START TRANSACTION;
   47 --error ER_INVALID_ENUM_VALUE
   48 DELETE FROM t1
   49 WHERE `col_enum_key` = 923074560
   50  ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,
   51 `col_bigint_not_null_key`,`col_char_10`,`col_char_1024`,
   52 `col_char_1024_key`,`col_char_1024_not_null`,`col_char_1024_not_null_key`,
   53 `col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_enum`,
   54 `col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,
   55 `col_int_not_null`,`col_int_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,
   56 `col_text_not_null_key`,`pk` LIMIT 1;
   57 
   58 --replace_result $DRIZZLETEST_VARDIR DTR_VARDIR
   59 --system cat $DRIZZLETEST_VARDIR/log/master.err |awk 'BEGIN {x=0}; /^CURRENT_TEST: regression.676770/{x=1;}; /Sort aborted/{ if (x==1) print}; /^CURRENT_TEST: (^regression.676770)/{x=0;}' > $DRIZZLETEST_VARDIR/tmp/enum_errlog.tmp
   60 
   61 --replace_result $DRIZZLETEST_VARDIR DTR_VARDIR
   62 eval SELECT LOAD_FILE('$DRIZZLETEST_VARDIR/tmp/enum_errlog.tmp');
   63 
   64 --echo
   65 --echo
   66 COMMIT;
   67 DROP TABLE t1;
   68 --remove_file $DRIZZLETEST_VARDIR/tmp/enum_errlog.tmp