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

[Wolfgang Zarre]

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