Package: libdbd-pg-ruby1.9.1 Version: 0.3.9-1 Severity: important Tags: squeeze sid
Hi,
libdbd-pg-ruby1.9.1 (used with ruby1.9.1) always returns the last row of a
set of rows.
Example:
$ cat test.rb
require 'dbi'
db = DBI.connect('DBI:Pg:template1', ARGV.shift || ENV['USER'])
db.select_all('SELECT * FROM pg_database').each do |row|
p row
end
$ ruby1.8 test.rb
["template1", "10", 6, "en_US.UTF-8", "en_US.UTF-8", true, true, -1, "11563",
"648", "1663", nil, ["=c/postgres", "postgres=CTc/postgres"]]
["template0", "10", 6, "en_US.UTF-8", "en_US.UTF-8", true, false, -1, "11563",
"648", "1663", nil, ["=c/postgres", "postgres=CTc/postgres"]]
["postgres", "10", 6, "en_US.UTF-8", "en_US.UTF-8", false, true, -1, "11563",
"648", "1663", nil, nil]
["twitter", "16384", 6, "en_US.UTF-8", "en_US.UTF-8", false, true, -1, "11563",
"648", "1663", nil, nil]
["schnucki", "16384", 6, "en_US.UTF-8", "en_US.UTF-8", false, true, -1,
"11563", "648", "1663", nil, nil]
["test", "16384", 6, "en_US.UTF-8", "en_US.UTF-8", false, true, -1, "11563",
"648", "1663", nil, nil]
$ ruby1.9.1 test.rb
["test", "16384", 6, "en_US.UTF-8", "en_US.UTF-8", false, true, -1, "11563",
"648", "1663", nil, nil]
["test", "16384", 6, "en_US.UTF-8", "en_US.UTF-8", false, true, -1, "11563",
"648", "1663", nil, nil]
["test", "16384", 6, "en_US.UTF-8", "en_US.UTF-8", false, true, -1, "11563",
"648", "1663", nil, nil]
["test", "16384", 6, "en_US.UTF-8", "en_US.UTF-8", false, true, -1, "11563",
"648", "1663", nil, nil]
["test", "16384", 6, "en_US.UTF-8", "en_US.UTF-8", false, true, -1, "11563",
"648", "1663", nil, nil]
["test", "16384", 6, "en_US.UTF-8", "en_US.UTF-8", false, true, -1, "11563",
"648", "1663", nil, nil]
The underlying driver, Pg, works fine:
$ cat test2.rb
require 'pg'
db = PGconn.open('dbname=template1')
res = db.exec('select * from pg_database;')
res.to_a.each do |row|
p row['datname']
end
$ ruby1.9.1 test2.rb
"template1"
"template0"
"postgres"
"twitter"
"schnucki"
"test"
This renders the dbi adapter unusable for me (and I suspect for others, too).
Regards,
- Alexander
-- System Information:
Debian Release: squeeze/sid
APT prefers testing
APT policy: (990, 'testing'), (500, 'unstable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.32-5-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages libdbd-pg-ruby1.9.1 depends on:
ii libdbi-ruby1.9.1 0.4.3-2 Database Independent Interface for
ii libpgsql-ruby1.9.1 0.8.0-1.1 PostgreSQL interface for Ruby 1.9.
libdbd-pg-ruby1.9.1 recommends no packages.
libdbd-pg-ruby1.9.1 suggests no packages.
-- no debconf information
signature.asc
Description: Digital signature
