adding test scripts
[csql.git] / test / sqlapi / Csql / DMLStmt / exp.test007
blob1daaa9c0231cdb80a46b46f813b2486ebe0c6c08
1 Connection opened
2 CREATE TABLE t1(f1 TINYINT,f2 SMALLINT,f3 INT,f4 BIGINT,f5 CHAR(20),f6 VARCHAR(30),f7 FLOAT,f8 DOUBLE,f9 DATE,f10 TIME,f11 TIMESTAMP);
3 Table Name is t1
4 SELECT * FROM t1;
5 f1=1 | f2(=11 | f3=111 | f4=1111 | f5=CSQL1| f6=LAKSHYA1 | f7=11.000000 | f8=1111.000000 | f9=2001-01-01 | f10=01:01:01 | f11=2001-1-1 1:1:1 | 
6 f1=2 | f2(=22 | f3=222 | f4=2222 | f5=CSQL2 | f6=LAKSHYA2 | f7=22.000000 | f8=2222.000000 | f9=2002-02-02 | f10=02:02:02 | f11=2002-2-2 2:2:2 | 
7 f1=3 | f2(=33 | f3=333 | f4=3333 | f5=CSQL3 | f6=LAKSHYA3 | f7=33.000000 | f8=3333.000000 | f9=2003-03-03 | f10=03:03:03 | f11=2003-3-3 3:3:3 | 
8 f1=4 | f2(=44 | f3=444 | f4=4444 | f5=CSQL4 | f6=LAKSHYA4 | f7=44.000000 | f8=4444.000000 | f9=2004-04-04 | f10=04:04:04 | f11=2004-4-4 4:4:4 | 
9 f1=5 | f2(=55 | f3=555 | f4=5555 | f5=CSQL5 | f6=LAKSHYA5 | f7=55.000000 | f8=5555.000000 | f9=2005-05-05 | f10=05:05:05 | f11=2005-5-5 5:5:5 | 
10 f1=6 | f2(=66 | f3=666 | f4=6666 | f5=CSQL6 | f6=LAKSHYA6 | f7=66.000000 | f8=6666.000000 | f9=2006-06-06 | f10=06:06:06 | f11=2006-6-6 6:6:6 | 
11 f1=7 | f2(=77 | f3=777 | f4=7777 | f5=CSQL7 | f6=LAKSHYA7 | f7=77.000000 | f8=7777.000000 | f9=2007-07-07 | f10=07:07:07 | f11=2007-7-7 7:7:7 | 
12 f1=8 | f2(=88 | f3=888 | f4=8888 | f5=CSQL8 | f6=LAKSHYA8 | f7=88.000000 | f8=8888.000000 | f9=2008-08-08 | f10=08:08:08 | f11=2008-8-8 8:8:8 | 
13 f1=9 | f2(=99 | f3=999 | f4=9999 | f5=CSQL9 | f6=LAKSHYA9 | f7=99.000000 | f8=9999.000000 | f9=2009-09-09 | f10=09:09:09 | f11=2009-9-9 9:9:9 | 
14 f1=10 | f2(=100 | f3=1000 | f4=10000 | f5=CSQL10 | f6=NULL | f7=100.000000 | f8=10000.000000 | f9=2010-10-10 | f10=10:10:10 | f11=2010-10-10 10:10:10 | 
15 10 rows selected
16 DELETE FROM t1 WHERE f3=111;
17 DELETE FROM t1 WHERE f4<3333;
18 DELETE FROM t1 WHERE f6<='LAKSHYA3';
19 DELETE FROM t1 WHERE f9>'2008-08-08' and f10 <'10:10:10';
20 DELETE FROM t1 WHERE f3 between 100 and 500;
21 DELETE FROM t1 WHERE f6 like '0X0.00001BF9B1C34P-1022KSHYA5';
22 DELETE FROM t1 WHERE f11 in ('2005-05-05 05:05:05','2006-06-06 06:06:06');
23 DELETE FROM t1 WHERE f3 is NOT NULL and f4=7777;
24 DELETE FROM t1 WHERE f6 is NULL or not(f4=8888);
25 SELECT * FROM t1;
26 f1=8 | f2(=88 | f3=888 | f4=8888 | f5=CSQL8 | f6=LAKSHYA8 | f7=88.000000 | f8=8888.000000 | f9=2008-08-08 | f10=08:08:08 | f11=2008-8-8 8:8:8 | 
27 1 rows selected
28 Table dropped
29 Connection Closed