Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.23 » View Incident Report |
Serious |
Reported By: Oliver Bock Reported On: 3/12/2006 For: Version 4.22 Build 6 |
drop table if exists t1; create table t1 (f1 INTEGER NOT NULL, f2 BOOLEAN NOT NULL, primary key (f1)); insert into t1 (f1, f2) values (1, true); insert into t1 (f1, f2) values (2, false); drop table if exists t2; create table t2 (f1 INTEGER NOT NULL, f3 INTEGER, primary key (f1)); insert into t2 (f1) values (3); insert into t2 (f1, f3) values (4, 0); select t1.f1, t2.f1, t2.f3, if(t1.f2, t2.f3 is not null, false) from t1 join t2 on t2.f1 = 3 and if(t1.f2, t2.f3 is not null, false);
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |