Received: by 10.180.24.202 with SMTP id w10mr414438wif.0.1343919604969;
        Thu, 02 Aug 2012 08:00:04 -0700 (PDT)
Path: n2ni6348685win.0!nntp.google.com!volia.net!news2.volia.net!feed-A.news.volia.net!news.musoftware.de!wum.musoftware.de!news.swapon.de!eternal-september.org!feeder.eternal-september.org!border3.nntp.ams.giganews.com!Xl.tags.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!local2.nntp.ams.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Thu, 02 Aug 2012 10:00:04 -0500
X-Spam-Status: No, hits=0.0 required=4.5
	tests=TOTAL_SCORE: 0.000
X-Spam-Level: 
X-Whitelist: 2560
X-Envelope-From: schen...@kbcomputer.com
X-Envelope-To: info-ing...@kettleriverconsulting.com
X-pair-Authenticated: 74.98.225.117
Mime-Version: 1.0 (Apple Message framework v1084)
From: Karl Schendel <schen...@kbcomputer.com>
In-Reply-To: <57765A44B573A747BAEC13DBB1E209AD527DC33D@EXCH2.ctsu.ox.ac.uk>
Date: Thu, 2 Aug 2012 10:56:34 -0400
References: <57765A44B573A747BAEC13DBB1E209AD527DC33D@EXCH2.ctsu.ox.ac.uk>
To: Ingres and related product discussion forum
	<info-ing...@kettleriverconsulting.com>
X-Mailer: Apple Mail (2.1084)
X-MailCleaner-Information: Please contact helpd...@atomic-colo.com for more
	information
X-MailCleaner: Not scanned: please contact helpd...@atomic-colo.com for details
X-MailCleaner-SpamCheck: not spam, SpamAssassin (not cached, score=-2.599,
	required 5, BAYES_00 -2.60)
X-MFR-SpamCheck: score=-1.9, required=4, BAYES_00=-1.9, UNPARSEABLE_RELAY=0.001
X-MIME-Autoconverted: from quoted-printable to 8bit by
	cando.kettleriverconsulting.com id q72EuuNn013036
Subject: Re: [Info-Ingres] dates and procedures in 10.1
X-BeenThere: info-ing...@kettleriverconsulting.com
X-Mailman-Version: 2.1.9
Precedence: list
Reply-To: Ingres and related product discussion forum
	<info-ing...@kettleriverconsulting.com>
List-Id: Ingres and related product discussion forum
	<info-ingres.kettleriverconsulting.com>
List-Unsubscribe: <http://ext-cando.kettleriverconsulting.com/mailman/listinfo/info-ingres>,
	<mailto:info-ingres-requ...@kettleriverconsulting.com?subject=unsubscribe>
List-Archive: <http://ext-cando.kettleriverconsulting.com/pipermail/info-ingres>
List-Post: <mailto:info-ing...@kettleriverconsulting.com>
List-Help: <mailto:info-ingres-requ...@kettleriverconsulting.com?subject=help>
List-Subscribe: <http://ext-cando.kettleriverconsulting.com/mailman/listinfo/info-ingres>,
	<mailto:info-ingres-requ...@kettleriverconsulting.com?subject=subscribe>
Newsgroups: comp.databases.ingres
Message-ID: <mailman.172.1343919417.16084.info-ing...@kettleriverconsulting.com>
Lines: 21
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-kx6Cx0NtW9fBDFzHk/T5bo/AYSq+4RBnBlWSdw25F/KtAfMhSxw+BZ/beKDvAiJTfygQd6rnd/hn7F8!6XR/aWsRVoyAsPNL0WFd5GdcguKNa2Uxbpl3DVZOYLw+N15UFPJgLHu9KRVU0/bVqGceZwCqDrE6!SsnO2QkKdmkXXQoK+LzV/Mqyx9Zi
X-Complaints-To: ab...@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 3421
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 8bit


On Aug 2, 2012, at 10:43 AM, Martin Bowes wrote:

> Hi All,
>  
> On II 10.1.0 (a64.lnx/126)NPTL + p14302
>  
> The date(‘now’) in a procedure fixes on the date the procedure was created and not the actual date(‘now’) when it is executed.
>  

Oops.  Constant folding strikes!  I'm guessing that we have one of the
function definition flags set a bit astray, allowing folding when it should
not be allowed.

If you don't already have an issue open on this, you might want to open
one for bug tracking purposes.

Karl