Архив : [cache_ru] FW: [Cache-News] Correction to SQL NOT with AND or OR : группа пользователей постреляционной СУБД Cache

[Предыдущее - [cache_ru] Область по умолчанию в веб - интерфейсе] [Следующее - [cache_ru] Import global Как импортировать файл ?]

Письмо #5236

Тема: [cache_ru] FW: [Cache-News] Correction to SQL NOT with AND or OR
Начало этой темы: [cache_ru] FW: [Cache-News] Correction to SQL NOT with AND or OR
Это ответ на: нет
Ответ на это письмо: нет
От: Andrey Grachev Дата: 04 Октября 2006 19:53


С уважением,
Андрей Грачёв

InterSystems Corp, Россия
Руководитель отдела консалтинга


-----Original Message-----
Sent: Tuesday, October 03, 2006 8:57 PM
Subject: [Cache-News] Correction to SQL NOT with AND or OR

October 2, 2006 - Correction to SQL NOT with AND or OR

A problem has been corrected where SQL queries containing NOT in the
WHERE clause in conjunction with AND or OR could return the wrong results.


Cache 5.2, Ensemble 4.0


  Query that match the following format

SELECT f1 from Table1 where NOT (... AND...)

SELECT f1 from Table1 where NOT (... OR ...)


A bug fix that overhauled the way negation was handled in SQL statements
was incompletely integrated into Cache 5.2, which introduced this


InterSystems has a patch available that will prevent this problem
from happening. If you would like to receive this patch please
contact Support and reference Dev Change JLF090 and JLF111. This
correction will be part of Cache 2007.1 and Ensemble 4.0.1

If you have any questions regarding this advisory, please contact the
Worldwide Response Center at (617) 621-0700 or

This is an announcement mailing list for Cache'.
Cache' news, release information, and support issues from

InterSystems Corporation will be sent to this list.

The information is also posted to our website.

All the Cache' support issues announced on this list are at:


Current release information is available at:


Now available - Ensemble-News mailing list.  
You can get more information and sign up at:


You can also sign up for our monthly e-UpDate newsletter.  
In it you will find timely information about Cache' and InterSystems.  
See the latest edition and sign up at:



Subscription information about Cache-News is available at:


[2000|2001|2002|2003|2004|2005|2006|2007|2008] [Январь|Февраль|Март|Апрель|Май|Июнь]

Error. Page cannot be displayed. Please contact your service provider for more details. (5)