← Back to branch summary

~stewart/drizzle/embedded-innodb-create-select-transaction-arrgh

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/r/is_tables_is_falcon.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/funcs_1/r/is_tables_is_falcon.result
 
1
DROP DATABASE IF EXISTS db_datadict;
 
2
CREATE DATABASE db_datadict;
 
3
SELECT *,
 
4
LEFT( table_comment,
 
5
IF(INSTR(table_comment,'InnoDB free') = 0
 
6
AND INSTR(table_comment,'number_of_replicas') = 0,
 
7
LENGTH(table_comment),
 
8
INSTR(table_comment,'InnoDB free')
 
9
+ INSTR(table_comment,'number_of_replicas') - 1))
 
10
AS "user_comment",
 
11
'-----------------------------------------------------' AS "Separator"
 
12
FROM information_schema.tables
 
13
WHERE table_schema = 'information_schema'
 
14
AND table_name LIKE 'falcon_%'
 
15
ORDER BY table_schema,table_name;
 
16
TABLE_CATALOG   NULL
 
17
TABLE_SCHEMA    information_schema
 
18
TABLE_NAME      FALCON_DATABASE_IO
 
19
TABLE_TYPE      SYSTEM VIEW
 
20
ENGINE  MEMORY
 
21
VERSION 10
 
22
ROW_FORMAT      Fixed
 
23
TABLE_ROWS      #TBLR#
 
24
AVG_ROW_LENGTH  #ARL#
 
25
DATA_LENGTH     #DL#
 
26
MAX_DATA_LENGTH #MDL#
 
27
INDEX_LENGTH    #IL#
 
28
DATA_FREE       #DF#
 
29
AUTO_INCREMENT  NULL
 
30
CREATE_TIME     #CRT#
 
31
UPDATE_TIME     #UT#
 
32
CHECK_TIME      #CT#
 
33
TABLE_COLLATION utf8_general_ci
 
34
CHECKSUM        NULL
 
35
CREATE_OPTIONS  #CO#
 
36
TABLE_COMMENT   #TC#
 
37
user_comment    
 
38
Separator       -----------------------------------------------------
 
39
TABLE_CATALOG   NULL
 
40
TABLE_SCHEMA    information_schema
 
41
TABLE_NAME      FALCON_RECORD_CACHE_DETAIL
 
42
TABLE_TYPE      SYSTEM VIEW
 
43
ENGINE  MEMORY
 
44
VERSION 10
 
45
ROW_FORMAT      Fixed
 
46
TABLE_ROWS      #TBLR#
 
47
AVG_ROW_LENGTH  #ARL#
 
48
DATA_LENGTH     #DL#
 
49
MAX_DATA_LENGTH #MDL#
 
50
INDEX_LENGTH    #IL#
 
51
DATA_FREE       #DF#
 
52
AUTO_INCREMENT  NULL
 
53
CREATE_TIME     #CRT#
 
54
UPDATE_TIME     #UT#
 
55
CHECK_TIME      #CT#
 
56
TABLE_COLLATION utf8_general_ci
 
57
CHECKSUM        NULL
 
58
CREATE_OPTIONS  #CO#
 
59
TABLE_COMMENT   #TC#
 
60
user_comment    
 
61
Separator       -----------------------------------------------------
 
62
TABLE_CATALOG   NULL
 
63
TABLE_SCHEMA    information_schema
 
64
TABLE_NAME      FALCON_RECORD_CACHE_SUMMARY
 
65
TABLE_TYPE      SYSTEM VIEW
 
66
ENGINE  MEMORY
 
67
VERSION 10
 
68
ROW_FORMAT      Fixed
 
69
TABLE_ROWS      #TBLR#
 
70
AVG_ROW_LENGTH  #ARL#
 
71
DATA_LENGTH     #DL#
 
72
MAX_DATA_LENGTH #MDL#
 
73
INDEX_LENGTH    #IL#
 
74
DATA_FREE       #DF#
 
75
AUTO_INCREMENT  NULL
 
76
CREATE_TIME     #CRT#
 
77
UPDATE_TIME     #UT#
 
78
CHECK_TIME      #CT#
 
79
TABLE_COLLATION utf8_general_ci
 
80
CHECKSUM        NULL
 
81
CREATE_OPTIONS  #CO#
 
82
TABLE_COMMENT   #TC#
 
83
user_comment    
 
84
Separator       -----------------------------------------------------
 
85
TABLE_CATALOG   NULL
 
86
TABLE_SCHEMA    information_schema
 
87
TABLE_NAME      FALCON_SERIAL_LOG_INFO
 
88
TABLE_TYPE      SYSTEM VIEW
 
89
ENGINE  MEMORY
 
90
VERSION 10
 
91
ROW_FORMAT      Fixed
 
92
TABLE_ROWS      #TBLR#
 
93
AVG_ROW_LENGTH  #ARL#
 
94
DATA_LENGTH     #DL#
 
95
MAX_DATA_LENGTH #MDL#
 
96
INDEX_LENGTH    #IL#
 
97
DATA_FREE       #DF#
 
98
AUTO_INCREMENT  NULL
 
99
CREATE_TIME     #CRT#
 
100
UPDATE_TIME     #UT#
 
101
CHECK_TIME      #CT#
 
102
TABLE_COLLATION utf8_general_ci
 
103
CHECKSUM        NULL
 
104
CREATE_OPTIONS  #CO#
 
105
TABLE_COMMENT   #TC#
 
106
user_comment    
 
107
Separator       -----------------------------------------------------
 
108
TABLE_CATALOG   NULL
 
109
TABLE_SCHEMA    information_schema
 
110
TABLE_NAME      FALCON_SYNCOBJECTS
 
111
TABLE_TYPE      SYSTEM VIEW
 
112
ENGINE  MEMORY
 
113
VERSION 10
 
114
ROW_FORMAT      Fixed
 
115
TABLE_ROWS      #TBLR#
 
116
AVG_ROW_LENGTH  #ARL#
 
117
DATA_LENGTH     #DL#
 
118
MAX_DATA_LENGTH #MDL#
 
119
INDEX_LENGTH    #IL#
 
120
DATA_FREE       #DF#
 
121
AUTO_INCREMENT  NULL
 
122
CREATE_TIME     #CRT#
 
123
UPDATE_TIME     #UT#
 
124
CHECK_TIME      #CT#
 
125
TABLE_COLLATION utf8_general_ci
 
126
CHECKSUM        NULL
 
127
CREATE_OPTIONS  #CO#
 
128
TABLE_COMMENT   #TC#
 
129
user_comment    
 
130
Separator       -----------------------------------------------------
 
131
TABLE_CATALOG   NULL
 
132
TABLE_SCHEMA    information_schema
 
133
TABLE_NAME      FALCON_SYSTEM_MEMORY_DETAIL
 
134
TABLE_TYPE      SYSTEM VIEW
 
135
ENGINE  MEMORY
 
136
VERSION 10
 
137
ROW_FORMAT      Fixed
 
138
TABLE_ROWS      #TBLR#
 
139
AVG_ROW_LENGTH  #ARL#
 
140
DATA_LENGTH     #DL#
 
141
MAX_DATA_LENGTH #MDL#
 
142
INDEX_LENGTH    #IL#
 
143
DATA_FREE       #DF#
 
144
AUTO_INCREMENT  NULL
 
145
CREATE_TIME     #CRT#
 
146
UPDATE_TIME     #UT#
 
147
CHECK_TIME      #CT#
 
148
TABLE_COLLATION utf8_general_ci
 
149
CHECKSUM        NULL
 
150
CREATE_OPTIONS  #CO#
 
151
TABLE_COMMENT   #TC#
 
152
user_comment    
 
153
Separator       -----------------------------------------------------
 
154
TABLE_CATALOG   NULL
 
155
TABLE_SCHEMA    information_schema
 
156
TABLE_NAME      FALCON_SYSTEM_MEMORY_SUMMARY
 
157
TABLE_TYPE      SYSTEM VIEW
 
158
ENGINE  MEMORY
 
159
VERSION 10
 
160
ROW_FORMAT      Fixed
 
161
TABLE_ROWS      #TBLR#
 
162
AVG_ROW_LENGTH  #ARL#
 
163
DATA_LENGTH     #DL#
 
164
MAX_DATA_LENGTH #MDL#
 
165
INDEX_LENGTH    #IL#
 
166
DATA_FREE       #DF#
 
167
AUTO_INCREMENT  NULL
 
168
CREATE_TIME     #CRT#
 
169
UPDATE_TIME     #UT#
 
170
CHECK_TIME      #CT#
 
171
TABLE_COLLATION utf8_general_ci
 
172
CHECKSUM        NULL
 
173
CREATE_OPTIONS  #CO#
 
174
TABLE_COMMENT   #TC#
 
175
user_comment    
 
176
Separator       -----------------------------------------------------
 
177
TABLE_CATALOG   NULL
 
178
TABLE_SCHEMA    information_schema
 
179
TABLE_NAME      FALCON_TABLES
 
180
TABLE_TYPE      SYSTEM VIEW
 
181
ENGINE  MEMORY
 
182
VERSION 10
 
183
ROW_FORMAT      Fixed
 
184
TABLE_ROWS      #TBLR#
 
185
AVG_ROW_LENGTH  #ARL#
 
186
DATA_LENGTH     #DL#
 
187
MAX_DATA_LENGTH #MDL#
 
188
INDEX_LENGTH    #IL#
 
189
DATA_FREE       #DF#
 
190
AUTO_INCREMENT  NULL
 
191
CREATE_TIME     #CRT#
 
192
UPDATE_TIME     #UT#
 
193
CHECK_TIME      #CT#
 
194
TABLE_COLLATION utf8_general_ci
 
195
CHECKSUM        NULL
 
196
CREATE_OPTIONS  #CO#
 
197
TABLE_COMMENT   #TC#
 
198
user_comment    
 
199
Separator       -----------------------------------------------------
 
200
TABLE_CATALOG   NULL
 
201
TABLE_SCHEMA    information_schema
 
202
TABLE_NAME      FALCON_TRANSACTIONS
 
203
TABLE_TYPE      SYSTEM VIEW
 
204
ENGINE  MEMORY
 
205
VERSION 10
 
206
ROW_FORMAT      Fixed
 
207
TABLE_ROWS      #TBLR#
 
208
AVG_ROW_LENGTH  #ARL#
 
209
DATA_LENGTH     #DL#
 
210
MAX_DATA_LENGTH #MDL#
 
211
INDEX_LENGTH    #IL#
 
212
DATA_FREE       #DF#
 
213
AUTO_INCREMENT  NULL
 
214
CREATE_TIME     #CRT#
 
215
UPDATE_TIME     #UT#
 
216
CHECK_TIME      #CT#
 
217
TABLE_COLLATION utf8_general_ci
 
218
CHECKSUM        NULL
 
219
CREATE_OPTIONS  #CO#
 
220
TABLE_COMMENT   #TC#
 
221
user_comment    
 
222
Separator       -----------------------------------------------------
 
223
TABLE_CATALOG   NULL
 
224
TABLE_SCHEMA    information_schema
 
225
TABLE_NAME      FALCON_TRANSACTION_SUMMARY
 
226
TABLE_TYPE      SYSTEM VIEW
 
227
ENGINE  MEMORY
 
228
VERSION 10
 
229
ROW_FORMAT      Fixed
 
230
TABLE_ROWS      #TBLR#
 
231
AVG_ROW_LENGTH  #ARL#
 
232
DATA_LENGTH     #DL#
 
233
MAX_DATA_LENGTH #MDL#
 
234
INDEX_LENGTH    #IL#
 
235
DATA_FREE       #DF#
 
236
AUTO_INCREMENT  NULL
 
237
CREATE_TIME     #CRT#
 
238
UPDATE_TIME     #UT#
 
239
CHECK_TIME      #CT#
 
240
TABLE_COLLATION utf8_general_ci
 
241
CHECKSUM        NULL
 
242
CREATE_OPTIONS  #CO#
 
243
TABLE_COMMENT   #TC#
 
244
user_comment    
 
245
Separator       -----------------------------------------------------
 
246
TABLE_CATALOG   NULL
 
247
TABLE_SCHEMA    information_schema
 
248
TABLE_NAME      FALCON_VERSION
 
249
TABLE_TYPE      SYSTEM VIEW
 
250
ENGINE  MEMORY
 
251
VERSION 10
 
252
ROW_FORMAT      Fixed
 
253
TABLE_ROWS      #TBLR#
 
254
AVG_ROW_LENGTH  #ARL#
 
255
DATA_LENGTH     #DL#
 
256
MAX_DATA_LENGTH #MDL#
 
257
INDEX_LENGTH    #IL#
 
258
DATA_FREE       #DF#
 
259
AUTO_INCREMENT  NULL
 
260
CREATE_TIME     #CRT#
 
261
UPDATE_TIME     #UT#
 
262
CHECK_TIME      #CT#
 
263
TABLE_COLLATION utf8_general_ci
 
264
CHECKSUM        NULL
 
265
CREATE_OPTIONS  #CO#
 
266
TABLE_COMMENT   #TC#
 
267
user_comment    
 
268
Separator       -----------------------------------------------------
 
269
DROP   USER testuser1@localhost;
 
270
CREATE USER testuser1@localhost;
 
271
GRANT SELECT ON db_datadict.* TO testuser1@localhost;
 
272
# Establish connection testuser1 (user=testuser1)
 
273
SELECT *,
 
274
LEFT( table_comment,
 
275
IF(INSTR(table_comment,'InnoDB free') = 0
 
276
AND INSTR(table_comment,'number_of_replicas') = 0,
 
277
LENGTH(table_comment),
 
278
INSTR(table_comment,'InnoDB free')
 
279
+ INSTR(table_comment,'number_of_replicas') - 1))
 
280
AS "user_comment",
 
281
'-----------------------------------------------------' AS "Separator"
 
282
FROM information_schema.tables
 
283
WHERE table_schema = 'information_schema'
 
284
AND table_name LIKE 'falcon_%'
 
285
ORDER BY table_schema,table_name;
 
286
TABLE_CATALOG   NULL
 
287
TABLE_SCHEMA    information_schema
 
288
TABLE_NAME      FALCON_DATABASE_IO
 
289
TABLE_TYPE      SYSTEM VIEW
 
290
ENGINE  MEMORY
 
291
VERSION 10
 
292
ROW_FORMAT      Fixed
 
293
TABLE_ROWS      #TBLR#
 
294
AVG_ROW_LENGTH  #ARL#
 
295
DATA_LENGTH     #DL#
 
296
MAX_DATA_LENGTH #MDL#
 
297
INDEX_LENGTH    #IL#
 
298
DATA_FREE       #DF#
 
299
AUTO_INCREMENT  NULL
 
300
CREATE_TIME     #CRT#
 
301
UPDATE_TIME     #UT#
 
302
CHECK_TIME      #CT#
 
303
TABLE_COLLATION utf8_general_ci
 
304
CHECKSUM        NULL
 
305
CREATE_OPTIONS  #CO#
 
306
TABLE_COMMENT   #TC#
 
307
user_comment    
 
308
Separator       -----------------------------------------------------
 
309
TABLE_CATALOG   NULL
 
310
TABLE_SCHEMA    information_schema
 
311
TABLE_NAME      FALCON_RECORD_CACHE_DETAIL
 
312
TABLE_TYPE      SYSTEM VIEW
 
313
ENGINE  MEMORY
 
314
VERSION 10
 
315
ROW_FORMAT      Fixed
 
316
TABLE_ROWS      #TBLR#
 
317
AVG_ROW_LENGTH  #ARL#
 
318
DATA_LENGTH     #DL#
 
319
MAX_DATA_LENGTH #MDL#
 
320
INDEX_LENGTH    #IL#
 
321
DATA_FREE       #DF#
 
322
AUTO_INCREMENT  NULL
 
323
CREATE_TIME     #CRT#
 
324
UPDATE_TIME     #UT#
 
325
CHECK_TIME      #CT#
 
326
TABLE_COLLATION utf8_general_ci
 
327
CHECKSUM        NULL
 
328
CREATE_OPTIONS  #CO#
 
329
TABLE_COMMENT   #TC#
 
330
user_comment    
 
331
Separator       -----------------------------------------------------
 
332
TABLE_CATALOG   NULL
 
333
TABLE_SCHEMA    information_schema
 
334
TABLE_NAME      FALCON_RECORD_CACHE_SUMMARY
 
335
TABLE_TYPE      SYSTEM VIEW
 
336
ENGINE  MEMORY
 
337
VERSION 10
 
338
ROW_FORMAT      Fixed
 
339
TABLE_ROWS      #TBLR#
 
340
AVG_ROW_LENGTH  #ARL#
 
341
DATA_LENGTH     #DL#
 
342
MAX_DATA_LENGTH #MDL#
 
343
INDEX_LENGTH    #IL#
 
344
DATA_FREE       #DF#
 
345
AUTO_INCREMENT  NULL
 
346
CREATE_TIME     #CRT#
 
347
UPDATE_TIME     #UT#
 
348
CHECK_TIME      #CT#
 
349
TABLE_COLLATION utf8_general_ci
 
350
CHECKSUM        NULL
 
351
CREATE_OPTIONS  #CO#
 
352
TABLE_COMMENT   #TC#
 
353
user_comment    
 
354
Separator       -----------------------------------------------------
 
355
TABLE_CATALOG   NULL
 
356
TABLE_SCHEMA    information_schema
 
357
TABLE_NAME      FALCON_SERIAL_LOG_INFO
 
358
TABLE_TYPE      SYSTEM VIEW
 
359
ENGINE  MEMORY
 
360
VERSION 10
 
361
ROW_FORMAT      Fixed
 
362
TABLE_ROWS      #TBLR#
 
363
AVG_ROW_LENGTH  #ARL#
 
364
DATA_LENGTH     #DL#
 
365
MAX_DATA_LENGTH #MDL#
 
366
INDEX_LENGTH    #IL#
 
367
DATA_FREE       #DF#
 
368
AUTO_INCREMENT  NULL
 
369
CREATE_TIME     #CRT#
 
370
UPDATE_TIME     #UT#
 
371
CHECK_TIME      #CT#
 
372
TABLE_COLLATION utf8_general_ci
 
373
CHECKSUM        NULL
 
374
CREATE_OPTIONS  #CO#
 
375
TABLE_COMMENT   #TC#
 
376
user_comment    
 
377
Separator       -----------------------------------------------------
 
378
TABLE_CATALOG   NULL
 
379
TABLE_SCHEMA    information_schema
 
380
TABLE_NAME      FALCON_SYNCOBJECTS
 
381
TABLE_TYPE      SYSTEM VIEW
 
382
ENGINE  MEMORY
 
383
VERSION 10
 
384
ROW_FORMAT      Fixed
 
385
TABLE_ROWS      #TBLR#
 
386
AVG_ROW_LENGTH  #ARL#
 
387
DATA_LENGTH     #DL#
 
388
MAX_DATA_LENGTH #MDL#
 
389
INDEX_LENGTH    #IL#
 
390
DATA_FREE       #DF#
 
391
AUTO_INCREMENT  NULL
 
392
CREATE_TIME     #CRT#
 
393
UPDATE_TIME     #UT#
 
394
CHECK_TIME      #CT#
 
395
TABLE_COLLATION utf8_general_ci
 
396
CHECKSUM        NULL
 
397
CREATE_OPTIONS  #CO#
 
398
TABLE_COMMENT   #TC#
 
399
user_comment    
 
400
Separator       -----------------------------------------------------
 
401
TABLE_CATALOG   NULL
 
402
TABLE_SCHEMA    information_schema
 
403
TABLE_NAME      FALCON_SYSTEM_MEMORY_DETAIL
 
404
TABLE_TYPE      SYSTEM VIEW
 
405
ENGINE  MEMORY
 
406
VERSION 10
 
407
ROW_FORMAT      Fixed
 
408
TABLE_ROWS      #TBLR#
 
409
AVG_ROW_LENGTH  #ARL#
 
410
DATA_LENGTH     #DL#
 
411
MAX_DATA_LENGTH #MDL#
 
412
INDEX_LENGTH    #IL#
 
413
DATA_FREE       #DF#
 
414
AUTO_INCREMENT  NULL
 
415
CREATE_TIME     #CRT#
 
416
UPDATE_TIME     #UT#
 
417
CHECK_TIME      #CT#
 
418
TABLE_COLLATION utf8_general_ci
 
419
CHECKSUM        NULL
 
420
CREATE_OPTIONS  #CO#
 
421
TABLE_COMMENT   #TC#
 
422
user_comment    
 
423
Separator       -----------------------------------------------------
 
424
TABLE_CATALOG   NULL
 
425
TABLE_SCHEMA    information_schema
 
426
TABLE_NAME      FALCON_SYSTEM_MEMORY_SUMMARY
 
427
TABLE_TYPE      SYSTEM VIEW
 
428
ENGINE  MEMORY
 
429
VERSION 10
 
430
ROW_FORMAT      Fixed
 
431
TABLE_ROWS      #TBLR#
 
432
AVG_ROW_LENGTH  #ARL#
 
433
DATA_LENGTH     #DL#
 
434
MAX_DATA_LENGTH #MDL#
 
435
INDEX_LENGTH    #IL#
 
436
DATA_FREE       #DF#
 
437
AUTO_INCREMENT  NULL
 
438
CREATE_TIME     #CRT#
 
439
UPDATE_TIME     #UT#
 
440
CHECK_TIME      #CT#
 
441
TABLE_COLLATION utf8_general_ci
 
442
CHECKSUM        NULL
 
443
CREATE_OPTIONS  #CO#
 
444
TABLE_COMMENT   #TC#
 
445
user_comment    
 
446
Separator       -----------------------------------------------------
 
447
TABLE_CATALOG   NULL
 
448
TABLE_SCHEMA    information_schema
 
449
TABLE_NAME      FALCON_TABLES
 
450
TABLE_TYPE      SYSTEM VIEW
 
451
ENGINE  MEMORY
 
452
VERSION 10
 
453
ROW_FORMAT      Fixed
 
454
TABLE_ROWS      #TBLR#
 
455
AVG_ROW_LENGTH  #ARL#
 
456
DATA_LENGTH     #DL#
 
457
MAX_DATA_LENGTH #MDL#
 
458
INDEX_LENGTH    #IL#
 
459
DATA_FREE       #DF#
 
460
AUTO_INCREMENT  NULL
 
461
CREATE_TIME     #CRT#
 
462
UPDATE_TIME     #UT#
 
463
CHECK_TIME      #CT#
 
464
TABLE_COLLATION utf8_general_ci
 
465
CHECKSUM        NULL
 
466
CREATE_OPTIONS  #CO#
 
467
TABLE_COMMENT   #TC#
 
468
user_comment    
 
469
Separator       -----------------------------------------------------
 
470
TABLE_CATALOG   NULL
 
471
TABLE_SCHEMA    information_schema
 
472
TABLE_NAME      FALCON_TRANSACTIONS
 
473
TABLE_TYPE      SYSTEM VIEW
 
474
ENGINE  MEMORY
 
475
VERSION 10
 
476
ROW_FORMAT      Fixed
 
477
TABLE_ROWS      #TBLR#
 
478
AVG_ROW_LENGTH  #ARL#
 
479
DATA_LENGTH     #DL#
 
480
MAX_DATA_LENGTH #MDL#
 
481
INDEX_LENGTH    #IL#
 
482
DATA_FREE       #DF#
 
483
AUTO_INCREMENT  NULL
 
484
CREATE_TIME     #CRT#
 
485
UPDATE_TIME     #UT#
 
486
CHECK_TIME      #CT#
 
487
TABLE_COLLATION utf8_general_ci
 
488
CHECKSUM        NULL
 
489
CREATE_OPTIONS  #CO#
 
490
TABLE_COMMENT   #TC#
 
491
user_comment    
 
492
Separator       -----------------------------------------------------
 
493
TABLE_CATALOG   NULL
 
494
TABLE_SCHEMA    information_schema
 
495
TABLE_NAME      FALCON_TRANSACTION_SUMMARY
 
496
TABLE_TYPE      SYSTEM VIEW
 
497
ENGINE  MEMORY
 
498
VERSION 10
 
499
ROW_FORMAT      Fixed
 
500
TABLE_ROWS      #TBLR#
 
501
AVG_ROW_LENGTH  #ARL#
 
502
DATA_LENGTH     #DL#
 
503
MAX_DATA_LENGTH #MDL#
 
504
INDEX_LENGTH    #IL#
 
505
DATA_FREE       #DF#
 
506
AUTO_INCREMENT  NULL
 
507
CREATE_TIME     #CRT#
 
508
UPDATE_TIME     #UT#
 
509
CHECK_TIME      #CT#
 
510
TABLE_COLLATION utf8_general_ci
 
511
CHECKSUM        NULL
 
512
CREATE_OPTIONS  #CO#
 
513
TABLE_COMMENT   #TC#
 
514
user_comment    
 
515
Separator       -----------------------------------------------------
 
516
TABLE_CATALOG   NULL
 
517
TABLE_SCHEMA    information_schema
 
518
TABLE_NAME      FALCON_VERSION
 
519
TABLE_TYPE      SYSTEM VIEW
 
520
ENGINE  MEMORY
 
521
VERSION 10
 
522
ROW_FORMAT      Fixed
 
523
TABLE_ROWS      #TBLR#
 
524
AVG_ROW_LENGTH  #ARL#
 
525
DATA_LENGTH     #DL#
 
526
MAX_DATA_LENGTH #MDL#
 
527
INDEX_LENGTH    #IL#
 
528
DATA_FREE       #DF#
 
529
AUTO_INCREMENT  NULL
 
530
CREATE_TIME     #CRT#
 
531
UPDATE_TIME     #UT#
 
532
CHECK_TIME      #CT#
 
533
TABLE_COLLATION utf8_general_ci
 
534
CHECKSUM        NULL
 
535
CREATE_OPTIONS  #CO#
 
536
TABLE_COMMENT   #TC#
 
537
user_comment    
 
538
Separator       -----------------------------------------------------
 
539
# Switch to connection default and close connection testuser1
 
540
DROP USER testuser1@localhost;
 
541
DROP DATABASE db_datadict;