Your message dated Sat, 24 Aug 2019 23:48:59 +0000 with message-id <[email protected]> and subject line Bug#935649: Removed package(s) from unstable has caused the Debian Bug report #623193, regarding tora: Update failure if row contains timestamp field with NULL to be marked as done.
This means that you claim that the problem has been dealt with. If this is not the case it is now your responsibility to reopen the Bug report if necessary, and/or fix the problem forthwith. (NB: If you are a system administrator and have no idea what this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 623193: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=623193 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Package: tora Version: 2.1.2-1 Severity: important This bug affects the unstable version as well. Following procedure to reproduce this bug: Create a table: Table "public.test1" Column | Type | Modifiers --------+-----------------------------+----------- id | integer | dt1 | timestamp without time zone | dt2 | timestamp without time zone | cnt | integer | Populate: id | dt1 | dt2 | cnt ----+----------------------------+------+----- 1 | 2011-04-18 05:21:52.98716 | NULL | 2 2 | 2011-04-18 05:22:00.323138 | NULL | 2 3 | 2011-04-18 05:22:00.323138 | NULL | 2 Open this table in tora with schema browser, activate 'data' tab and change for example the field cnt of row number 2 to the value 3 and try to save the change. Following failure message is the result: ERROR: invalid input syntax for type timestamp: "" LINE 1: ...'2011-04-18T05:22:00') AND (dt2 IS NULL OR dt2 = '') AND (c... ^ Query not active UPDATE public.test1 SET cnt= :f0<char[4000],in> WHERE (id = :c1<char[4000],in>) AND (dt1 = :c2<char[4000],in>) AND (dt2 IS NULL OR dt2 = :c3<char[4000],in>) AND (cnt = :c4<char[4000],in>) It seems that the query created for the update is not correct when a field is not a number but the backend doesn't allow comparing with an empty string like types of timestamp, time and date. -- System Information: Debian Release: 6.0.1 APT prefers proposed-updates APT policy: (500, 'proposed-updates'), (500, 'stable') Architecture: i386 (i686) Kernel: Linux 2.6.36.2-686-w5f (SMP w/2 CPU cores) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages tora depends on: ii libc6 2.11.2-10 Embedded GNU C Library: Shared lib ii libgcc1 1:4.4.5-8 GCC support library ii libpq5 8.4.7-0squeeze2 PostgreSQL C client library ii libqscintilla2-5 2.4.3-1+b1 The Qt4 port of the Scintilla sour ii libqt4-network 4:4.6.3-4 Qt 4 network module ii libqt4-sql 4:4.6.3-4 Qt 4 SQL module ii libqt4-xml 4:4.6.3-4 Qt 4 XML module ii libqtcore4 4:4.6.3-4 Qt 4 core module ii libqtgui4 4:4.6.3-4 Qt 4 GUI module ii libstdc++6 4.4.5-8 The GNU Standard C++ Library v3 tora recommends no packages. tora suggests no packages. -- no debconf information
--- End Message ---
--- Begin Message ---Version: 2.1.3-4+rm Dear submitter, as the package tora has just been removed from the Debian archive unstable we hereby close the associated bug reports. We are sorry that we couldn't deal with your issue properly. For details on the removal, please see https://bugs.debian.org/935649 The version of this package that was in Debian prior to this removal can still be found using http://snapshot.debian.org/. This message was generated automatically; if you believe that there is a problem with it please contact the archive administrators by mailing [email protected]. Debian distribution maintenance software pp. Scott Kitterman (the ftpmaster behind the curtain)
--- End Message ---
_______________________________________________ pkg-kde-extras mailing list [email protected] https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/pkg-kde-extras
