AryaWu/sqlite

1# 2014-03-032#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# This file verifies that an OP_Copy operation is used instead of OP_SCopy13# in a compound select in a case where the source register might be changed14# before the copy is used.15#16 17set testdir [file dirname $argv0]18source $testdir/tester.tcl19set testprefix selectF20 21do_execsql_test 1 {22  BEGIN TRANSACTION;23  CREATE TABLE t1(a, b, c);24  INSERT INTO "t1" VALUES(1,'one','I');25  CREATE TABLE t2(d, e, f);26  INSERT INTO "t2" VALUES(5,'ten','XX');27  INSERT INTO "t2" VALUES(6,NULL,NULL);28 29  CREATE INDEX i1 ON t1(b, a);30  COMMIT;31}32 33#explain_i {34#  SELECT * FROM t235#  UNION ALL 36#  SELECT * FROM t1 WHERE a<5 37#  ORDER BY 2, 138#}39 40do_execsql_test 2 {41  SELECT * FROM t242  UNION ALL 43  SELECT * FROM t1 WHERE a<5 44  ORDER BY 2, 145} {6 {} {} 1 one I 5 ten XX}46 47 48  49finish_test50