Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread AV with union
Thu, Mar 22 2007 6:53 AMPermanent Link

"Ole Willy Tuv"
select
 (true and true) true_and_true,
 (true and false) true_and_false,
 (true and cast(null as boolean)) true_and_unknown,
 (false and true) false_and_true,
 (false and false) false_and_false,
 (false and cast(null as boolean)) false_and_unknown,
 (cast(null as boolean) and true) unknown_and_true,
 (cast(null as boolean) and false) unknown_and_false,
 (cast(null as boolean) and cast(null as boolean)) unknown_and_unknown
from dummy
union all
select
 true,
 false,
 cast(null as boolean),
 false,
 false,
 false,
 cast(null as boolean),
 false,
 cast(null as boolean)
from dummy

Error:
Access violation at address 00403FE8 in module 'edbmgr.exe'. Read of address
0A890867

"dummy" is a single-column table with the structure (col1 integer)
containing a single row with the null value.

Ole Willy Tuv

Thu, Mar 22 2007 5:46 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Ole,

This must be related to some other issue that has been fixed already since
it works fine here with the latest fixes applied.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image