aboutsummaryrefslogtreecommitdiff
path: root/test/func.test
diff options
context:
space:
mode:
Diffstat (limited to 'test/func.test')
-rw-r--r--test/func.test130
1 files changed, 1 insertions, 129 deletions
diff --git a/test/func.test b/test/func.test
index ab8b6f6df..d8e5c3f09 100644
--- a/test/func.test
+++ b/test/func.test
@@ -11,7 +11,7 @@
# This file implements regression tests for SQLite library. The
# focus of this file is testing built-in functions.
#
-# $Id: func.test,v 1.35 2005/06/22 10:53:59 drh Exp $
+# $Id: func.test,v 1.36 2005/06/25 18:42:16 drh Exp $
set testdir [file dirname $argv0]
source $testdir/tester.tcl
@@ -485,134 +485,6 @@ do_test func-16.1 {
}
} {X'616263' NULL}
-# Tests for the blob(), text() and numeric() built-ins
-#
-do_test func-17.1 {
- execsql {SELECT x'616263'}
-} abc
-do_test func-17.2 {
- execsql {SELECT typeof(x'616263')}
-} blob
-do_test func-17.3 {
- execsql {SELECT text(x'616263')}
-} abc
-do_test func-17.4 {
- execsql {SELECT typeof(text(x'616263'))}
-} text
-do_test func-17.5 {
- execsql {SELECT numeric(x'616263')}
-} 0
-do_test func-17.6 {
- execsql {SELECT typeof(numeric(x'616263'))}
-} integer
-do_test func-17.7 {
- execsql {SELECT blob(x'616263')}
-} abc
-do_test func-17.8 {
- execsql {SELECT typeof(blob(x'616263'))}
-} blob
-do_test func-17.11 {
- execsql {SELECT null}
-} {{}}
-do_test func-17.12 {
- execsql {SELECT typeof(NULL)}
-} null
-do_test func-17.13 {
- execsql {SELECT text(NULL)}
-} {{}}
-do_test func-17.14 {
- execsql {SELECT typeof(text(NULL))}
-} text
-do_test func-17.15 {
- execsql {SELECT numeric(NULL)}
-} 0
-do_test func-17.16 {
- execsql {SELECT typeof(numeric(NULL))}
-} integer
-do_test func-17.17 {
- execsql {SELECT blob(NULL)}
-} {{}}
-do_test func-17.18 {
- execsql {SELECT typeof(blob(NULL))}
-} blob
-do_test func-17.21 {
- execsql {SELECT 123}
-} {123}
-do_test func-17.22 {
- execsql {SELECT typeof(123)}
-} integer
-do_test func-17.23 {
- execsql {SELECT text(123)}
-} {123}
-do_test func-17.24 {
- execsql {SELECT typeof(text(123))}
-} text
-do_test func-17.25 {
- execsql {SELECT numeric(123)}
-} 123
-do_test func-17.26 {
- execsql {SELECT typeof(numeric(123))}
-} integer
-do_test func-17.27 {
- execsql {SELECT blob(123)}
-} {123}
-do_test func-17.28 {
- execsql {SELECT typeof(blob(123))}
-} blob
-do_test func-17.31 {
- execsql {SELECT 123.456}
-} {123.456}
-do_test func-17.32 {
- execsql {SELECT typeof(123.456)}
-} real
-do_test func-17.33 {
- execsql {SELECT text(123.456)}
-} {123.456}
-do_test func-17.34 {
- execsql {SELECT typeof(text(123.456))}
-} text
-do_test func-17.35 {
- execsql {SELECT numeric(123.456)}
-} 123.456
-do_test func-17.36 {
- execsql {SELECT typeof(numeric(123.456))}
-} real
-do_test func-17.37 {
- execsql {SELECT blob(123.456)}
-} {123.456}
-do_test func-17.38 {
- execsql {SELECT typeof(blob(123.456))}
-} blob
-do_test func-17.41 {
- execsql {SELECT '123abc'}
-} {123abc}
-do_test func-17.42 {
- execsql {SELECT typeof('123abc')}
-} text
-do_test func-17.43 {
- execsql {SELECT text('123abc')}
-} {123abc}
-do_test func-17.44 {
- execsql {SELECT typeof(text('123abc'))}
-} text
-do_test func-17.45 {
- execsql {SELECT numeric('123abc')}
-} 123
-do_test func-17.46 {
- execsql {SELECT typeof(numeric('123abc'))}
-} integer
-do_test func-17.47 {
- execsql {SELECT blob('123abc')}
-} {123abc}
-do_test func-17.48 {
- execsql {SELECT typeof(blob('123abc'))}
-} blob
-do_test func-17.49 {
- execsql {SELECT numeric('123.5abc')}
-} 123.5
-do_test func-17.49b {
- execsql {SELECT typeof(numeric('123.5abc'))}
-} real
finish_test