diff options
author | danielk1977 <danielk1977@noemail.net> | 2004-11-10 12:34:20 +0000 |
---|---|---|
committer | danielk1977 <danielk1977@noemail.net> | 2004-11-10 12:34:20 +0000 |
commit | ae381aa1b6cb30a09f323355347746cf6c9183ab (patch) | |
tree | 8515e55a4f9f41db14710b3b60bae65d233870c4 /test/expr.test | |
parent | e6efa74b9f8fca9f6baafc33d7091ae282079001 (diff) | |
download | sqlite-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.test | 26 |
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 |