adding test scripts
[csql.git] / test / sqlapi / Csql / DMLStmt / exp.test004n
blob19201a87ff3cbee8f5f2e4085c1d960a5fd3a74c
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,111,1111,'CSQL1','LAKSHYA1',11.00,1111.00,'2001-01-01','01:01:01','2001-01-01 01:01:01');
5 INSERT INTO t1 VALUES(2,22,222,2222,'CSQL2','LAKSHYA2',22.00,2222.00,'2002-02-02','02:02:02','2002-02-02 02:02:02');
6 INSERT INTO t1 VALUES(3,33,333,3333,'CSQL3','LAKSHYA3',33.00,3333.00,'2003-03-03','03:03:03','2003-03-03 03:03:03');
7 INSERT INTO t1 VALUES(4,44,444,4444,'CSQL4','LAKSHYA4',44.00,4444.00,'2004-04-04','04:04:04','2004-04-04 04:04:04');
8 INSERT INTO t1 VALUES(5,55,555,5555,'CSQL5','LAKSHYA5',55.00,5555.00,'2005-05-05','05:05:05','2005-05-05 05:05:05');
9 f1(tinyint)=1 | f2(smallint)=11 | f3(int)=111 | f4(bigint)=1111 | f5(char)= | f6(varchar)=LAKSHYA1 | f7(float)=11.000000 | f8(double)=1111.000000 | 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)=LAKSHYA2 | f7(float)=22.000000 | f8(double)=2222.000000 | 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.000000 | f8(double)=3333.000000 | 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.000000 | f8(double)=4444.000000 | f9(date)=2004-04-04 | 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.000000 | f8(double)=5555.000000 | f9(date)=2005-05-05 | f10(time)=05:05:05 | f11(timestamp)=2005-5-5 5:5:5 | 
14 5 rows selected
15 UPDATE t1 SET f1=f1+10, f2=f2+100, f3=f3+1000, f4=f4+10000, f5='CSQLMMDB1', f6='LAKSHYA_BANGALORE1', f7=f7+100, f8=f8+10000,f9='2001-01-11', f10='01:01:11', f11='2001-01-11 01:01:11' WHERE f1=1 and f2=11 and f3=111 and f4=1111;
16 UPDATE t1 SET f1=f1+20, f2=f2+200, f3=f3+2000, f4=f4+20000, f5='CSQLMMDB2', f6='LAKSHYA_BANGALORE2', f7=f7+200, f8=f8+20000,f9='2002-02-12', f10='02:02:12', f11='2002-02-12 02:02:12' WHERE f3=222 and f5='CSQL2' and f6<='LAKSHYA2';
17 UPDATE t1 SET f1=f1+30, f2=f2+300, f3=f3+3000, f4=f4+30000, f5='CSQLMMDB3', f6='LAKSHYA_BANGALORE3', f7=f7+300, f8=f8+30000,f9='2003-03-13', f10='03:03:13', f11='2003-03-13 03:03:13' WHERE f3<=333 and f6<='LAKSHYA4' and (f3 = 333 or f3 = 2222);
18 UPDATE t1 SET f1=f1+40, f2=f2+400, f3=f3+4000, f4=f4+40000, f5='CSQLMMDB4', f6='LAKSHYA_BANGALORE4', f7=f7+400, f8=f8+40000,f9='2004-04-14', f10='04:04:14', f11='2004-04-14 04:04:14' WHERE f3<=3333 and f6<='LAKSHYA6' and not(f3 = 3333 or f3 = 555) and (f6 = 'LAKSHYA4' or f6='LAKSHYA_BANGALORE3' or f9='2004/4/4');
19 UPDATE t1 SET f1=f1+50, f2=f2+500, f3=f3+5000, f4=f4+50000, f5='CSQLMMDB5', f6='LAKSHYA_BANGALORE5', f7=f7+500, f8=f8+50000,f9='2005-05-15', f10='05:05:15', f11='2005-05-15 05:05:15' WHERE f1=5 and f2=55 and f3=555 and f4=5555 and f5='CSQL5' and f6='LAKSHYA5' and f7=55 and f8=5555 and f9='2005/05/05' and f10='05:05:05' and f11='2005/05/05 05:05:05';
20 UPDATE t1 SET f1=50, f2=500, f3=5000, f4=50000, f5='CSQLMMDB50', f6='LAKSHYA_BANGALORE50', f7=500, f8=50000,f9='2005-05-15', f10='05:05:15', f11='2005-05-15 05:05:15' WHERE f3=5555 or f4=44444 or f6='LAKSHYA_BANGALORE3' or f8=22222 or f11='2001/01/11 01:01:11';
21 f1(tinyint)=50 | f2(smallint)=500 | f3(int)=5000 | f4(bigint)=50000 | f5(char)= | f6(varchar)=LAKSHYA_BANGALORE50 | f7(float)=500.000000 | f8(double)=50000.000000 | f9(date)=2005-05-15 | f10(time)=05:05:15 | f11(timestamp)=2005-5-15 5:5:15 | 
22 f1(tinyint)=50 | f2(smallint)=500 | f3(int)=5000 | f4(bigint)=50000 | f5(char)= | f6(varchar)=LAKSHYA_BANGALORE50 | f7(float)=500.000000 | f8(double)=50000.000000 | f9(date)=2005-05-15 | f10(time)=05:05:15 | f11(timestamp)=2005-5-15 5:5:15 | 
23 f1(tinyint)=50 | f2(smallint)=500 | f3(int)=5000 | f4(bigint)=50000 | f5(char)= | f6(varchar)=LAKSHYA_BANGALORE50 | f7(float)=500.000000 | f8(double)=50000.000000 | f9(date)=2005-05-15 | f10(time)=05:05:15 | f11(timestamp)=2005-5-15 5:5:15 | 
24 f1(tinyint)=50 | f2(smallint)=500 | f3(int)=5000 | f4(bigint)=50000 | f5(char)= | f6(varchar)=LAKSHYA_BANGALORE50 | f7(float)=500.000000 | f8(double)=50000.000000 | f9(date)=2005-05-15 | f10(time)=05:05:15 | f11(timestamp)=2005-5-15 5:5:15 | 
25 f1(tinyint)=50 | f2(smallint)=500 | f3(int)=5000 | f4(bigint)=50000 | f5(char)= | f6(varchar)=LAKSHYA_BANGALORE50 | f7(float)=500.000000 | f8(double)=50000.000000 | f9(date)=2005-05-15 | f10(time)=05:05:15 | f11(timestamp)=2005-5-15 5:5:15 | 
26 5 rows selected
27 Table dropped
28 Connection Closed