-
Notifications
You must be signed in to change notification settings - Fork 225
/
Copy pathcomdb2sys.expected
440 lines (440 loc) · 22.3 KB
/
comdb2sys.expected
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
(tablename='alltypes')
(tablename='dummy')
(tablename='partidx')
(tablename='sqlite_stat1')
(tablename='sqlite_stat4')
(tablename='t1')
(tablename='t2')
(tablename='t3')
(tablename='t4')
[select * from comdb2_tables order by tablename] rc 0
(tablename='t1', columnname='allowed_null_value', type='int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_blob', type='blob', size=5, sqltype='blob', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_byte', type='byte', size=17, sqltype='blob(16)', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_cstring', type='cstring', size=16, sqltype='char(15)', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_datetime', type='datetime', size=11, sqltype='datetime', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_datetimeus', type='datetimeus', size=13, sqltype='datetimeus', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_decimal128', type='decimal128', size=22, sqltype='decimal', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_decimal32', type='decimal32', size=7, sqltype='decimal', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_decimal64', type='decimal64', size=13, sqltype='decimal', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_double', type='double', size=9, sqltype='double', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_float', type='float', size=5, sqltype='smallfloat', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_int', type='int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_intervalds', type='intervalds', size=11, sqltype='interval sec', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_intervaldsus', type='intervaldsus', size=13, sqltype='interval usec', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_intervalym', type='intervalym', size=5, sqltype='interval month', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_longlong', type='longlong', size=9, sqltype='largeint', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_pstring', type='cstring', size=17, sqltype='char(16)', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_short', type='short', size=3, sqltype='smallint', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_u_int', type='u_int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_u_short', type='u_short', size=3, sqltype='smallint', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='alltypes', columnname='alltypes_vutf8', type='vutf8', size=21, sqltype='varchar', varinlinesize='16', defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='dummy', columnname='dummy', type='byte', size=2, sqltype='blob(1)', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='t1', columnname='dup_value', type='int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='sqlite_stat1', columnname='idx', type='cstring', size=64, sqltype='char(63)', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='Y', lastsequence=NULL)
(tablename='sqlite_stat4', columnname='idx', type='cstring', size=64, sqltype='char(63)', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='sqlite_stat4', columnname='sample', type='byte', size=1025, sqltype='blob(1024)', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='sqlite_stat4', columnname='samplelen', type='int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='sqlite_stat1', columnname='stat', type='cstring', size=4096, sqltype='char(4095)', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='sqlite_stat1', columnname='tbl', type='cstring', size=64, sqltype='char(63)', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='sqlite_stat4', columnname='tbl', type='cstring', size=64, sqltype='char(63)', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='partidx', columnname='uid', type='int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='t1', columnname='uid', type='int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='t2', columnname='uid', type='int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='t3', columnname='uid', type='int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='t4', columnname='uid', type='int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='partidx', columnname='value', type='int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='t1', columnname='value', type='int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='t2', columnname='value', type='int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='t3', columnname='value', type='int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
(tablename='t4', columnname='value', type='int', size=5, sqltype='int', varinlinesize=NULL, defaultvalue=NULL, dbload=NULL, isnullable='N', lastsequence=NULL)
[select * from comdb2_columns order by columnname, tablename] rc 0
(tablename='t1', keyname='DUP_VALUE', keynumber=2, isunique='N', isdatacopy='N', isrecnum='N', condition=NULL, uniqnulls='N', ispartialdatacopy='N')
(tablename='partidx', keyname='UID', keynumber=0, isunique='Y', isdatacopy='N', isrecnum='N', condition=NULL, uniqnulls='N', ispartialdatacopy='N')
(tablename='t1', keyname='UID', keynumber=0, isunique='Y', isdatacopy='N', isrecnum='N', condition=NULL, uniqnulls='N', ispartialdatacopy='N')
(tablename='t2', keyname='UID1', keynumber=0, isunique='Y', isdatacopy='N', isrecnum='N', condition=NULL, uniqnulls='N', ispartialdatacopy='N')
(tablename='t3', keyname='UID1', keynumber=0, isunique='Y', isdatacopy='N', isrecnum='N', condition=NULL, uniqnulls='N', ispartialdatacopy='N')
(tablename='t4', keyname='UID1', keynumber=0, isunique='Y', isdatacopy='N', isrecnum='N', condition=NULL, uniqnulls='N', ispartialdatacopy='N')
(tablename='partidx', keyname='UID_WHERE', keynumber=1, isunique='Y', isdatacopy='N', isrecnum='N', condition='where value > 10', uniqnulls='N', ispartialdatacopy='N')
(tablename='t1', keyname='VALUE', keynumber=1, isunique='Y', isdatacopy='N', isrecnum='N', condition=NULL, uniqnulls='N', ispartialdatacopy='N')
[select * from comdb2_keys order by keyname, tablename] rc 0
(tablename='partidx', keyname='UID', columnnumber=0, columnname='uid', isdescending='N')
(tablename='partidx', keyname='UID_WHERE', columnnumber=0, columnname='uid', isdescending='N')
(tablename='t1', keyname='UID', columnnumber=0, columnname='uid', isdescending='N')
(tablename='t1', keyname='VALUE', columnnumber=0, columnname='value', isdescending='N')
(tablename='t1', keyname='DUP_VALUE', columnnumber=0, columnname='value', isdescending='N')
(tablename='t2', keyname='UID1', columnnumber=0, columnname='uid', isdescending='N')
(tablename='t3', keyname='UID1', columnnumber=0, columnname='uid', isdescending='N')
(tablename='t4', keyname='UID1', columnnumber=0, columnname='uid', isdescending='N')
[select * from comdb2_keycomponents order by tablename] rc 0
(name='$CONSTRAINT_E4C60238', type='FOREIGN KEY', tablename='t2', keyname='UID1', foreigntablename='t1', foreignkeyname='UID', iscascadingdelete='N', iscascadingupdate='N', expr=NULL)
(name='$CONSTRAINT_E4C60238', type='FOREIGN KEY', tablename='t3', keyname='UID1', foreigntablename='t1', foreignkeyname='UID', iscascadingdelete='Y', iscascadingupdate='N', expr=NULL)
(name='$CONSTRAINT_E4C60238', type='FOREIGN KEY', tablename='t4', keyname='UID1', foreigntablename='t1', foreignkeyname='UID', iscascadingdelete='N', iscascadingupdate='Y', expr=NULL)
[select * from comdb2_constraints order by tablename] rc 0
(tablename='alltypes', bytes=2162688)
(tablename='dummy', bytes=65536)
(tablename='partidx', bytes=81920)
(tablename='sqlite_stat1', bytes=532480)
(tablename='sqlite_stat4', bytes=139264)
(tablename='t1', bytes=90112)
(tablename='t2', bytes=73728)
(tablename='t3', bytes=73728)
(tablename='t4', bytes=73728)
[select * from comdb2_tablesizes order by tablename] rc 0
(KEYWORDS_COUNT=224)
[SELECT COUNT(*) AS KEYWORDS_COUNT FROM comdb2_keywords] rc 0
(RESERVED_KW=67)
[SELECT COUNT(*) AS RESERVED_KW FROM comdb2_keywords WHERE reserved = 'Y'] rc 0
(NONRESERVED_KW=157)
[SELECT COUNT(*) AS NONRESERVED_KW FROM comdb2_keywords WHERE reserved = 'N'] rc 0
(name='ALL', reserved='Y')
(name='ALTER', reserved='Y')
(name='AND', reserved='Y')
(name='AS', reserved='Y')
(name='AUTOINCREMENT', reserved='Y')
(name='BETWEEN', reserved='Y')
(name='CASE', reserved='Y')
(name='COLLATE', reserved='Y')
(name='COMMIT', reserved='Y')
(name='CONSTRAINT', reserved='Y')
(name='CREATE', reserved='Y')
(name='CROSS', reserved='Y')
(name='DEFAULT', reserved='Y')
(name='DELETE', reserved='Y')
(name='DISTINCT', reserved='Y')
(name='DROP', reserved='Y')
(name='ELSE', reserved='Y')
(name='ENCODING', reserved='Y')
(name='ESCAPE', reserved='Y')
(name='EXCEPT', reserved='Y')
(name='EXISTS', reserved='Y')
(name='FILTER', reserved='Y')
(name='FOREIGN', reserved='Y')
(name='FROM', reserved='Y')
(name='FULL', reserved='Y')
(name='GROUP', reserved='Y')
(name='HAVING', reserved='Y')
(name='IN', reserved='Y')
(name='INDEX', reserved='Y')
(name='INDEXED', reserved='Y')
(name='INNER', reserved='Y')
(name='INSERT', reserved='Y')
(name='INTERSECT', reserved='Y')
(name='INTO', reserved='Y')
(name='IS', reserved='Y')
(name='ISNULL', reserved='Y')
(name='JOIN', reserved='Y')
(name='LEFT', reserved='Y')
(name='LIMIT', reserved='Y')
(name='NATURAL', reserved='Y')
(name='NOT', reserved='Y')
(name='NOTHING', reserved='Y')
(name='NOTNULL', reserved='Y')
(name='NULL', reserved='Y')
(name='ON', reserved='Y')
(name='OR', reserved='Y')
(name='ORDER', reserved='Y')
(name='OUTER', reserved='Y')
(name='OVER', reserved='Y')
(name='PRIMARY', reserved='Y')
(name='REFERENCES', reserved='Y')
(name='RIGHT', reserved='Y')
(name='SELECT', reserved='Y')
(name='SELECTV', reserved='Y')
(name='SET', reserved='Y')
(name='TABLE', reserved='Y')
(name='THEN', reserved='Y')
(name='TO', reserved='Y')
(name='TRANSACTION', reserved='Y')
(name='UNION', reserved='Y')
(name='UNIQUE', reserved='Y')
(name='UPDATE', reserved='Y')
(name='USING', reserved='Y')
(name='VALUES', reserved='Y')
(name='WHEN', reserved='Y')
(name='WHERE', reserved='Y')
(name='WINDOW', reserved='Y')
[SELECT * FROM comdb2_keywords WHERE reserved = 'Y' ORDER BY name] rc 0
(name='ABORT', reserved='N')
(name='ACTION', reserved='N')
(name='ADD', reserved='N')
(name='AFTER', reserved='N')
(name='AGGREGATE', reserved='N')
(name='ALIAS', reserved='N')
(name='ANALYZE', reserved='N')
(name='ANALYZEEXPERT', reserved='N')
(name='ANALYZESQLITE', reserved='N')
(name='ASC', reserved='N')
(name='ATTACH', reserved='N')
(name='AUTHENTICATION', reserved='N')
(name='BEFORE', reserved='N')
(name='BEGIN', reserved='N')
(name='BLOBFIELD', reserved='N')
(name='BULKIMPORT', reserved='N')
(name='BY', reserved='N')
(name='CASCADE', reserved='N')
(name='CAST', reserved='N')
(name='CHECK', reserved='N')
(name='COLUMN', reserved='N')
(name='COMMITSLEEP', reserved='N')
(name='CONFLICT', reserved='N')
(name='CONSUMER', reserved='N')
(name='CONVERTSLEEP', reserved='N')
(name='COUNTER', reserved='N')
(name='COVERAGE', reserved='N')
(name='CRLE', reserved='N')
(name='CURRENT', reserved='N')
(name='CURRENT_DATE', reserved='N')
(name='CURRENT_TIME', reserved='N')
(name='CURRENT_TIMESTAMP', reserved='N')
(name='DATA', reserved='N')
(name='DATABASE', reserved='N')
(name='DATABLOB', reserved='N')
(name='DATACOPY', reserved='N')
(name='DBPAD', reserved='N')
(name='DDL', reserved='N')
(name='DEFERRABLE', reserved='N')
(name='DEFERRED', reserved='N')
(name='DESC', reserved='N')
(name='DETACH', reserved='N')
(name='DETERMINISTIC', reserved='N')
(name='DISABLE', reserved='N')
(name='DISTRIBUTION', reserved='N')
(name='DO', reserved='N')
(name='DRYRUN', reserved='N')
(name='EACH', reserved='N')
(name='ENABLE', reserved='N')
(name='END', reserved='N')
(name='EXCLUDE', reserved='N')
(name='EXCLUSIVE', reserved='N')
(name='EXCLUSIVE_ANALYZE', reserved='N')
(name='EXEC', reserved='N')
(name='EXECUTE', reserved='N')
(name='EXPLAIN', reserved='N')
(name='FAIL', reserved='N')
(name='FOLLOWING', reserved='N')
(name='FOR', reserved='N')
(name='FORCE', reserved='N')
(name='FUNCTION', reserved='N')
(name='GENID48', reserved='N')
(name='GET', reserved='N')
(name='GLOB', reserved='N')
(name='GRANT', reserved='N')
(name='GROUPS', reserved='N')
(name='IF', reserved='N')
(name='IGNORE', reserved='N')
(name='IMMEDIATE', reserved='N')
(name='INCLUDE', reserved='N')
(name='INCREMENT', reserved='N')
(name='INITIALLY', reserved='N')
(name='INSTEAD', reserved='N')
(name='IPU', reserved='N')
(name='ISC', reserved='N')
(name='KEY', reserved='N')
(name='KW', reserved='N')
(name='LIKE', reserved='N')
(name='LUA', reserved='N')
(name='LZ4', reserved='N')
(name='MANUAL', reserved='N')
(name='MATCH', reserved='N')
(name='MERGE', reserved='N')
(name='NEXTSEQUENCE', reserved='N')
(name='NO', reserved='N')
(name='NONE', reserved='N')
(name='ODH', reserved='N')
(name='OF', reserved='N')
(name='OFF', reserved='N')
(name='OFFSET', reserved='N')
(name='OP', reserved='N')
(name='OPTION', reserved='N')
(name='OPTIONS', reserved='N')
(name='OTHERS', reserved='N')
(name='PAGEORDER', reserved='N')
(name='PARTITION', reserved='N')
(name='PARTITIONED', reserved='N')
(name='PASSWORD', reserved='N')
(name='PAUSE', reserved='N')
(name='PENDING', reserved='N')
(name='PERIOD', reserved='N')
(name='PLAN', reserved='N')
(name='PRAGMA', reserved='N')
(name='PRECEDING', reserved='N')
(name='PROCEDURE', reserved='N')
(name='PUT', reserved='N')
(name='QUERY', reserved='N')
(name='RAISE', reserved='N')
(name='RANGE', reserved='N')
(name='READ', reserved='N')
(name='READONLY', reserved='N')
(name='REBUILD', reserved='N')
(name='REC', reserved='N')
(name='RECURSIVE', reserved='N')
(name='REGEXP', reserved='N')
(name='REINDEX', reserved='N')
(name='RELEASE', reserved='N')
(name='RENAME', reserved='N')
(name='REPLACE', reserved='N')
(name='RESERVED', reserved='N')
(name='RESTRICT', reserved='N')
(name='RESUME', reserved='N')
(name='RETENTION', reserved='N')
(name='REVOKE', reserved='N')
(name='RLE', reserved='N')
(name='ROLLBACK', reserved='N')
(name='ROW', reserved='N')
(name='ROWLOCKS', reserved='N')
(name='ROWS', reserved='N')
(name='SAVEPOINT', reserved='N')
(name='SCALAR', reserved='N')
(name='SCHEMACHANGE', reserved='N')
(name='SEQUENCE', reserved='N')
(name='SKIPSCAN', reserved='N')
(name='START', reserved='N')
(name='SUMMARIZE', reserved='N')
(name='TEMP', reserved='N')
(name='TEMPORARY', reserved='N')
(name='TESTDEFAULT', reserved='N')
(name='THREADS', reserved='N')
(name='THRESHOLD', reserved='N')
(name='TIES', reserved='N')
(name='TIME', reserved='N')
(name='TRIGGER', reserved='N')
(name='TRUNCATE', reserved='N')
(name='TUNABLE', reserved='N')
(name='TYPE', reserved='N')
(name='UNBOUNDED', reserved='N')
(name='USERSCHEMA', reserved='N')
(name='VACUUM', reserved='N')
(name='VERSION', reserved='N')
(name='VIEW', reserved='N')
(name='VIRTUAL', reserved='N')
(name='WITH', reserved='N')
(name='WITHOUT', reserved='N')
(name='WRITE', reserved='N')
(name='ZLIB', reserved='N')
[SELECT * FROM comdb2_keywords WHERE reserved = 'N' ORDER BY name] rc 0
(name='max_blob_fields', description='Maximum number of blob/vutf8 fields per table', value=15)
(name='max_blob_length', description='Maximum blob length', value=268435455)
(name='max_bounded_parameters', description='Maximum number of bounded parameters per prepared statement', value=2048)
(name='max_column_name_length', description='Maximum column name length', value=99)
(name='max_columns', description='Maximum columns per table', value=1024)
(name='max_consumers', description='Maximum queue consumers per table', value=32)
(name='max_data_files', description='Maximum number of data files per table', value=16)
(name='max_data_stipes', description='Maximum number of data stripes per table', value=16)
(name='max_database_name_length', description='Maximum length of database name', value=64)
(name='max_expr_depth', description='Maximum depth of an expression tree', value=3000)
(name='max_indexes', description='Maximum number of indexes per table', value=50)
(name='max_key_length', description='Maximum key length', value=512)
(name='max_key_name_length', description='Maximum key name length', value=53)
(name='max_networks', description='Maximum number of networks', value=2)
(name='max_nodes', description='Maximum number of nodes', value=32)
(name='max_operation_name_length', description='Maximum length of a custom operation name', value=32)
(name='max_pattern_length', description='Maximum length of the pattern in a LIKE or GLOB operator', value=50000)
(name='max_plugins', description='Maximum number of plugins', value=100)
(name='max_queues', description='Maximum number of queues', value=1024)
(name='max_record_size', description='Maximum record size', value=16384)
(name='max_sp_name_length', description='Maximum stored procedure name length', value=32)
(name='max_sp_version_length', description='Maximum length of stored procedure version', value=80)
(name='max_sql_length', description='Maximum query length', value=1000000000)
(name='max_table_name_length', description='Maximum table name length', value=31)
(name='max_tables', description='Maximum number of tables', value=1024)
(name='max_tag_name_length', description='Maximum tag name length', value=64)
(name='max_views', description='Maximum number of views', value=1024)
[SELECT * FROM comdb2_limits ORDER BY name] rc 0
(name='appsockpool')
(name='loadcache')
(name='memptrickle')
(name='osqlpfaultpool')
(name='pgcompactpool')
(name='recovery_processors')
(name='recovery_workers')
(name='sqlenginepool')
(name='udppfaultpool')
[SELECT name FROM comdb2_threadpools ORDER BY name] rc 0
(COUNT(*)=1=0)
[SELECT COUNT(*)=1 FROM comdb2_plugins WHERE name = 'newsql'] rc 0
(COUNT(*)=1=0)
[SELECT COUNT(*)=1 FROM comdb2_appsock_handlers WHERE name = 'newsql'] rc 0
(COUNT(*)=1=1)
[SELECT COUNT(*)=1 FROM comdb2_opcode_handlers WHERE name = 'blockop'] rc 0
(type='blkseqs')
(type='others')
(type='sqlsorters')
(type='temptables')
[SELECT type FROM comdb2_temporary_file_sizes ORDER BY type] rc 0
(name='comdb2_active_osqls')
(name='comdb2_api_history')
(name='comdb2_appsock_handlers')
(name='comdb2_auto_analyze_tables')
(name='comdb2_blkseq')
(name='comdb2_clientstats')
(name='comdb2_cluster')
(name='comdb2_columns')
(name='comdb2_completion')
(name='comdb2_connections')
(name='comdb2_constraints')
(name='comdb2_cron_events')
(name='comdb2_cron_schedulers')
(name='comdb2_dbinfo')
(name='comdb2_fdb_info')
(name='comdb2_filenames')
(name='comdb2_files')
(name='comdb2_fingerprints')
(name='comdb2_functions')
(name='comdb2_index_usage')
(name='comdb2_keycomponents')
(name='comdb2_keys')
(name='comdb2_keywords')
(name='comdb2_limits')
(name='comdb2_locks')
(name='comdb2_logical_operations')
(name='comdb2_memstats')
(name='comdb2_metrics')
(name='comdb2_net_userfuncs')
(name='comdb2_opcode_handlers')
(name='comdb2_partial_datacopies')
(name='comdb2_plugins')
(name='comdb2_prepared')
(name='comdb2_procedures')
(name='comdb2_query_plans')
(name='comdb2_queues')
(name='comdb2_repl_stats')
(name='comdb2_replication_netqueue')
(name='comdb2_sample_queries')
(name='comdb2_sc_history')
(name='comdb2_sc_status')
(name='comdb2_schemaversions')
(name='comdb2_sql_client_stats')
(name='comdb2_sqlpool_queue')
(name='comdb2_stacks')
(name='comdb2_stringrefs')
(name='comdb2_systablepermissions')
(name='comdb2_systables')
(name='comdb2_table_metrics')
(name='comdb2_table_properties')
(name='comdb2_tablepermissions')
(name='comdb2_tables')
(name='comdb2_tablesizes')
(name='comdb2_tag_columns')
(name='comdb2_tags')
(name='comdb2_temporary_file_sizes')
(name='comdb2_threadpools')
(name='comdb2_timepartevents')
(name='comdb2_timepartitions')
(name='comdb2_timepartpermissions')
(name='comdb2_timepartshards')
(name='comdb2_timeseries')
(name='comdb2_transaction_commit')
(name='comdb2_transaction_logs')
(name='comdb2_transaction_state')
(name='comdb2_triggers')
(name='comdb2_tunables')
(name='comdb2_type_samples')
(name='comdb2_users')
(name='comdb2_views')
[SELECT * FROM comdb2_systables ORDER BY name] rc 0
[CREATE TABLE tpt1(a int PRIMARY KEY) PARTITIONED BY TIME PERIOD 'yearly' RETENTION 7 start '2000-01-01T UTC'] rc 0
(COUNT(*)=1)
[SELECT COUNT(*) FROM comdb2_keys WHERE tablename = 'tpt1'] rc 0
(COUNT(*)=1)
[SELECT COUNT(*) FROM comdb2_keycomponents WHERE tablename = 'tpt1'] rc 0