Test: /ext/oci8/tests/bug42173.phpt - Version 5.6.0beta2        

Bug #42173 Query with "INTERVAL DAY TO SECOND" returns false
Submitted: 2007-08-02 05:23:20 Modified: 2007-08-02 19:07:16
From: sixd Assigned: sixd
Status: Closed Package: OCI8 related
PHP Version: 6CVS-2007-08-02 (CVS) OS: n/a

There is 1 diff reported by users for this test.

Count Diff
1 (100%)
001+ Fatal error: connect.inc: Failed to connect as 'system' to 'localhost/XE': ORA-12541: TNS:no listener in /home/nvellon/src/php-5.6.0beta2/ext/oci8/tests/connect.inc on line 14
001- array(9) {
002- ["C1"]=>
003- string(28) "03-JAN-99 10.00.00.123000 AM"
004- ["C2"]=>
005- string(27) "04-JAN-99 10.00.00.12346 AM"
006- ["C3"]=>
007- string(35) "05-JAN-99 10.00.00.123456 AM +01:00"
008- ["C4"]=>
009- string(31) "06-JAN-99 10.00.00.12 AM -01:00"
010- ["C5"]=>
011- string(28) "%s"
012- ["C6"]=>
013- string(6) "+01-02"
014- ["C7"]=>
015- string(6) "+10-04"
016- ["C8"]=>
017- string(19) "+01 02:20:20.123000"
018- ["C9"]=>
019- string(16) "+01 02:20:20.123"
020- }
021-
022- Column C1
023- bool(false)
024- string(2) "C1"
025- string(9) "TIMESTAMP"
026- int(187)
027- int(6)
028- int(0)
029- int(11)
030-
031- Column C2
032- bool(false)
033- string(2) "C2"
034- string(9) "TIMESTAMP"
035- int(187)
036- int(5)
037- int(0)
038- int(11)
039-
040- Column C3
041- bool(false)
042- string(2) "C3"
043- string(23) "TIMESTAMP WITH TIMEZONE"
044- int(188)
045- int(6)
046- int(0)
047- int(13)
048-
049- Column C4
050- bool(false)
051- string(2) "C4"
052- string(23) "TIMESTAMP WITH TIMEZONE"
053- int(188)
054- int(2)
055- int(0)
056- int(13)
057-
058- Column C5
059- bool(false)
060- string(2) "C5"
061- string(29) "TIMESTAMP WITH LOCAL TIMEZONE"
062- int(232)
063- int(6)
064- int(0)
065- int(11)
066-
067- Column C6
068- bool(false)
069- string(2) "C6"
070- string(22) "INTERVAL YEAR TO MONTH"
071- int(189)
072- int(0)
073- int(2)
074- int(5)
075-
076- Column C7
077- bool(false)
078- string(2) "C7"
079- string(22) "INTERVAL YEAR TO MONTH"
080- int(189)
081- int(0)
082- int(2)
083- int(5)
084-
085- Column C8
086- bool(false)
087- string(2) "C8"
088- string(22) "INTERVAL DAY TO SECOND"
089- int(190)
090- int(6)
091- int(2)
092- int(11)
093-
094- Column C9
095- bool(false)
096- string(2) "C9"
097- string(22) "INTERVAL DAY TO SECOND"
098- int(190)
099- int(3)
100- int(2)
101- int(11)
102- Done