[Pkg-kde-extras] Bug#623193: tora: Update failure if row contains timestamp field with NULL

Wolfgang Zarre info at essax.com
Mon Apr 18 09:09:12 UTC 2011

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                     |

 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 (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

More information about the pkg-kde-extras mailing list