1drop table if exists s; 2create table s (a int, b int, c int) engine=tokudb; 3insert into s values (10,10,10); 4insert into s values (10,10,9); 5insert into s values (10,10,8); 6insert into s values (10,10,7); 7insert into s values (10,10,6); 8insert into s values (10,10,5); 9insert into s values (10,10,4); 10insert into s values (10,10,3); 11insert into s values (10,10,2); 12insert into s values (10,10,1); 13insert into s values (10,9,10); 14insert into s values (10,9,9); 15insert into s values (10,9,8); 16insert into s values (10,9,7); 17insert into s values (10,9,6); 18insert into s values (10,9,5); 19insert into s values (10,9,4); 20insert into s values (10,9,3); 21insert into s values (10,9,2); 22insert into s values (10,9,1); 23insert into s values (10,8,10); 24insert into s values (10,8,9); 25insert into s values (10,8,8); 26insert into s values (10,8,7); 27insert into s values (10,8,6); 28insert into s values (10,8,5); 29insert into s values (10,8,4); 30insert into s values (10,8,3); 31insert into s values (10,8,2); 32insert into s values (10,8,1); 33insert into s values (10,7,10); 34insert into s values (10,7,9); 35insert into s values (10,7,8); 36insert into s values (10,7,7); 37insert into s values (10,7,6); 38insert into s values (10,7,5); 39insert into s values (10,7,4); 40insert into s values (10,7,3); 41insert into s values (10,7,2); 42insert into s values (10,7,1); 43insert into s values (10,6,10); 44insert into s values (10,6,9); 45insert into s values (10,6,8); 46insert into s values (10,6,7); 47insert into s values (10,6,6); 48insert into s values (10,6,5); 49insert into s values (10,6,4); 50insert into s values (10,6,3); 51insert into s values (10,6,2); 52insert into s values (10,6,1); 53insert into s values (10,5,10); 54insert into s values (10,5,9); 55insert into s values (10,5,8); 56insert into s values (10,5,7); 57insert into s values (10,5,6); 58insert into s values (10,5,5); 59insert into s values (10,5,4); 60insert into s values (10,5,3); 61insert into s values (10,5,2); 62insert into s values (10,5,1); 63insert into s values (10,4,10); 64insert into s values (10,4,9); 65insert into s values (10,4,8); 66insert into s values (10,4,7); 67insert into s values (10,4,6); 68insert into s values (10,4,5); 69insert into s values (10,4,4); 70insert into s values (10,4,3); 71insert into s values (10,4,2); 72insert into s values (10,4,1); 73insert into s values (10,3,10); 74insert into s values (10,3,9); 75insert into s values (10,3,8); 76insert into s values (10,3,7); 77insert into s values (10,3,6); 78insert into s values (10,3,5); 79insert into s values (10,3,4); 80insert into s values (10,3,3); 81insert into s values (10,3,2); 82insert into s values (10,3,1); 83insert into s values (10,2,10); 84insert into s values (10,2,9); 85insert into s values (10,2,8); 86insert into s values (10,2,7); 87insert into s values (10,2,6); 88insert into s values (10,2,5); 89insert into s values (10,2,4); 90insert into s values (10,2,3); 91insert into s values (10,2,2); 92insert into s values (10,2,1); 93insert into s values (10,1,10); 94insert into s values (10,1,9); 95insert into s values (10,1,8); 96insert into s values (10,1,7); 97insert into s values (10,1,6); 98insert into s values (10,1,5); 99insert into s values (10,1,4); 100insert into s values (10,1,3); 101insert into s values (10,1,2); 102insert into s values (10,1,1); 103insert into s values (9,10,10); 104insert into s values (9,10,9); 105insert into s values (9,10,8); 106insert into s values (9,10,7); 107insert into s values (9,10,6); 108insert into s values (9,10,5); 109insert into s values (9,10,4); 110insert into s values (9,10,3); 111insert into s values (9,10,2); 112insert into s values (9,10,1); 113insert into s values (9,9,10); 114insert into s values (9,9,9); 115insert into s values (9,9,8); 116insert into s values (9,9,7); 117insert into s values (9,9,6); 118insert into s values (9,9,5); 119insert into s values (9,9,4); 120insert into s values (9,9,3); 121insert into s values (9,9,2); 122insert into s values (9,9,1); 123insert into s values (9,8,10); 124insert into s values (9,8,9); 125insert into s values (9,8,8); 126insert into s values (9,8,7); 127insert into s values (9,8,6); 128insert into s values (9,8,5); 129insert into s values (9,8,4); 130insert into s values (9,8,3); 131insert into s values (9,8,2); 132insert into s values (9,8,1); 133insert into s values (9,7,10); 134insert into s values (9,7,9); 135insert into s values (9,7,8); 136insert into s values (9,7,7); 137insert into s values (9,7,6); 138insert into s values (9,7,5); 139insert into s values (9,7,4); 140insert into s values (9,7,3); 141insert into s values (9,7,2); 142insert into s values (9,7,1); 143insert into s values (9,6,10); 144insert into s values (9,6,9); 145insert into s values (9,6,8); 146insert into s values (9,6,7); 147insert into s values (9,6,6); 148insert into s values (9,6,5); 149insert into s values (9,6,4); 150insert into s values (9,6,3); 151insert into s values (9,6,2); 152insert into s values (9,6,1); 153insert into s values (9,5,10); 154insert into s values (9,5,9); 155insert into s values (9,5,8); 156insert into s values (9,5,7); 157insert into s values (9,5,6); 158insert into s values (9,5,5); 159insert into s values (9,5,4); 160insert into s values (9,5,3); 161insert into s values (9,5,2); 162insert into s values (9,5,1); 163insert into s values (9,4,10); 164insert into s values (9,4,9); 165insert into s values (9,4,8); 166insert into s values (9,4,7); 167insert into s values (9,4,6); 168insert into s values (9,4,5); 169insert into s values (9,4,4); 170insert into s values (9,4,3); 171insert into s values (9,4,2); 172insert into s values (9,4,1); 173insert into s values (9,3,10); 174insert into s values (9,3,9); 175insert into s values (9,3,8); 176insert into s values (9,3,7); 177insert into s values (9,3,6); 178insert into s values (9,3,5); 179insert into s values (9,3,4); 180insert into s values (9,3,3); 181insert into s values (9,3,2); 182insert into s values (9,3,1); 183insert into s values (9,2,10); 184insert into s values (9,2,9); 185insert into s values (9,2,8); 186insert into s values (9,2,7); 187insert into s values (9,2,6); 188insert into s values (9,2,5); 189insert into s values (9,2,4); 190insert into s values (9,2,3); 191insert into s values (9,2,2); 192insert into s values (9,2,1); 193insert into s values (9,1,10); 194insert into s values (9,1,9); 195insert into s values (9,1,8); 196insert into s values (9,1,7); 197insert into s values (9,1,6); 198insert into s values (9,1,5); 199insert into s values (9,1,4); 200insert into s values (9,1,3); 201insert into s values (9,1,2); 202insert into s values (9,1,1); 203insert into s values (8,10,10); 204insert into s values (8,10,9); 205insert into s values (8,10,8); 206insert into s values (8,10,7); 207insert into s values (8,10,6); 208insert into s values (8,10,5); 209insert into s values (8,10,4); 210insert into s values (8,10,3); 211insert into s values (8,10,2); 212insert into s values (8,10,1); 213insert into s values (8,9,10); 214insert into s values (8,9,9); 215insert into s values (8,9,8); 216insert into s values (8,9,7); 217insert into s values (8,9,6); 218insert into s values (8,9,5); 219insert into s values (8,9,4); 220insert into s values (8,9,3); 221insert into s values (8,9,2); 222insert into s values (8,9,1); 223insert into s values (8,8,10); 224insert into s values (8,8,9); 225insert into s values (8,8,8); 226insert into s values (8,8,7); 227insert into s values (8,8,6); 228insert into s values (8,8,5); 229insert into s values (8,8,4); 230insert into s values (8,8,3); 231insert into s values (8,8,2); 232insert into s values (8,8,1); 233insert into s values (8,7,10); 234insert into s values (8,7,9); 235insert into s values (8,7,8); 236insert into s values (8,7,7); 237insert into s values (8,7,6); 238insert into s values (8,7,5); 239insert into s values (8,7,4); 240insert into s values (8,7,3); 241insert into s values (8,7,2); 242insert into s values (8,7,1); 243insert into s values (8,6,10); 244insert into s values (8,6,9); 245insert into s values (8,6,8); 246insert into s values (8,6,7); 247insert into s values (8,6,6); 248insert into s values (8,6,5); 249insert into s values (8,6,4); 250insert into s values (8,6,3); 251insert into s values (8,6,2); 252insert into s values (8,6,1); 253insert into s values (8,5,10); 254insert into s values (8,5,9); 255insert into s values (8,5,8); 256insert into s values (8,5,7); 257insert into s values (8,5,6); 258insert into s values (8,5,5); 259insert into s values (8,5,4); 260insert into s values (8,5,3); 261insert into s values (8,5,2); 262insert into s values (8,5,1); 263insert into s values (8,4,10); 264insert into s values (8,4,9); 265insert into s values (8,4,8); 266insert into s values (8,4,7); 267insert into s values (8,4,6); 268insert into s values (8,4,5); 269insert into s values (8,4,4); 270insert into s values (8,4,3); 271insert into s values (8,4,2); 272insert into s values (8,4,1); 273insert into s values (8,3,10); 274insert into s values (8,3,9); 275insert into s values (8,3,8); 276insert into s values (8,3,7); 277insert into s values (8,3,6); 278insert into s values (8,3,5); 279insert into s values (8,3,4); 280insert into s values (8,3,3); 281insert into s values (8,3,2); 282insert into s values (8,3,1); 283insert into s values (8,2,10); 284insert into s values (8,2,9); 285insert into s values (8,2,8); 286insert into s values (8,2,7); 287insert into s values (8,2,6); 288insert into s values (8,2,5); 289insert into s values (8,2,4); 290insert into s values (8,2,3); 291insert into s values (8,2,2); 292insert into s values (8,2,1); 293insert into s values (8,1,10); 294insert into s values (8,1,9); 295insert into s values (8,1,8); 296insert into s values (8,1,7); 297insert into s values (8,1,6); 298insert into s values (8,1,5); 299insert into s values (8,1,4); 300insert into s values (8,1,3); 301insert into s values (8,1,2); 302insert into s values (8,1,1); 303insert into s values (7,10,10); 304insert into s values (7,10,9); 305insert into s values (7,10,8); 306insert into s values (7,10,7); 307insert into s values (7,10,6); 308insert into s values (7,10,5); 309insert into s values (7,10,4); 310insert into s values (7,10,3); 311insert into s values (7,10,2); 312insert into s values (7,10,1); 313insert into s values (7,9,10); 314insert into s values (7,9,9); 315insert into s values (7,9,8); 316insert into s values (7,9,7); 317insert into s values (7,9,6); 318insert into s values (7,9,5); 319insert into s values (7,9,4); 320insert into s values (7,9,3); 321insert into s values (7,9,2); 322insert into s values (7,9,1); 323insert into s values (7,8,10); 324insert into s values (7,8,9); 325insert into s values (7,8,8); 326insert into s values (7,8,7); 327insert into s values (7,8,6); 328insert into s values (7,8,5); 329insert into s values (7,8,4); 330insert into s values (7,8,3); 331insert into s values (7,8,2); 332insert into s values (7,8,1); 333insert into s values (7,7,10); 334insert into s values (7,7,9); 335insert into s values (7,7,8); 336insert into s values (7,7,7); 337insert into s values (7,7,6); 338insert into s values (7,7,5); 339insert into s values (7,7,4); 340insert into s values (7,7,3); 341insert into s values (7,7,2); 342insert into s values (7,7,1); 343insert into s values (7,6,10); 344insert into s values (7,6,9); 345insert into s values (7,6,8); 346insert into s values (7,6,7); 347insert into s values (7,6,6); 348insert into s values (7,6,5); 349insert into s values (7,6,4); 350insert into s values (7,6,3); 351insert into s values (7,6,2); 352insert into s values (7,6,1); 353insert into s values (7,5,10); 354insert into s values (7,5,9); 355insert into s values (7,5,8); 356insert into s values (7,5,7); 357insert into s values (7,5,6); 358insert into s values (7,5,5); 359insert into s values (7,5,4); 360insert into s values (7,5,3); 361insert into s values (7,5,2); 362insert into s values (7,5,1); 363insert into s values (7,4,10); 364insert into s values (7,4,9); 365insert into s values (7,4,8); 366insert into s values (7,4,7); 367insert into s values (7,4,6); 368insert into s values (7,4,5); 369insert into s values (7,4,4); 370insert into s values (7,4,3); 371insert into s values (7,4,2); 372insert into s values (7,4,1); 373insert into s values (7,3,10); 374insert into s values (7,3,9); 375insert into s values (7,3,8); 376insert into s values (7,3,7); 377insert into s values (7,3,6); 378insert into s values (7,3,5); 379insert into s values (7,3,4); 380insert into s values (7,3,3); 381insert into s values (7,3,2); 382insert into s values (7,3,1); 383insert into s values (7,2,10); 384insert into s values (7,2,9); 385insert into s values (7,2,8); 386insert into s values (7,2,7); 387insert into s values (7,2,6); 388insert into s values (7,2,5); 389insert into s values (7,2,4); 390insert into s values (7,2,3); 391insert into s values (7,2,2); 392insert into s values (7,2,1); 393insert into s values (7,1,10); 394insert into s values (7,1,9); 395insert into s values (7,1,8); 396insert into s values (7,1,7); 397insert into s values (7,1,6); 398insert into s values (7,1,5); 399insert into s values (7,1,4); 400insert into s values (7,1,3); 401insert into s values (7,1,2); 402insert into s values (7,1,1); 403insert into s values (6,10,10); 404insert into s values (6,10,9); 405insert into s values (6,10,8); 406insert into s values (6,10,7); 407insert into s values (6,10,6); 408insert into s values (6,10,5); 409insert into s values (6,10,4); 410insert into s values (6,10,3); 411insert into s values (6,10,2); 412insert into s values (6,10,1); 413insert into s values (6,9,10); 414insert into s values (6,9,9); 415insert into s values (6,9,8); 416insert into s values (6,9,7); 417insert into s values (6,9,6); 418insert into s values (6,9,5); 419insert into s values (6,9,4); 420insert into s values (6,9,3); 421insert into s values (6,9,2); 422insert into s values (6,9,1); 423insert into s values (6,8,10); 424insert into s values (6,8,9); 425insert into s values (6,8,8); 426insert into s values (6,8,7); 427insert into s values (6,8,6); 428insert into s values (6,8,5); 429insert into s values (6,8,4); 430insert into s values (6,8,3); 431insert into s values (6,8,2); 432insert into s values (6,8,1); 433insert into s values (6,7,10); 434insert into s values (6,7,9); 435insert into s values (6,7,8); 436insert into s values (6,7,7); 437insert into s values (6,7,6); 438insert into s values (6,7,5); 439insert into s values (6,7,4); 440insert into s values (6,7,3); 441insert into s values (6,7,2); 442insert into s values (6,7,1); 443insert into s values (6,6,10); 444insert into s values (6,6,9); 445insert into s values (6,6,8); 446insert into s values (6,6,7); 447insert into s values (6,6,6); 448insert into s values (6,6,5); 449insert into s values (6,6,4); 450insert into s values (6,6,3); 451insert into s values (6,6,2); 452insert into s values (6,6,1); 453insert into s values (6,5,10); 454insert into s values (6,5,9); 455insert into s values (6,5,8); 456insert into s values (6,5,7); 457insert into s values (6,5,6); 458insert into s values (6,5,5); 459insert into s values (6,5,4); 460insert into s values (6,5,3); 461insert into s values (6,5,2); 462insert into s values (6,5,1); 463insert into s values (6,4,10); 464insert into s values (6,4,9); 465insert into s values (6,4,8); 466insert into s values (6,4,7); 467insert into s values (6,4,6); 468insert into s values (6,4,5); 469insert into s values (6,4,4); 470insert into s values (6,4,3); 471insert into s values (6,4,2); 472insert into s values (6,4,1); 473insert into s values (6,3,10); 474insert into s values (6,3,9); 475insert into s values (6,3,8); 476insert into s values (6,3,7); 477insert into s values (6,3,6); 478insert into s values (6,3,5); 479insert into s values (6,3,4); 480insert into s values (6,3,3); 481insert into s values (6,3,2); 482insert into s values (6,3,1); 483insert into s values (6,2,10); 484insert into s values (6,2,9); 485insert into s values (6,2,8); 486insert into s values (6,2,7); 487insert into s values (6,2,6); 488insert into s values (6,2,5); 489insert into s values (6,2,4); 490insert into s values (6,2,3); 491insert into s values (6,2,2); 492insert into s values (6,2,1); 493insert into s values (6,1,10); 494insert into s values (6,1,9); 495insert into s values (6,1,8); 496insert into s values (6,1,7); 497insert into s values (6,1,6); 498insert into s values (6,1,5); 499insert into s values (6,1,4); 500insert into s values (6,1,3); 501insert into s values (6,1,2); 502insert into s values (6,1,1); 503insert into s values (5,10,10); 504insert into s values (5,10,9); 505insert into s values (5,10,8); 506insert into s values (5,10,7); 507insert into s values (5,10,6); 508insert into s values (5,10,5); 509insert into s values (5,10,4); 510insert into s values (5,10,3); 511insert into s values (5,10,2); 512insert into s values (5,10,1); 513insert into s values (5,9,10); 514insert into s values (5,9,9); 515insert into s values (5,9,8); 516insert into s values (5,9,7); 517insert into s values (5,9,6); 518insert into s values (5,9,5); 519insert into s values (5,9,4); 520insert into s values (5,9,3); 521insert into s values (5,9,2); 522insert into s values (5,9,1); 523insert into s values (5,8,10); 524insert into s values (5,8,9); 525insert into s values (5,8,8); 526insert into s values (5,8,7); 527insert into s values (5,8,6); 528insert into s values (5,8,5); 529insert into s values (5,8,4); 530insert into s values (5,8,3); 531insert into s values (5,8,2); 532insert into s values (5,8,1); 533insert into s values (5,7,10); 534insert into s values (5,7,9); 535insert into s values (5,7,8); 536insert into s values (5,7,7); 537insert into s values (5,7,6); 538insert into s values (5,7,5); 539insert into s values (5,7,4); 540insert into s values (5,7,3); 541insert into s values (5,7,2); 542insert into s values (5,7,1); 543insert into s values (5,6,10); 544insert into s values (5,6,9); 545insert into s values (5,6,8); 546insert into s values (5,6,7); 547insert into s values (5,6,6); 548insert into s values (5,6,5); 549insert into s values (5,6,4); 550insert into s values (5,6,3); 551insert into s values (5,6,2); 552insert into s values (5,6,1); 553insert into s values (5,5,10); 554insert into s values (5,5,9); 555insert into s values (5,5,8); 556insert into s values (5,5,7); 557insert into s values (5,5,6); 558insert into s values (5,5,5); 559insert into s values (5,5,4); 560insert into s values (5,5,3); 561insert into s values (5,5,2); 562insert into s values (5,5,1); 563insert into s values (5,4,10); 564insert into s values (5,4,9); 565insert into s values (5,4,8); 566insert into s values (5,4,7); 567insert into s values (5,4,6); 568insert into s values (5,4,5); 569insert into s values (5,4,4); 570insert into s values (5,4,3); 571insert into s values (5,4,2); 572insert into s values (5,4,1); 573insert into s values (5,3,10); 574insert into s values (5,3,9); 575insert into s values (5,3,8); 576insert into s values (5,3,7); 577insert into s values (5,3,6); 578insert into s values (5,3,5); 579insert into s values (5,3,4); 580insert into s values (5,3,3); 581insert into s values (5,3,2); 582insert into s values (5,3,1); 583insert into s values (5,2,10); 584insert into s values (5,2,9); 585insert into s values (5,2,8); 586insert into s values (5,2,7); 587insert into s values (5,2,6); 588insert into s values (5,2,5); 589insert into s values (5,2,4); 590insert into s values (5,2,3); 591insert into s values (5,2,2); 592insert into s values (5,2,1); 593insert into s values (5,1,10); 594insert into s values (5,1,9); 595insert into s values (5,1,8); 596insert into s values (5,1,7); 597insert into s values (5,1,6); 598insert into s values (5,1,5); 599insert into s values (5,1,4); 600insert into s values (5,1,3); 601insert into s values (5,1,2); 602insert into s values (5,1,1); 603insert into s values (4,10,10); 604insert into s values (4,10,9); 605insert into s values (4,10,8); 606insert into s values (4,10,7); 607insert into s values (4,10,6); 608insert into s values (4,10,5); 609insert into s values (4,10,4); 610insert into s values (4,10,3); 611insert into s values (4,10,2); 612insert into s values (4,10,1); 613insert into s values (4,9,10); 614insert into s values (4,9,9); 615insert into s values (4,9,8); 616insert into s values (4,9,7); 617insert into s values (4,9,6); 618insert into s values (4,9,5); 619insert into s values (4,9,4); 620insert into s values (4,9,3); 621insert into s values (4,9,2); 622insert into s values (4,9,1); 623insert into s values (4,8,10); 624insert into s values (4,8,9); 625insert into s values (4,8,8); 626insert into s values (4,8,7); 627insert into s values (4,8,6); 628insert into s values (4,8,5); 629insert into s values (4,8,4); 630insert into s values (4,8,3); 631insert into s values (4,8,2); 632insert into s values (4,8,1); 633insert into s values (4,7,10); 634insert into s values (4,7,9); 635insert into s values (4,7,8); 636insert into s values (4,7,7); 637insert into s values (4,7,6); 638insert into s values (4,7,5); 639insert into s values (4,7,4); 640insert into s values (4,7,3); 641insert into s values (4,7,2); 642insert into s values (4,7,1); 643insert into s values (4,6,10); 644insert into s values (4,6,9); 645insert into s values (4,6,8); 646insert into s values (4,6,7); 647insert into s values (4,6,6); 648insert into s values (4,6,5); 649insert into s values (4,6,4); 650insert into s values (4,6,3); 651insert into s values (4,6,2); 652insert into s values (4,6,1); 653insert into s values (4,5,10); 654insert into s values (4,5,9); 655insert into s values (4,5,8); 656insert into s values (4,5,7); 657insert into s values (4,5,6); 658insert into s values (4,5,5); 659insert into s values (4,5,4); 660insert into s values (4,5,3); 661insert into s values (4,5,2); 662insert into s values (4,5,1); 663insert into s values (4,4,10); 664insert into s values (4,4,9); 665insert into s values (4,4,8); 666insert into s values (4,4,7); 667insert into s values (4,4,6); 668insert into s values (4,4,5); 669insert into s values (4,4,4); 670insert into s values (4,4,3); 671insert into s values (4,4,2); 672insert into s values (4,4,1); 673insert into s values (4,3,10); 674insert into s values (4,3,9); 675insert into s values (4,3,8); 676insert into s values (4,3,7); 677insert into s values (4,3,6); 678insert into s values (4,3,5); 679insert into s values (4,3,4); 680insert into s values (4,3,3); 681insert into s values (4,3,2); 682insert into s values (4,3,1); 683insert into s values (4,2,10); 684insert into s values (4,2,9); 685insert into s values (4,2,8); 686insert into s values (4,2,7); 687insert into s values (4,2,6); 688insert into s values (4,2,5); 689insert into s values (4,2,4); 690insert into s values (4,2,3); 691insert into s values (4,2,2); 692insert into s values (4,2,1); 693insert into s values (4,1,10); 694insert into s values (4,1,9); 695insert into s values (4,1,8); 696insert into s values (4,1,7); 697insert into s values (4,1,6); 698insert into s values (4,1,5); 699insert into s values (4,1,4); 700insert into s values (4,1,3); 701insert into s values (4,1,2); 702insert into s values (4,1,1); 703insert into s values (3,10,10); 704insert into s values (3,10,9); 705insert into s values (3,10,8); 706insert into s values (3,10,7); 707insert into s values (3,10,6); 708insert into s values (3,10,5); 709insert into s values (3,10,4); 710insert into s values (3,10,3); 711insert into s values (3,10,2); 712insert into s values (3,10,1); 713insert into s values (3,9,10); 714insert into s values (3,9,9); 715insert into s values (3,9,8); 716insert into s values (3,9,7); 717insert into s values (3,9,6); 718insert into s values (3,9,5); 719insert into s values (3,9,4); 720insert into s values (3,9,3); 721insert into s values (3,9,2); 722insert into s values (3,9,1); 723insert into s values (3,8,10); 724insert into s values (3,8,9); 725insert into s values (3,8,8); 726insert into s values (3,8,7); 727insert into s values (3,8,6); 728insert into s values (3,8,5); 729insert into s values (3,8,4); 730insert into s values (3,8,3); 731insert into s values (3,8,2); 732insert into s values (3,8,1); 733insert into s values (3,7,10); 734insert into s values (3,7,9); 735insert into s values (3,7,8); 736insert into s values (3,7,7); 737insert into s values (3,7,6); 738insert into s values (3,7,5); 739insert into s values (3,7,4); 740insert into s values (3,7,3); 741insert into s values (3,7,2); 742insert into s values (3,7,1); 743insert into s values (3,6,10); 744insert into s values (3,6,9); 745insert into s values (3,6,8); 746insert into s values (3,6,7); 747insert into s values (3,6,6); 748insert into s values (3,6,5); 749insert into s values (3,6,4); 750insert into s values (3,6,3); 751insert into s values (3,6,2); 752insert into s values (3,6,1); 753insert into s values (3,5,10); 754insert into s values (3,5,9); 755insert into s values (3,5,8); 756insert into s values (3,5,7); 757insert into s values (3,5,6); 758insert into s values (3,5,5); 759insert into s values (3,5,4); 760insert into s values (3,5,3); 761insert into s values (3,5,2); 762insert into s values (3,5,1); 763insert into s values (3,4,10); 764insert into s values (3,4,9); 765insert into s values (3,4,8); 766insert into s values (3,4,7); 767insert into s values (3,4,6); 768insert into s values (3,4,5); 769insert into s values (3,4,4); 770insert into s values (3,4,3); 771insert into s values (3,4,2); 772insert into s values (3,4,1); 773insert into s values (3,3,10); 774insert into s values (3,3,9); 775insert into s values (3,3,8); 776insert into s values (3,3,7); 777insert into s values (3,3,6); 778insert into s values (3,3,5); 779insert into s values (3,3,4); 780insert into s values (3,3,3); 781insert into s values (3,3,2); 782insert into s values (3,3,1); 783insert into s values (3,2,10); 784insert into s values (3,2,9); 785insert into s values (3,2,8); 786insert into s values (3,2,7); 787insert into s values (3,2,6); 788insert into s values (3,2,5); 789insert into s values (3,2,4); 790insert into s values (3,2,3); 791insert into s values (3,2,2); 792insert into s values (3,2,1); 793insert into s values (3,1,10); 794insert into s values (3,1,9); 795insert into s values (3,1,8); 796insert into s values (3,1,7); 797insert into s values (3,1,6); 798insert into s values (3,1,5); 799insert into s values (3,1,4); 800insert into s values (3,1,3); 801insert into s values (3,1,2); 802insert into s values (3,1,1); 803insert into s values (2,10,10); 804insert into s values (2,10,9); 805insert into s values (2,10,8); 806insert into s values (2,10,7); 807insert into s values (2,10,6); 808insert into s values (2,10,5); 809insert into s values (2,10,4); 810insert into s values (2,10,3); 811insert into s values (2,10,2); 812insert into s values (2,10,1); 813insert into s values (2,9,10); 814insert into s values (2,9,9); 815insert into s values (2,9,8); 816insert into s values (2,9,7); 817insert into s values (2,9,6); 818insert into s values (2,9,5); 819insert into s values (2,9,4); 820insert into s values (2,9,3); 821insert into s values (2,9,2); 822insert into s values (2,9,1); 823insert into s values (2,8,10); 824insert into s values (2,8,9); 825insert into s values (2,8,8); 826insert into s values (2,8,7); 827insert into s values (2,8,6); 828insert into s values (2,8,5); 829insert into s values (2,8,4); 830insert into s values (2,8,3); 831insert into s values (2,8,2); 832insert into s values (2,8,1); 833insert into s values (2,7,10); 834insert into s values (2,7,9); 835insert into s values (2,7,8); 836insert into s values (2,7,7); 837insert into s values (2,7,6); 838insert into s values (2,7,5); 839insert into s values (2,7,4); 840insert into s values (2,7,3); 841insert into s values (2,7,2); 842insert into s values (2,7,1); 843insert into s values (2,6,10); 844insert into s values (2,6,9); 845insert into s values (2,6,8); 846insert into s values (2,6,7); 847insert into s values (2,6,6); 848insert into s values (2,6,5); 849insert into s values (2,6,4); 850insert into s values (2,6,3); 851insert into s values (2,6,2); 852insert into s values (2,6,1); 853insert into s values (2,5,10); 854insert into s values (2,5,9); 855insert into s values (2,5,8); 856insert into s values (2,5,7); 857insert into s values (2,5,6); 858insert into s values (2,5,5); 859insert into s values (2,5,4); 860insert into s values (2,5,3); 861insert into s values (2,5,2); 862insert into s values (2,5,1); 863insert into s values (2,4,10); 864insert into s values (2,4,9); 865insert into s values (2,4,8); 866insert into s values (2,4,7); 867insert into s values (2,4,6); 868insert into s values (2,4,5); 869insert into s values (2,4,4); 870insert into s values (2,4,3); 871insert into s values (2,4,2); 872insert into s values (2,4,1); 873insert into s values (2,3,10); 874insert into s values (2,3,9); 875insert into s values (2,3,8); 876insert into s values (2,3,7); 877insert into s values (2,3,6); 878insert into s values (2,3,5); 879insert into s values (2,3,4); 880insert into s values (2,3,3); 881insert into s values (2,3,2); 882insert into s values (2,3,1); 883insert into s values (2,2,10); 884insert into s values (2,2,9); 885insert into s values (2,2,8); 886insert into s values (2,2,7); 887insert into s values (2,2,6); 888insert into s values (2,2,5); 889insert into s values (2,2,4); 890insert into s values (2,2,3); 891insert into s values (2,2,2); 892insert into s values (2,2,1); 893insert into s values (2,1,10); 894insert into s values (2,1,9); 895insert into s values (2,1,8); 896insert into s values (2,1,7); 897insert into s values (2,1,6); 898insert into s values (2,1,5); 899insert into s values (2,1,4); 900insert into s values (2,1,3); 901insert into s values (2,1,2); 902insert into s values (2,1,1); 903insert into s values (1,10,10); 904insert into s values (1,10,9); 905insert into s values (1,10,8); 906insert into s values (1,10,7); 907insert into s values (1,10,6); 908insert into s values (1,10,5); 909insert into s values (1,10,4); 910insert into s values (1,10,3); 911insert into s values (1,10,2); 912insert into s values (1,10,1); 913insert into s values (1,9,10); 914insert into s values (1,9,9); 915insert into s values (1,9,8); 916insert into s values (1,9,7); 917insert into s values (1,9,6); 918insert into s values (1,9,5); 919insert into s values (1,9,4); 920insert into s values (1,9,3); 921insert into s values (1,9,2); 922insert into s values (1,9,1); 923insert into s values (1,8,10); 924insert into s values (1,8,9); 925insert into s values (1,8,8); 926insert into s values (1,8,7); 927insert into s values (1,8,6); 928insert into s values (1,8,5); 929insert into s values (1,8,4); 930insert into s values (1,8,3); 931insert into s values (1,8,2); 932insert into s values (1,8,1); 933insert into s values (1,7,10); 934insert into s values (1,7,9); 935insert into s values (1,7,8); 936insert into s values (1,7,7); 937insert into s values (1,7,6); 938insert into s values (1,7,5); 939insert into s values (1,7,4); 940insert into s values (1,7,3); 941insert into s values (1,7,2); 942insert into s values (1,7,1); 943insert into s values (1,6,10); 944insert into s values (1,6,9); 945insert into s values (1,6,8); 946insert into s values (1,6,7); 947insert into s values (1,6,6); 948insert into s values (1,6,5); 949insert into s values (1,6,4); 950insert into s values (1,6,3); 951insert into s values (1,6,2); 952insert into s values (1,6,1); 953insert into s values (1,5,10); 954insert into s values (1,5,9); 955insert into s values (1,5,8); 956insert into s values (1,5,7); 957insert into s values (1,5,6); 958insert into s values (1,5,5); 959insert into s values (1,5,4); 960insert into s values (1,5,3); 961insert into s values (1,5,2); 962insert into s values (1,5,1); 963insert into s values (1,4,10); 964insert into s values (1,4,9); 965insert into s values (1,4,8); 966insert into s values (1,4,7); 967insert into s values (1,4,6); 968insert into s values (1,4,5); 969insert into s values (1,4,4); 970insert into s values (1,4,3); 971insert into s values (1,4,2); 972insert into s values (1,4,1); 973insert into s values (1,3,10); 974insert into s values (1,3,9); 975insert into s values (1,3,8); 976insert into s values (1,3,7); 977insert into s values (1,3,6); 978insert into s values (1,3,5); 979insert into s values (1,3,4); 980insert into s values (1,3,3); 981insert into s values (1,3,2); 982insert into s values (1,3,1); 983insert into s values (1,2,10); 984insert into s values (1,2,9); 985insert into s values (1,2,8); 986insert into s values (1,2,7); 987insert into s values (1,2,6); 988insert into s values (1,2,5); 989insert into s values (1,2,4); 990insert into s values (1,2,3); 991insert into s values (1,2,2); 992insert into s values (1,2,1); 993insert into s values (1,1,10); 994insert into s values (1,1,9); 995insert into s values (1,1,8); 996insert into s values (1,1,7); 997insert into s values (1,1,6); 998insert into s values (1,1,5); 999insert into s values (1,1,4); 1000insert into s values (1,1,3); 1001insert into s values (1,1,2); 1002insert into s values (1,1,1); 1003drop table if exists t; 1004create table t like s; 1005insert into t select * from s; 1006drop table if exists u; 1007create table u like s; 1008insert into u select * from s; 1009show create table s; 1010Table Create Table 1011s CREATE TABLE `s` ( 1012 `a` int(11) DEFAULT NULL, 1013 `b` int(11) DEFAULT NULL, 1014 `c` int(11) DEFAULT NULL 1015) ENGINE=TokuDB DEFAULT CHARSET=latin1 1016show create table t; 1017Table Create Table 1018t CREATE TABLE `t` ( 1019 `a` int(11) DEFAULT NULL, 1020 `b` int(11) DEFAULT NULL, 1021 `c` int(11) DEFAULT NULL 1022) ENGINE=TokuDB DEFAULT CHARSET=latin1 1023show create table u; 1024Table Create Table 1025u CREATE TABLE `u` ( 1026 `a` int(11) DEFAULT NULL, 1027 `b` int(11) DEFAULT NULL, 1028 `c` int(11) DEFAULT NULL 1029) ENGINE=TokuDB DEFAULT CHARSET=latin1 1030explain select straight_join * from s,t,u where s.b = t.b and s.c = t.c; 1031id select_type table type possible_keys key key_len ref rows Extra 10321 SIMPLE s ALL NULL NULL NULL NULL 1000 10331 SIMPLE t ALL NULL NULL NULL NULL 1000 Using where; Using join buffer (flat, BNL join) 10341 SIMPLE u ALL NULL NULL NULL NULL 1000 Using join buffer (incremental, BNL join) 1035alter table s add key (b); 1036alter table t add key (b); 1037alter table u add key (c); 1038show create table s; 1039Table Create Table 1040s CREATE TABLE `s` ( 1041 `a` int(11) DEFAULT NULL, 1042 `b` int(11) DEFAULT NULL, 1043 `c` int(11) DEFAULT NULL, 1044 KEY `b` (`b`) 1045) ENGINE=TokuDB DEFAULT CHARSET=latin1 1046show create table t; 1047Table Create Table 1048t CREATE TABLE `t` ( 1049 `a` int(11) DEFAULT NULL, 1050 `b` int(11) DEFAULT NULL, 1051 `c` int(11) DEFAULT NULL, 1052 KEY `b` (`b`) 1053) ENGINE=TokuDB DEFAULT CHARSET=latin1 1054show create table u; 1055Table Create Table 1056u CREATE TABLE `u` ( 1057 `a` int(11) DEFAULT NULL, 1058 `b` int(11) DEFAULT NULL, 1059 `c` int(11) DEFAULT NULL, 1060 KEY `c` (`c`) 1061) ENGINE=TokuDB DEFAULT CHARSET=latin1 1062explain select straight_join * from s,t,u where s.b = t.b and s.c = u.c; 1063id select_type table type possible_keys key key_len ref rows Extra 10641 SIMPLE s ALL b NULL NULL NULL 1000 Using where 10651 SIMPLE t ref b b 5 test.s.b 1 10661 SIMPLE u ref c c 5 test.s.c 1 1067alter table s add key (b) clustering=yes; 1068Warnings: 1069Note 1831 Duplicate index `b_2`. This is deprecated and will be disallowed in a future release 1070alter table t add key (b) clustering=yes; 1071Warnings: 1072Note 1831 Duplicate index `b_2`. This is deprecated and will be disallowed in a future release 1073alter table u add key (c) clustering=yes; 1074Warnings: 1075Note 1831 Duplicate index `c_2`. This is deprecated and will be disallowed in a future release 1076show create table s; 1077Table Create Table 1078s CREATE TABLE `s` ( 1079 `a` int(11) DEFAULT NULL, 1080 `b` int(11) DEFAULT NULL, 1081 `c` int(11) DEFAULT NULL, 1082 KEY `b` (`b`), 1083 KEY `b_2` (`b`) `clustering`=yes 1084) ENGINE=TokuDB DEFAULT CHARSET=latin1 1085show create table t; 1086Table Create Table 1087t CREATE TABLE `t` ( 1088 `a` int(11) DEFAULT NULL, 1089 `b` int(11) DEFAULT NULL, 1090 `c` int(11) DEFAULT NULL, 1091 KEY `b` (`b`), 1092 KEY `b_2` (`b`) `clustering`=yes 1093) ENGINE=TokuDB DEFAULT CHARSET=latin1 1094show create table u; 1095Table Create Table 1096u CREATE TABLE `u` ( 1097 `a` int(11) DEFAULT NULL, 1098 `b` int(11) DEFAULT NULL, 1099 `c` int(11) DEFAULT NULL, 1100 KEY `c` (`c`), 1101 KEY `c_2` (`c`) `clustering`=yes 1102) ENGINE=TokuDB DEFAULT CHARSET=latin1 1103explain select straight_join * from s,t,u where s.b = t.b and s.c = u.c; 1104id select_type table type possible_keys key key_len ref rows Extra 11051 SIMPLE s ALL b,b_2 NULL NULL NULL 1000 Using where 11061 SIMPLE t ref b,b_2 b_2 5 test.s.b 1 Using index 11071 SIMPLE u ref c,c_2 c_2 5 test.s.c 1 Using index 1108drop table s,t,u; 1109