select...where...in...union bug?

------_=_NextPart_001_01C4F554.7A5FF48D
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: base64

SGksDQoNCigxKSBJZiBJIGlzc3VlIHRoZSBmb2xsb3dpbmcgcXVlcnk6DQoN CiBTRUxFQ1QgR0VP
TV9DTEFTUy4qIEZST00gR0VPTV9DTEFTUw0KDQpJIGdldCB0aGUgZm9sbG93 aW5nIHJlc3VsdDoN
Cg0KICstLS0tLSsNCiB8IEdJRCB8DQogKy0tLS0tKw0KIHwgICAxIHwNCiB8 ICAgMiB8DQogKy0t
LS0tKw0KDQooMikgSWYgSSBpc3N1ZSB0aGUgZm9sbG93aW5nIHF1ZXJ5Og0K DQogU0VMRUNUIEdF
T01fQ0xBU1MuR0lEIEZST00gR0VPTV9DTEFTUyBXSEVSRSAoR0VPTV9DTEFT Uy5HSUQgPSAyKQ0K
IFVOSU9ODQogU0VMRUNUIEdFT01fQ0xBU1MuR0lEIEZST00gR0VPTV9DTEFT UyBXSEVSRSAoR0VP
TV9DTEFTUy5HSUQgPSAxKQ0KDQpJIGdldCB0aGUgZm9sbG93aW5nIHJlc3Vs dDoNCg0KICstLS0t
LSsNCiB8IEdJRCB8DQogKy0tLS0tKw0KIHwgICAyIHwNCiB8ICAgMSB8DQog Ky0tLS0tKw0KDQoo
MykgTm93LCBpZiBJIGNvbWJpbmUgKDEpIGFuZCAoMikgaW4gdGhlIGZvbGxv d2luZyB3YXk6DQoN
CiBTRUxFQ1QgR0VPTV9DTEFTUy4qIEZST00gR0VPTV9DTEFTUyBXSEVSRSAo R0VPTV9DTEFTUy5H
SUQgSU4gKA0KICBTRUxFQ1QgR0VPTV9DTEFTUy5HSUQgRlJPTSBHRU9NX0NM QVNTIFdIRVJFIChH
RU9NX0NMQVNTLkdJRCA9IDIpDQogIFVOSU9ODQogIFNFTEVDVCBHRU9NX0NM QVNTLkdJRCBGUk9N
IEdFT01fQ0xBU1MgV0hFUkUgKEdFT01fQ0xBU1MuR0lEID0gMSkNCiApKQ0K DQpJIGdldCB0aGUg
Zm9sbG93aW5nIHJlc3VsdDoNCg0KICstLS0tLSsNCiB8IEdJRCB8DQogKy0t LS0tKw0KIHwgICAx
IHwNCiArLS0tLS0rDQoNClNob3VsZG4ndCBJIGdldDoNCg0KICstLS0tLSsN CiB8IEdJRCB8DQog
Ky0tLS0tKw0KIHwgICAxIHwNCiB8ICAgMiB8DQogKy0tLS0tKw0KDQooNCkg SSBkbyBnZXQgdGhl
IGFib3ZlIHJlc3VsdCBpZiBJIHJ1biB0aGUgZm9sbG93aW5nIHF1ZXJ5Og0K DQogU0VMRUNUIEdF
T01fQ0xBU1MuKiBGUk9NIEdFT01fQ0xBU1MgV0hFUkUgKEdFT01fQ0xBU1Mu R0lEIElOICgNCiAg
U0VMRUNUIDIgVU5JT04gU0VMRUNUIDENCiApKQ0KDQp0aGFua3MgaW4gYWR2 YW5jZSwgQ2h1Y2sN
Cg0KDQo=

------_=_NextPart_001_01C4F554.7A5FF48D--

RE: select...where...in...union bug?

------_=_NextPart_001_01C4F559.5C909F9D
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: base64

SGVyZSBpcyB0aGUgc3FsIHNjcmlwdDoNCg0KLS0tY3V0IGhlcmUtLS0NCg0K LS0gTXlTUUwgZHVt
cCAxMC40DQotLQ0KLS0gSG9zdDogbG9jYWxob3N0ICAgIERhdGFiYXNlOiBm b28NCi0tIC0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLQ0KLS0gU2Vy
dmVyIHZlcnNpb24gNS4wLjAtYWxwaGEtbWF4LWRlYnVnDQoNCi8qITQwMTAx IFNFVCBAT0xEX0NI
QVJBQ1RFUl9TRVRfQ0xJRU5UPUBAQ0hBUkFDVEVSX1NFVF9DTElFTlQsIENI QVJBQ1RFUl9TRVRf
Q0xJRU5UPXV0ZjggKi87DQovKiE0MDAxNCBTRVQgQE9MRF9VTklRVUVfQ0hF Q0tTPUBAVU5JUVVF
X0NIRUNLUywgVU5JUVVFX0NIRUNLUz0wICovOw0KLyohNDAwMTQgU0VUIEBP TERfRk9SRUlHTl9L
RVlfQ0hFQ0tTPUBARk9SRUlHTl9LRVlfQ0hFQ0tTLCBGT1JFSUdOX0tFWV9D SEVDS1M9MCAqLzsN
Ci8qITQwMTAxIFNFVCBAT0xEX1NRTF9NT0RFPUBAU1FMX01PREUsIFNRTF9N T0RFPU5PX0FVVE9f
VkFMVUVfT05fWkVSTyAqLzsNCi0tIE15U1FMIGR1bXAgMTAuNA0KLS0NCi0t IEhvc3Q6IGxvY2Fs
aG9zdCAgICBEYXRhYmFzZTogZm9vDQotLSAtLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCi0tIFNlcnZlciB2ZXJzaW9uIDUu MC4wLWFscGhhLW1h
eC1kZWJ1Zw0KDQovKiE0MDEwMSBTRVQgQE9MRF9DSEFSQUNURVJfU0VUX0NM SUVOVD1AQENIQVJB
Q1RFUl9TRVRfQ0xJRU5ULCBDSEFSQUNURVJfU0VUX0NMSUVOVD11dGY4ICov Ow0KLyohNDAwMTQg
U0VUIEBPTERfVU5JUVVFX0NIRUNLUz1AQFVOSVFVRV9DSEVDS1MsIFVOSVFV RV9DSEVDS1M9MCAq
LzsNCi8qITQwMDE0IFNFVCBAT0xEX0ZPUkVJR05fS0VZX0NIRUNLUz1AQEZP UkVJR05fS0VZX0NI
RUNLUywgRk9SRUlHTl9LRVlfQ0hFQ0tTPTAgKi87DQovKiE0MDEwMSBTRVQg QE9MRF9TUUxfTU9E
RT1AQFNRTF9NT0RFLCBTUUxfTU9ERT1OT19BVVRPX1ZBTFVFX09OX1pFUk8g Ki87DQoNCi0tDQot
LSBUYWJsZSBzdHJ1Y3R1cmUgZm9yIHRhYmxlIGBnZW9tX2NsYXNzYA0KLS0N Cg0KRFJPUCBUQUJM
RSBJRiBFWElTVFMgZ2VvbV9jbGFzczsNCkNSRUFURSBUQUJMRSBnZW9tX2Ns YXNzICgNCiAgR0lE
IGRlY2ltYWwoMjAsMCkgTk9UIE5VTEwgZGVmYXVsdCAnMCcsDQogIERFU0NS SVBUSU9OIHZhcmNo
YXIoMTYpLA0KICBQUklNQVJZIEtFWSAgKEdJRCkNCikgRU5HSU5FPU15SVNB TSBERUZBVUxUIENI
QVJTRVQ9bGF0aW4xOw0KDQotLQ0KLS0gRHVtcGluZyBkYXRhIGZvciB0YWJs ZSBgZ2VvbV9jbGFz
c2ANCi0tDQoNCg0KLyohNDAwMDAgQUxURVIgVEFCTEUgZ2VvbV9jbGFzcyBE SVNBQkxFIEtFWVMg
Ki87DQpMT0NLIFRBQkxFUyBnZW9tX2NsYXNzIFdSSVRFOw0KSU5TRVJUIElO VE8gZ2VvbV9jbGFz
cyBWQUxVRVMgKCIxIiwgImFwcGxlcyIpLCgiMiIsICJvcmFuZ2VzIik7DQpV TkxPQ0sgVEFCTEVT
Ow0KLyohNDAwMDAgQUxURVIgVEFCTEUgZ2VvbV9jbGFzcyBFTkFCTEUgS0VZ UyAqLzsNCg0KLyoh
NDAxMDEgU0VUIFNRTF9NT0RFPUBPTERfU1FMX01PREUgPG1haWx0bzpTUUxf TU9ERT1AT0xEX1NR
TF9NT0RFPiAgKi87DQovKiE0MDAxNCBTRVQgRk9SRUlHTl9LRVlfQ0hFQ0tT PUBPTERfRk9SRUlH
Tl9LRVlfQ0hFQ0tTIDxtYWlsdG86Rk9SRUlHTl9LRVlfQ0hFQ0tTPUBPTERf Rk9SRUlHTl9LRVlf
Q0hFQ0tTPiAgKi87DQovKiE0MDAxNCBTRVQgVU5JUVVFX0NIRUNLUz1AT0xE X1VOSVFVRV9DSEVD
S1MgPG1haWx0bzpVTklRVUVfQ0hFQ0tTPUBPTERfVU5JUVVFX0NIRUNLUz4g ICovOw0KLyohNDAx
MDEgU0VUIENIQVJBQ1RFUl9TRVRfQ0xJRU5UPUBPTERfQ0hBUkFDVEVSX1NF VF9DTElFTlQgPG1h
aWx0bzpDSEFSQUNURVJfU0VUX0NMSUVOVD1AT0xEX0NIQVJBQ1RFUl9TRVRf Q0xJRU5UPiAgKi87
DQoNClNFTEVDVCBHRU9NX0NMQVNTLiogRlJPTSBHRU9NX0NMQVNTOw0KU0VM RUNUIEdFT01fQ0xB
U1MuR0lEIEZST00gR0VPTV9DTEFTUyBXSEVSRSAoR0VPTV9DTEFTUy5HSUQg PSAyKQ0KVU5JT04N
ClNFTEVDVCBHRU9NX0NMQVNTLkdJRCBGUk9NIEdFT01fQ0xBU1MgV0hFUkUg KEdFT01fQ0xBU1Mu
R0lEID0gMSk7DQpTRUxFQ1QgR0VPTV9DTEFTUy4qIEZST00gR0VPTV9DTEFT UyBXSEVSRSAoR0VP
TV9DTEFTUy5HSUQgSU4gKA0KU0VMRUNUIEdFT01fQ0xBU1MuR0lEIEZST00g R0VPTV9DTEFTUyBX
SEVSRSAoR0VPTV9DTEFTUy5HSUQgPSAyKQ0KVU5JT04NClNFTEVDVCBHRU9N X0NMQVNTLkdJRCBG
Uk9NIEdFT01fQ0xBU1MgV0hFUkUgKEdFT01fQ0xBU1MuR0lEID0gMSkNCikp Ow0KU0VMRUNUIEdF
T01fQ0xBU1MuKiBGUk9NIEdFT01fQ0xBU1MgV0hFUkUgKEdFT01fQ0xBU1Mu R0lEIElOICgNClNF
TEVDVCAyIFVOSU9OIFNFTEVDVCAxDQopKTsNCg0KLS0tY3V0IGhlcmUtLS0N Cg0KTm90ZSB0aGF0
IEkgYWRkZWQgYSAiREVTQ1JJUFRJT04iIGZpZWxkIHRvIHRoZSB0YWJsZSBz byB0aGF0IHRoZSBy
ZXN1bHQgSSB0aGluayBJIHNob3VsZCBnZXQgaXM6DQoNCistLS0tLSstLS0t LS0tLS0tLS0tKw0K
fCBHSUQgfCBERVNDUklQVElPTiB8DQorLS0tLS0rLS0tLS0tLS0tLS0tLSsN CnwgICAxIHwgYXBw
bGVzICAgICAgfA0KfCAgIDIgfCBvcmFuZ2VzICAgICB8DQorLS0tLS0rLS0t LS0tLS0tLS0tLSsN
Cg0KLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0gDQpGcm9tOiBDaHVjayBI YW4gDQpTZW50OiBG
cmkgMS83LzIwMDUgMTE6MzQgUE0gDQpUbzogYnVnc0BsaXN0cy5teXNxbC5j b20gDQpDYzogDQpT
dWJqZWN0OiBzZWxlY3QuLi53aGVyZS4uLmluLi4udW5pb24gYnVnPw0KDQoN Cg0KSGksDQoNCigx
KSBJZiBJIGlzc3VlIHRoZSBmb2xsb3dpbmcgcXVlcnk6DQoNCiBTRUxFQ1Qg R0VPTV9DTEFTUy4q
IEZST00gR0VPTV9DTEFTUw0KDQpJIGdldCB0aGUgZm9sbG93aW5nIHJlc3Vs dDoNCg0KICstLS0t
LSsNCiB8IEdJRCB8DQogKy0tLS0tKw0KIHwgICAxIHwNCiB8ICAgMiB8DQog Ky0tLS0tKw0KDQoo
MikgSWYgSSBpc3N1ZSB0aGUgZm9sbG93aW5nIHF1ZXJ5Og0KDQogU0VMRUNU IEdFT01fQ0xBU1Mu
R0lEIEZST00gR0VPTV9DTEFTUyBXSEVSRSAoR0VPTV9DTEFTUy5HSUQgPSAy KQ0KIFVOSU9ODQog
U0VMRUNUIEdFT01fQ0xBU1MuR0lEIEZST00gR0VPTV9DTEFTUyBXSEVSRSAo R0VPTV9DTEFTUy5H
SUQgPSAxKQ0KDQpJIGdldCB0aGUgZm9sbG93aW5nIHJlc3VsdDoNCg0KICst LS0tLSsNCiB8IEdJ
RCB8DQogKy0tLS0tKw0KIHwgICAyIHwNCiB8ICAgMSB8DQogKy0tLS0tKw0K DQooMykgTm93LCBp
ZiBJIGNvbWJpbmUgKDEpIGFuZCAoMikgaW4gdGhlIGZvbGxvd2luZyB3YXk6 DQoNCiBTRUxFQ1Qg
R0VPTV9DTEFTUy4qIEZST00gR0VPTV9DTEFTUyBXSEVSRSAoR0VPTV9DTEFT Uy5HSUQgSU4gKA0K
ICBTRUxFQ1QgR0VPTV9DTEFTUy5HSUQgRlJPTSBHRU9NX0NMQVNTIFdIRVJF IChHRU9NX0NMQVNT
LkdJRCA9IDIpDQogIFVOSU9ODQogIFNFTEVDVCBHRU9NX0NMQVNTLkdJRCBG Uk9NIEdFT01fQ0xB
U1MgV0hFUkUgKEdFT01fQ0xBU1MuR0lEID0gMSkNCiApKQ0KDQpJIGdldCB0 aGUgZm9sbG93aW5n
IHJlc3VsdDoNCg0KICstLS0tLSsNCiB8IEdJRCB8DQogKy0tLS0tKw0KIHwg ICAxIHwNCiArLS0t
LS0rDQoNClNob3VsZG4ndCBJIGdldDoNCg0KICstLS0tLSsNCiB8IEdJRCB8 DQogKy0tLS0tKw0K
IHwgICAxIHwNCiB8ICAgMiB8DQogKy0tLS0tKw0KDQooNCkgSSBkbyBnZXQg dGhlIGFib3ZlIHJl
c3VsdCBpZiBJIHJ1biB0aGUgZm9sbG93aW5nIHF1ZXJ5Og0KDQogU0VMRUNU IEdFT01fQ0xBU1Mu
KiBGUk9NIEdFT01fQ0xBU1MgV0hFUkUgKEdFT01fQ0xBU1MuR0lEIElOICgN CiAgU0VMRUNUIDIg
VU5JT04gU0VMRUNUIDENCiApKQ0KDQp0aGFua3MgaW4gYWR2YW5jZSwgQ2h1 Y2sNCg0KDQo=

------_=_NextPart_001_01C4F559.5C909F9D--