aboutsummaryrefslogtreecommitdiff
path: root/test/expr.test
diff options
context:
space:
mode:
authordanielk1977 <danielk1977@noemail.net>2004-11-10 12:34:20 +0000
committerdanielk1977 <danielk1977@noemail.net>2004-11-10 12:34:20 +0000
commitae381aa1b6cb30a09f323355347746cf6c9183ab (patch)
tree8515e55a4f9f41db14710b3b60bae65d233870c4 /test/expr.test
parente6efa74b9f8fca9f6baafc33d7091ae282079001 (diff)
downloadsqlite-ae381aa1b6cb30a09f323355347746cf6c9183ab.tar.gz
sqlite-ae381aa1b6cb30a09f323355347746cf6c9183ab.zip
Fix expr.test so that it works when the date-time functions are compiled out of the library. (CVS 2086)
FossilOrigin-Name: 540ce7de1b3f1882c40d4e20d3986775e1dcf77a
Diffstat (limited to 'test/expr.test')
-rw-r--r--test/expr.test26
1 files changed, 14 insertions, 12 deletions
diff --git a/test/expr.test b/test/expr.test
index 425f2a913..e22bd5470 100644
--- a/test/expr.test
+++ b/test/expr.test
@@ -11,7 +11,7 @@
# This file implements regression tests for SQLite library. The
# focus of this file is testing expressions.
#
-# $Id: expr.test,v 1.37 2004/11/09 12:44:39 danielk1977 Exp $
+# $Id: expr.test,v 1.38 2004/11/10 12:34:20 danielk1977 Exp $
set testdir [file dirname $argv0]
source $testdir/tester.tcl
@@ -480,23 +480,25 @@ set sqlite_current_time [clock seconds]
set date [clock format $sqlite_current_time -format %Y-%m-%d -gmt 1]
set time [clock format $sqlite_current_time -format %H:%M:%S -gmt 1]
do_test expr-8.1 {
- execsql {SELECT CURRENT_TIME==time('now');}
-} 1
-do_test expr-8.2 {
execsql {SELECT CURRENT_TIME}
} $time
-do_test expr-8.3 {
- execsql {SELECT CURRENT_DATE==date('now');}
-} 1
-do_test expr-8.4 {
+do_test expr-8.2 {
execsql {SELECT CURRENT_DATE}
} $date
-do_test expr-8.5 {
- execsql {SELECT CURRENT_TIMESTAMP==datetime('now');}
-} 1
-do_test expr-8.6 {
+do_test expr-8.3 {
execsql {SELECT CURRENT_TIMESTAMP}
} [list "$date $time"]
+ifcapable datetime {
+ do_test expr-8.4 {
+ execsql {SELECT CURRENT_TIME==time('now');}
+ } 1
+ do_test expr-8.5 {
+ execsql {SELECT CURRENT_DATE==date('now');}
+ } 1
+ do_test expr-8.6 {
+ execsql {SELECT CURRENT_TIMESTAMP==datetime('now');}
+ } 1
+}
set sqlite_current_time 0
finish_test