Return to field_funcs2.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / oci8 / tests

Annotation of embedaddon/php/ext/oci8/tests/field_funcs2.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: Bug #41917 (invalid scale and precision)
        !             3: --SKIPIF--
        !             4: <?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
        !             5: --FILE--
        !             6: <?php
        !             7: 
        !             8: require(dirname(__FILE__)."/connect.inc");
        !             9: 
        !            10: $s = oci_parse($c, 'drop table field_funcs2_tab');
        !            11: @oci_execute($s);
        !            12: 
        !            13: $t = array("C01" => "NUMBER",
        !            14:                   "C02" => "NUMBER(*,1)",
        !            15:                   "C03" => "NUMBER(9)",
        !            16:                   "C04" => "NUMBER(9,2)",
        !            17:                   "C05" => "NUMBER(9,1)",
        !            18:                   "C06" => "NUMBER(7,-2)",
        !            19:                   "C07" => "DECIMAL(4,9)",
        !            20:                   "C08" => "NUMERIC(4,9)",
        !            21:                   "C09" => "DECIMAL(4)",
        !            22:                   "C10" => "INTEGER",
        !            23:                   "C11" => "INT",
        !            24:                   "C12" => "SMALLINT",
        !            25:                   "C13" => "FLOAT",
        !            26:                   "C14" => "FLOAT(9)",
        !            27:                   "C15" => "DOUBLE PRECISION",
        !            28:                   "C16" => "REAL",
        !            29:                   );
        !            30: 
        !            31: $stmt = "create table field_funcs2_tab (\n";
        !            32: foreach ($t as $colname => $type) {
        !            33:        $stmt .= "$colname $type,\n";
        !            34: }
        !            35: $stmt[strlen($stmt)-2] = ")";
        !            36: 
        !            37: $s = oci_parse($c, $stmt);
        !            38: oci_execute($s);
        !            39: 
        !            40: $s = oci_parse($c, "select * from field_funcs2_tab");
        !            41: oci_execute($s);
        !            42: 
        !            43: for ($i = 1; $i <= oci_num_fields($s); $i++) {
        !            44:        $name = oci_field_name($s, $i);
        !            45:        $precision = oci_field_precision($s, $i);
        !            46:        $scale = oci_field_scale($s, $i);
        !            47:        echo "$name ".$t[$name] .": precision $precision, scale $scale\n";
        !            48: }
        !            49: 
        !            50: echo "Done\n";
        !            51: ?>
        !            52: --EXPECT--
        !            53: C01 NUMBER: precision 0, scale -127
        !            54: C02 NUMBER(*,1): precision 38, scale 1
        !            55: C03 NUMBER(9): precision 9, scale 0
        !            56: C04 NUMBER(9,2): precision 9, scale 2
        !            57: C05 NUMBER(9,1): precision 9, scale 1
        !            58: C06 NUMBER(7,-2): precision 7, scale -2
        !            59: C07 DECIMAL(4,9): precision 4, scale 9
        !            60: C08 NUMERIC(4,9): precision 4, scale 9
        !            61: C09 DECIMAL(4): precision 4, scale 0
        !            62: C10 INTEGER: precision 38, scale 0
        !            63: C11 INT: precision 38, scale 0
        !            64: C12 SMALLINT: precision 38, scale 0
        !            65: C13 FLOAT: precision 126, scale -127
        !            66: C14 FLOAT(9): precision 9, scale -127
        !            67: C15 DOUBLE PRECISION: precision 126, scale -127
        !            68: C16 REAL: precision 63, scale -127
        !            69: Done