Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update a comment in e_createtable.test. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | d8b149f5e465f7794739ed0210e1e5c5 |
| User & Date: | dan 2011-04-20 13:35:44 |
Context
|
2011-04-22
| ||
| 22:55 | Add the "getlock" utility for determining if a database file (on unix) is currently locked. check-in: 0ab24b13 user: drh tags: trunk | |
| 19:37 | Add the start of the "uri-filenames" feature. check-in: b8a8132e user: dan tags: uri | |
|
2011-04-20
| ||
| 13:35 | Update a comment in e_createtable.test. check-in: d8b149f5 user: dan tags: trunk | |
|
2011-04-19
| ||
| 06:43 | Avoid passing NULL to the xOpen method of an FTS3/4 tokenizer. check-in: 0dd09fc0 user: dan tags: trunk | |
Changes
Changes to test/e_createtable.test.
985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 |
SELECT quote(a), quote(b) FROM t6;
} {1 2 'X' 3}
do_execsql_test e_createtable-3.7.4 {
INSERT INTO t6(a) SELECT a FROM t6;
SELECT quote(a), quote(b) FROM t6;
} {1 2 'X' 3 1 4 'X' 5}
# EVIDENCE-OF: R-18683-56219 If the default value of a column is
# CURRENT_TIME, CURRENT_DATE or CURRENT_DATETIME, then the value used in
# the new row is a text representation of the current UTC date and/or
# time.
#
# This is difficult to test literally without knowing what time the
# user will run the tests. Instead, we test that the three cases
# above set the value to the current date and/or time according to
# the xCurrentTime() method of the VFS. Which is usually the same
# as UTC. In this case, however, we instrument it to always return
|
| | | |
985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 |
SELECT quote(a), quote(b) FROM t6;
} {1 2 'X' 3}
do_execsql_test e_createtable-3.7.4 {
INSERT INTO t6(a) SELECT a FROM t6;
SELECT quote(a), quote(b) FROM t6;
} {1 2 'X' 3 1 4 'X' 5}
# EVIDENCE-OF: R-15363-55230 If the default value of a column is
# CURRENT_TIME, CURRENT_DATE or CURRENT_TIMESTAMP, then the value used
# in the new row is a text representation of the current UTC date and/or
# time.
#
# This is difficult to test literally without knowing what time the
# user will run the tests. Instead, we test that the three cases
# above set the value to the current date and/or time according to
# the xCurrentTime() method of the VFS. Which is usually the same
# as UTC. In this case, however, we instrument it to always return
|