[cl-debian] Bug#338270: marked as done (cl-sql: date calculations buggy)

Wed Nov 30 06:03:06 UTC 2005

Your message dated Tue, 29 Nov 2005 22:46:33 -0700
with message-id <20051130054633.GA24441 at rosenberg.net>
and subject line fixed
has caused the attached Bug report 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 I am
talking about this indicates a serious mail system misconfiguration
somewhere.  Please contact me immediately.)

Debian bug tracking system administrator
(administrator, Debian Bugs database)

--------------------------------------
Received: (at submit) by bugs.debian.org; 9 Nov 2005 05:29:08 +0000
>From lynbech at defun.dk Tue Nov 08 21:29:08 2005
Return-path: <lynbech at defun.dk>
Received: from pfepb.post.tele.dk [195.41.46.236] 
	by spohr.debian.org with esmtp (Exim 3.36 1 (Debian))
	id 1EZiWC-0008F4-00; Tue, 08 Nov 2005 21:29:08 -0800
Received: from localhost (cpe.atm2-0-1071145.0x3ef2610a.arcnxx16.customer.tele.dk [62.242.97.10])
	by pfepb.post.tele.dk (Postfix) with ESMTP id 27EF65EE044
	for <submit at bugs.debian.org>; Wed,  9 Nov 2005 06:29:07 +0100 (CET)
Received: from lynbech by localhost with local (Exim 4.54)
	id 1EZiW9-0005LB-B2
	for submit at bugs.debian.org; Wed, 09 Nov 2005 06:29:05 +0100
From: Christian Lynbech <christian at defun.dk>
To: Debian Bug Tracking System <submit at bugs.debian.org>
Subject: cl-sql: date calculations buggy
X-Debbugs-CC: Christian Lynbech <Christian Lynbech <christian.lynbech at ericsson.com>>
BX-Debbugs-CC: christian at defun.dk
Comments: Hyperbole mail buttons accepted, v04.18.
Message-Id: <E1EZiW9-0005LB-B2 at localhost>
Date: Wed, 09 Nov 2005 06:29:05 +0100
Delivered-To: submit at bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 
	(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level: 
X-Spam-Status: No, hits=-11.0 required=4.0 tests=BAYES_00,HAS_PACKAGE,
	X_DEBBUGS_CC autolearn=ham version=2.60-bugs.debian.org_2005_01_02

Package: cl-sql
Version: 3.3.4-1
Severity: normal

Somehow the functions in time.lisp manages to swap day and month as
witnessed by the code below. It is possible the problem is related to
the fact that I am running on a european system with a national
setting for LC_CTYPE.

The problem hits both CMUCL and SBCL.

With this code:

	(clc:clc-require :clsql-mysql)

	(multiple-value-bind (second minute hour day mon year)
	      (decode-universal-time (get-universal-time))
	    (format t "current date is month=~D, day=~D~%" mon day))

	(format t "clsql date says month=~D, day=~D~%"
		(clsql-sys:current-month)
		(clsql-sys:current-day))

I get the output:

	current date is month=11, day=8
	clsql date says month=8, day=11

-- System Information:
Debian Release: testing/unstable
  APT prefers unstable
  APT policy: (500, 'unstable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.12-1-k7
Locale: LANG=C, LC_CTYPE=da_DK (charmap=ISO-8859-1)

Versions of packages cl-sql depends on:
ii  common-lisp-controller        4.23       This is a Common Lisp source and c

Versions of packages cl-sql recommends:
ii  cl-sql-mysql [cl-sql-backend] 3.3.4-1    CLSQL database backend, MySQL

-- no debconf information

---------------------------------------
Received: (at 338270-done) by bugs.debian.org; 30 Nov 2005 05:46:43 +0000
>From kevin at tiger.med-info.com Tue Nov 29 21:46:43 2005
Return-path: <kevin at tiger.med-info.com>
Received: from tiger.med-info.com ([216.184.11.129])
	by spohr.debian.org with esmtp (Exim 4.50)
	id 1EhKnj-0001zg-F0
	for 338270-done at bugs.debian.org; Tue, 29 Nov 2005 21:46:43 -0800
Received: from tiger.med-info.com (kevin at localhost [127.0.0.1])
	by tiger.med-info.com (8.13.5/8.13.5/Debian-3) with ESMTP id jAU5kgV4024478
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT)
	for <338270-done at bugs.debian.org>; Tue, 29 Nov 2005 22:46:42 -0700
Received: (from kevin at localhost)
	by tiger.med-info.com (8.13.5/8.13.5/Submit) id jAU5kXJd024456
	for 338270-done at bugs.debian.org; Tue, 29 Nov 2005 22:46:33 -0700
Received: by tiger.med-info.com (hashcash-sendmail, from uid 1000);
	Tue, 29 Nov 2005 22:46:33 -0700
Date: Tue, 29 Nov 2005 22:46:33 -0700
From: Kevin Rosenberg <kevin at rosenberg.net>
To: 338270-done at bugs.debian.org
Subject: fixed
Message-ID: <20051130054633.GA24441 at rosenberg.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
X-GPG-ID: 0xC4A4823E
X-GPG-FP: D7A0 55B6 4768 3582 B10D  3F0C 112E CDF2 C4A3 823E
X-GPG-Key: http://b9.com/kevin.gpg.asc
User-Agent: Mutt/1.5.11
X-Hashcash: 1:24:051130:338270-done at bugs.debian.org::iPLINOwLTrq7xlRD:0000000000
	000000000000000000000001mObR
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02 
	(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level: 
X-Spam-Status: No, hits=-0.5 required=4.0 tests=BAYES_10,ONEWORD autolearn=no 
	version=2.60-bugs.debian.org_2005_01_02

fixed in clsql 3.5.0 -- thanks

-- 
Kevin Rosenberg
kevin at rosenberg.net