Package: buildd.debian.org
Severity: normal

Hi.

The pkg_history table is defined as follows:

CREATE TABLE pkg_history (
    package character varying NOT NULL,
    distribution character varying NOT NULL,
    version character varying NOT NULL,
    "timestamp" timestamp without time zone NOT NULL,
    result character varying NOT NULL,
    build_time integer,
    disk_space bigint
);

version here is of type "character varying", but maybe it should use
"debversion" instead? (to take advantage of debversion_cmp).

The effect appears on [1] where "1:9.7.3.dfsg-1~squeeze1~bpo50+1"
comes _before_ "1:9.7.3.dfsg-1".

[1] https://buildd.debian.org/status/logs.php?pkg=bind9

(Same remark goes for "packages" and "transactions" tables).

Regards,

-- System Information:
Debian Release: 6.0.1
  APT prefers stable
  APT policy: (990, 'stable'), (500, 'stable-updates'), (500, 
'proposed-updates')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.32-5-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash



-- 
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]

Reply via email to