table_info bug with Sybase - switches database ?

[Hall, Roger]

Hi,

I am using DBI-1.14.tar.gz and DBD-Sybase-0.91.tar.gz and am getting
some behavior that I do not understand... I guess its either me or a bug.

When I use table_info, I seem to be switching to the default database of the
login id that I use. An example of some code I was testing stuff with is
shown
below. The two prints show me a different database.

Roger.


##################################################
      my($sth_1, $sth_2, $sth_3);
      $sth_1 = $sybh->prepare("select db_name()"); 
      $sth_1->execute();
      while (my($d) = $sth_1->fetchrow_array()) {
          print "***** $d *****\n";
      }
##################################################

   my $tabsth = $dbh->table_info();
   my $colsth;
   my $sql;
   my $table;

###############################################################
      $sth_1 = $dbh->prepare("select db_name()");
      $sth_1->execute();
      while (my($d) = $sth_1->fetchrow_array()) {
          print "***** $d *****\n";
      }