v2 v3: note (CHANGELOG) on ruby DBI bug affecting sisu cgi sample search forms

* see <http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=596103> however, it
  affects sqlite3 in the same way as pgsql (the driver against which it is
  reported)
* includes possible workarounds (for sisu sample search forms)

2 files changed, 48 insertions, 0 deletions

diff --git a/data/doc/sisu/CHANGELOG_v2 b/data/doc/sisu/CHANGELOG_v2
index 1ea45430..4d090f70 100644
--- a/data/doc/sisu/CHANGELOG_v2
+++ b/data/doc/sisu/CHANGELOG_v2
@@ -35,6 +35,30 @@ http://git.sisudoc.org/?p=code/sisu.git;a=shortlog;h=refs/tags/debian/3.0.8-1
   * manpage, reinstate escape of hyphens (clearly preferred, else lintian
     reports hyphen-used-as-minus-sign)
 
+  * NOTE: generated cgi sample search form caught by Ruby/DBI libdbi-ruby1.9.1
+    reported as libdbd-pg-ruby1.9.1 bug #596103, where "select_all fails". The
+    cgi sample search scripts for postgresql and sqlite3 are almost identical,
+    both work in ruby 1.8.7, both have the same error in ruby 1.9.2... a very
+    similar bug is reported about the mysql library. Should #596103 and the
+    upstream report be reported against Ruby/DBI (libdbi-ruby1.9.1) rather than
+    libdbd-pg-ruby1.9.1?
+    * <http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=596103>
+    * <http://rubyforge.org/tracker/index.php?func=detail&aid=28624&group_id=234&atid=967>
+    * <http://rubyforge.org/forum/forum.php?set=custom&forum_id=958&style=nested&max_rows=25&submit=Change+View>
+    fix/workaround options include:
+    * await bugfix, (bug has existed at least since 2010-09)
+    * rewrite for ruby-dbi using other constructs
+      e.g. s.fetch {|row| ...}
+    * revert to ruby 1.8.7 for the cgi script (they work independently of the
+      rest of the program anyway)
+    * rewrite for individual database dbi re: psql  and sqlite3
+    * await rdbi (ruby-dbi replacement), also needs to be packaged for Debian
+      <rdbi https://github.com/RDBI/rdbi>
+      <http://rdbi.hollensbe.org/>
+      <http://rdbi.hollensbe.org/files/README_rdoc.html>
+      and develop for that
+    or some meaningful combination of any of the above.
+
 %% 2.9.2.orig.tar.gz (2011-04-20:16/3) [see 3.0.7]
 http://git.sisudoc.org/?p=code/sisu.git;a=shortlog;h=refs/tags/debian/3.0.7-1
 
diff --git a/data/doc/sisu/CHANGELOG_v3 b/data/doc/sisu/CHANGELOG_v3
index d40e1084..11828790 100644
--- a/data/doc/sisu/CHANGELOG_v3
+++ b/data/doc/sisu/CHANGELOG_v3
@@ -42,6 +42,30 @@ http://www.jus.uio.no/sisu/pkg/src/sisu_3.0.8.orig.tar.gz
 
   * manpges escaped hyphens reinstated (remove lintian info)
 
+  * NOTE: cgi sample search form caught by Ruby/DBI libdbi-ruby1.9.1 reported
+    reported as libdbd-pg-ruby1.9.1 bug #596103, where "select_all fails". The
+    cgi sample search scripts for postgresql and sqlite3 are almost identical,
+    both work in ruby 1.8.7, both have the same error in ruby 1.9.2... a very
+    similar bug is reported about the mysql library. Should #596103 and the
+    upstream report be reported against Ruby/DBI (libdbi-ruby1.9.1) rather than
+    libdbd-pg-ruby1.9.1?
+    * <http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=596103>
+    * <http://rubyforge.org/tracker/index.php?func=detail&aid=28624&group_id=234&atid=967>
+    * <http://rubyforge.org/forum/forum.php?set=custom&forum_id=958&style=nested&max_rows=25&submit=Change+View>
+    fix/workaround options include:
+    * await bugfix, (bug has existed at least since 2010-09)
+    * rewrite for ruby-dbi using other constructs
+      e.g. s.fetch {|row| ...}
+    * revert to ruby 1.8.7 for the cgi script (they work independently of the
+      rest of the program anyway)
+    * rewrite for individual database dbi re: psql  and sqlite3
+    * await rdbi (ruby-dbi replacement), also needs to be packaged for Debian
+      <rdbi https://github.com/RDBI/rdbi>
+      <http://rdbi.hollensbe.org/>
+      <http://rdbi.hollensbe.org/files/README_rdoc.html>
+      and develop for that
+    or some meaningful combination of any of the above.
+
 %% 3.0.7.orig.tar.gz (2011-04-20:16/3)
 http://git.sisudoc.org/?p=code/sisu.git;a=log;h=refs/tags/debian/3.0.7-1
 http://www.jus.uio.no/sisu/pkg/src/sisu_3.0.7.orig.tar.gz