Обсуждение: BUG #14176: Re: BUG #14173: Not using partitions with ANY(ARRAY[...])
BUG #14176: Re: BUG #14173: Not using partitions with ANY(ARRAY[...])
От
furstenheim@gmail.com
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDE3NgpMb2dnZWQgYnk6ICAg ICAgICAgIEdhYnJpZWwgZgpFbWFpbCBhZGRyZXNzOiAgICAgIGZ1cnN0ZW5o ZWltQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNS4zCk9wZXJh dGluZyBzeXN0ZW06ICAgTGludXggNjRiaXQKRGVzY3JpcHRpb246ICAgICAg ICAKClRoaXMgaXMgYW4gYW5zd2VyIHRvCmh0dHBzOi8vd3d3LnBvc3RncmVz cWwub3JnL21lc3NhZ2UtaWQvMTI5NTUuMTQ2NDk2Mzc3NSU0MHNzcy5wZ2gu cGEudXMgDQoNCklmIHRoZSB0eXBlIGlzIGFuIGludGVnZXIgdGhlbiBJIGRv bid0IGhhdmUgdGhlIHByb2JsZW0uIEhvd2V2ZXIgaWYgSSB1c2UKY2hhcigy KSB0aGVuIEkgaGF2ZSBpdC4NCg0KY3JlYXRlIHRhYmxlIG10YWJsZSAobXZh ciBjaGFyICgyKSk7DQpjcmVhdGUgdGFibGUgYzEgKGNoZWNrIChtdmFyID0g J2FhJykpIGluaGVyaXRzKG10YWJsZSk7DQpjcmVhdGUgdGFibGUgYzIgKGNo ZWNrIChtdmFyID0gJ2JiJykpIGluaGVyaXRzKG10YWJsZSk7DQpleHBsYWlu IHNlbGVjdCAqIGZyb20gbXRhYmxlIHdoZXJlIG12YXIgPSAnYWEnOw0KJ0Fw cGVuZCAoY29zdD0wLjAwLi4zNS41MCByb3dzPTExIHdpZHRoPTEyKScNCicg LT4gU2VxIFNjYW4gb24gbXRhYmxlIChjb3N0PTAuMDAuLjAuMDAgcm93cz0x IHdpZHRoPTEyKScNCicgRmlsdGVyOiAobXZhciA9ICdhYSc6OmJwY2hhcikn DQonIC0+IFNlcSBTY2FuIG9uIGMxIChjb3N0PTAuMDAuLjM1LjUwIHJvd3M9 MTAgd2lkdGg9MTIpJw0KJyBGaWx0ZXI6IChtdmFyID0gJ2FhJzo6YnBjaGFy KScNCg0KZXhwbGFpbiBzZWxlY3QgKiBmcm9tIG10YWJsZSB3aGVyZSBtdmFy ID0gYW55IChhcnJheVsnYWEnXSk7DQonQXBwZW5kIChjb3N0PTAuMDAuLjc2 LjEwIHJvd3M9MjEgd2lkdGg9MTIpJw0KJyAtPiBTZXEgU2NhbiBvbiBtdGFi bGUgKGNvc3Q9MC4wMC4uMC4wMCByb3dzPTEgd2lkdGg9MTIpJw0KJyBGaWx0 ZXI6ICgobXZhcik6OnRleHQgPSBBTlkgKCd7YWF9Jzo6dGV4dFtdKSknDQon IC0+IFNlcSBTY2FuIG9uIGMxIChjb3N0PTAuMDAuLjM4LjA1IHJvd3M9MTAg d2lkdGg9MTIpJw0KJyBGaWx0ZXI6ICgobXZhcik6OnRleHQgPSBBTlkgKCd7 YWF9Jzo6dGV4dFtdKSknDQonIC0+IFNlcSBTY2FuIG9uIGMyIChjb3N0PTAu MDAuLjM4LjA1IHJvd3M9MTAgd2lkdGg9MTIpJw0KJyBGaWx0ZXI6ICgobXZh cik6OnRleHQgPSBBTlkgKCd7YWF9Jzo6dGV4dFtdKSknDQoNCkN1cmlvdXNs eSBpZiBJIHVzZSBjaGFyIHZhcnlpbmcoMikgdGhlbiBpdCB3b3JrcyBhcyBl eHBlY3RlZA0KDQpQUyBzb3JyeSBJIGNhbm5vdCBmaW5kIGhvdyB0byBhbnN3 ZXIgZGlyZWN0bHkgdG8gdGhlIG1haWwKCg==
Hi: On Fri, Jun 3, 2016 at 6:14 PM, <furstenheim@gmail.com> wrote: > If the type is an integer then I don't have the problem. However if I use > char(2) then I have it. char tends to do this things. Anyway.... ..... > ' Filter: ((mvar)::text = ANY ('{aa}'::text[]))' Notice the ::text[]? > Curiously if I use char varying(2) then it works as expected Maybe because text[] and varchar[] convert and text[] and char(2)[] not, you could try to use explicit types ( array['aa'::char(2)] ). I've seen this happen in other contexts when using char ( unqualified strings are text, text does not convert that well to char the moment there is something, like an array[], any() or other function calls, in the middle ). > PS sorry I cannot find how to answer directly to the mail There is alway cut&paste for these things. Francisco Olarte.