Strange DBI Bug

farkasp_at_post.ch
Date: 03/23/05 

Date: Wed, 23 Mar 2005 19:56:48 +0100
To: <dbi-users@perl.org>

Hi!

This statement

 $SqlStr_pstes_i = "insert into zplus_pstes\@$dwh_link (PSTES_OC, PSTES_ECO_SCHAPO, PSTES_DATUM) ".
                   "select PSTES_OC, PSTES_ECO_SCHAPO, PSTES_DATUM ".
                   "from zplus_pstes ".
                   "where PSTES_OC = :1 and PSTES_DATUM = to_date(:2, 'yyyymmdd')";

causes a deadlock. But accidently, we found that this one (with just the first two columns exchanged)

 $SqlStr_pstes_i = "insert into zplus_pstes\@$dwh_link (PSTES_ECO_SCHAPO, PSTES_OC, PSTES_DATUM) ".
                   "select PSTES_ECO_SCHAPO, PSTES_OC, PSTES_DATUM ".
                   "from zplus_pstes ".
                   "where PSTES_OC = :1 and PSTES_DATUM = to_date(:2, 'yyyymmdd')";

works!

We use DBI version 1.42.

Best regards
Peter

BSI Business Systems Integration AG
Täfernstrasse 16a
CH-5405 Baden-Dättwil
Phone (direct): +41 56 484 16 86
http://www.bsiag.com <http://www.bsiag.com/>

Relevant Pages