OLD | NEW |
1 # 2001 September 15 | 1 # 2001 September 15 |
2 # | 2 # |
3 # The author disclaims copyright to this source code. In place of | 3 # The author disclaims copyright to this source code. In place of |
4 # a legal notice, here is a blessing: | 4 # a legal notice, here is a blessing: |
5 # | 5 # |
6 # May you do good and not evil. | 6 # May you do good and not evil. |
7 # May you find forgiveness for yourself and forgive others. | 7 # May you find forgiveness for yourself and forgive others. |
8 # May you share freely, never taking more than you give. | 8 # May you share freely, never taking more than you give. |
9 # | 9 # |
10 #*********************************************************************** | 10 #*********************************************************************** |
(...skipping 586 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
597 CREATE TABLE tablet8( | 597 CREATE TABLE tablet8( |
598 a integer primary key, | 598 a integer primary key, |
599 tm text DEFAULT CURRENT_TIME, | 599 tm text DEFAULT CURRENT_TIME, |
600 dt text DEFAULT CURRENT_DATE, | 600 dt text DEFAULT CURRENT_DATE, |
601 dttm text DEFAULT CURRENT_TIMESTAMP | 601 dttm text DEFAULT CURRENT_TIMESTAMP |
602 ); | 602 ); |
603 SELECT * FROM tablet8; | 603 SELECT * FROM tablet8; |
604 } | 604 } |
605 } {} | 605 } {} |
606 set i 0 | 606 set i 0 |
| 607 unset -nocomplain date time seconds |
607 foreach {date time seconds} { | 608 foreach {date time seconds} { |
608 1976-07-04 12:00:00 205329600 | 609 1976-07-04 12:00:00 205329600 |
609 1994-04-16 14:00:00 766504800 | 610 1994-04-16 14:00:00 766504800 |
610 2000-01-01 00:00:00 946684800 | 611 2000-01-01 00:00:00 946684800 |
611 2003-12-31 12:34:56 1072874096 | 612 2003-12-31 12:34:56 1072874096 |
612 } { | 613 } { |
613 incr i | 614 incr i |
614 set sqlite_current_time $seconds | 615 set sqlite_current_time $seconds |
615 do_test table-13.2.$i { | 616 do_test table-13.2.$i { |
616 execsql " | 617 execsql " |
(...skipping 89 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
706 } {} | 707 } {} |
707 do_test table-15.2 { | 708 do_test table-15.2 { |
708 execsql {BEGIN} | 709 execsql {BEGIN} |
709 for {set i 0} {$i<2000} {incr i} { | 710 for {set i 0} {$i<2000} {incr i} { |
710 execsql "DROP TABLE tbl$i" | 711 execsql "DROP TABLE tbl$i" |
711 } | 712 } |
712 execsql {COMMIT} | 713 execsql {COMMIT} |
713 } {} | 714 } {} |
714 | 715 |
715 finish_test | 716 finish_test |
OLD | NEW |