Return to bug42173.phpt CVS log

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

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

1.1     ! misho       1: --TEST--
        !             2: Bug #42173 (TIMESTAMP and INTERVAL query and field functions)
        !             3: --SKIPIF--
        !             4: <?php
        !             5: $target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
        !             6: require(dirname(__FILE__).'/skipif.inc');
        !             7: ?> 
        !             8: --FILE--
        !             9: <?php
        !            10: 
        !            11: require(dirname(__FILE__).'/connect.inc');
        !            12: 
        !            13: $stmts = array(
        !            14: 
        !            15: "drop table ts_test",
        !            16: 
        !            17: "create table ts_test (
        !            18: c1 TIMESTAMP,
        !            19: c2 TIMESTAMP (5),
        !            20: c3 TIMESTAMP WITH TIME ZONE,
        !            21: c4 TIMESTAMP (2) WITH TIME ZONE,
        !            22: c5 TIMESTAMP WITH LOCAL TIME ZONE,
        !            23: c6 INTERVAL YEAR TO MONTH,
        !            24: c7 INTERVAL YEAR(2) TO MONTH,
        !            25: c8 INTERVAL DAY TO SECOND,
        !            26: c9 INTERVAL DAY(2) TO SECOND(3)
        !            27: )",
        !            28: 
        !            29: "insert into ts_test values (
        !            30: timestamp'1999-01-03 10:00:00.123',
        !            31: timestamp'1999-01-04 10:00:00.123456',
        !            32: timestamp'1999-01-05 10:00:00.123456+1:0',
        !            33: timestamp'1999-01-06 10:00:00.123456-1:0',
        !            34: timestamp'1999-01-06 10:00:00.123456-1:0',
        !            35: interval'1-2' year to month,
        !            36: interval'10-4' year to month,
        !            37: interval'1 2:20:20.123' day to second,
        !            38: interval'1 2:20:20.12345' day to second)");
        !            39: 
        !            40: foreach ($stmts as $sql) {
        !            41:        $s = oci_parse($c, $sql);
        !            42:        $r = @oci_execute($s);
        !            43: }
        !            44: 
        !            45: $s = oci_parse($c, "select * from ts_test");
        !            46: $r = oci_execute($s);
        !            47: $row = oci_fetch_array($s, OCI_ASSOC);
        !            48: var_dump($row);
        !            49: 
        !            50: foreach ($row as $name => $field) {
        !            51:        echo "\nColumn $name\n";
        !            52:        var_dump(oci_field_is_null($s, $name));
        !            53:        var_dump(oci_field_name($s, $name));
        !            54:        var_dump(oci_field_type($s, $name));
        !            55:        var_dump(oci_field_type_raw($s, $name));
        !            56:        var_dump(oci_field_scale($s, $name));
        !            57:        var_dump(oci_field_precision($s, $name));
        !            58:        var_dump(oci_field_size($s, $name));
        !            59: }
        !            60: 
        !            61: // Cleanup
        !            62: 
        !            63: $s = oci_parse($c, "drop table ts_test");
        !            64: $r = @oci_execute($s);
        !            65: 
        !            66: echo "Done\n";
        !            67: 
        !            68: ?>
        !            69: --EXPECTF--
        !            70: array(9) {
        !            71:   ["C1"]=>
        !            72:   string(28) "03-JAN-99 10.00.00.123000 AM"
        !            73:   ["C2"]=>
        !            74:   string(27) "04-JAN-99 10.00.00.12346 AM"
        !            75:   ["C3"]=>
        !            76:   string(35) "05-JAN-99 10.00.00.123456 AM +01:00"
        !            77:   ["C4"]=>
        !            78:   string(31) "06-JAN-99 10.00.00.12 AM -01:00"
        !            79:   ["C5"]=>
        !            80:   string(28) "%s"
        !            81:   ["C6"]=>
        !            82:   string(6) "+01-02"
        !            83:   ["C7"]=>
        !            84:   string(6) "+10-04"
        !            85:   ["C8"]=>
        !            86:   string(19) "+01 02:20:20.123000"
        !            87:   ["C9"]=>
        !            88:   string(16) "+01 02:20:20.123"
        !            89: }
        !            90: 
        !            91: Column C1
        !            92: bool(false)
        !            93: string(2) "C1"
        !            94: string(9) "TIMESTAMP"
        !            95: int(187)
        !            96: int(6)
        !            97: int(0)
        !            98: int(11)
        !            99: 
        !           100: Column C2
        !           101: bool(false)
        !           102: string(2) "C2"
        !           103: string(9) "TIMESTAMP"
        !           104: int(187)
        !           105: int(5)
        !           106: int(0)
        !           107: int(11)
        !           108: 
        !           109: Column C3
        !           110: bool(false)
        !           111: string(2) "C3"
        !           112: string(23) "TIMESTAMP WITH TIMEZONE"
        !           113: int(188)
        !           114: int(6)
        !           115: int(0)
        !           116: int(13)
        !           117: 
        !           118: Column C4
        !           119: bool(false)
        !           120: string(2) "C4"
        !           121: string(23) "TIMESTAMP WITH TIMEZONE"
        !           122: int(188)
        !           123: int(2)
        !           124: int(0)
        !           125: int(13)
        !           126: 
        !           127: Column C5
        !           128: bool(false)
        !           129: string(2) "C5"
        !           130: string(29) "TIMESTAMP WITH LOCAL TIMEZONE"
        !           131: int(232)
        !           132: int(6)
        !           133: int(0)
        !           134: int(11)
        !           135: 
        !           136: Column C6
        !           137: bool(false)
        !           138: string(2) "C6"
        !           139: string(22) "INTERVAL YEAR TO MONTH"
        !           140: int(189)
        !           141: int(0)
        !           142: int(2)
        !           143: int(5)
        !           144: 
        !           145: Column C7
        !           146: bool(false)
        !           147: string(2) "C7"
        !           148: string(22) "INTERVAL YEAR TO MONTH"
        !           149: int(189)
        !           150: int(0)
        !           151: int(2)
        !           152: int(5)
        !           153: 
        !           154: Column C8
        !           155: bool(false)
        !           156: string(2) "C8"
        !           157: string(22) "INTERVAL DAY TO SECOND"
        !           158: int(190)
        !           159: int(6)
        !           160: int(2)
        !           161: int(11)
        !           162: 
        !           163: Column C9
        !           164: bool(false)
        !           165: string(2) "C9"
        !           166: string(22) "INTERVAL DAY TO SECOND"
        !           167: int(190)
        !           168: int(3)
        !           169: int(2)
        !           170: int(11)
        !           171: Done