« back to all changes in this revision
Viewing changes to tests/r/pool_of_threads.result
- browse files at revision 1094
- compare with another revision
- compare with revision 1089
- download diff
- download tarball
- view history from revision 1094
- Committer: Brian Aker
- Date: 2009-07-12 00:49:18 UTC
- mfrom: (1063.9.51 brian-tmp-fix)
- Revision ID: brian@gaz-20090712004918-chprmyj387ex6l8a
Merge Stewart
- files removed:
- tests/r/drizzlecheck.result
- files renamed:
- tests/r/rollback.result => tests/r/myisam_rollback.result
- tests/t/rollback.test => tests/t/myisam_rollback.test
- files modified:
- drizzled/base.h
added
removed
tests/r/pool_of_threads.result
2
2
CREATE TABLE t1 (
3
3
Period int DEFAULT '0000' NOT NULL,
4
4
Varor_period int DEFAULT '0' NOT NULL
5
) ENGINE=myisam;
5
);
6
6
INSERT INTO t1 VALUES (9410,9412);
7
7
select period from t1;
8
8
period
24
24
UNIQUE fld1 (fld1),
25
25
KEY fld3 (fld3),
26
26
PRIMARY KEY (auto)
27
) ENGINE=myisam;
27
);
28
28
select t2.fld3 from t2 where companynr = 58 and fld3 like "%imaginable%";
29
29
fld3
30
30
imaginable
128
128
fld3
129
129
explain select t2.fld3 from t2 where fld3 = 'honeysuckle';
130
130
id select_type table type possible_keys key key_len ref rows Extra
131
1 SIMPLE t2 ref fld3 fld3 122 const 1 Using where; Using index
131
1 SIMPLE t2 ref fld3 fld3 122 const # Using where; Using index
132
132
explain select fld3 from t2 ignore index (fld3) where fld3 = 'honeysuckle';
133
133
id select_type table type possible_keys key key_len ref rows Extra
134
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where
134
1 SIMPLE t2 ALL NULL NULL NULL NULL # Using where
135
135
explain select fld3 from t2 use index (fld1) where fld3 = 'honeysuckle';
136
136
id select_type table type possible_keys key key_len ref rows Extra
137
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where
137
1 SIMPLE t2 ALL NULL NULL NULL NULL # Using where
138
138
explain select fld3 from t2 use index (fld3) where fld3 = 'honeysuckle';
139
139
id select_type table type possible_keys key key_len ref rows Extra
140
1 SIMPLE t2 ref fld3 fld3 122 const 1 Using where; Using index
140
1 SIMPLE t2 ref fld3 fld3 122 const # Using where; Using index
141
141
explain select fld3 from t2 use index (fld1,fld3) where fld3 = 'honeysuckle';
142
142
id select_type table type possible_keys key key_len ref rows Extra
143
1 SIMPLE t2 ref fld3 fld3 122 const 1 Using where; Using index
143
1 SIMPLE t2 ref fld3 fld3 122 const # Using where; Using index
144
144
explain select fld3 from t2 ignore index (fld3,not_used);
145
145
ERROR 42000: Key 'not_used' doesn't exist in table 't2'
146
146
explain select fld3 from t2 use index (not_used);
151
151
honoring
152
152
explain select t2.fld3 from t2 where fld3 >= 'honeysuckle' and fld3 <= 'honoring' order by fld3;
153
153
id select_type table type possible_keys key key_len ref rows Extra
154
1 SIMPLE t2 range fld3 fld3 122 NULL 2 Using where; Using index
154
1 SIMPLE t2 range fld3 fld3 122 NULL # Using where; Using index
155
155
select fld1,fld3 from t2 where fld3="Colombo" or fld3 = "nondecreasing" order by fld3;
156
156
fld1 fld3
157
157
148504 Colombo
171
171
250502
172
172
explain select fld1 from t2 where fld1=250501 or fld1="250502";
173
173
id select_type table type possible_keys key key_len ref rows Extra
174
1 SIMPLE t2 range fld1 fld1 4 NULL 2 Using where; Using index
174
1 SIMPLE t2 range fld1 fld1 4 NULL # Using where; Using index
175
175
select fld1 from t2 where fld1=250501 or fld1=250502 or fld1 >= 250505 and fld1 <= 250601 or fld1 between 250501 and 250502;
176
176
fld1
177
177
250501
180
180
250601
181
181
explain select fld1 from t2 where fld1=250501 or fld1=250502 or fld1 >= 250505 and fld1 <= 250601 or fld1 between 250501 and 250502;
182
182
id select_type table type possible_keys key key_len ref rows Extra
183
1 SIMPLE t2 range fld1 fld1 4 NULL 4 Using where; Using index
183
1 SIMPLE t2 range fld1 fld1 4 NULL # Using where; Using index
184
184
select fld1,fld3 from t2 where companynr = 37 and fld3 like 'f%';
185
185
fld1 fld3
186
186
12001 flanking
275
275
34
276
276
29
277
277
0
278
select distinct t2.fld3,period from t2,t1 where companynr=37 and fld3 like "O%";
278
select distinct t2.fld3,period from t2,t1 where companynr=37 and fld3 like "O%" ORDER BY t2.fld3,period;
279
279
fld3 period
280
280
obliterates 9410
281
281
offload 9410
355
355
uprisings
356
356
versatility
357
357
vest
358
select distinct fld3 from t2 limit 10;
358
select distinct fld3 from t2 ORDER BY fld3 limit 10;
359
359
fld3
360
360
abates
361
361
abiding
443
443
awe
444
444
aye
445
445
Azt
446
select distinct substring(fld3,1,3) as a from t2 having a like "A%" order by a limit 10;
446
select distinct lower(substring(fld3,1,3)) as a from t2 having a like "A%" order by a limit 10;
447
447
a
448
448
aba
449
449
abi
450
Abr
450
abr
451
451
abs
452
452
abu
453
453
acc
454
454
acq
455
455
acu
456
Ade
456
ade
457
457
adj
458
458
select distinct substring(fld3,1,3) from t2 where fld3 like "A%" limit 10;
459
459
substring(fld3,1,3)
467
467
acu
468
468
Ade
469
469
adj
470
select distinct substring(fld3,1,3) as a from t2 having a like "A%" limit 10;
471
a
472
aba
473
abi
474
Abr
475
abs
476
abu
477
acc
478
acq
479
acu
480
Ade
481
adj
482
470
create table t3 (
483
471
period int not null,
484
472
name char(32) not null,
487
475
price2 double(11,0),
488
476
key (period),
489
477
key (name)
490
) engine=myisam;
478
);
491
479
create temporary table tmp engine = myisam select * from t3;
492
480
insert into t3 select * from tmp;
493
481
insert into tmp select * from t3;
593
581
fld3
594
582
explain select t3.t2nr,fld3 from t2,t3 where t2.companynr = 34 and t2.fld1=t3.t2nr order by t3.t2nr,fld3;
595
583
id select_type table type possible_keys key key_len ref rows Extra
596
1 SIMPLE t2 ALL fld1 NULL NULL NULL 1199 Using where; Using temporary; Using filesort
597
1 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t2.fld1 1 Using index
584
1 SIMPLE t2 ALL fld1 NULL NULL NULL # Using where; Using temporary; Using filesort
585
1 SIMPLE t3 eq_ref PRIMARY PRIMARY 4 test.t2.fld1 # Using index
598
586
explain select * from t3 as t1,t3 where t1.period=t3.period order by t3.period;
599
587
id select_type table type possible_keys key key_len ref rows Extra
600
1 SIMPLE t1 ALL period NULL NULL NULL 41810 Using temporary; Using filesort
601
1 SIMPLE t3 ref period period 4 test.t1.period 4181
588
1 SIMPLE t1 ALL period NULL NULL NULL # Using temporary; Using filesort
589
1 SIMPLE t3 ref period period 4 test.t1.period #
602
590
explain select * from t3 as t1,t3 where t1.period=t3.period order by t3.period limit 10;
603
591
id select_type table type possible_keys key key_len ref rows Extra
604
1 SIMPLE t3 index period period 4 NULL 1
605
1 SIMPLE t1 ref period period 4 test.t3.period 4181
592
1 SIMPLE t3 index period period 4 NULL #
593
1 SIMPLE t1 ref period period 4 test.t3.period #
606
594
explain select * from t3 as t1,t3 where t1.period=t3.period order by t1.period limit 10;
607
595
id select_type table type possible_keys key key_len ref rows Extra
608
1 SIMPLE t1 index period period 4 NULL 1
609
1 SIMPLE t3 ref period period 4 test.t1.period 4181
596
1 SIMPLE t1 index period period 4 NULL #
597
1 SIMPLE t3 ref period period 4 test.t1.period #
610
598
select period from t1;
611
599
period
612
600
9410
620
608
breaking 1001
621
609
explain select fld3,period from t2,t3 where t2.fld1 = 011401 and t3.t2nr=t2.fld1 and 1001 = t3.period;
622
610
id select_type table type possible_keys key key_len ref rows Extra
623
1 SIMPLE t2 const fld1 fld1 4 const 1
624
1 SIMPLE t3 const PRIMARY,period PRIMARY 4 const 1
611
1 SIMPLE t2 const fld1 fld1 4 const #
612
1 SIMPLE t3 const PRIMARY,period PRIMARY 4 const #
625
613
select fld3,period from t2,t1 where companynr*10 = 37*10;
626
614
fld3 period
627
breaking 9410
628
Romans 9410
629
intercepted 9410
630
bewilderingly 9410
631
astound 9410
632
admonishing 9410
633
sumac 9410
634
flanking 9410
635
combed 9410
636
subjective 9410
637
scatterbrain 9410
615
Abraham 9410
616
Aden 9410
617
Adolph 9410
618
Aldrich 9410
619
Alison 9410
620
Anatole 9410
621
Antarctica 9410
622
Antares 9410
623
Arabia 9410
624
Artemia 9410
625
Augustine 9410
626
Baird 9410
627
Beebe 9410
628
Butterfield 9410
629
CERN 9410
630
Cassites 9410
631
Chicana 9410
632
Chippewa 9410
633
Clayton 9410
634
Conley 9410
635
Connally 9410
636
Crays 9410
637
DiMaggio 9410
638
Dutchman 9410
638
639
Eulerian 9410
640
Evanston 9410
641
Everhart 9410
642
Fenton 9410
643
Fitzpatrick 9410
644
Galatean 9410
645
Gandhian 9410
646
Ganymede 9410
647
Goldstine 9410
648
Gothicism 9410
649
Graves 9410
650
Greenberg 9410
651
Gurkha 9410
652
Hawaii 9410
653
Hegelian 9410
654
Hornblower 9410
655
Huffman 9410
656
Hunter 9410
657
Joplin 9410
658
Judas 9410
639
659
Kane 9410
640
overlay 9410
641
perturb 9410
642
goblins 9410
643
annihilates 9410
660
Kantian 9410
661
Kevin 9410
662
Kinsey 9410
663
Kline 9410
664
Lars 9410
665
Latinizes 9410
666
Lillian 9410
667
Lizzy 9410
668
Majorca 9410
669
Manhattanize 9410
670
McGovern 9410
671
Melinda 9410
672
Merritt 9410
673
Micronesia 9410
674
Miles 9410
675
Miltonism 9410
676
Nabisco 9410
677
Nazis 9410
678
Newtonian 9410
679
Norwalk 9410
680
Pandora 9410
681
Parsifal 9410
682
Peruvian 9410
683
Punjab 9410
684
Pyle 9410
685
Quixotism 9410
686
Romano 9410
687
Romans 9410
688
Sabine 9410
689
Sault 9410
690
Saxony 9410
691
Selfridge 9410
692
Shanghais 9410
693
Simla 9410
694
Simon 9410
695
Stalin 9410
696
Steinberg 9410
697
Taoism 9410
698
Teresa 9410
699
Tipperary 9410
700
Weissmuller 9410
701
Winsett 9410
644
702
Wotan 9410
645
snatching 9410
646
concludes 9410
647
laterally 9410
648
yelped 9410
649
grazing 9410
650
Baird 9410
651
celery 9410
652
misunderstander 9410
653
handgun 9410
654
foldout 9410
655
mystic 9410
656
succumbed 9410
657
Nabisco 9410
658
fingerings 9410
703
abates 9410
704
abrogating 9410
705
accessed 9410
706
admiring 9410
707
admonishing 9410
708
afield 9410
709
afore 9410
659
710
aging 9410
660
afield 9410
711
airships 9410
712
alike 9410
713
allot 9410
714
already 9410
715
amenities 9410
661
716
ammonium 9410
662
boat 9410
663
intelligibility 9410
664
Augustine 9410
665
teethe 9410
666
dreaded 9410
667
scholastics 9410
717
analogy 9410
718
analyzable 9410
719
animals 9410
720
animized 9410
721
annihilates 9410
722
announced 9410
723
announces 9410
724
apiary 9410
725
appendixes 9410
726
appendixes 9410
727
appendixes 9410
728
appendixes 9410
729
appendixes 9410
730
appendixes 9410
731
arriving 9410
732
arteriole 9410
733
assails 9410
734
astound 9410
735
attainments 9410
736
attrition 9410
668
737
audiology 9410
669
wallet 9410
670
parters 9410
671
eschew 9410
672
quitter 9410
673
neat 9410
674
Steinberg 9410
675
jarring 9410
676
tinily 9410
738
avenge 9410
739
avoidable 9410
740
babies 9410
741
babysitting 9410
677
742
balled 9410
678
persist 9410
679
attainments 9410
680
fanatic 9410
681
measures 9410
682
rightfulness 9410
683
capably 9410
684
impulsive 9410
685
starlet 9410
686
terminators 9410
687
untying 9410
688
announces 9410
689
featherweight 9410
690
pessimist 9410
691
daughter 9410
692
decliner 9410
693
lawgiver 9410
694
stated 9410
695
readable 9410
696
attrition 9410
697
cascade 9410
698
motors 9410
699
interrogate 9410
700
pests 9410
701
stairway 9410
702
dopers 9410
703
testicle 9410
704
Parsifal 9410
705
leavings 9410
706
postulation 9410
707
squeaking 9410
708
contrasted 9410
709
leftover 9410
710
whiteners 9410
711
erases 9410
712
Punjab 9410
713
Merritt 9410
714
Quixotism 9410
715
sweetish 9410
716
dogging 9410
717
scornfully 9410
743
beaner 9410
744
beaters 9410
745
bee 9410
746
befouled 9410
718
747
bellow 9410
748
bestseller 9410
749
betroth 9410
750
bewilderingly 9410
719
751
bills 9410
720
cupboard 9410
721
sureties 9410
722
puddings 9410
723
fetters 9410
752
bitterroot 9410
724
753
bivalves 9410
725
incurring 9410
726
Adolph 9410
727
pithed 9410
728
Miles 9410
729
trimmings 9410
730
tragedies 9410
731
skulking 9410
732
flint 9410
733
flopping 9410
734
relaxing 9410
735
offload 9410
736
suites 9410
737
lists 9410
738
animized 9410
739
multilayer 9410
740
standardizes 9410
741
Judas 9410
742
vacuuming 9410
743
dentally 9410
744
humanness 9410
745
inch 9410
746
Weissmuller 9410
747
irresponsibly 9410
748
luckily 9410
749
culled 9410
750
medical 9410
754
bloater 9410
751
755
bloodbath 9410
752
subschema 9410
753
animals 9410
754
Micronesia 9410
755
repetitions 9410
756
Antares 9410
757
ventilate 9410
758
pityingly 9410
759
interdependent 9410
760
Graves 9410
761
neonatal 9410
756
boat 9410
757
boom 9410
758
boorish 9410
759
boulder 9410
760
breaking 9410
761
brunch 9410
762
buckboards 9410
763
burlesque 9410
764
cage 9410
765
capably 9410
766
capped 9410
767
cascade 9410
768
causality 9410
769
cautioned 9410
770
ceiling 9410
771
celery 9410
772
certificates 9410
762
773
chafe 9410
763
honoring 9410
764
realtor 9410
765
elite 9410
766
funereal 9410
767
abrogating 9410
768
sorters 9410
769
Conley 9410
770
lectured 9410
771
Abraham 9410
772
Hawaii 9410
773
cage 9410
774
hushes 9410
775
Simla 9410
776
reporters 9410
777
Dutchman 9410
778
descendants 9410
779
groupings 9410
780
dissociate 9410
774
chaperone 9410
775
charges 9410
776
chasm 9410
777
checkpoints 9410
778
chewing 9410
779
chews 9410
780
chillingly 9410
781
chronicle 9410
782
ciphers 9410
783
civics 9410
784
clamored 9410
785
clenched 9410
786
clockers 9410
781
787
coexist 9410
782
Beebe 9410
783
Taoism 9410
784
Connally 9410
785
fetched 9410
786
checkpoints 9410
787
rusting 9410
788
galling 9410
789
obliterates 9410
790
traitor 9410
791
resumes 9410
792
analyzable 9410
793
terminator 9410
794
gritty 9410
795
firearm 9410
796
minima 9410
797
Selfridge 9410
798
disable 9410
799
witchcraft 9410
800
betroth 9410
801
Manhattanize 9410
802
imprint 9410
803
peeked 9410
804
swelling 9410
805
interrelationships 9410
806
riser 9410
807
Gandhian 9410
808
peacock 9410
809
bee 9410
810
kanji 9410
811
dental 9410
812
scarf 9410
813
chasm 9410
814
insolence 9410
815
syndicate 9410
816
alike 9410
817
imperial 9410
788
cokes 9410
789
combed 9410
790
coming 9410
791
commencements 9410
792
commonplace 9410
793
communicants 9410
794
compartment 9410
795
comprehensive 9410
796
comprised 9410
797
conceptions 9410
798
concludes 9410
799
congregates 9410
800
contrary 9410
801
contrasted 9410
802
convenient 9410
818
803
convulsion 9410
819
railway 9410
820
validate 9410
821
normalizes 9410
822
comprehensive 9410
823
chewing 9410
804
corset 9410
805
count 9410
806
coverings 9410
807
craziness 9410
808
creak 9410
809
creek 9410
810
critiques 9410
811
crunches 9410
812
culled 9410
813
cult 9410
814
cupboard 9410
815
cured 9410
816
cute 9410
817
daughter 9410
818
decliner 9410
819
decomposition 9410
820
deductions 9410
821
dehydrate 9410
822
deludes 9410
824
823
denizen 9410
825
schemer 9410
826
chronicle 9410
827
Kline 9410
828
Anatole 9410
829
partridges 9410
830
brunch 9410
831
recruited 9410
824
denotative 9410
825
denounces 9410
826
dental 9410
827
dentally 9410
828
descendants 9410
829
despot 9410
830
destroyer 9410
831
detectably 9410
832
dialysis 9410
832
833
dimensions 9410
833
Chicana 9410
834
announced 9410
835
praised 9410
836
employing 9410
837
linear 9410
838
quagmire 9410
839
western 9410
840
relishing 9410
841
serving 9410
842
scheduling 9410
843
lore 9410
844
eventful 9410
845
arteriole 9410
834
disable 9410
835
discounts 9410
846
836
disentangle 9410
847
cured 9410
848
Fenton 9410
849
avoidable 9410
837
disobedience 9410
838
dissociate 9410
839
dogging 9410
840
dopers 9410
850
841
drains 9410
851
detectably 9410
852
husky 9410
853
impelling 9410
854
undoes 9410
842
dreaded 9410
843
ducks 9410
844
dusted 9410
845
effortlessly 9410
846
electroencephalography 9410
847
elite 9410
848
embassies 9410
849
employing 9410
850
encompass 9410
851
encompasses 9410
852
environing 9410
853
epistle 9410
854
equilibrium 9410
855
erases 9410
856
error 9410
857
eschew 9410
858
eternal 9410
855
859
evened 9410
856
squeezes 9410
857
destroyer 9410
858
rudeness 9410
859
beaner 9410
860
boorish 9410
861
Everhart 9410
862
encompass 9410
863
mushrooms 9410
864
Alison 9410
860
evenhandedly 9410
861
eventful 9410
862
excises 9410
863
exclamation 9410
864
excrete 9410
865
exhausts 9410
866
expelled 9410
867
extents 9410
865
868
externally 9410
866
pellagra 9410
867
cult 9410
868
creek 9410
869
Huffman 9410
870
Majorca 9410
871
governing 9410
872
gadfly 9410
873
reassigned 9410
874
intentness 9410
875
craziness 9410
876
psychic 9410
877
squabbled 9410
878
burlesque 9410
879
capped 9410
880
869
extracted 9410
881
DiMaggio 9410
882
exclamation 9410
883
subdirectory 9410
884
Gothicism 9410
870
faithful 9410
871
fanatic 9410
872
fated 9410
873
featherweight 9410
874
feed 9410
885
875
feminine 9410
886
metaphysically 9410
887
sanding 9410
888
Miltonism 9410
876
fetched 9410
877
fetters 9410
878
fiftieth 9410
879
filial 9410
880
fingerings 9410
881
finishers 9410
882
firearm 9410
883
fitting 9410
884
fixedly 9410
885
flanking 9410
886
flint 9410
887
flopping 9410
888
flurried 9410
889
foldout 9410
890
foothill 9410
891
forgivably 9410
892
forthcoming 9410
889
893
freakish 9410
890
index 9410
891
straight 9410
892
flurried 9410
893
denotative 9410
894
coming 9410
895
commencements 9410
894
freest 9410
895
freezes 9410
896
funereal 9410
897
furnishings 9410
898
furthermore 9410
899
gadfly 9410
900
gainful 9410
901
galling 9410
902
garage 9410
896
903
gentleman 9410
897
904
gifted 9410
898
Shanghais 9410
899
sportswriting 9410
900
sloping 9410
901
navies 9410
902
leaflet 9410
903
shooter 9410
904
Joplin 9410
905
babies 9410
906
assails 9410
907
admiring 9410
908
swaying 9410
909
Goldstine 9410
910
fitting 9410
911
Norwalk 9410
912
analogy 9410
913
deludes 9410
914
cokes 9410
915
Clayton 9410
916
exhausts 9410
917
causality 9410
918
sating 9410
905
gleaning 9410
906
glut 9410
907
goblins 9410
908
governing 9410
909
gradually 9410
910
grazing 9410
911
gritty 9410
912
groupings 9410
913
guides 9410
914
guitars 9410
915
handgun 9410
916
handy 9410
917
heiress 9410
918
hoarder 9410
919
honoring 9410
920
hostess 9410
921
humanness 9410
922
humiliation 9410
923
humility 9410
924
hushes 9410
925
husky 9410
926
hypothesizer 9410
919
927
icon 9410
920
throttles 9410
921
communicants 9410
922
dehydrate 9410
923
priceless 9410
924
publicly 9410
928
ideas 9410
929
impelling 9410
930
impending 9410
931
imperial 9410
932
imperiously 9410
933
imprint 9410
934
impulsive 9410
935
inaccuracy 9410
936
inch 9410
925
937
incidentals 9410
926
commonplace 9410
938
incorrectly 9410
939
incurring 9410
940
index 9410
941
indulge 9410
942
indulgences 9410
943
ineffective 9410
944
infallibly 9410
945
infest 9410
946
inform 9410
947
inmate 9410
948
insolence 9410
949
instruments 9410
950
intelligibility 9410
951
intentness 9410
952
intercepted 9410
953
interdependent 9410
954
interrelationships 9410
955
interrogate 9410
956
investigations 9410
957
irresponsibly 9410
958
jarring 9410
959
journalizing 9410
960
juveniles 9410
961
kanji 9410
962
kingdom 9410
963
kiting 9410
964
labeled 9410
965
languages 9410
966
laterally 9410
967
lawgiver 9410
968
leaflet 9410
969
leavings 9410
970
lectured 9410
971
leftover 9410
972
lewdly 9410
973
lied 9410
974
linear 9410
975
lists 9410
976
lithograph 9410
977
lore 9410
978
luckily 9410
979
males 9410
980
marginal 9410
981
mastering 9410
982
mayoral 9410
983
meanwhile 9410
984
measures 9410
985
measures 9410
986
mechanizing 9410
987
medical 9410
988
meditation 9410
989
metaphysically 9410
990
mineral 9410
991
miniaturizes 9410
992
minima 9410
993
minion 9410
994
minting 9410
995
misted 9410
996
misunderstander 9410
997
mixture 9410
998
motors 9410
999
mournfulness 9410
1000
multilayer 9410
927
1001
mumbles 9410
928
furthermore 9410
929
cautioned 9410
1002
mushrooms 9410
1003
mystic 9410
1004
navies 9410
1005
navigate 9410
1006
neat 9410
1007
neonatal 9410
1008
nested 9410
1009
noncritical 9410
1010
normalizes 9410
1011
obliterates 9410
1012
offload 9410
1013
opaquely 9410
1014
organizer 9410
1015
overestimating 9410
1016
overlay 9410
930
1017
parametrized 9410
1018
parenthood 9410
1019
parters 9410
1020
participated 9410
1021
partridges 9410
1022
peacock 9410
1023
peeked 9410
1024
pellagra 9410
1025
percentage 9410
1026
percentage 9410
1027
persist 9410
1028
perturb 9410
1029
pessimist 9410
1030
pests 9410
1031
petted 9410
1032
pictures 9410
1033
pithed 9410
1034
pityingly 9410
1035
poison 9410
1036
posed 9410
1037
positioning 9410
1038
postulation 9410
1039
praised 9410
1040
precaution 9410
1041
precipitable 9410
1042
preclude 9410
1043
presentation 9410
1044
pressure 9410
1045
previewing 9410
1046
priceless 9410
1047
primary 9410
1048
psychic 9410
1049
publicly 9410
1050
puddings 9410
1051
quagmire 9410
1052
quitter 9410
1053
railway 9410
1054
raining 9410
1055
rains 9410
1056
ravines 9410
1057
readable 9410
1058
realized 9410
1059
realtor 9410
1060
reassigned 9410
1061
recruited 9410
1062
reduce 9410
1063
regimented 9410
931
1064
registration 9410
1065
relatively 9410
1066
relaxing 9410
1067
relishing 9410
1068
relives 9410
1069
renew 9410
1070
repelled 9410
1071
repetitions 9410
1072
reporters 9410
1073
reporters 9410
1074
repressions 9410
1075
resplendent 9410
1076
resumes 9410
1077
rifles 9410
1078
rightful 9410
1079
rightfully 9410
1080
rightfulness 9410
1081
ripeness 9410
1082
riser 9410
1083
roped 9410
1084
rudeness 9410
1085
rules 9410
1086
rural 9410
1087
rusting 9410
932
1088
sadly 9410
933
positioning 9410
934
babysitting 9410
935
eternal 9410
936
hoarder 9410
937
congregates 9410
938
rains 9410
939
workers 9410
940
1089
sags 9410
941
unplug 9410
942
garage 9410
943
boulder 9410
944
specifics 9410
945
Teresa 9410
946
Winsett 9410
947
convenient 9410
948
buckboards 9410
949
amenities 9410
950
resplendent 9410
951
sews 9410
952
participated 9410
953
Simon 9410
954
certificates 9410
955
Fitzpatrick 9410
956
Evanston 9410
957
misted 9410
958
textures 9410
1090
sanding 9410
1091
saplings 9410
1092
sating 9410
959
1093
save 9410
960
count 9410
961
rightful 9410
962
chaperone 9410
963
Lizzy 9410
964
clenched 9410
965
effortlessly 9410
966
accessed 9410
967
beaters 9410
968
Hornblower 9410
969
vests 9410
970
indulgences 9410
971
infallibly 9410
972
unwilling 9410
973
excrete 9410
974
spools 9410
975
crunches 9410
976
overestimating 9410
977
ineffective 9410
978
humiliation 9410
979
sophomore 9410
980
star 9410
981
rifles 9410
982
dialysis 9410
983
arriving 9410
984
indulge 9410
985
clockers 9410
986
languages 9410
987
Antarctica 9410
988
percentage 9410
989
ceiling 9410
990
specification 9410
991
regimented 9410
992
ciphers 9410
993
pictures 9410
1094
sawtooth 9410
1095
scarf 9410
1096
scatterbrain 9410
1097
scheduling 9410
1098
schemer 9410
1099
scholastics 9410
1100
scornfully 9410
1101
secures 9410
1102
securing 9410
1103
seminaries 9410
1104
serializations 9410
994
1105
serpents 9410
995
allot 9410
996
realized 9410
997
mayoral 9410
998
opaquely 9410
999
hostess 9410
1000
fiftieth 9410
1001
incorrectly 9410
1002
decomposition 9410
1003
stranglings 9410
1004
mixture 9410
1005
electroencephalography 9410
1106
serving 9410
1107
severely 9410
1108
sews 9410
1109
shapelessly 9410
1110
shipyard 9410
1111
shooter 9410
1006
1112
similarities 9410
1007
charges 9410
1008
freest 9410
1009
Greenberg 9410
1010
tinting 9410
1011
expelled 9410
1012
warm 9410
1113
skulking 9410
1114
slaughter 9410
1115
sloping 9410
1013
1116
smoothed 9410
1014
deductions 9410
1015
Romano 9410
1016
bitterroot 9410
1017
corset 9410
1018
securing 9410
1019
environing 9410
1020
cute 9410
1021
Crays 9410
1022
heiress 9410
1023
inform 9410
1024
avenge 9410
1025
universals 9410
1026
Kinsey 9410
1027
ravines 9410
1028
bestseller 9410
1029
equilibrium 9410
1030
extents 9410
1031
relatively 9410
1032
pressure 9410
1033
critiques 9410
1034
befouled 9410
1035
rightfully 9410
1036
mechanizing 9410
1037
Latinizes 9410
1038
timesharing 9410
1039
Aden 9410
1040
embassies 9410
1041
males 9410
1042
shapelessly 9410
1043
mastering 9410
1044
Newtonian 9410
1045
finishers 9410
1046
abates 9410
1047
teem 9410
1048
kiting 9410
1117
snatching 9410
1118
socializes 9410
1119
sophomore 9410
1120
sorters 9410
1121
spatial 9410
1122
specification 9410
1123
specifics 9410
1124
spongers 9410
1125
spools 9410
1126
sportswriting 9410
1127
sporty 9410
1128
squabbled 9410
1129
squeaking 9410
1130
squeezes 9410
1131
stabilizes 9410
1132
stairway 9410
1133
standardizes 9410
1134
star 9410
1135
starlet 9410
1136
stated 9410
1137
stint 9410
1049
1138
stodgy 9410
1050
feed 9410
1051
guitars 9410
1052
airships 9410
1053
1139
store 9410
1054
denounces 9410
1055
Pyle 9410
1056
Saxony 9410
1057
serializations 9410
1058
Peruvian 9410
1140
straight 9410
1141
stranglings 9410
1142
subdirectory 9410
1143
subjective 9410
1144
subschema 9410
1145
succumbed 9410
1146
suites 9410
1147
sumac 9410
1148
sureties 9410
1149
swaying 9410
1150
sweetish 9410
1151
swelling 9410
1152
syndicate 9410
1059
1153
taxonomically 9410
1060
kingdom 9410
1061
stint 9410
1062
Sault 9410
1063
faithful 9410
1064
Ganymede 9410
1154
techniques 9410
1155
teem 9410
1156
teethe 9410
1157
tempering 9410
1158
terminal 9410
1159
terminator 9410
1160
terminators 9410
1161
test 9410
1162
testicle 9410
1163
textures 9410
1164
theorizers 9410
1165
throttles 9410
1065
1166
tidiness 9410
1066
gainful 9410
1067
contrary 9410
1068
Tipperary 9410
1167
timesharing 9410
1168
tinily 9410
1169
tinting 9410
1170
title 9410
1171
tragedies 9410
1172
traitor 9410
1173
trimmings 9410
1069
1174
tropics 9410
1070
theorizers 9410
1071
renew 9410
1072
already 9410
1073
terminal 9410
1074
Hegelian 9410
1075
hypothesizer 9410
1175
unaffected 9410
1176
uncovering 9410
1177
undoes 9410
1178
ungrateful 9410
1179
universals 9410
1180
unplug 9410
1181
unruly 9410
1182
untying 9410
1183
unwilling 9410
1184
vacuuming 9410
1185
validate 9410
1186
vanish 9410
1187
ventilate 9410
1188
veranda 9410
1189
vests 9410
1190
wallet 9410
1191
waltz 9410
1192
warm 9410
1076
1193
warningly 9410
1077
journalizing 9410
1078
nested 9410
1079
Lars 9410
1080
saplings 9410
1081
foothill 9410
1082
labeled 9410
1083
imperiously 9410
1084
reporters 9410
1085
furnishings 9410
1086
precipitable 9410
1087
discounts 9410
1088
excises 9410
1089
Stalin 9410
1090
despot 9410
1091
ripeness 9410
1092
Arabia 9410
1093
unruly 9410
1094
mournfulness 9410
1095
boom 9410
1096
slaughter 9410
1097
Sabine 9410
1098
handy 9410
1099
rural 9410
1100
organizer 9410
1101
shipyard 9410
1102
civics 9410
1103
inaccuracy 9410
1104
rules 9410
1105
juveniles 9410
1106
comprised 9410
1107
investigations 9410
1108
stabilizes 9410
1109
seminaries 9410
1110
Hunter 9410
1111
sporty 9410
1112
test 9410
1194
watering 9410
1113
1195
weasels 9410
1114
CERN 9410
1115
tempering 9410
1116
afore 9410
1117
Galatean 9410
1118
techniques 9410
1119
error 9410
1120
veranda 9410
1121
severely 9410
1122
Cassites 9410
1123
forthcoming 9410
1124
guides 9410
1125
vanish 9410
1126
lied 9410
1127
sawtooth 9410
1128
fated 9410
1129
gradually 9410
1196
western 9410
1197
whiteners 9410
1130
1198
widens 9410
1131
preclude 9410
1132
evenhandedly 9410
1133
percentage 9410
1134
disobedience 9410
1135
humility 9410
1136
gleaning 9410
1137
petted 9410
1138
bloater 9410
1139
minion 9410
1140
marginal 9410
1141
apiary 9410
1142
measures 9410
1143
precaution 9410
1144
repelled 9410
1145
primary 9410
1146
coverings 9410
1147
Artemia 9410
1148
navigate 9410
1149
spatial 9410
1150
Gurkha 9410
1151
meanwhile 9410
1152
Melinda 9410
1153
Butterfield 9410
1154
Aldrich 9410
1155
previewing 9410
1156
glut 9410
1157
unaffected 9410
1158
inmate 9410
1159
mineral 9410
1160
impending 9410
1161
meditation 9410
1162
ideas 9410
1163
miniaturizes 9410
1164
lewdly 9410
1165
title 9410
1199
witchcraft 9410
1200
workers 9410
1201
yelped 9410
1166
1202
youthfulness 9410
1167
creak 9410
1168
Chippewa 9410
1169
clamored 9410
1170
freezes 9410
1171
forgivably 9410
1172
reduce 9410
1173
McGovern 9410
1174
Nazis 9410
1175
epistle 9410
1176
socializes 9410
1177
conceptions 9410
1178
Kevin 9410
1179
uncovering 9410
1180
chews 9410
1181
appendixes 9410
1182
appendixes 9410
1183
appendixes 9410
1184
appendixes 9410
1185
appendixes 9410
1186
appendixes 9410
1187
raining 9410
1188
infest 9410
1189
compartment 9410
1190
minting 9410
1191
ducks 9410
1192
roped 9410
1193
waltz 9410
1194
Lillian 9410
1195
repressions 9410
1196
chillingly 9410
1197
noncritical 9410
1198
lithograph 9410
1199
spongers 9410
1200
parenthood 9410
1201
posed 9410
1202
instruments 9410
1203
filial 9410
1204
fixedly 9410
1205
relives 9410
1206
Pandora 9410
1207
watering 9410
1208
ungrateful 9410
1209
secures 9410
1210
poison 9410
1211
dusted 9410
1212
encompasses 9410
1213
presentation 9410
1214
Kantian 9410
1215
1203
select fld3,period,price,price2 from t2,t3 where t2.fld1=t3.t2nr and period >= 1001 and period <= 1002 and t2.companynr = 37 order by fld3,period, price;
1216
1204
fld3 period price price2
1217
1205
admonishing 1002 28357832 8723648
1279
1267
18601 vacuuming 1001 5987435 234724
1280
1268
18801 inch 1001 5987435 234724
1281
1269
18811 repetitions 1001 5987435 234724
1282
create table t4 (
1270
create temporary table t4 (
1283
1271
companynr int NOT NULL default '00',
1284
1272
companyname char(30) NOT NULL default '',
1285
1273
PRIMARY KEY (companynr),
1352
1340
1199
1353
1341
explain select t2.companynr,companyname from t2 left join t4 using (companynr) where t4.companynr is null;
1354
1342
id select_type table type possible_keys key key_len ref rows Extra
1355
1 SIMPLE t2 ALL NULL NULL NULL NULL 1200
1356
1 SIMPLE t4 eq_ref PRIMARY PRIMARY 4 test.t2.companynr 1 Using where; Not exists
1343
1 SIMPLE t2 ALL NULL NULL NULL NULL #
1344
1 SIMPLE t4 eq_ref PRIMARY PRIMARY 4 test.t2.companynr # Using where; Not exists
1357
1345
explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr is null;
1358
1346
id select_type table type possible_keys key key_len ref rows Extra
1359
1 SIMPLE t4 ALL NULL NULL NULL NULL 12
1360
1 SIMPLE t2 ALL NULL NULL NULL NULL 1200 Using where; Not exists
1347
1 SIMPLE t4 ALL NULL NULL NULL NULL #
1348
1 SIMPLE t2 ALL NULL NULL NULL NULL # Using where; Not exists
1361
1349
select companynr,companyname from t2 left join t4 using (companynr) where companynr is null;
1362
1350
companynr companyname
1363
1351
select count(*) from t2 left join t4 using (companynr) where companynr is not null;
1365
1353
1200
1366
1354
explain select companynr,companyname from t2 left join t4 using (companynr) where companynr is null;
1367
1355
id select_type table type possible_keys key key_len ref rows Extra
1368
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE
1356
1 SIMPLE NULL NULL NULL NULL NULL NULL # Impossible WHERE
1369
1357
explain select companynr,companyname from t4 left join t2 using (companynr) where companynr is null;
1370
1358
id select_type table type possible_keys key key_len ref rows Extra
1371
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE
1359
1 SIMPLE NULL NULL NULL NULL NULL NULL # Impossible WHERE
1372
1360
delete from t2 where fld1=999999;
1373
1361
explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0;
1374
1362
id select_type table type possible_keys key key_len ref rows Extra
1375
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where
1376
1 SIMPLE t4 eq_ref PRIMARY PRIMARY 4 test.t2.companynr 1
1363
1 SIMPLE t2 ALL NULL NULL NULL NULL # Using where
1364
1 SIMPLE t4 eq_ref PRIMARY PRIMARY 4 test.t2.companynr #
1377
1365
explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr < 0;
1378
1366
id select_type table type possible_keys key key_len ref rows Extra
1379
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where
1380
1 SIMPLE t4 eq_ref PRIMARY PRIMARY 4 test.t2.companynr 1
1367
1 SIMPLE t2 ALL NULL NULL NULL NULL # Using where
1368
1 SIMPLE t4 eq_ref PRIMARY PRIMARY 4 test.t2.companynr #
1381
1369
explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 and t4.companynr > 0;
1382
1370
id select_type table type possible_keys key key_len ref rows Extra
1383
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where
1384
1 SIMPLE t4 eq_ref PRIMARY PRIMARY 4 test.t2.companynr 1
1371
1 SIMPLE t2 ALL NULL NULL NULL NULL # Using where
1372
1 SIMPLE t4 eq_ref PRIMARY PRIMARY 4 test.t2.companynr #
1385
1373
explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0;
1386
1374
id select_type table type possible_keys key key_len ref rows Extra
1387
1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where
1388
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199
1375
1 SIMPLE t4 ALL PRIMARY NULL NULL NULL # Using where
1376
1 SIMPLE t2 ALL NULL NULL NULL NULL #
1389
1377
explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr < 0;
1390
1378
id select_type table type possible_keys key key_len ref rows Extra
1391
1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where
1392
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199
1379
1 SIMPLE t4 ALL PRIMARY NULL NULL NULL # Using where
1380
1 SIMPLE t2 ALL NULL NULL NULL NULL #
1393
1381
explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 and companynr > 0;
1394
1382
id select_type table type possible_keys key key_len ref rows Extra
1395
1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where
1396
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199
1383
1 SIMPLE t4 ALL PRIMARY NULL NULL NULL # Using where
1384
1 SIMPLE t2 ALL NULL NULL NULL NULL #
1397
1385
explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr is null;
1398
1386
id select_type table type possible_keys key key_len ref rows Extra
1399
1 SIMPLE t4 ALL NULL NULL NULL NULL 12
1400
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where
1387
1 SIMPLE t4 ALL NULL NULL NULL NULL #
1388
1 SIMPLE t2 ALL NULL NULL NULL NULL # Using where
1401
1389
explain select t2.companynr,companyname from t4 left join t2 using (companynr) where t2.companynr > 0 or t2.companynr < 0 or t4.companynr > 0;
1402
1390
id select_type table type possible_keys key key_len ref rows Extra
1403
1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12
1404
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where
1391
1 SIMPLE t4 ALL PRIMARY NULL NULL NULL #
1392
1 SIMPLE t2 ALL NULL NULL NULL NULL # Using where
1405
1393
explain select t2.companynr,companyname from t4 left join t2 using (companynr) where ifnull(t2.companynr,1)>0;
1406
1394
id select_type table type possible_keys key key_len ref rows Extra
1407
1 SIMPLE t4 ALL NULL NULL NULL NULL 12
1408
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where
1395
1 SIMPLE t4 ALL NULL NULL NULL NULL #
1396
1 SIMPLE t2 ALL NULL NULL NULL NULL # Using where
1409
1397
explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr is null;
1410
1398
id select_type table type possible_keys key key_len ref rows Extra
1411
1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where
1412
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199
1399
1 SIMPLE t4 ALL PRIMARY NULL NULL NULL # Using where
1400
1 SIMPLE t2 ALL NULL NULL NULL NULL #
1413
1401
explain select companynr,companyname from t4 left join t2 using (companynr) where companynr > 0 or companynr < 0 or companynr > 0;
1414
1402
id select_type table type possible_keys key key_len ref rows Extra
1415
1 SIMPLE t4 ALL PRIMARY NULL NULL NULL 12 Using where
1416
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199
1403
1 SIMPLE t4 ALL PRIMARY NULL NULL NULL # Using where
1404
1 SIMPLE t2 ALL NULL NULL NULL NULL #
1417
1405
explain select companynr,companyname from t4 left join t2 using (companynr) where ifnull(companynr,1)>0;
1418
1406
id select_type table type possible_keys key key_len ref rows Extra
1419
1 SIMPLE t4 ALL NULL NULL NULL NULL 12 Using where
1420
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199
1407
1 SIMPLE t4 ALL NULL NULL NULL NULL # Using where
1408
1 SIMPLE t2 ALL NULL NULL NULL NULL #
1421
1409
select distinct t2.companynr,t4.companynr from t2,t4 where t2.companynr=t4.companynr+1;
1422
1410
companynr companynr
1423
1411
37 36
1424
1412
41 40
1425
1413
explain select distinct t2.companynr,t4.companynr from t2,t4 where t2.companynr=t4.companynr+1;
1426
1414
id select_type table type possible_keys key key_len ref rows Extra
1427
1 SIMPLE t4 index NULL PRIMARY 4 NULL 12 Using index; Using temporary
1428
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer
1415
1 SIMPLE t4 index NULL PRIMARY 4 NULL # Using index; Using temporary
1416
1 SIMPLE t2 ALL NULL NULL NULL NULL # Using where; Using join buffer
1429
1417
select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and period = 1008 or t2.fld1 = 38008 and t2.fld1 =t3.t2nr and period = 1008;
1430
1418
fld1 companynr fld3 period
1431
1419
38008 37 reporters 1008
1499
1487
70 absentee vest 17788966 254128.0857 3272.5940 10709871.3069
1500
1488
explain extended select count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 where companynr = 34 and fld4<>"";
1501
1489
id select_type table type possible_keys key key_len ref rows filtered Extra
1502
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 100.00 Using where
1490
1 SIMPLE t2 ALL NULL NULL NULL NULL # 100.00 Using where
1503
1491
Warnings:
1504
1492
Note 1003 select count(0) AS `count(*)`,min(`test`.`t2`.`fld4`) AS `min(fld4)`,max(`test`.`t2`.`fld4`) AS `max(fld4)`,sum(`test`.`t2`.`fld1`) AS `sum(fld1)`,avg(`test`.`t2`.`fld1`) AS `avg(fld1)`,std(`test`.`t2`.`fld1`) AS `std(fld1)`,variance(`test`.`t2`.`fld1`) AS `variance(fld1)` from `test`.`t2` where ((`test`.`t2`.`companynr` = 34) and (`test`.`t2`.`fld4` <> ''))
1505
1493
select companynr,count(*),min(fld4),max(fld4),sum(fld1),avg(fld1),std(fld1),variance(fld1) from t2 group by companynr limit 3;
1940
1928
38008 234298
1941
1929
explain select fld3 from t2 where 1>2 or 2>3;
1942
1930
id select_type table type possible_keys key key_len ref rows Extra
1943
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE
1931
1 SIMPLE NULL NULL NULL NULL NULL NULL # Impossible WHERE
1944
1932
explain select fld3 from t2 where fld1=fld1;
1945
1933
id select_type table type possible_keys key key_len ref rows Extra
1946
1 SIMPLE t2 ALL NULL NULL NULL NULL 1199
1934
1 SIMPLE t2 ALL NULL NULL NULL NULL #
1947
1935
select companynr,fld1 from t2 HAVING fld1=250501 or fld1=250502;
1948
1936
companynr fld1
1949
1937
34 250501
1995
1983
4181
1996
1984
explain select min(fld1),max(fld1),count(*) from t2;
1997
1985
id select_type table type possible_keys key key_len ref rows Extra
1998
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Select tables optimized away
1986
1 SIMPLE t2 index NULL PRIMARY 4 NULL #
1999
1987
select min(fld1),max(fld1),count(*) from t2;
2000
1988
min(fld1) max(fld1) count(*)
2001
1989
0 1232609 1199
2056
2044
t1
2057
2045
t2
2058
2046
t3
2059
t4
2060
2047
show tables from test like "s%";
2061
2048
Tables_in_test (s%)
2062
2049
show tables from test like "t?";
2081
2068
Field Type Collation Null Key Default Extra Privileges Comment
2082
2069
show keys from t2;
2083
2070
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
2084
t2 0 PRIMARY 1 auto A 1199 NULL NULL BTREE
2085
t2 0 fld1 1 fld1 A 1199 NULL NULL BTREE
2086
t2 1 fld3 1 fld3 A NULL NULL NULL BTREE
2071
t2 0 PRIMARY 1 auto A # NULL NULL BTREE
2072
t2 0 fld1 1 fld1 A # NULL NULL BTREE
2073
t2 1 fld3 1 fld3 A # NULL NULL BTREE
2087
2074
drop table t4, t3, t2, t1;
2088
CREATE TABLE t1 (
2075
CREATE TEMPORARY TABLE t1 (
2089
2076
cont_nr int NOT NULL auto_increment,
2090
2077
ver_nr int NOT NULL default '0',
2091
2078
aufnr int NOT NULL default '0',
Loggerhead is a web-based interface for Breezy
Version: 2.0.1