1# 2015 November 18 2# 3# The author disclaims copyright to this source code. In place of 4# 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 the __hidden__ hack. 13# 14 15set testdir [file dirname $argv0] 16source $testdir/tester.tcl 17set testprefix hidden 18 19do_execsql_test 1.1 { 20 CREATE TABLE t1(__hidden__a, b); 21 INSERT INTO t1 VALUES('1'); 22 INSERT INTO t1(__hidden__a, b) VALUES('x', 'y'); 23} {} 24 25do_execsql_test 1.2 { 26 SELECT * FROM t1; 27} {1 y} 28 29do_execsql_test 1.3 { 30 SELECT __hidden__a, * FROM t1; 31} {{} 1 x y} 32 33foreach {tn view} { 34 1 { CREATE VIEW v1(a, b, __hidden__c) AS SELECT a, b, c FROM x1 } 35 2 { CREATE VIEW v1 AS SELECT a, b, c AS __hidden__c FROM x1 } 36} { 37 do_execsql_test 2.$tn.1 { 38 DROP TABLE IF EXISTS x1; 39 CREATE TABLE x1(a, b, c); 40 INSERT INTO x1 VALUES(1, 2, 3); 41 } 42 43 catchsql { DROP VIEW v1 } 44 execsql $view 45 46 do_execsql_test 2.$tn.2 { 47 SELECT a, b, __hidden__c FROM v1; 48 } {1 2 3} 49 50 do_execsql_test 2.$tn.3 { 51 SELECT * FROM v1; 52 } {1 2} 53 54 do_execsql_test 2.$tn.4 { 55 CREATE TRIGGER tr1 INSTEAD OF INSERT ON v1 BEGIN 56 INSERT INTO x1 VALUES(new.a, new.b, new.__hidden__c); 57 END; 58 59 INSERT INTO v1 VALUES(4, 5); 60 SELECT * FROM x1; 61 } {1 2 3 4 5 {}} 62 63 do_execsql_test 2.$tn.5 { 64 INSERT INTO v1(a, b, __hidden__c) VALUES(7, 8, 9); 65 SELECT * FROM x1; 66 } {1 2 3 4 5 {} 7 8 9} 67} 68 69 70 71 72 73finish_test 74