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

[PHP]Return value of cubrid_column_types() is "unknown" when the column is set(list)

    Details

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

      Description

      Test Build: CUBRID 2008 R4.1 (8.4.1.3024)
      OS: Linux 64
      Description:
      when the column likes set(set), set(multiset), set(list), set(sequence) or multiset(int, CHAR(1)), the return value of cubrid_column_types() is "unknown"

      Repro steps:
      php issue12.php

      Statements in issue12.php

      $create_result=cubrid_query("create class collection_tb(sChar set(char(10)),
         ...................
              sTimestamp set(timestamp),
              sSet set(set),
              sMultiSet set(multiset),
              sList set(list),
              sSequence set(sequence),
              multiset_t multiset(int, CHAR(1)),
              list_t list(float, VARCHAR(1))
      )");
      if (!$create_result) {
          die('Create Failed: ' . cubrid_error());
      }
      
      $result = cubrid_execute($conn, "SELECT * FROM collection_tb;");
      
      $column_names = cubrid_column_names($result);
      $column_types = cubrid_column_types($result);
      

      Actual result

      Column Names                   Column Types          Column Maxlen  
      stimestamp                     timestamp                      1073741823     
      sset                           unknown                        1073741823     
      smultiset                      unknown                        1073741823     
      slist                          unknown                        1073741823     
      ssequence                      unknown                        1073741823     
      multiset_t                     unknown                        1073741823     
      list_t                         unknown                        1073741823     
      

      Expect result:
      Maybe the return value of cubrid_column_types() is set or multiset when the column is set(set), set(multiset), set(list), set(sequence) or multiset(int, CHAR(1))

      1. APIS-196_FIX01.creview
        55 kB
        张慧
      2. issue12.php
        2 kB
        ZouJing

        Activity

        Hide
        hellohuizhang 张慧 added a comment -

        Commit rev on PHP-8.4.1: 607

        Show
        hellohuizhang 张慧 added a comment - Commit rev on PHP-8.4.1: 607
        Hide
        hellohuizhang 张慧 added a comment -

        Fixed on PHP-8.4.1

        Show
        hellohuizhang 张慧 added a comment - Fixed on PHP-8.4.1
        Hide
        zoujing ZouJing added a comment -

        Test build : CUBRID 2008 R4.1 (8.4.1.3024)
        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.3024) OS: Linux 64bit Test Result: PASS so i close it

          People

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

            Dates

            • Created:
              Updated:
              Resolved: