Re: ����� ������ ���� ...

[Malinovsky Vladimir]

"Fynda" >
> îÁÓÞÅÔ FAQ ÎÅ ÚÎÁÀ, Á × bugtracker'Å ÎÅÞÔÏ ÐÏÄÏÂÎÏÅ ÕÖÅ ÅÓÔØ: 
> http://tracker.firebirdsql.org/browse/CORE-989
> ôÁË ÞÔÏ ÄÕÍÁÀ ÒÁÚÒÁÂÏÔÞÉËÉ × ËÕÒÓÅ ÔÁËÏÇÏ ÐÏ×ÅÄÅÎÉÑ.
>

ëÁËÏÊ "âáç"???

èÒÅÎ Ó ÎÉÍÉ, Ó ÖÕÒÎÁÌÁÍÉ [EMAIL PROTECTED]

óÍÏÔÒÉ:

 select 'Ok' from  rdb$database
   where 0 not in  (null, 1)

ÔÏ ÖÅ ÓÁÍÏÅ, ÞÔÏ:

 select 'Ok' from  rdb$database
   where not (null=0 or 1=0)

ÉÌÉ ÔÏÖÅ ÓÁÍÏÅ:

 select 'Ok' from  rdb$database
   where (null<>0 and 1<>0)
(ÐÏÔÏÍÕ ÞÔÏ
not (A=B or C=D) = =  (A<>B) and (C<>D)
)

÷ÏÚ×ÒÁÝÁÅÍÓÑ Ë ÐÏÓÌÅÄÎÅÍÕ:

 select 'Ok' from  rdb$database
   where (null<>0 and 1<>0)

á null<>0 - ×ÓÅÇÄÁ false
False and ÞÔÏ_ÕÇÏÄÎÏ ÔÏÖÅ ×ÓÅÇÄÁ false.

÷ÏÔ É ×ÓÅ. é ÎÉËÁËÉÈ ÂÁÇÏ×.
ðÔÉÞËÁ - ÒÕÌÅÚ.

(ÅÓÔØ ÄÌÉÎÎÀÞÅÅ ÏÂÓÕÖÄÅÎÉÅ ÜÔÏÇÏ ÖÅ "ÂÁÇÁ" ÎÁ ïÒÁËÌÅ:
http://oracle.ukrsat.com/tutorial/openxs.php?n=18)

:)