From ab3b9d5aa88a7bf683ab258c86ed7b8f26a9d5e2 Mon Sep 17 00:00:00 2001 From: kishoramballi Date: Mon, 28 Jul 2008 08:07:37 +0000 Subject: [PATCH] input for IN and BETWEEN test case --- test/tools/csql/csql9.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/test/tools/csql/csql9.sql b/test/tools/csql/csql9.sql index 9dec2d70..02e9b963 100644 --- a/test/tools/csql/csql9.sql +++ b/test/tools/csql/csql9.sql @@ -17,17 +17,17 @@ echo select * from t1 where f3 between 12 and 14; select * from t1 where f3 between 12 and 14; echo select * from t1 where f1 IN (12, 14, 50); -echo select * from t1 where f1 IN (12, 14, 50); +select * from t1 where f1 IN (12, 14, 50); echo select * from t1 where f1 IN (12, 14, 50) AND f3 IN (50); -echo select * from t1 where f1 IN (12, 14, 50) AND f3 IN (50); +select * from t1 where f1 IN (12, 14, 50) AND f3 IN (50); echo select * from t1 where f1 IN (12, 14, 50) OR f3 IN (50); -echo select * from t1 where f1 IN (12, 14, 50) OR f3 IN (50); +select * from t1 where f1 IN (12, 14, 50) OR f3 IN (50); echo select * from t1 where f1 IN (12, 14, 50) AND f3 between 12 and 14; -echo select * from t1 where f1 IN (12, 14, 50) AND f3 between 12 and 14; +select * from t1 where f1 IN (12, 14, 50) AND f3 between 12 and 14; echo select * from t1 where f1 NOT IN (12, 14, 50); -echo select * from t1 where f1 NOT IN (12, 14, 50); +select * from t1 where f1 NOT IN (12, 14, 50); drop table t1; -- 2.11.4.GIT