AryaWu/sqlite

1# 2018-12-122#3# The author disclaims copyright to this source code.  In place of4# a legal notice, here is a blessing:5#6#    May you do good and not evil.7#    May you find forgiveness for yourself and forgive others.8#    May you share freely, never taking more than you give.9#10#***********************************************************************11# 12# Test cases found by Matthew Denton's fuzzer at Chrome.13#14 15 16set testdir [file dirname $argv0]17source $testdir/tester.tcl18 19do_execsql_test fuzz4-100 {20  CREATE TABLE Table0 (Col0  NOT NULL DEFAULT (CURRENT_TIME IS 1 > 1));21  INSERT OR REPLACE INTO Table0 DEFAULT VALUES ;22  SELECT * FROM Table0;23} {0}24 25do_execsql_test fuzz4-110 {26  CREATE TABLE Table1(27    Col0 TEXT DEFAULT (CASE WHEN 1 IS 3530822107858468864 28                            THEN 1 ELSE quote(1) IS 3530822107858468864 END)29  );30  INSERT INTO Table1 DEFAULT VALUES;31  SELECT * FROM Table1;32} {0}33 34do_execsql_test fuzz4-200 {35  CREATE TABLE Table2a(36     Col0  NOT NULL   DEFAULT (CURRENT_TIME IS 1  IS NOT 1  > 1)37  );38  INSERT OR REPLACE INTO Table2a DEFAULT VALUES;39  SELECT * FROM Table2a;40} {0}41 42do_execsql_test fuzz4-210 {43  CREATE TABLE Table2b (Col0  NOT NULL  DEFAULT (CURRENT_TIME  IS NOT FALSE)) ;44  INSERT OR REPLACE INTO Table2b DEFAULT VALUES ;45  SELECT * FROM Table2b;46} {1}47 48do_execsql_test fuzz4-300 {49  CREATE TABLE Table3 (Col0 DEFAULT (CURRENT_TIMESTAMP BETWEEN 1 AND 1));50  INSERT INTO Table3 DEFAULT VALUES;51  SELECT * FROM Table3;52} {0}53 54do_execsql_test fuzz4-400 {55  CREATE TABLE Table4 (Col0 DEFAULT (1 BETWEEN CURRENT_TIMESTAMP AND 1));56  INSERT INTO Table4 DEFAULT VALUES;57  SELECT * FROM Table4;58} {0}59 60do_execsql_test fuzz4-500 {61  CREATE TABLE Table5 (Col0 DEFAULT (1 BETWEEN 1 AND CURRENT_TIMESTAMP));62  INSERT INTO Table5 DEFAULT VALUES;63  SELECT * FROM Table5;64} {1}65 66do_execsql_test fuzz4-600 {67  CREATE TEMPORARY TABLE Table6(68    Col0 DEFAULT (CASE x'5d' WHEN 1 THEN69        CASE CURRENT_TIMESTAMP WHEN 1 THEN 1 ELSE 1 END70        ELSE CASE WHEN 1 THEN FALSE END  END )71  );72  INSERT INTO temp.Table6 DEFAULT VALUES ;73  SELECT * FROM Table6;74} {0}75do_execsql_test fuzz4-610 {76  WITH TableX AS (SELECT DISTINCT * ORDER BY 1  , 1 COLLATE RTRIM)77      DELETE FROM Table6  WHERE Col0 || +8388608  ;78  SELECT * FROM Table6;79} {}80 81 82finish_test83