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

[Perl]Method of type_info_all can't work normally

    Details

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

      Description

      Test Build:CUBRID 2008 R4.0 (8.4.0.2019) (64bit release build for linux_gnu)
      OS: Linux 64
      Description: Method of type_info_all can't work normally

      Repro Steps:
      perl type_info_all_01.pl

      Actual result:

      can't return result of type_info_all
      

      Expect result:

      return a refence to an array. this array contain the information about each data type.
      such as:
      DATA_TYPE: 12;   TYPE_NAME: varchar;    
      DATA_TYPE: 3;    TYPE_NAME: decimal;     
      DATA_TYPE: -6;   TYPE_NAME: tinyint;     
      DATA_TYPE: 5;    TYPE_NAME: smallint;   
      DATA_TYPE: 4;    TYPE_NAME: integer;     
      DATA_TYPE: 7;    TYPE_NAME: float;       
      DATA_TYPE: 6;    TYPE_NAME: double;      
      DATA_TYPE: 8;    TYPE_NAME: double;      
      DATA_TYPE: 11;   TYPE_NAME: timestamp;   
      DATA_TYPE: -5;   TYPE_NAME: bigint;      
      DATA_TYPE: 4;    TYPE_NAME: middleint;   
      DATA_TYPE: 9;    TYPE_NAME: date;        
      DATA_TYPE: 10;   TYPE_NAME: time;        
      
      
      1. APIS-63_FIX01.creview
        7 kB
        张慧
      2. APIS-63_FIX02.creview
        25 kB
        张慧
      3. type_info_all_01.pl
        0.7 kB
        ZouJing

        Activity

        Hide
        hellohuizhang 张慧 added a comment -

        Actually, we haven't implement this function yet. Therefore, we add it in rev: 332

        Show
        hellohuizhang 张慧 added a comment - Actually, we haven't implement this function yet. Therefore, we add it in rev: 332
        Hide
        zoujing ZouJing added a comment -

        Now the results:

        DATA_TYPE: 1;    TYPE_NAME: CHAR;        cubrid:  CHAR
        DATA_TYPE: 12;   TYPE_NAME: VARCHAR;     cubrid:  VARCHAR
        DATA_TYPE: -2;   TYPE_NAME: BIT;         cubrid:  BIT
        DATA_TYPE: -3;   TYPE_NAME: BIT VARYING;         cubrid:  BIT VARYING
        DATA_TYPE: 2;    TYPE_NAME: NUMERIC;     cubrid:  NUMERIC
        DATA_TYPE: 3;    TYPE_NAME: DECIMAL;     cubrid:  DECIMAL
        DATA_TYPE: 4;    TYPE_NAME: INTEGER;     cubrid:  INTEGER
        DATA_TYPE: 5;    TYPE_NAME: SMALLINT;    cubrid:  SMALLINT
        DATA_TYPE: 7;    TYPE_NAME: REAL;        cubrid:  REAL
        DATA_TYPE: 6;    TYPE_NAME: FLOAT;       cubrid:  FLOAT
        DATA_TYPE: 8;    TYPE_NAME: DOUBLE;      cubrid:  DOUBLE
        DATA_TYPE: 91;   TYPE_NAME: DATE;        cubrid:  DATE
        DATA_TYPE: 92;   TYPE_NAME: TIME;        cubrid:  TIME
        DATA_TYPE: 93;   TYPE_NAME: TIMESTAMP;   cubrid:  TIMESTAMP
        DATA_TYPE: -5;   TYPE_NAME: BIGINT;      cubrid:  BIGINT
        DATA_TYPE: 93;   TYPE_NAME: DATETIME;    cubrid:  DATETIME
        

        But those results don't contain some types, such as blob,character varying, clob, datetime, monetary, glo, set_of and so on

        Show
        zoujing ZouJing added a comment - Now the results: DATA_TYPE: 1; TYPE_NAME: CHAR; cubrid: CHAR DATA_TYPE: 12; TYPE_NAME: VARCHAR; cubrid: VARCHAR DATA_TYPE: -2; TYPE_NAME: BIT; cubrid: BIT DATA_TYPE: -3; TYPE_NAME: BIT VARYING; cubrid: BIT VARYING DATA_TYPE: 2; TYPE_NAME: NUMERIC; cubrid: NUMERIC DATA_TYPE: 3; TYPE_NAME: DECIMAL; cubrid: DECIMAL DATA_TYPE: 4; TYPE_NAME: INTEGER; cubrid: INTEGER DATA_TYPE: 5; TYPE_NAME: SMALLINT; cubrid: SMALLINT DATA_TYPE: 7; TYPE_NAME: REAL; cubrid: REAL DATA_TYPE: 6; TYPE_NAME: FLOAT; cubrid: FLOAT DATA_TYPE: 8; TYPE_NAME: DOUBLE; cubrid: DOUBLE DATA_TYPE: 91; TYPE_NAME: DATE; cubrid: DATE DATA_TYPE: 92; TYPE_NAME: TIME; cubrid: TIME DATA_TYPE: 93; TYPE_NAME: TIMESTAMP; cubrid: TIMESTAMP DATA_TYPE: -5; TYPE_NAME: BIGINT; cubrid: BIGINT DATA_TYPE: 93; TYPE_NAME: DATETIME; cubrid: DATETIME But those results don't contain some types, such as blob,character varying, clob, datetime, monetary, glo, set_of and so on
        Hide
        xiaoshan78 李成龙[이성룡] added a comment -

        add blob, character varying, clob related information

        Show
        xiaoshan78 李成龙[이성룡] added a comment - add blob, character varying, clob related information
        Hide
        hellohuizhang 张慧 added a comment -

        Commit rev: 361

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

        Test build : CUBRID 2008 R4.0 (8.4.0.2019)
        OS: Linux 64bit
        Test Result: PASS

        ADD BLOB and CLOB

        Show
        zoujing ZouJing added a comment - Test build : CUBRID 2008 R4.0 (8.4.0.2019) OS: Linux 64bit Test Result: PASS ADD BLOB and CLOB

          People

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

            Dates

            • Created:
              Updated:
              Resolved: