adding test scripts
[csql.git] / test / sqlapi / Csql / DDLStmt / exp.test008.ksh
blob5e638d715901a4a111cbc2e2ffdf90efdf8ea239
1 Connection opened
2 Table t1 Created
3 Tree Index Created on TINYINT field f1
4 Tree Index Created on SMALLINT field f2
5 Tree Index Created on INT field f3
6 Tree Index Created on BIGINT field f4
7 Tree Index Created on CHAR field f5
8 Tree Index Created on VARCHAR field f6
9 Tree Index Created on FLOAT field f7
10 Tree Index Created on DOUBLE field f8
11 Tree Index Created on DATE field f9
12 Tree Index Created on TIME field f10
13 Tree Index Created on TIMESTAMP field f11
14 TABLES
15 --------
17 Connection Closed
18 <Table Information of all tables>
19 <TableInfo>
20 <TableName> t1 </TableName>
21 <FieldInfo>
22 <FieldName> f1 </FieldName>
23 <Type> 4 </Type>
24 <Length> 4 </Length>
25 <Primary> 0 </Primary>
26 <Null> 0 </Null>
27 <Default> 0 </Default>
28 <DefaultValue> </DefaultValue>
29 </FieldInfo>
30 <FieldInfo>
31 <FieldName> f2 </FieldName>
32 <Type> 3 </Type>
33 <Length> 4 </Length>
34 <Primary> 0 </Primary>
35 <Null> 0 </Null>
36 <Default> 0 </Default>
37 <DefaultValue> </DefaultValue>
38 </FieldInfo>
39 <FieldInfo>
40 <FieldName> f3 </FieldName>
41 <Type> 0 </Type>
42 <Length> 4 </Length>
43 <Primary> 0 </Primary>
44 <Null> 0 </Null>
45 <Default> 0 </Default>
46 <DefaultValue> </DefaultValue>
47 </FieldInfo>
48 <FieldInfo>
49 <FieldName> f4 </FieldName>
50 <Type> 2 </Type>
51 <Length> 8 </Length>
52 <Primary> 0 </Primary>
53 <Null> 0 </Null>
54 <Default> 0 </Default>
55 <DefaultValue> </DefaultValue>
56 </FieldInfo>
57 <FieldInfo>
58 <FieldName> f5 </FieldName>
59 <Type> 30 </Type>
60 <Length> 20 </Length>
61 <Primary> 0 </Primary>
62 <Null> 0 </Null>
63 <Default> 0 </Default>
64 <DefaultValue> </DefaultValue>
65 </FieldInfo>
66 <FieldInfo>
67 <FieldName> f6 </FieldName>
68 <Type> 32 </Type>
69 <Length> 32 </Length>
70 <Primary> 0 </Primary>
71 <Null> 0 </Null>
72 <Default> 0 </Default>
73 <DefaultValue> </DefaultValue>
74 </FieldInfo>
75 <FieldInfo>
76 <FieldName> f7 </FieldName>
77 <Type> 11 </Type>
78 <Length> 4 </Length>
79 <Primary> 0 </Primary>
80 <Null> 0 </Null>
81 <Default> 0 </Default>
82 <DefaultValue> </DefaultValue>
83 </FieldInfo>
84 <FieldInfo>
85 <FieldName> f8 </FieldName>
86 <Type> 10 </Type>
87 <Length> 8 </Length>
88 <Primary> 0 </Primary>
89 <Null> 0 </Null>
90 <Default> 0 </Default>
91 <DefaultValue> </DefaultValue>
92 </FieldInfo>
93 <FieldInfo>
94 <FieldName> f9 </FieldName>
95 <Type> 20 </Type>
96 <Length> 4 </Length>
97 <Primary> 0 </Primary>
98 <Null> 0 </Null>
99 <Default> 0 </Default>
100 <DefaultValue> </DefaultValue>
101 </FieldInfo>
102 <FieldInfo>
103 <FieldName> f10 </FieldName>
104 <Type> 21 </Type>
105 <Length> 4 </Length>
106 <Primary> 0 </Primary>
107 <Null> 0 </Null>
108 <Default> 0 </Default>
109 <DefaultValue> </DefaultValue>
110 </FieldInfo>
111 <FieldInfo>
112 <FieldName> f11 </FieldName>
113 <Type> 22 </Type>
114 <Length> 8 </Length>
115 <Primary> 0 </Primary>
116 <Null> 0 </Null>
117 <Default> 0 </Default>
118 <DefaultValue> </DefaultValue>
119 </FieldInfo>
120 </TableInfo>
121 </Table Information of all tables>
122 <Index Information of all Indexs>
123 <Index Name> idxtiny </Index Name>
124 <Index Type> Tree Index </Index Type>
125 <Table Name> t1 </Table Name>
126 <Field Name> f1 </Field Name>
127 <Index Name> idxsmall </Index Name>
128 <Index Type> Tree Index </Index Type>
129 <Table Name> t1 </Table Name>
130 <Field Name> f2 </Field Name>
131 <Index Name> idxint </Index Name>
132 <Index Type> Tree Index </Index Type>
133 <Table Name> t1 </Table Name>
134 <Field Name> f3 </Field Name>
135 <Index Name> idxbig </Index Name>
136 <Index Type> Tree Index </Index Type>
137 <Table Name> t1 </Table Name>
138 <Field Name> f4 </Field Name>
139 <Index Name> idxchar </Index Name>
140 <Index Type> Tree Index </Index Type>
141 <Table Name> t1 </Table Name>
142 <Field Name> f5 </Field Name>
143 <Index Name> idxvarchar </Index Name>
144 <Index Type> Tree Index </Index Type>
145 <Table Name> t1 </Table Name>
146 <Field Name> f6 </Field Name>
147 <Index Name> idxfloat </Index Name>
148 <Index Type> Tree Index </Index Type>
149 <Table Name> t1 </Table Name>
150 <Field Name> f7 </Field Name>
151 <Index Name> idxdouble </Index Name>
152 <Index Type> Tree Index </Index Type>
153 <Table Name> t1 </Table Name>
154 <Field Name> f8 </Field Name>
155 <Index Name> idxdate </Index Name>
156 <Index Type> Tree Index </Index Type>
157 <Table Name> t1 </Table Name>
158 <Field Name> f9 </Field Name>
159 <Index Name> idxtime </Index Name>
160 <Index Type> Tree Index </Index Type>
161 <Table Name> t1 </Table Name>
162 <Field Name> f10 </Field Name>
163 <Index Name> idxtimestamp </Index Name>
164 <Index Type> Tree Index </Index Type>
165 <Table Name> t1 </Table Name>
166 <Field Name> f11 </Field Name>
167 </Index Information of all Indexs>
168 echo drop table t1;
169 Statement Executed