~ubuntu-branches/ubuntu/trusty/drizzle/trusty

col_bigint col_enum col_char_10 col_char_1024 col_int col_char_10_not_null col_int_not_null_key col_enum_not_null col_char_1024_not_null_key col_int_key col_char_10_key col_char_1024_not_null col_enum_not_null_key pk col_bigint_key col_int_not_null col_bigint_not_null col_bigint_not_null_key col_char_10_not_null_key col_enum_key col_char_1024_key

NULL p him out NULL SATEF 4 k j NULL CSZXW JJVVK m 1 -8422575728112959488 4 8 2 e w ok

2 y he's q 3 we 7 v HLHTR NULL what ZQRDC n 2 5 1 6 8 TYZGK b JRKMQ

NULL n TOERV at 489684992 a 0 q he's -656408576 XDOYG q n 3 NULL 4 4 6 t m WCFTE

5 y see what NULL had -1408040960 p go 8 OZXNB CJZXI c 4 1 4 -2731714648976916480 5 IJRLL u t

NULL i ZDPHP what 8 h -609353728 u tell NULL all why i 5 -2309783658887643136 -447479808 1794402976530432000 -5135792425062629376 one j NOZRH

NULL x could was -1362362368 PJDZV 1 i URSPR NULL GRPQU at k 6 -7964897415981432832 1017315328 6 7 ok i j

8 m JWAGE no NULL to 0 w CNEMI 6 BRRIF got u 7 3 0 1 1 p a d

NULL x WPTIG why 6 QIGWE 8 f u 7 n then t 8 0 -748224512 8820862820158537728 -5981906205054861312 HJWPU q BZPOM

-4702602435904929792 d you really NULL TQVBJ 8 c a NULL how x o 9 NULL -280166400 -7567454748865986560 4133178558019272704 r w with

0 m this MSYSE 9 c 1507065856 v v 606601216 one j d 10 1 3 9 3 r p it

2 c HUYRF UEZQE 1515061248 well 4 x z NULL r JYCYO q 11 NULL 416415744 5 3220073733569904640 LOOQX v XCGOH

-3214725709012402176 t BWCQX w 2 EBGJZ 1524367360 e have 534904832 say QADUT q 12 4 5 6442680741930205184 -7162975207332773888 with q no

NULL f VETFO OCGPF -219217920 VXUGM 8 w OGLVA 8 will JRZIM e 13 NULL -721027072 -8546987667819069440 4 HEPKH f a

6 j some KKWBL NULL NFPET 8 a didn't NULL f from k 14 5784873721357402112 6 2771402620693118976 -3209377684454899712 a v FEKXH

NULL m l ERGSH NULL this 8 g have 4 oh l y 15 NULL 5 -4316137292881199104 3830874433032028160 f d u

6 e I'll h 9 why 1903689728 s USBHU 8 URBRY q b 16 3 9 2 6 l d XEUHW

-4108127285092024320 f b WMPKH 7 c 178520064 r XIHTV 1119158272 could ANVSO x 17 3 9 1443966630525665280 2 x p i

NULL d f have 763953152 a 4 w w -875102208 l a x 18 6 -1990328320 7 6345008925011607552 from b PTZYO

NULL q e didn't NULL well 1973485568 t EJXKT -1814364160 IUDZN ASBVO v 19 6 1733361664 7 2 MHDLC e q

7447827883763957760 a j e -771620864 i 973144064 n f 46727168 u because f 20 8 9 4 3 ITBED j u

1568941520185196544 g SLDZX DYQRN 5 g 2 x UOYXK -2097610752 it's from m 21 NULL -1349844992 5221923767936090112 -8438901276762177536 VFCRO f TTNNK

NULL g l i NULL k 1130889216 x q 1 m DXSWH h 22 7789257030513983488 2056716288 0 -6883189080482381824 i n z

8 k then RRXXD 1104019456 u 2 l had NULL t BVGQA m 23 -4929471267133718528 659619840 1279022294173220864 887772076545409024 JZBYO t why

NULL z like she NULL d 680329216 d OLKNI -1310916608 d up n 24 -4552294798341439488 5 5 4 mean y RDNAH

6 k all b -2054946816 u 3 u your 2024996864 l KZOIW m 25 1 162856960 8270860715665915904 5 GUIUY e go

6556396632521310208 k is PDNXO 476315648 XPLMI 1707212800 a l NULL SXUOG m m 26 -6770880564774830080 -154402816 -6301661778598166528 -6796776262632210432 would l at

NULL p GHWYO QBEEI 0 f 226557952 i DBSXY -2028666880 i GNWDR d 27 5 0 3 -2258836688103014400 n f b

3533355382648864768 a KDXMJ are NULL VMLJU 2 p QPCRJ NULL c now w 28 NULL 0 6 -1995939059855261696 b w your

NULL l b when 2 VCLTM 33751040 v q 747110400 VNMTO y b 29 5 6 5818650718562680832 -8166714974282973184 o i TKIIP

NULL k TVNFL he's NULL e 1454112768 g m 1 y v a 30 0 -356384768 6 0 z v h

9 x CLGFS a NULL f 8 e v 7 d get p 31 0 1 -5241345541329125376 6451687941184946176 it c o

4 g w I NULL x -370081792 m e 0 CHXCP mean a 32 9 -1495400448 5 353814045725294592 t d c

NULL u KPDSD a 6 GEDEE 1637154816 z RORBZ 6 now SLTKG x 33 -7162130782402641920 9 9 3 mean p did

NULL e i XVHGM NULL time 97517568 z LJWJL 4 who there d 34 NULL 5 1847601747128745984 2 think o then

-5505087594507010048 p l h 8 u -2111242240 j with 6 p MTQOR a 35 5580804363242176512 3 2 -7699747987919994880 TDARB o o

3465238438284886016 v JBPUP ZSHTA -1207828480 a 2 m KXCXD 9 h f w 36 3 7 1 5 you're y can

NULL x don't c 5 LHQZG 50003968 w HGQLX NULL n or u 37 NULL -1414135808 6938358175917670400 9 o f GPPDO

NULL v IEPYU a 1920008192 FXOJE 1985150976 a IOBFS NULL k j a 38 NULL -2143485952 2732840548883759104 3187985586224889856 right y XXZAH

-646266546527666176 f VSBWR could 800915456 APRXR 9 r d -1298137088 will when t 39 NULL 1822883840 1 3 there a s

NULL p ZAZJK TSIEI 1 how 120061952 s SDADP -704184320 can a w 40 3884073203630342144 7 0 7 TWWGS j UFYRK

7 x d UMFYV 1462960128 no -1078001664 w from 1795620864 m CXCAX j 41 -7156219807891718144 8 9 3377699720527872000 her u UKIUK

1704893933936443392 l q w 2 don't 909770752 w something NULL j c n 42 3 9 4 5 x m b

-8849854742759735296 e oh y NULL who -1872166912 l ZFBVI -1316356096 YOFSX her r 43 -8150389425633755136 -1386610688 0 -33776997205278720 something w EIUSF

-1878563994566918144 m i EDVII NULL say 819396608 c GMESX 791019520 UPVRS but e 44 NULL 7 8794404172347736064 2413084975340453888 w p here

4 i x h NULL f 141099008 h one -1709572096 RIICG like u 45 6 1 5 7 you k c

-76842668642009088 h EXZPO PFYHG NULL UBPGM 9 g here -1922957312 JBOWU w x 46 8 1352466432 1 9 I'll f KAQCG

7 w o at NULL v 5 t good NULL would IQUAV q 47 8 1 5 -6735414717709287424 m e RWJSL

8990592231115063296 f v OGNJD NULL KPOBP -579731456 i u NULL that's really i 48 3 -621150208 9 -7248262125276102656 y l but

NULL t good HEFMW 9 PNINW 7 k d 463863808 m a t 49 3 1192755200 9 -2311753983724617728 KEVRQ l HZMCU

8 z some w NULL KUJES -2143551488 u EOYYW 5 FIUID s n 50 6 4 8 721138890332700672 q l OLIZZ

SHOW CREATE TABLE A;

Table Create Table

A CREATE TABLE `A` (

`col_bigint` BIGINT DEFAULT NULL,

`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') DEFAULT NULL,

`col_char_10` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,

`col_char_1024` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL,

`col_int` INT DEFAULT NULL,

`col_char_10_not_null` VARCHAR(10) COLLATE utf8_general_ci NOT NULL,

`col_int_not_null_key` INT NOT NULL,

`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,

`col_char_1024_not_null_key` VARCHAR(1024) COLLATE utf8_general_ci NOT NULL,

`col_int_key` INT DEFAULT NULL,

`col_char_10_key` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,

`col_char_1024_not_null` VARCHAR(1024) COLLATE utf8_general_ci NOT NULL,

`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,

`pk` INT NOT NULL AUTO_INCREMENT,

`col_bigint_key` BIGINT DEFAULT NULL,

`col_int_not_null` INT NOT NULL,

`col_bigint_not_null` BIGINT NOT NULL,

`col_bigint_not_null_key` BIGINT NOT NULL,

`col_char_10_not_null_key` VARCHAR(10) COLLATE utf8_general_ci NOT NULL,

`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') DEFAULT NULL,

`col_char_1024_key` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL,

PRIMARY KEY (`pk`),

KEY `col_int_not_null_key` (`col_int_not_null_key`),

KEY `col_char_1024_not_null_key` (`col_char_1024_not_null_key`(255)),

KEY `col_int_key` (`col_int_key`),

KEY `col_char_10_key` (`col_char_10_key`),

KEY `col_enum_not_null_key` (`col_enum_not_null_key`),

KEY `col_bigint_key` (`col_bigint_key`),

KEY `col_bigint_not_null_key` (`col_bigint_not_null_key`),

KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`),

KEY `col_enum_key` (`col_enum_key`),

KEY `col_char_1024_key` (`col_char_1024_key`(255))

) ENGINE=InnoDB COLLATE = utf8_general_ci

DROP TABLE A;

Older »