test/tools/csql/exp.testnw005.ksh

   1 Network CSql
   2 echo create table t1 (f1 char(10), f2 tinyint, f3 smallint,f4 int, f5 bigint,f6 integer, f7 float, f8 real,f9 double,f10 long,f11 binary(128),f12 date,f13 time,f14 timestamp);
   3 Statement Executed
   4 echo insert into t1 values('NIHAR', 1,1,-2147483648,9223372036854775807, 2147483648,1.1, 1000000000.000000,10000001.10000001,99999,'ABCDEF0123456789','2001-1-1', '01:01:01', '2001-11-30 01:01:01');
   5 Statement Executed: Rows Affected = 1
   6 echo select * from t1;
   7 ---------------------------------------------------------
   8         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9   t1.f10  t1.f11  t1.f12  t1.f13  t1.f14
   9 ---------------------------------------------------------
  10         NIHAR   1       1       -2147483648     9223372036854775807     2147483647      1.100000        1000000000.000000       10000001.100000 99999   ABCDEF0123456789        2001/1/1        1:1:1.0 2001/11/30 1:1:1.0
  11
  12 echo insert into t1 values(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
  13 Statement Executed: Rows Affected = 1
  14 echo select * from t1;
  15 ---------------------------------------------------------
  16         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9   t1.f10  t1.f11  t1.f12  t1.f13  t1.f14
  17 ---------------------------------------------------------
  18         NIHAR   1       1       -2147483648     9223372036854775807     2147483647      1.100000        1000000000.000000       10000001.100000 99999   ABCDEF0123456789        2001/1/1        1:1:1.0 2001/11/30 1:1:1.0
  19         NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
  20
  21 echo UPDATE t1 set f1='PAPU', f2=10, f3=2, f4=2147483647, f5=-9223372036854775808, f6=-2147483647, f7=10.01, f8=2000000002.000002, f9=20000002.200002, f10=2147483647, f11='9876543210DcAbEf', f12='2003-3-3', f13='03:03:03', f14='2003-3-3 03:03:03';
  22 Statement Executed: Rows Affected = 2
  23 echo select * from t1;
  24 ---------------------------------------------------------
  25         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9   t1.f10  t1.f11  t1.f12  t1.f13  t1.f14
  26 ---------------------------------------------------------
  27         PAPU    10      2       2147483647      9223372036854775807     2147483647      10.010000       2000000002.000002       20000002.200002 2147483647      9876543210DCABEF        2003/3/3        3:3:3.0 2003/3/3 3:3:3.0
  28         PAPU    10      2       2147483647      9223372036854775807     2147483647      10.010000       2000000002.000002       20000002.200002 2147483647      9876543210DCABEF        2003/3/3        3:3:3.0 2003/3/3 3:3:3.0
  29
  30 echo UPDATE t1 set f1=NULL, f2=NULL, f3=NULL, f4=NULL, f5=NULL, f6=NULL, f7=NULL, f8=NULL, f9=NULL, f10=NULL, f11=NULL, f12=NULL, f13=NULL, f14=NULL;
  31 Statement Executed: Rows Affected = 2
  32 echo select * from t1;
  33 ---------------------------------------------------------
  34         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9   t1.f10  t1.f11  t1.f12  t1.f13  t1.f14
  35 ---------------------------------------------------------
  36         NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
  37         NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
  38
  39 echo delete from t1;
  40 Statement Executed: Rows Affected = 2
  41 echo select * from t1;
  42 ---------------------------------------------------------
  43         t1.f1   t1.f2   t1.f3   t1.f4   t1.f5   t1.f6   t1.f7   t1.f8   t1.f9   t1.f10  t1.f11  t1.f12  t1.f13  t1.f14
  44 ---------------------------------------------------------
  45
  46 echo drop table t1;
  47 Statement Executed