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

[PHP] cubrid_column_types could not get data type date

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: PHP 9.3.0.0001
    • Fix Version/s: PHP 9.3.0.0001
    • Component/s: PHP Driver
    • Labels:
    • Environment:

      Test Build: 9.3.0.0137
      Test OS: Linux 64bit
      PHP: 5.5.0
      Driver: cubrid-php9.3.0.0001(20140221)

      Description

      The cubrid_column_types() function doesn't work properly for date data type

      Test Case

      $conn = cubrid_connect("localhost", 33000, "demodb", "dba", "");
      
      @cubrid_execute($conn, "DROP TABLE t1");
      @cubrid_execute($conn, "CREATE TABLE t1 (col_1 date)");
      
      $result = cubrid_execute($conn, "SELECT * FROM t1;");
      
      $column_name = cubrid_column_names($result);
      $column_type = cubrid_column_types($result);
      
      var_dump($column_name);
      var_dump($column_type);
      
      

      Actual output

      array(1) { [0]=> string(5) "col_1" } array(1) { [0]=> string(7) "unknown" }
      

      Expecting output

      array(1) { [0]=> string(5) "col_1" } array(1) { [0]=> string(7) "date" }
      

        Activity

        Hide
        cn15800 谢韦华[Bert] added a comment -

        Fixed

        {code}
        array(1) { [0]=> string(5) "col_1" } array(1) { [0]=> string(4) "date" }{code}
        Show
        cn15800 谢韦华[Bert] added a comment - Fixed {code} array(1) { [0]=> string(5) "col_1" } array(1) { [0]=> string(4) "date" }{code}
        Hide
        ryin005 Ray Yin added a comment -

        Add a case for this issue

        RB-9.3.0

        [php@NC-PL-QA-012 _14_issues]$ svn ci --username cn14323 -m "[APIS-724]Add a case to test cubrid_column_types could not get data type date"
        Adding         _14_issues/_14_1h
        Adding         _14_issues/_14_1h/bugs_apis_724.phpt
        Transmitting file data .
        Committed revision 43045.
        

        Link: http://svn.bds.nhncorp.com/xdbms/cubridqa/branches/RB-9.3.0/interface/PHP/scenario/php/_14_issues/_14_1h/

        Show
        ryin005 Ray Yin added a comment - Add a case for this issue RB-9.3.0 [php@NC-PL-QA-012 _14_issues]$ svn ci --username cn14323 -m "[APIS-724]Add a case to test cubrid_column_types could not get data type date" Adding _14_issues/_14_1h Adding _14_issues/_14_1h/bugs_apis_724.phpt Transmitting file data . Committed revision 43045. Link: http://svn.bds.nhncorp.com/xdbms/cubridqa/branches/RB-9.3.0/interface/PHP/scenario/php/_14_issues/_14_1h/
        Hide
        ryin005 Ray Yin added a comment -

        Test Build: 9.3.0.0137
        Test OS: Linux 64bit
        PHP: 5.5.0
        Driver: cubrid-php9.3.0.0001(20140401)

        Test Result: Pass

        Show
        ryin005 Ray Yin added a comment - Test Build: 9.3.0.0137 Test OS: Linux 64bit PHP: 5.5.0 Driver: cubrid-php9.3.0.0001(20140401) Test Result: Pass

          People

          • Assignee:
            ryin005 Ray Yin
            Reporter:
            ryin005 Ray Yin
            CC (Referrer):
            Esen Sagynov, Isaiah Choe, 唐勤, 户向伟, 范再强, 谢韦华[Bert]
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: