« back to all changes in this revision
Viewing changes to tests/r/select.result
- browse files at revision 505
- compare with another revision
- compare with revision 971.1.39
- download diff
- download tarball
- view history from revision 505
- Committer: Brian Aker
- Date: 2008-10-11 18:46:03 UTC
- mfrom: (499.1.1 codestyle)
- Revision ID: brian@tangent.org-20081011184603-acnvl454409fzhvq
Merging Monty
- files added:
- tests/r/pbxt
- files modified:
- client/drizzletest.cc
added
removed
tests/r/select.result
164
164
18054 fetters
165
165
18103 flint
166
166
18104 flopping
167
36002 funereal
168
38017 fetched
169
38205 firearm
170
58004 Fenton
171
88303 feminine
172
167
186002 freakish
173
168
188007 flurried
174
169
188505 fitting
187
182
232102 forgivably
188
183
238007 filial
189
184
238008 fixedly
185
36002 funereal
186
38017 fetched
187
38205 firearm
188
58004 Fenton
189
88303 feminine
190
190
select fld3 from t2 where fld3 like "L%" and fld3 = "ok";
191
191
fld3
192
192
select fld3 from t2 where (fld3 like "C%" and fld3 = "Chantilly");
250
250
0
251
251
select distinct t2.fld3,period from t2,t1 where companynr=37 and fld3 like "O%";
252
252
fld3 period
253
overlay 9410
253
obliterates 9410
254
254
offload 9410
255
obliterates 9410
256
overestimating 9410
257
255
opaquely 9410
258
256
organizer 9410
257
overestimating 9410
258
overlay 9410
259
259
select distinct fld3 from t2 where companynr = 34 order by fld3;
260
260
fld3
261
261
absentee
331
331
select distinct fld3 from t2 limit 10;
332
332
fld3
333
333
Omaha
334
Romans
335
admonishing
336
astound
337
bewilderingly
334
338
breaking
335
Romans
339
combed
340
flanking
336
341
intercepted
337
bewilderingly
338
astound
339
admonishing
340
342
sumac
341
flanking
342
combed
343
343
select distinct fld3 from t2 having fld3 like "A%" limit 10;
344
344
fld3
345
345
abates
442
442
adj
443
443
select distinct substring(fld3,1,3) as a from t2 having a like "A%" limit 10;
444
444
a
445
ast
445
Ado
446
Aug
446
447
adm
448
afi
449
agi
450
amm
447
451
ann
448
agi
449
afi
450
amm
451
Aug
452
ast
453
att
452
454
aud
453
att
454
Ado
455
455
create table t3 (
456
456
period int not null,
457
457
name char(32) not null,
581
581
breaking 1001
582
582
select fld3,period from t2,t1 where companynr*10 = 37*10;
583
583
fld3 period
584
breaking 9410
585
Romans 9410
586
intercepted 9410
587
bewilderingly 9410
588
astound 9410
589
admonishing 9410
590
sumac 9410
591
flanking 9410
592
combed 9410
593
subjective 9410
594
scatterbrain 9410
584
Abraham 9410
585
Aden 9410
586
Adolph 9410
587
Aldrich 9410
588
Alison 9410
589
Anatole 9410
590
Antarctica 9410
591
Antares 9410
592
Arabia 9410
593
Artemia 9410
594
Augustine 9410
595
Baird 9410
596
Beebe 9410
597
Butterfield 9410
598
CERN 9410
599
Cassites 9410
600
Chicana 9410
601
Chippewa 9410
602
Clayton 9410
603
Conley 9410
604
Connally 9410
605
Crays 9410
606
DiMaggio 9410
607
Dutchman 9410
595
608
Eulerian 9410
609
Evanston 9410
610
Everhart 9410
611
Fenton 9410
612
Fitzpatrick 9410
613
Galatean 9410
614
Gandhian 9410
615
Ganymede 9410
616
Goldstine 9410
617
Gothicism 9410
618
Graves 9410
619
Greenberg 9410
620
Gurkha 9410
621
Hawaii 9410
622
Hegelian 9410
623
Hornblower 9410
624
Huffman 9410
625
Hunter 9410
626
Joplin 9410
627
Judas 9410
596
628
Kane 9410
597
overlay 9410
598
perturb 9410
599
goblins 9410
600
annihilates 9410
629
Kantian 9410
630
Kevin 9410
631
Kinsey 9410
632
Kline 9410
633
Lars 9410
634
Latinizes 9410
635
Lillian 9410
636
Lizzy 9410
637
Majorca 9410
638
Manhattanize 9410
639
McGovern 9410
640
Melinda 9410
641
Merritt 9410
642
Micronesia 9410
643
Miles 9410
644
Miltonism 9410
645
Nabisco 9410
646
Nazis 9410
647
Newtonian 9410
648
Norwalk 9410
649
Pandora 9410
650
Parsifal 9410
651
Peruvian 9410
652
Punjab 9410
653
Pyle 9410
654
Quixotism 9410
655
Romano 9410
656
Romans 9410
657
Sabine 9410
658
Sault 9410
659
Saxony 9410
660
Selfridge 9410
661
Shanghais 9410
662
Simla 9410
663
Simon 9410
664
Stalin 9410
665
Steinberg 9410
666
Taoism 9410
667
Teresa 9410
668
Tipperary 9410
669
Weissmuller 9410
670
Winsett 9410
601
671
Wotan 9410
602
snatching 9410
603
concludes 9410
604
laterally 9410
605
yelped 9410
606
grazing 9410
607
Baird 9410
608
celery 9410
609
misunderstander 9410
610
handgun 9410
611
foldout 9410
612
mystic 9410
613
succumbed 9410
614
Nabisco 9410
615
fingerings 9410
672
abates 9410
673
abrogating 9410
674
accessed 9410
675
admiring 9410
676
admonishing 9410
677
afield 9410
678
afore 9410
616
679
aging 9410
617
afield 9410
680
airships 9410
681
alike 9410
682
allot 9410
683
already 9410
684
amenities 9410
618
685
ammonium 9410
619
boat 9410
620
intelligibility 9410
621
Augustine 9410
622
teethe 9410
623
dreaded 9410
624
scholastics 9410
686
analogy 9410
687
analyzable 9410
688
animals 9410
689
animized 9410
690
annihilates 9410
691
announced 9410
692
announces 9410
693
apiary 9410
694
appendixes 9410
695
appendixes 9410
696
appendixes 9410
697
appendixes 9410
698
appendixes 9410
699
appendixes 9410
700
arriving 9410
701
arteriole 9410
702
assails 9410
703
astound 9410
704
attainments 9410
705
attrition 9410
625
706
audiology 9410
626
wallet 9410
627
parters 9410
628
eschew 9410
629
quitter 9410
630
neat 9410
631
Steinberg 9410
632
jarring 9410
633
tinily 9410
707
avenge 9410
708
avoidable 9410
709
babies 9410
710
babysitting 9410
634
711
balled 9410
635
persist 9410
636
attainments 9410
637
fanatic 9410
638
measures 9410
639
rightfulness 9410
640
capably 9410
641
impulsive 9410
642
starlet 9410
643
terminators 9410
644
untying 9410
645
announces 9410
646
featherweight 9410
647
pessimist 9410
648
daughter 9410
649
decliner 9410
650
lawgiver 9410
651
stated 9410
652
readable 9410
653
attrition 9410
654
cascade 9410
655
motors 9410
656
interrogate 9410
657
pests 9410
658
stairway 9410
659
dopers 9410
660
testicle 9410
661
Parsifal 9410
662
leavings 9410
663
postulation 9410
664
squeaking 9410
665
contrasted 9410
666
leftover 9410
667
whiteners 9410
668
erases 9410
669
Punjab 9410
670
Merritt 9410
671
Quixotism 9410
672
sweetish 9410
673
dogging 9410
674
scornfully 9410
712
beaner 9410
713
beaters 9410
714
bee 9410
715
befouled 9410
675
716
bellow 9410
717
bestseller 9410
718
betroth 9410
719
bewilderingly 9410
676
720
bills 9410
677
cupboard 9410
678
sureties 9410
679
puddings 9410
680
fetters 9410
721
bitterroot 9410
681
722
bivalves 9410
682
incurring 9410
683
Adolph 9410
684
pithed 9410
685
Miles 9410
686
trimmings 9410
687
tragedies 9410
688
skulking 9410
689
flint 9410
690
flopping 9410
691
relaxing 9410
692
offload 9410
693
suites 9410
694
lists 9410
695
animized 9410
696
multilayer 9410
697
standardizes 9410
698
Judas 9410
699
vacuuming 9410
700
dentally 9410
701
humanness 9410
702
inch 9410
703
Weissmuller 9410
704
irresponsibly 9410
705
luckily 9410
706
culled 9410
707
medical 9410
723
bloater 9410
708
724
bloodbath 9410
709
subschema 9410
710
animals 9410
711
Micronesia 9410
712
repetitions 9410
713
Antares 9410
714
ventilate 9410
715
pityingly 9410
716
interdependent 9410
717
Graves 9410
718
neonatal 9410
725
boat 9410
726
boom 9410
727
boorish 9410
728
boulder 9410
729
breaking 9410
730
brunch 9410
731
buckboards 9410
732
burlesque 9410
733
cage 9410
734
capably 9410
735
capped 9410
736
cascade 9410
737
causality 9410
738
cautioned 9410
739
ceiling 9410
740
celery 9410
741
certificates 9410
719
742
chafe 9410
720
honoring 9410
721
realtor 9410
722
elite 9410
723
funereal 9410
724
abrogating 9410
725
sorters 9410
726
Conley 9410
727
lectured 9410
728
Abraham 9410
729
Hawaii 9410
730
cage 9410
731
hushes 9410
732
Simla 9410
733
reporters 9410
734
Dutchman 9410
735
descendants 9410
736
groupings 9410
737
dissociate 9410
743
chaperone 9410
744
charges 9410
745
chasm 9410
746
checkpoints 9410
747
chewing 9410
748
chews 9410
749
chillingly 9410
750
chronicle 9410
751
ciphers 9410
752
civics 9410
753
clamored 9410
754
clenched 9410
755
clockers 9410
738
756
coexist 9410
739
Beebe 9410
740
Taoism 9410
741
Connally 9410
742
fetched 9410
743
checkpoints 9410
744
rusting 9410
745
galling 9410
746
obliterates 9410
747
traitor 9410
748
resumes 9410
749
analyzable 9410
750
terminator 9410
751
gritty 9410
752
firearm 9410
753
minima 9410
754
Selfridge 9410
755
disable 9410
756
witchcraft 9410
757
betroth 9410
758
Manhattanize 9410
759
imprint 9410
760
peeked 9410
761
swelling 9410
762
interrelationships 9410
763
riser 9410
764
Gandhian 9410
765
peacock 9410
766
bee 9410
767
kanji 9410
768
dental 9410
769
scarf 9410
770
chasm 9410
771
insolence 9410
772
syndicate 9410
773
alike 9410
774
imperial 9410
757
cokes 9410
758
combed 9410
759
coming 9410
760
commencements 9410
761
commonplace 9410
762
communicants 9410
763
compartment 9410
764
comprehensive 9410
765
comprised 9410
766
conceptions 9410
767
concludes 9410
768
congregates 9410
769
contrary 9410
770
contrasted 9410
771
convenient 9410
775
772
convulsion 9410
776
railway 9410
777
validate 9410
778
normalizes 9410
779
comprehensive 9410
780
chewing 9410
773
corset 9410
774
count 9410
775
coverings 9410
776
craziness 9410
777
creak 9410
778
creek 9410
779
critiques 9410
780
crunches 9410
781
culled 9410
782
cult 9410
783
cupboard 9410
784
cured 9410
785
cute 9410
786
daughter 9410
787
decliner 9410
788
decomposition 9410
789
deductions 9410
790
dehydrate 9410
791
deludes 9410
781
792
denizen 9410
782
schemer 9410
783
chronicle 9410
784
Kline 9410
785
Anatole 9410
786
partridges 9410
787
brunch 9410
788
recruited 9410
793
denotative 9410
794
denounces 9410
795
dental 9410
796
dentally 9410
797
descendants 9410
798
despot 9410
799
destroyer 9410
800
detectably 9410
801
dialysis 9410
789
802
dimensions 9410
790
Chicana 9410
791
announced 9410
792
praised 9410
793
employing 9410
794
linear 9410
795
quagmire 9410
796
western 9410
797
relishing 9410
798
serving 9410
799
scheduling 9410
800
lore 9410
801
eventful 9410
802
arteriole 9410
803
disable 9410
804
discounts 9410
803
805
disentangle 9410
804
cured 9410
805
Fenton 9410
806
avoidable 9410
806
disobedience 9410
807
dissociate 9410
808
dogging 9410
809
dopers 9410
807
810
drains 9410
808
detectably 9410
809
husky 9410
810
impelling 9410
811
undoes 9410
811
dreaded 9410
812
ducks 9410
813
dusted 9410
814
effortlessly 9410
815
electroencephalography 9410
816
elite 9410
817
embassies 9410
818
employing 9410
819
encompass 9410
820
encompasses 9410
821
environing 9410
822
epistle 9410
823
equilibrium 9410
824
erases 9410
825
error 9410
826
eschew 9410
827
eternal 9410
812
828
evened 9410
813
squeezes 9410
814
destroyer 9410
815
rudeness 9410
816
beaner 9410
817
boorish 9410
818
Everhart 9410
819
encompass 9410
820
mushrooms 9410
821
Alison 9410
829
evenhandedly 9410
830
eventful 9410
831
excises 9410
832
exclamation 9410
833
excrete 9410
834
exhausts 9410
835
expelled 9410
836
extents 9410
822
837
externally 9410
823
pellagra 9410
824
cult 9410
825
creek 9410
826
Huffman 9410
827
Majorca 9410
828
governing 9410
829
gadfly 9410
830
reassigned 9410
831
intentness 9410
832
craziness 9410
833
psychic 9410
834
squabbled 9410
835
burlesque 9410
836
capped 9410
837
838
extracted 9410
838
DiMaggio 9410
839
exclamation 9410
840
subdirectory 9410
841
Gothicism 9410
839
faithful 9410
840
fanatic 9410
841
fated 9410
842
featherweight 9410
843
feed 9410
842
844
feminine 9410
843
metaphysically 9410
844
sanding 9410
845
Miltonism 9410
845
fetched 9410
846
fetters 9410
847
fiftieth 9410
848
filial 9410
849
fingerings 9410
850
finishers 9410
851
firearm 9410
852
fitting 9410
853
fixedly 9410
854
flanking 9410
855
flint 9410
856
flopping 9410
857
flurried 9410
858
foldout 9410
859
foothill 9410
860
forgivably 9410
861
forthcoming 9410
846
862
freakish 9410
847
index 9410
848
straight 9410
849
flurried 9410
850
denotative 9410
851
coming 9410
852
commencements 9410
863
freest 9410
864
freezes 9410
865
funereal 9410
866
furnishings 9410
867
furthermore 9410
868
gadfly 9410
869
gainful 9410
870
galling 9410
871
garage 9410
853
872
gentleman 9410
854
873
gifted 9410
855
Shanghais 9410
856
sportswriting 9410
857
sloping 9410
858
navies 9410
859
leaflet 9410
860
shooter 9410
861
Joplin 9410
862
babies 9410
863
assails 9410
864
admiring 9410
865
swaying 9410
866
Goldstine 9410
867
fitting 9410
868
Norwalk 9410
869
analogy 9410
870
deludes 9410
871
cokes 9410
872
Clayton 9410
873
exhausts 9410
874
causality 9410
875
sating 9410
874
gleaning 9410
875
glut 9410
876
goblins 9410
877
governing 9410
878
gradually 9410
879
grazing 9410
880
gritty 9410
881
groupings 9410
882
guides 9410
883
guitars 9410
884
handgun 9410
885
handy 9410
886
heiress 9410
887
hoarder 9410
888
honoring 9410
889
hostess 9410
890
humanness 9410
891
humiliation 9410
892
humility 9410
893
hushes 9410
894
husky 9410
895
hypothesizer 9410
876
896
icon 9410
877
throttles 9410
878
communicants 9410
879
dehydrate 9410
880
priceless 9410
881
publicly 9410
897
ideas 9410
898
impelling 9410
899
impending 9410
900
imperial 9410
901
imperiously 9410
902
imprint 9410
903
impulsive 9410
904
inaccuracy 9410
905
inch 9410
882
906
incidentals 9410
883
commonplace 9410
907
incorrectly 9410
908
incurring 9410
909
index 9410
910
indulge 9410
911
indulgences 9410
912
ineffective 9410
913
infallibly 9410
914
infest 9410
915
inform 9410
916
inmate 9410
917
insolence 9410
918
instruments 9410
919
intelligibility 9410
920
intentness 9410
921
intercepted 9410
922
interdependent 9410
923
interrelationships 9410
924
interrogate 9410
925
investigations 9410
926
irresponsibly 9410
927
jarring 9410
928
journalizing 9410
929
juveniles 9410
930
kanji 9410
931
kingdom 9410
932
kiting 9410
933
labeled 9410
934
languages 9410
935
laterally 9410
936
lawgiver 9410
937
leaflet 9410
938
leavings 9410
939
lectured 9410
940
leftover 9410
941
lewdly 9410
942
lied 9410
943
linear 9410
944
lists 9410
945
lithograph 9410
946
lore 9410
947
luckily 9410
948
males 9410
949
marginal 9410
950
mastering 9410
951
mayoral 9410
952
meanwhile 9410
953
measures 9410
954
measures 9410
955
mechanizing 9410
956
medical 9410
957
meditation 9410
958
metaphysically 9410
959
mineral 9410
960
miniaturizes 9410
961
minima 9410
962
minion 9410
963
minting 9410
964
misted 9410
965
misunderstander 9410
966
mixture 9410
967
motors 9410
968
mournfulness 9410
969
multilayer 9410
884
970
mumbles 9410
885
furthermore 9410
886
cautioned 9410
971
mushrooms 9410
972
mystic 9410
973
navies 9410
974
navigate 9410
975
neat 9410
976
neonatal 9410
977
nested 9410
978
noncritical 9410
979
normalizes 9410
980
obliterates 9410
981
offload 9410
982
opaquely 9410
983
organizer 9410
984
overestimating 9410
985
overlay 9410
887
986
parametrized 9410
987
parenthood 9410
988
parters 9410
989
participated 9410
990
partridges 9410
991
peacock 9410
992
peeked 9410
993
pellagra 9410
994
percentage 9410
995
percentage 9410
996
persist 9410
997
perturb 9410
998
pessimist 9410
999
pests 9410
1000
petted 9410
1001
pictures 9410
1002
pithed 9410
1003
pityingly 9410
1004
poison 9410
1005
posed 9410
1006
positioning 9410
1007
postulation 9410
1008
praised 9410
1009
precaution 9410
1010
precipitable 9410
1011
preclude 9410
1012
presentation 9410
1013
pressure 9410
1014
previewing 9410
1015
priceless 9410
1016
primary 9410
1017
psychic 9410
1018
publicly 9410
1019
puddings 9410
1020
quagmire 9410
1021
quitter 9410
1022
railway 9410
1023
raining 9410
1024
rains 9410
1025
ravines 9410
1026
readable 9410
1027
realized 9410
1028
realtor 9410
1029
reassigned 9410
1030
recruited 9410
1031
reduce 9410
1032
regimented 9410
888
1033
registration 9410
1034
relatively 9410
1035
relaxing 9410
1036
relishing 9410
1037
relives 9410
1038
renew 9410
1039
repelled 9410
1040
repetitions 9410
1041
reporters 9410
1042
reporters 9410
1043
repressions 9410
1044
resplendent 9410
1045
resumes 9410
1046
rifles 9410
1047
rightful 9410
1048
rightfully 9410
1049
rightfulness 9410
1050
ripeness 9410
1051
riser 9410
1052
roped 9410
1053
rudeness 9410
1054
rules 9410
1055
rural 9410
1056
rusting 9410
889
1057
sadly 9410
890
positioning 9410
891
babysitting 9410
892
eternal 9410
893
hoarder 9410
894
congregates 9410
895
rains 9410
896
workers 9410
897
1058
sags 9410
898
unplug 9410
899
garage 9410
900
boulder 9410
901
specifics 9410
902
Teresa 9410
903
Winsett 9410
904
convenient 9410
905
buckboards 9410
906
amenities 9410
907
resplendent 9410
908
sews 9410
909
participated 9410
910
Simon 9410
911
certificates 9410
912
Fitzpatrick 9410
913
Evanston 9410
914
misted 9410
915
textures 9410
1059
sanding 9410
1060
saplings 9410
1061
sating 9410
916
1062
save 9410
917
count 9410
918
rightful 9410
919
chaperone 9410
920
Lizzy 9410
921
clenched 9410
922
effortlessly 9410
923
accessed 9410
924
beaters 9410
925
Hornblower 9410
926
vests 9410
927
indulgences 9410
928
infallibly 9410
929
unwilling 9410
930
excrete 9410
931
spools 9410
932
crunches 9410
933
overestimating 9410
934
ineffective 9410
935
humiliation 9410
936
sophomore 9410
937
star 9410
938
rifles 9410
939
dialysis 9410
940
arriving 9410
941
indulge 9410
942
clockers 9410
943
languages 9410
944
Antarctica 9410
945
percentage 9410
946
ceiling 9410
947
specification 9410
948
regimented 9410
949
ciphers 9410
950
pictures 9410
1063
sawtooth 9410
1064
scarf 9410
1065
scatterbrain 9410
1066
scheduling 9410
1067
schemer 9410
1068
scholastics 9410
1069
scornfully 9410
1070
secures 9410
1071
securing 9410
1072
seminaries 9410
1073
serializations 9410
951
1074
serpents 9410
952
allot 9410
953
realized 9410
954
mayoral 9410
955
opaquely 9410
956
hostess 9410
957
fiftieth 9410
958
incorrectly 9410
959
decomposition 9410
960
stranglings 9410
961
mixture 9410
962
electroencephalography 9410
1075
serving 9410
1076
severely 9410
1077
sews 9410
1078
shapelessly 9410
1079
shipyard 9410
1080
shooter 9410
963
1081
similarities 9410
964
charges 9410
965
freest 9410
966
Greenberg 9410
967
tinting 9410
968
expelled 9410
969
warm 9410
1082
skulking 9410
1083
slaughter 9410
1084
sloping 9410
970
1085
smoothed 9410
971
deductions 9410
972
Romano 9410
973
bitterroot 9410
974
corset 9410
975
securing 9410
976
environing 9410
977
cute 9410
978
Crays 9410
979
heiress 9410
980
inform 9410
981
avenge 9410
982
universals 9410
983
Kinsey 9410
984
ravines 9410
985
bestseller 9410
986
equilibrium 9410
987
extents 9410
988
relatively 9410
989
pressure 9410
990
critiques 9410
991
befouled 9410
992
rightfully 9410
993
mechanizing 9410
994
Latinizes 9410
995
timesharing 9410
996
Aden 9410
997
embassies 9410
998
males 9410
999
shapelessly 9410
1000
mastering 9410
1001
Newtonian 9410
1002
finishers 9410
1003
abates 9410
1004
teem 9410
1005
kiting 9410
1086
snatching 9410
1087
socializes 9410
1088
sophomore 9410
1089
sorters 9410
1090
spatial 9410
1091
specification 9410
1092
specifics 9410
1093
spongers 9410
1094
spools 9410
1095
sportswriting 9410
1096
sporty 9410
1097
squabbled 9410
1098
squeaking 9410
1099
squeezes 9410
1100
stabilizes 9410
1101
stairway 9410
1102
standardizes 9410
1103
star 9410
1104
starlet 9410
1105
stated 9410
1106
stint 9410
1006
1107
stodgy 9410
1007
feed 9410
1008
guitars 9410
1009
airships 9410
1010
1108
store 9410
1011
denounces 9410
1012
Pyle 9410
1013
Saxony 9410
1014
serializations 9410
1015
Peruvian 9410
1109
straight 9410
1110
stranglings 9410
1111
subdirectory 9410
1112
subjective 9410
1113
subschema 9410
1114
succumbed 9410
1115
suites 9410
1116
sumac 9410
1117
sureties 9410
1118
swaying 9410
1119
sweetish 9410
1120
swelling 9410
1121
syndicate 9410
1016
1122
taxonomically 9410
1017
kingdom 9410
1018
stint 9410
1019
Sault 9410
1020
faithful 9410
1021
Ganymede 9410
1123
techniques 9410
1124
teem 9410
1125
teethe 9410
1126
tempering 9410
1127
terminal 9410
1128
terminator 9410
1129
terminators 9410
1130
test 9410
1131
testicle 9410
1132
textures 9410
1133
theorizers 9410
1134
throttles 9410
1022
1135
tidiness 9410
1023
gainful 9410
1024
contrary 9410
1025
Tipperary 9410
1136
timesharing 9410
1137
tinily 9410
1138
tinting 9410
1139
title 9410
1140
tragedies 9410
1141
traitor 9410
1142
trimmings 9410
1026
1143
tropics 9410
1027
theorizers 9410
1028
renew 9410
1029
already 9410
1030
terminal 9410
1031
Hegelian 9410
1032
hypothesizer 9410
1144
unaffected 9410
1145
uncovering 9410
1146
undoes 9410
1147
ungrateful 9410
1148
universals 9410
1149
unplug 9410
1150
unruly 9410
1151
untying 9410
1152
unwilling 9410
1153
vacuuming 9410
1154
validate 9410
1155
vanish 9410
1156
ventilate 9410
1157
veranda 9410
1158
vests 9410
1159
wallet 9410
1160
waltz 9410
1161
warm 9410
1033
1162
warningly 9410
1034
journalizing 9410
1035
nested 9410
1036
Lars 9410
1037
saplings 9410
1038
foothill 9410
1039
labeled 9410
1040
imperiously 9410
1041
reporters 9410
1042
furnishings 9410
1043
precipitable 9410
1044
discounts 9410
1045
excises 9410
1046
Stalin 9410
1047
despot 9410
1048
ripeness 9410
1049
Arabia 9410
1050
unruly 9410
1051
mournfulness 9410
1052
boom 9410
1053
slaughter 9410
1054
Sabine 9410
1055
handy 9410
1056
rural 9410
1057
organizer 9410
1058
shipyard 9410
1059
civics 9410
1060
inaccuracy 9410
1061
rules 9410
1062
juveniles 9410
1063
comprised 9410
1064
investigations 9410
1065
stabilizes 9410
1066
seminaries 9410
1067
Hunter 9410
1068
sporty 9410
1069
test 9410
1163
watering 9410
1070
1164
weasels 9410
1071
CERN 9410
1072
tempering 9410
1073
afore 9410
1074
Galatean 9410
1075
techniques 9410
1076
error 9410
1077
veranda 9410
1078
severely 9410
1079
Cassites 9410
1080
forthcoming 9410
1081
guides 9410
1082
vanish 9410
1083
lied 9410
1084
sawtooth 9410
1085
fated 9410
1086
gradually 9410
1165
western 9410
1166
whiteners 9410
1087
1167
widens 9410
1088
preclude 9410
1089
evenhandedly 9410
1090
percentage 9410
1091
disobedience 9410
1092
humility 9410
1093
gleaning 9410
1094
petted 9410
1095
bloater 9410
1096
minion 9410
1097
marginal 9410
1098
apiary 9410
1099
measures 9410
1100
precaution 9410
1101
repelled 9410
1102
primary 9410
1103
coverings 9410
1104
Artemia 9410
1105
navigate 9410
1106
spatial 9410
1107
Gurkha 9410
1108
meanwhile 9410
1109
Melinda 9410
1110
Butterfield 9410
1111
Aldrich 9410
1112
previewing 9410
1113
glut 9410
1114
unaffected 9410
1115
inmate 9410
1116
mineral 9410
1117
impending 9410
1118
meditation 9410
1119
ideas 9410
1120
miniaturizes 9410
1121
lewdly 9410
1122
title 9410
1168
witchcraft 9410
1169
workers 9410
1170
yelped 9410
1123
1171
youthfulness 9410
1124
creak 9410
1125
Chippewa 9410
1126
clamored 9410
1127
freezes 9410
1128
forgivably 9410
1129
reduce 9410
1130
McGovern 9410
1131
Nazis 9410
1132
epistle 9410
1133
socializes 9410
1134
conceptions 9410
1135
Kevin 9410
1136
uncovering 9410
1137
chews 9410
1138
appendixes 9410
1139
raining 9410
1140
infest 9410
1141
compartment 9410
1142
minting 9410
1143
ducks 9410
1144
roped 9410
1145
waltz 9410
1146
Lillian 9410
1147
repressions 9410
1148
chillingly 9410
1149
noncritical 9410
1150
lithograph 9410
1151
spongers 9410
1152
parenthood 9410
1153
posed 9410
1154
instruments 9410
1155
filial 9410
1156
fixedly 9410
1157
relives 9410
1158
Pandora 9410
1159
watering 9410
1160
ungrateful 9410
1161
secures 9410
1162
poison 9410
1163
dusted 9410
1164
encompasses 9410
1165
presentation 9410
1166
Kantian 9410
1167
appendixes 9410
1168
appendixes 9410
1169
appendixes 9410
1170
appendixes 9410
1171
appendixes 9410
1172
1172
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;
1173
1173
fld3 period price price2
1174
1174
admonishing 1002 28357832 8723648
3206
3206
EXPLAIN SELECT * FROM t1
3207
3207
WHERE ID_better=1 AND ID1_with_null IS NULL AND ID2_with_null=3 ;
3208
3208
id select_type table type possible_keys key key_len ref rows Extra
3209
1 SIMPLE t1 index_merge idx1,idx2 idx2,idx1 4,10 NULL 1 Using intersect(idx2,idx1); Using where; Using index
3209
1 SIMPLE t1 index_merge idx1,idx2 idx2,idx1 4,10 NULL # Using intersect(idx2,idx1); Using where; Using index
3210
3210
EXPLAIN SELECT * FROM t1
3211
3211
WHERE ID_better=1 AND ID1_with_null=3 AND ID2_with_null=3 IS NULL ;
3212
3212
id select_type table type possible_keys key key_len ref rows Extra
3213
1 SIMPLE t1 ref idx1,idx2 idx2 4 const 2 Using where
3213
1 SIMPLE t1 ref idx1,idx2 idx2 4 const # Using where
3214
3214
EXPLAIN SELECT * FROM t1
3215
3215
WHERE ID_better=1 AND ID1_with_null IS NULL AND ID2_with_null IS NULL;
3216
3216
id select_type table type possible_keys key key_len ref rows Extra
3217
1 SIMPLE t1 ref idx1,idx2 idx2 4 const 2 Using where
3217
1 SIMPLE t1 ref idx1,idx2 idx2 4 const # Using where
3218
3218
DROP INDEX idx1 ON t1;
3219
3219
CREATE UNIQUE INDEX idx1 ON t1(ID1_with_null,ID2_with_null);
3220
3220
EXPLAIN SELECT * FROM t1
Loggerhead is a web-based interface for Breezy
Version: 2.0.1