OLD | NEW |
1 # 2014-11-10 | 1 # 2014-11-10 |
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 76 matching lines...) Expand 10 before | Expand all | Expand 10 after Loading... |
87 0 3 {} 10 3 {} | 87 0 3 {} 10 3 {} |
88 0 4 {} 10 4 {} | 88 0 4 {} 10 4 {} |
89 0 5 {} 10 5 {} | 89 0 5 {} 10 5 {} |
90 0 6 {} 10 {} {} | 90 0 6 {} 10 {} {} |
91 0 7 {} 10 {} {} | 91 0 7 {} 10 {} {} |
92 0 8 {} 10 {} {} | 92 0 8 {} 10 {} {} |
93 0 9 {} 10 {} {} | 93 0 9 {} 10 {} {} |
94 0 10 {} 10 {} {} | 94 0 10 {} 10 {} {} |
95 } | 95 } |
96 | 96 |
| 97 # 2016-02-26: An assertion fault found by the libFuzzer project |
| 98 # |
| 99 do_execsql_test misc8-3.0 { |
| 100 SELECT * |
| 101 FROM |
| 102 ( |
| 103 (SELECT 0 AS i) AS x1, |
| 104 (SELECT 1) AS x2 |
| 105 ) AS x3, |
| 106 (SELECT 6 AS j UNION ALL SELECT 7) AS x4 |
| 107 WHERE i<rowid |
| 108 ORDER BY 1; |
| 109 } {0 1 6 0 1 7} |
| 110 |
| 111 # The SQLITE_DBCONFIG_MAINDBNAME interface |
| 112 # |
| 113 db close |
| 114 forcedelete test.db test2.db |
| 115 sqlite3 db test.db |
| 116 do_execsql_test misc8-4.0 { |
| 117 CREATE TABLE t1(a,b,c); |
| 118 INSERT INTO t1 VALUES(1,2,3); |
| 119 ATTACH 'test2.db' AS aux2; |
| 120 CREATE TABLE aux2.t2(c,d,e); |
| 121 INSERT INTO t2 VALUES(4,5,6); |
| 122 SELECT * FROM t1, t2; |
| 123 } {1 2 3 4 5 6} |
| 124 do_execsql_test misc8-4.1 { |
| 125 PRAGMA database_list; |
| 126 } {/0 main .* 2 aux2/} |
| 127 dbconfig_maindbname_icecube db |
| 128 do_execsql_test misc8-4.2 { |
| 129 SELECT name FROM icecube.sqlite_master; |
| 130 } {t1} |
| 131 do_execsql_test misc8-4.3 { |
| 132 PRAGMA database_list; |
| 133 } {/0 icecube .* 2 aux2/} |
| 134 |
| 135 |
97 | 136 |
98 finish_test | 137 finish_test |
OLD | NEW |