← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/information_schema.result

  • Committer: lbieber
  • Date: 2010-10-02 14:36:07 UTC
  • mfrom: (1799.7.7 drizzle-bug-649844)
  • mto: This revision was merged to the branch mainline in revision 1809.
  • Revision ID: lbieber@orisndriz08-20101002143607-fffgvc6l4gw9drmm
Merge Andrew - fix bug 649844 - Clean up and fix some drizzledump options along with some documentation fixes

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/information_schema.result
91
91
table_name NOT LIKE 'falcon%'
92
92
GROUP BY TABLE_SCHEMA ORDER BY table_schema;
93
93
table_schema    count(*)
94
 
DATA_DICTIONARY #
95
 
INFORMATION_SCHEMA      #
 
94
DATA_DICTIONARY 45
 
95
INFORMATION_SCHEMA      20
96
96
create table t1(f1 LONGBLOB, f2 LONGTEXT);
97
97
select column_name,data_type,CHARACTER_OCTET_LENGTH,
98
98
CHARACTER_MAXIMUM_LENGTH
194
194
CUMULATIVE_USER_STATS   BYTES_RECEIVED
195
195
CURRENT_SQL_COMMANDS    IP
196
196
DRIZZLE_PROTOCOL_STATUS VARIABLE_VALUE
197
 
ERRORS  ERROR_NAME
198
 
FOREIGN_KEYS    CONSTRAINT_SCHEMA
199
197
GLOBAL_STATEMENTS       VARIABLE_VALUE
200
198
GLOBAL_STATUS   VARIABLE_VALUE
201
199
GLOBAL_VARIABLES        VARIABLE_VALUE
202
200
INDEXES TABLE_SCHEMA
203
201
INDEX_PARTS     TABLE_SCHEMA
204
202
INNODB_CMP      COMPRESS_OPS
205
 
INNODB_CMPMEM   PAGE_SIZE
206
 
INNODB_CMPMEM_RESET     PAGE_SIZE
 
203
INNODB_CMPMEM   PAGES_USED
 
204
INNODB_CMPMEM_RESET     PAGES_USED
207
205
INNODB_CMP_RESET        COMPRESS_OPS
208
206
INNODB_LOCKS    LOCK_TRX_ID
209
207
INNODB_LOCK_WAITS       REQUESTED_LOCK_ID
210
 
INNODB_REPLICATION_LOG  TRANSACTION_MESSAGE_STRING
211
208
INNODB_STATUS   VARIABLE_VALUE
212
 
INNODB_SYS_COLUMNS      NAME
213
 
INNODB_SYS_FIELDS       NAME
214
 
INNODB_SYS_FOREIGN      FOR_NAME
215
 
INNODB_SYS_FOREIGN_COLS FOR_COL_NAME
216
 
INNODB_SYS_INDEXES      NAME
217
 
INNODB_SYS_TABLES       NAME
218
 
INNODB_SYS_TABLESTATS   NAME
219
209
INNODB_TRX      TRX_STATE
220
210
MODULES MODULE_VERSION
221
211
MYSQL_PROTOCOL_STATUS   VARIABLE_VALUE
222
212
PLUGINS PLUGIN_TYPE
223
213
PROCESSLIST     USER
 
214
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
224
215
REPLICATION_STREAMS     APPLIER
225
216
SCHEMAS SCHEMA_NAME
226
217
SCOREBOARD_STATISTICS   NUMBER_OF_RANGE_LOCKS
227
218
SESSION_STATEMENTS      VARIABLE_VALUE
228
219
SESSION_STATUS  VARIABLE_VALUE
229
220
SESSION_VARIABLES       VARIABLE_VALUE
 
221
SHOW_COLUMNS    Type
 
222
SHOW_INDEXES    Unique
 
223
SHOW_SCHEMAS    SCHEMA_NAME
 
224
SHOW_TABLE_STATUS       Schema
 
225
SHOW_TEMPORARY_TABLES   TABLE_SCHEMA
230
226
TABLES  TABLE_SCHEMA
231
227
TABLE_CACHE     TABLE_SCHEMA
232
228
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
233
229
TABLE_DEFINITION_CACHE  TABLE_SCHEMA
234
 
USER_DEFINED_BARRIERS   SESSION_ID
235
 
USER_DEFINED_LOCKS      SESSION_ID
236
 
USER_DEFINED_VARIABLES  VARIABLE_VALUE
237
230
SELECT t.table_name, c1.column_name
238
231
FROM data_dictionary.tables t
239
232
INNER JOIN
258
251
CUMULATIVE_USER_STATS   BYTES_RECEIVED
259
252
CURRENT_SQL_COMMANDS    IP
260
253
DRIZZLE_PROTOCOL_STATUS VARIABLE_VALUE
261
 
ERRORS  ERROR_NAME
262
 
FOREIGN_KEYS    CONSTRAINT_SCHEMA
263
254
GLOBAL_STATEMENTS       VARIABLE_VALUE
264
255
GLOBAL_STATUS   VARIABLE_VALUE
265
256
GLOBAL_VARIABLES        VARIABLE_VALUE
266
257
INDEXES TABLE_SCHEMA
267
258
INDEX_PARTS     TABLE_SCHEMA
268
259
INNODB_CMP      COMPRESS_OPS
269
 
INNODB_CMPMEM   PAGE_SIZE
270
 
INNODB_CMPMEM_RESET     PAGE_SIZE
 
260
INNODB_CMPMEM   PAGES_USED
 
261
INNODB_CMPMEM_RESET     PAGES_USED
271
262
INNODB_CMP_RESET        COMPRESS_OPS
272
263
INNODB_LOCKS    LOCK_TRX_ID
273
264
INNODB_LOCK_WAITS       REQUESTED_LOCK_ID
274
 
INNODB_REPLICATION_LOG  TRANSACTION_MESSAGE_STRING
275
265
INNODB_STATUS   VARIABLE_VALUE
276
 
INNODB_SYS_COLUMNS      NAME
277
 
INNODB_SYS_FIELDS       NAME
278
 
INNODB_SYS_FOREIGN      FOR_NAME
279
 
INNODB_SYS_FOREIGN_COLS FOR_COL_NAME
280
 
INNODB_SYS_INDEXES      NAME
281
 
INNODB_SYS_TABLES       NAME
282
 
INNODB_SYS_TABLESTATS   NAME
283
266
INNODB_TRX      TRX_STATE
284
267
MODULES MODULE_VERSION
285
268
MYSQL_PROTOCOL_STATUS   VARIABLE_VALUE
286
269
PLUGINS PLUGIN_TYPE
287
270
PROCESSLIST     USER
 
271
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
288
272
REPLICATION_STREAMS     APPLIER
289
273
SCHEMAS SCHEMA_NAME
290
274
SCOREBOARD_STATISTICS   NUMBER_OF_RANGE_LOCKS
291
275
SESSION_STATEMENTS      VARIABLE_VALUE
292
276
SESSION_STATUS  VARIABLE_VALUE
293
277
SESSION_VARIABLES       VARIABLE_VALUE
 
278
SHOW_COLUMNS    Type
 
279
SHOW_INDEXES    Unique
 
280
SHOW_SCHEMAS    SCHEMA_NAME
 
281
SHOW_TABLE_STATUS       Schema
 
282
SHOW_TEMPORARY_TABLES   TABLE_SCHEMA
294
283
TABLES  TABLE_SCHEMA
295
284
TABLE_CACHE     TABLE_SCHEMA
296
285
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
297
286
TABLE_DEFINITION_CACHE  TABLE_SCHEMA
298
 
USER_DEFINED_BARRIERS   SESSION_ID
299
 
USER_DEFINED_LOCKS      SESSION_ID
300
 
USER_DEFINED_VARIABLES  VARIABLE_VALUE
301
287
SELECT MAX(table_name) FROM data_dictionary.tables;
302
288
MAX(table_name)
303
289
VIEW_TABLE_USAGE