Обсуждение: BUG #14385: Operator IS changed priority in 9.5
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDM4NQpMb2dnZWQgYnk6ICAg ICAgICAgIFN0cmFoaW5qYSBLdXN0dWRpYwpFbWFpbCBhZGRyZXNzOiAgICAg IHN0cmFoaW5qYWtAbm9yZGV1cy5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5 LjUuNApPcGVyYXRpbmcgc3lzdGVtOiAgIENlbnRPUyA2CkRlc2NyaXB0aW9u OiAgICAgICAgCgpJZiB3ZSBjcmVhdGUgYSB0ZXN0IHRhYmxlIGxpa2UgdGhp czoNCg0KdGVzdC0jIGNyZWF0ZSB0YWJsZSB0ZXN0IChpIGludGVnZXIsIGIg Ym9vbGVhbik7DQoNCkFuZCBpbnNlcnQgdGhlIGZvbGxvd2luZyBkYXRhOg0K DQp0ZXN0LSMgaW5zZXJ0IGludG8gdGVzdCAoaSkgdmFsdWVzICg1KSwgKG51 bGwpOw0KdGVzdC0jIHVwZGF0ZSB0ZXN0IHNldCBiID0gaSBpcyBub3QgbnVs bDsNCg0KV2hlbiB3ZSBydW4gdGhlIGZvbGxvd2luZyBzZWxlY3Qgb24gUG9z dGdyZXMgOS4xLTkuNDoNCnRlc3QtIyBzZWxlY3QNCnRlc3QtIyAgJ2FhYScg fHwgaSBpcyBub3QgbnVsbCB8fCAnYmJiJyBhcyB2MSwNCnRlc3QtIyAgJ2Fh YScgfHwgYiB8fCAnYmJiJyBhcyB2MiwNCnRlc3QtIyAgJ2FhYScgfHwgaSBp cyBub3QgbnVsbCB8fCAnYmJiJyA9ICdhYWEnIHx8IGIgfHwgJ2JiYicgYXMg djFfZXFfdjINCnRlc3QtIyBmcm9tIHRlc3Q7DQogICAgIHYxICAgICAgfCAg ICAgdjIgICAgICB8IHYxX2VxX3YyIA0KLS0tLS0tLS0tLS0tLSstLS0tLS0t LS0tLS0tKy0tLS0tLS0tLS0NCiBhYWF0cnVlYmJiICB8IGFhYXRydWViYmIg IHwgdA0KIGFhYWZhbHNlYmJiIHwgYWFhZmFsc2ViYmIgfCB0DQooMiByb3dz KQ0KDQpidXQgaWYgd2UgcnVuIHRoZSBzYW1lIHF1ZXJ5IG9uIDkuNSB3ZSBn ZXQgYSBkaWZmZXJlbnQgb3V0cHV0Og0KDQp0ZXN0LSMgc2VsZWN0DQp0ZXN0 LSMgICdhYWEnIHx8IGkgaXMgbm90IG51bGwgfHwgJ2JiYicgYXMgdjEsDQp0 ZXN0LSMgICdhYWEnIHx8IGIgfHwgJ2JiYicgYXMgdjIsDQp0ZXN0LSMgICdh YWEnIHx8IGkgaXMgbm90IG51bGwgfHwgJ2JiYicgPSAnYWFhJyB8fCBiIHx8 ICdiYmInIGFzIHYxX2VxX3YyDQp0ZXN0LSMgZnJvbSB0ZXN0Ow0KICAgIHYx ICAgIHwgICAgIHYyICAgICAgfCB2MV9lcV92MiANCi0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tLSstLS0tLS0tLS0tDQogdHJ1ZWJiYiAgfCBhYWF0cnVlYmJi ICB8IGYNCiBmYWxzZWJiYiB8IGFhYWZhbHNlYmJiIHwgZg0KKDIgcm93cykN Cg0KQXMgeW91IGNhbiBzZWUgOS41IHJlbW92ZXMgdGhlIGZpcnN0ICdhYWEn IHN0cmluZyBmcm9tIGNvbmNhdGVuYXRpb24uIFdlCmd1ZXNzIGl0J3MgYmVj YXVzZSBvZiB0aGUgb3BlcmF0b3IgSVMgcHJpb3JpdHkgaGFzIGNoYW5nZWQg aW4gOS41LCBiZWNhdXNlCmlmIHdlIHB1dCAnaSBpcyBub3QgbnVsbCcgYmV0 d2VlbiBwYXJlbnRoZXNpcywgaXQgd29ya3MgbGlrZSBiZWZvcmUgOS41Og0K DQp0ZXN0LSMgc2VsZWN0DQp0ZXN0LSMgICdhYWEnIHx8IChpIGlzIG5vdCBu dWxsKSB8fCAnYmJiJyBhcyB2MSwNCnRlc3QtIyAgJ2FhYScgfHwgYiB8fCAn YmJiJyBhcyB2MiwNCnRlc3QtIyAgJ2FhYScgfHwgKGkgaXMgbm90IG51bGwp IHx8ICdiYmInID0gJ2FhYScgfHwgYiB8fCAnYmJiJyBhcwp2MV9lcV92Mg0K dGVzdC0jIGZyb20gdGVzdDsNCiAgICAgdjEgICAgICB8ICAgICB2MiAgICAg IHwgdjFfZXFfdjIgDQotLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0t LS0tLS0tLQ0KIGFhYXRydWViYmIgIHwgYWFhdHJ1ZWJiYiAgfCB0DQogYWFh ZmFsc2ViYmIgfCBhYWFmYWxzZWJiYiB8IHQNCigyIHJvd3MpDQoNCldlIGNv dWxkbid0IGZpbmQgYW55IGRvY3VtZW50YXRpb24gY2hhbmdlcyBhYm91dCB0 aGlzLCBzbyBpcyB0aGlzIGEgYnVnLCBvcgp3YXMgaXQgaW50ZW50aW9uYWw/ Cgo=
You can ignore this bug, since it's not a bug. We found it in the official documentation https://www.postgresql.org/docs/9.5/static/release-9-5.html once we reported it.
At first we thought it was a bug with the '||' operator, so we couldn't find it in the documentation, then while we were reporting it we realized it is a change in operator precedence. We mostly checked the https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.5 for new changes, but in there it wasn't mention.
Sorry about this and thanks for the operator_precedence_warning, it will help a lot.At first we thought it was a bug with the '||' operator, so we couldn't find it in the documentation, then while we were reporting it we realized it is a change in operator precedence. We mostly checked the https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.5 for new changes, but in there it wasn't mention.