| 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 |