Uploaded image for project: 'CUBRID APIs'
  1. CUBRID APIs
  2. APIS-101

[Perl]Data was inserted into demodb DB when url isn't correct

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: Perl-8.4.1
    • Fix Version/s: Perl-8.4.1, Perl-Apricot
    • Component/s: Perl Driver
    • Labels:
      None

      Description

      Test Build: CUBRID 2008 R4.1 (8.4.1.1005) (64bit release build for linux_gnu)
      OS: Linux 64
      Description: Data was inserted into demodb DB when url isn't correct

      Repro Steps:
      perl prepare_test2.pl pldb2 33000 10.34.64.60

      Statements in prepare_test2.pl:

      $db=$ARGV[0];
      $port=$ARGV[1];
      $hostname=$ARGV[2];
      my $user="dba";
      my $pass="";
      
      my $data_source="dbi:cubrid:databaseaaaaa=$db;host=$hostname;port=$port";
      print $data_source ."\n";
      my $dbh;
      
      $dbh=DBI->connect($data_source, $user, $pass,{RaiseError => 1}) or die "connect err: $dbh->errstr";
      
      $dbh -> do("drop table if EXISTS tbl;") or die "drop error: $dbh->errstr";
      $dbh -> do("create table tbl(id int, name char(20));") or die "create error: $dbh->errstr";
      $dbh -> do("insert into tbl values(1,'zhangsan'),(2,'lisi'),(3,'wangwu'),(4,'mazi');") or die "insert error:$dbh->errstr";
      

      Actual Results:

      dbi:cubrid:databaseaaaaa=pldb2;host=10.34.64.60;port=33000
      1..1
      ok 1 - prepare of delete succeed
      
      csql -udba demodb
      
      csql> show tables;
      
      === <Result of SELECT Command in Line 4> ===
      
        Tables_in_demodb    
      ======================
        'tbl'               
      
      
      1 rows selected.
      
      

      Expect result:
      1.error appear
      2.tbl table can't be created in demodb

      1. APIS-101_FIX01.creview
        25 kB
        张慧
      2. prepare_test2.pl
        0.9 kB
        ZouJing

        Activity

        Hide
        hellohuizhang 张慧 added a comment -

        Commit rev: 467

        Show
        hellohuizhang 张慧 added a comment - Commit rev: 467
        Hide
        zoujing ZouJing added a comment -

        Test build : CUBRID 2008 R4.1 (8.4.1.1018)
        OS: Linux 64bit
        Test Result: PASS
        so i close it

        Show
        zoujing ZouJing added a comment - Test build : CUBRID 2008 R4.1 (8.4.1.1018) OS: Linux 64bit Test Result: PASS so i close it

          People

          • Assignee:
            zoujing ZouJing
            Reporter:
            zoujing ZouJing
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: