adding test scripts
[csql.git] / test / sqlapi / Csql / DMLStmt / exp.test015n
blob97687940e8d1ba92fb45af13e7ff463cd1fec931
1 Connection opened
2 CREATE TABLE t2(f1 TINYINT,f2 SMALLINT,f3 INT,f4 BIGINT,f5 CHAR(20),f6 FLOAT,f7 DOUBLE,f8 DATE,f9 TIME,f10 TIMESTAMP);
3 CREATE TABLE t1 AS SELECT * FROM t2;
4 Table Name is t2
5 Table Name is t1
6 INSERT INTO t1 VALUES(1,11,111,1111,'CSQL1',11.11,1111.11,'2001-01-01','01:01:01','2001-01-01 01:01:01');
7 INSERT INTO t1 VALUES(2,22,222,2222,'CSQL2',22.22,2222.22,'2002-02-02','02:02:02','2002-02-02 02:02:02');
8 f1(tinyint)=1 | f2(smallint)=11 | f3(int)=111 | f4(bigint)=1111 | f5(char)=CSQL1 | f6(float)=11.110000 | f7(double)=1111.110000 | f8(date)=2001-01-01 | f9(time)=01:01:01 | f10(timestamp)=2001-1-1 1:1:1 | 
9 f1(tinyint)=2 | f2(smallint)=22 | f3(int)=222 | f4(bigint)=2222 | f5(char)=CSQL2 | f6(float)=22.219999 | f7(double)=2222.220000 | f8(date)=2002-02-02 | f9(time)=02:02:02 | f10(timestamp)=2002-2-2 2:2:2 | 
10 2 rows selected
11 UPDATE t1 SET f1=f1+10, f2=f2+100, f3=f3+1000, f4=f4+10000, f5='CSQLMMDB', f6=f6+100, f7=f7+10000,f8='2009-11-20', f9='12:01:01', f10='2009-11-20 12:01:01' WHERE f1<=3;
12 f1(tinyint)=11 | f2(smallint)=111 | f3(int)=1111 | f4(bigint)=11111 | f5(char)=CSQLMMDB | f6(float)=111.110001 | f7(double)=11111.110000 | f8(date)=2009-11-20 | f9(time)=12:01:01 | f10(timestamp)=2009-11-20 12:1:1 | 
13 f1(tinyint)=12 | f2(smallint)=122 | f3(int)=1222 | f4(bigint)=12222 | f5(char)=CSQLMMDB | f6(float)=122.220001 | f7(double)=12222.220000 | f8(date)=2009-11-20 | f9(time)=12:01:01 | f10(timestamp)=2009-11-20 12:1:1 | 
14 2 rows selected
15 DELETE FROM t1 WHERE f1=12 OR f1=4;
16 f1(tinyint)=11 | f2(smallint)=111 | f3(int)=1111 | f4(bigint)=11111 | f5(char)=CSQLMMDB | f6(float)=111.110001 | f7(double)=11111.110000 | f8(date)=2009-11-20 | f9(time)=12:01:01 | f10(timestamp)=2009-11-20 12:1:1 | 
17 1 rows selected
18 Table t1 dropped
19 Table t2 dropped
20 Connection Closed