kubo/ruby-oci8 — Issue #2: make check got 2 failures when TZ set to "America/New_York"
Author: yahonda
Created: 2011-11-29 03:11:31+00:00
State: open

Hi, Thank you for the ruby-oci8 constant updates/fixes.

As I've found several failures and errors for make check,
please let me know if I should report to rubyforge or somewhere else.

```ruby
$ ruby -v
ruby 1.9.3p0 (2011-10-30 revision 33570) [x86_64-linux]
$ echo $TZ
America/New_York
[yahonda@myoel5 ruby-oci8]$ make check
ruby -w setup.rb setup
setup.rb:278: warning: assigned but unused variable - vname
setup.rb:278: warning: assigned but unused variable - desc
setup.rb:278: warning: assigned but unused variable - default2
setup.rb:109: Use RbConfig instead of obsolete and deprecated Config.
---> lib
---> lib/dbd
<--- lib/dbd
---> lib/oci8
<--- lib/oci8
<--- lib
---> ext
---> ext/oci8
make
make[1]: Entering directory `/home/yahonda/Dropbox/git/ruby-oci8/ext/oci8'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/home/yahonda/Dropbox/git/ruby-oci8/ext/oci8'
<--- ext/oci8
<--- ext
ruby -w setup.rb test
setup.rb:278: warning: assigned but unused variable - vname
setup.rb:278: warning: assigned but unused variable - desc
setup.rb:278: warning: assigned but unused variable - default2
setup.rb:109: Use RbConfig instead of obsolete and deprecated Config.
mkdir -p ./test
/home/yahonda/.rvm/rubies/ruby-1.9.3-p0/bin/ruby -w -I/home/yahonda/Dropbox/git/ruby-oci8/ext/oci8 -I/home/yahonda/Dropbox/git/ruby-oci8/lib -I/home/yahonda/Dropbox/git/ruby-oci8/support -I/home/yahonda/Dropbox/git/ruby-oci8/test /home/yahonda/Dropbox/git/ruby-oci8/test/test_all.rb
/home/yahonda/Dropbox/git/ruby-oci8/lib/oci8/object.rb:374: warning: assigned but unused variable - args
lib/rational.rb is deprecated
/home/yahonda/Dropbox/git/ruby-oci8/test/test_bind_time.rb:86: warning: assigned but unused variable - day_in
/home/yahonda/Dropbox/git/ruby-oci8/test/test_bind_time.rb:87: warning: assigned but unused variable - time_out
/home/yahonda/Dropbox/git/ruby-oci8/test/test_oci8.rb:218: warning: assigned but unused variable - dttm
/home/yahonda/Dropbox/git/ruby-oci8/test/test_metadata.rb:887: warning: assigned but unused variable - descs
/home/yahonda/Dropbox/git/ruby-oci8/test/test_metadata.rb:987: warning: assigned but unused variable - descs
Run options:

# Running tests:

..F..............................F.............................E........F......F....................................................................

Finished tests in 53.515697s, 2.7655 tests/s, 142.3881 assertions/s.

1) Failure:
test_set_client_info(TestAppInfo) [/home/yahonda/Dropbox/git/ruby-oci8/test/test_appinfo.rb:57]:
Expected "ruby-oci8:9216" to be nil.

2) Failure:
test_busy_and_open_count(TestConnectionPool) [/home/yahonda/Dropbox/git/ruby-oci8/test/test_connection_pool.rb:101]:
<3> expected but was
<2>.

3) Error:
test_column_metadata(TestMetadata):
OCIError: ORA-00902: invalid datatype
stmt.c:241:in oci8lib_191.so
/home/yahonda/Dropbox/git/ruby-oci8/lib/oci8/oci8.rb:427:in `exec'
/home/yahonda/Dropbox/git/ruby-oci8/lib/oci8/oci8.rb:255:in `exec_internal'
/home/yahonda/Dropbox/git/ruby-oci8/lib/oci8/oci8.rb:248:in `exec'
/home/yahonda/Dropbox/git/ruby-oci8/test/test_metadata.rb:1376:in `test_column_metadata'

4) Failure:
test_bind_cursor(TestOCI8) [/home/yahonda/Dropbox/git/ruby-oci8/test/test_oci8.rb:221]:
<2002-08-03 23:59:59 -0400> expected but was
<2002-08-03 23:59:59 -0500>.

5) Failure:
test_select(TestOCI8) [/home/yahonda/Dropbox/git/ruby-oci8/test/test_oci8.rb:128]:
<2002-08-03 23:59:59 -0400> expected but was
<2002-08-03 23:59:59 -0500>.

148 tests, 7620 assertions, 4 failures, 1 errors, 0 skips
[yahonda@myoel5 ruby-oci8]$
```

```sql
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production

```

Right now, I have no idea about failure 1) and 2) but These 2 tests do not get failure when TZ='Asia/Tokyo'

4) Failure:
test_bind_cursor(TestOCI8) [/home/yahonda/Dropbox/git/ruby-oci8/test/test_oci8.rb:221]:
<2002-08-03 23:59:59 -0400> expected but was
<2002-08-03 23:59:59 -0500>.

5) Failure:
test_select(TestOCI8) [/home/yahonda/Dropbox/git/ruby-oci8/test/test_oci8.rb:128]:
<2002-08-03 23:59:59 -0400> expected but was
<2002-08-03 23:59:59 -0500>.

Maybe the DST has some relationships with these failures.
I'll report about the error 3) later.