adding test scripts
[csql.git] / test / sqlapi / Csql / DMLStmt / exp.test012n
blobc2d243297a63fee27fe47a5f8d7bb026bfbf8d77
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 INSERT INTO t1 VALUES(1,11,NULL,1111,'CSQL1','LAKSHYA1',11.11,1111.11,'2001-01-01','01:01:01','2001-01-01 01:01:01');
5 INSERT INTO t1 VALUES(2,22,222,2222,'CSQL2',NULL,22.22,2222.22,'2002-02-02','02:02:02','2002-02-02 02:02:02');
6 INSERT INTO t1 VALUES(3,33,333,3333,'CSQL3','LAKSHYA3',33.33,NULL,'2003-03-03','03:03:03','2003-03-03 03:03:03');
7 INSERT INTO t1 VALUES(4,44,444,4444,'CSQL4','LAKSHYA4',44.44,4444.44,NULL,'04:04:04','2004-04-04 04:04:04');
8 INSERT INTO t1 VALUES(5,55,555,5555,'CSQL5','LAKSHYA5',55.55,5555.55,'2005-05-05','05:05:05',NULL);
9 f1(tinyint)=1 | f2(smallint)=11 | f3(int)=NULL | f4(bigint)=1111 | f5(char)= | f6(varchar)=LAKSHYA1 | f7(float)=11.110000 | f8(double)=1111.110000 | f9(date)=2001-01-01 | f10(time)=01:01:01 | f11(timestamp)=2001-1-1 1:1:1 | 
10 f1(tinyint)=2 | f2(smallint)=22 | f3(int)=222 | f4(bigint)=2222 | f5(char)= | f6(varchar)=NULL | f7(float)=22.219999 | f8(double)=2222.220000 | f9(date)=2002-02-02 | f10(time)=02:02:02 | f11(timestamp)=2002-2-2 2:2:2 | 
11 f1(tinyint)=3 | f2(smallint)=33 | f3(int)=333 | f4(bigint)=3333 | f5(char)= | f6(varchar)=LAKSHYA3 | f7(float)=33.330002 | f8(double)=NULL | f9(date)=2003-03-03 | f10(time)=03:03:03 | f11(timestamp)=2003-3-3 3:3:3 | 
12 f1(tinyint)=4 | f2(smallint)=44 | f3(int)=444 | f4(bigint)=4444 | f5(char)= | f6(varchar)=LAKSHYA4 | f7(float)=44.439999 | f8(double)=4444.440000 | f9(date)=NULL | f10(time)=04:04:04 | f11(timestamp)=2004-4-4 4:4:4 | 
13 f1(tinyint)=5 | f2(smallint)=55 | f3(int)=555 | f4(bigint)=5555 | f5(char)= | f6(varchar)=LAKSHYA5 | f7(float)=55.549999 | f8(double)=5555.550000 | f9(date)=2005-05-05 | f10(time)=05:05:05 | f11(timestamp)=NULL | 
14 5 rows selected
15 UPDATE t1 SET f3=111,f4=NULL where f3 is NULL;
16 UPDATE t1 SET f6='LAKSHYA2',f5=NULL where f6 is NULL;
17 UPDATE t1 SET f8=3333.33,f7=NULL where f8 is NULL;
18 UPDATE t1 SET f9='2004-04-04',f10=NULL where f9 is NULL;
19 UPDATE t1 SET f11='2005-05-05 05:05:05' where f11 is NULL;
20 UPDATE t1 SET f11=NULL where f11 = '2005-05-05 05:05:05';
21 f1(tinyint)=1 | f2(smallint)=11 | f3(int)=111 | f4(bigint)=NULL | f5(char)=CSQL1 | f6(varchar)=LAKSHYA1 | f7(float)=11.110000 | f8(double)=1111.110000 | f9(date)=2001-01-01 | f10(time)=01:01:01 | f11(timestamp)=2001-1-1 1:1:1 | 
22 f1(tinyint)=2 | f2(smallint)=22 | f3(int)=222 | f4(bigint)=2222 | f5(char)=NULL | f6(varchar)=LAKSHYA2 | f7(float)=22.219999 | f8(double)=2222.220000 | f9(date)=2002-02-02 | f10(time)=02:02:02 | f11(timestamp)=2002-2-2 2:2:2 | 
23 f1(tinyint)=3 | f2(smallint)=33 | f3(int)=333 | f4(bigint)=3333 | f5(char)=CSQL3 | f6(varchar)=LAKSHYA3 | f7(float)=NULL | f8(double)=3333.330000 | f9(date)=2003-03-03 | f10(time)=03:03:03 | f11(timestamp)=2003-3-3 3:3:3 | 
24 f1(tinyint)=4 | f2(smallint)=44 | f3(int)=444 | f4(bigint)=4444 | f5(char)=CSQL4 | f6(varchar)=LAKSHYA4 | f7(float)=44.439999 | f8(double)=4444.440000 | f9(date)=2004-04-04 | f10(time)=NULL | f11(timestamp)=2004-4-4 4:4:4 | 
25 f1(tinyint)=5 | f2(smallint)=55 | f3(int)=555 | f4(bigint)=5555 | f5(char)=CSQL5 | f6(varchar)=LAKSHYA5 | f7(float)=55.549999 | f8(double)=5555.550000 | f9(date)=2005-05-05 | f10(time)=05:05:05 | f11(timestamp)=NULL | 
26 5 rows selected
27 DELETE FROM t1 WHERE f4 is NULL;
28 DELETE FROM t1 WHERE f5 is NULL;
29 DELETE FROM t1 WHERE f7 is NULL;
30 DELETE FROM t1 WHERE f10 is NULL;
31 DELETE FROM t1 WHERE f11 is NULL;
32 0 rows selected
33 Table dropped
34 Connection Closed