← 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-06 16:34:16 UTC
  • mfrom: (1816.1.3 build)
  • Revision ID: lbieber@orisndriz08-20101006163416-ea0sl59qgpglk21y
Merge Monty - Change the requirement from either libinnodb to libhaildb. Also, tied it to version 2.2
Merge Andrew - fix bug 650935: remove --compress from all clients
Merge Andrew - fix bug 653471: Add -A to drizzle client
Merge Travis - 621861 = To change C structs to C++ classes in Drizzle

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/information_schema.result
27
27
a       INTEGER YES             YES     
28
28
select * from data_dictionary.columns where table_name="t1"
29
29
and column_name= "a";
30
 
TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     COLUMN_TYPE     ORDINAL_POSITION        COLUMN_DEFAULT  COLUMN_DEFAULT_IS_NULL  COLUMN_DEFAULT_UPDATE   IS_SIGNED       IS_AUTO_INCREMENT       IS_NULLABLE     IS_INDEXED      IS_USED_IN_PRIMARY      IS_UNIQUE       IS_MULTI        IS_FIRST_IN_MULTI       INDEXES_FOUND_IN        DATA_TYPE       DATA_ARCHETYPE  CHARACTER_MAXIMUM_LENGTH        CHARACTER_OCTET_LENGTH  NUMERIC_PRECISION       NUMERIC_SCALE   ENUM_VALUES     COLLATION_NAME  COLUMN_COMMENT
31
 
mysqltest       t1      a       INTEGER 0       NULL    YES             NULL    NO      YES     NO      NO      NO      NO      NO      0       INTEGER INTEGER 0       0       0       0       NULL            NULL
 
30
TABLE_SCHEMA    TABLE_NAME      COLUMN_NAME     COLUMN_TYPE     ORDINAL_POSITION        COLUMN_DEFAULT  COLUMN_DEFAULT_IS_NULL  COLUMN_DEFAULT_UPDATE   IS_AUTO_INCREMENT       IS_NULLABLE     IS_INDEXED      IS_USED_IN_PRIMARY      IS_UNIQUE       IS_MULTI        IS_FIRST_IN_MULTI       INDEXES_FOUND_IN        DATA_TYPE       CHARACTER_MAXIMUM_LENGTH        CHARACTER_OCTET_LENGTH  NUMERIC_PRECISION       NUMERIC_SCALE   ENUM_VALUES     COLLATION_NAME  COLUMN_COMMENT
 
31
mysqltest       t1      a       INTEGER 0       NULL    YES             NO      YES     NO      NO      NO      NO      NO      0       INTEGER 0       0       0       0       NULL            NULL
32
32
select table_name, column_name from data_dictionary.columns 
33
33
where table_schema = 'mysqltest' and table_name = 't1';
34
34
table_name      column_name
100
100
where table_name='t1';
101
101
column_name     data_type       CHARACTER_OCTET_LENGTH  CHARACTER_MAXIMUM_LENGTH
102
102
f1      BLOB    0       0
103
 
f2      TEXT    0       0
 
103
f2      BLOB    0       0
104
104
drop table t1;
105
105
create table t1(f1 int, f2 int, f3 BIGINT, f4 int,
106
106
f5 BIGINT, f6 int, f7 int);
187
187
AND t.table_name NOT LIKE 'falcon%'
188
188
  ORDER BY t.table_name, c1.column_name;
189
189
table_name      column_name
190
 
CATALOGS        CATALOG_CREATION_TIME
191
190
CHARACTER_SETS  DEFAULT_COLLATE_NAME
192
191
COLLATIONS      COLLATION_NAME
193
192
COLUMNS TABLE_SCHEMA
194
193
CUMULATIVE_SQL_COMMANDS COUNT_SELECT
195
194
CUMULATIVE_USER_STATS   BYTES_RECEIVED
196
195
CURRENT_SQL_COMMANDS    IP
197
 
ERRORS  ERROR_NAME
198
 
FOREIGN_KEYS    CONSTRAINT_SCHEMA
 
196
DRIZZLE_PROTOCOL_STATUS VARIABLE_VALUE
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_SEGMENT_ID
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
 
211
MYSQL_PROTOCOL_STATUS   VARIABLE_VALUE
221
212
PLUGINS PLUGIN_TYPE
222
 
PROCESSLIST     USERNAME
223
 
PROTOCOL_COUNTERS       COUNTER
 
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
230
 
SYS_REPLICATION_LOG     SEGID
 
221
SHOW_COLUMNS    Type
 
222
SHOW_INDEXES    Unique
 
223
SHOW_SCHEMAS    SCHEMA_NAME
 
224
SHOW_TABLE_STATUS       Schema
 
225
SHOW_TEMPORARY_TABLES   TABLE_SCHEMA
231
226
TABLES  TABLE_SCHEMA
232
227
TABLE_CACHE     TABLE_SCHEMA
233
228
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
234
229
TABLE_DEFINITION_CACHE  TABLE_SCHEMA
235
 
USER_DEFINED_BARRIERS   SESSION_ID
236
 
USER_DEFINED_LOCKS      SESSION_ID
237
 
USER_DEFINED_VARIABLES  VARIABLE_VALUE
238
230
SELECT t.table_name, c1.column_name
239
231
FROM data_dictionary.tables t
240
232
INNER JOIN
252
244
AND t.table_name NOT LIKE 'falcon%'
253
245
  ORDER BY t.table_name, c1.column_name;
254
246
table_name      column_name
255
 
CATALOGS        CATALOG_CREATION_TIME
256
247
CHARACTER_SETS  DEFAULT_COLLATE_NAME
257
248
COLLATIONS      COLLATION_NAME
258
249
COLUMNS TABLE_SCHEMA
259
250
CUMULATIVE_SQL_COMMANDS COUNT_SELECT
260
251
CUMULATIVE_USER_STATS   BYTES_RECEIVED
261
252
CURRENT_SQL_COMMANDS    IP
262
 
ERRORS  ERROR_NAME
263
 
FOREIGN_KEYS    CONSTRAINT_SCHEMA
 
253
DRIZZLE_PROTOCOL_STATUS VARIABLE_VALUE
264
254
GLOBAL_STATEMENTS       VARIABLE_VALUE
265
255
GLOBAL_STATUS   VARIABLE_VALUE
266
256
GLOBAL_VARIABLES        VARIABLE_VALUE
267
257
INDEXES TABLE_SCHEMA
268
258
INDEX_PARTS     TABLE_SCHEMA
269
259
INNODB_CMP      COMPRESS_OPS
270
 
INNODB_CMPMEM   PAGE_SIZE
271
 
INNODB_CMPMEM_RESET     PAGE_SIZE
 
260
INNODB_CMPMEM   PAGES_USED
 
261
INNODB_CMPMEM_RESET     PAGES_USED
272
262
INNODB_CMP_RESET        COMPRESS_OPS
273
263
INNODB_LOCKS    LOCK_TRX_ID
274
264
INNODB_LOCK_WAITS       REQUESTED_LOCK_ID
275
 
INNODB_REPLICATION_LOG  TRANSACTION_SEGMENT_ID
276
265
INNODB_STATUS   VARIABLE_VALUE
277
 
INNODB_SYS_COLUMNS      NAME
278
 
INNODB_SYS_FIELDS       NAME
279
 
INNODB_SYS_FOREIGN      FOR_NAME
280
 
INNODB_SYS_FOREIGN_COLS FOR_COL_NAME
281
 
INNODB_SYS_INDEXES      NAME
282
 
INNODB_SYS_TABLES       NAME
283
 
INNODB_SYS_TABLESTATS   NAME
284
266
INNODB_TRX      TRX_STATE
285
267
MODULES MODULE_VERSION
 
268
MYSQL_PROTOCOL_STATUS   VARIABLE_VALUE
286
269
PLUGINS PLUGIN_TYPE
287
 
PROCESSLIST     USERNAME
288
 
PROTOCOL_COUNTERS       COUNTER
 
270
PROCESSLIST     USER
 
271
REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA
289
272
REPLICATION_STREAMS     APPLIER
290
273
SCHEMAS SCHEMA_NAME
291
274
SCOREBOARD_STATISTICS   NUMBER_OF_RANGE_LOCKS
292
275
SESSION_STATEMENTS      VARIABLE_VALUE
293
276
SESSION_STATUS  VARIABLE_VALUE
294
277
SESSION_VARIABLES       VARIABLE_VALUE
295
 
SYS_REPLICATION_LOG     SEGID
 
278
SHOW_COLUMNS    Type
 
279
SHOW_INDEXES    Unique
 
280
SHOW_SCHEMAS    SCHEMA_NAME
 
281
SHOW_TABLE_STATUS       Schema
 
282
SHOW_TEMPORARY_TABLES   TABLE_SCHEMA
296
283
TABLES  TABLE_SCHEMA
297
284
TABLE_CACHE     TABLE_SCHEMA
298
285
TABLE_CONSTRAINTS       CONSTRAINT_SCHEMA
299
286
TABLE_DEFINITION_CACHE  TABLE_SCHEMA
300
 
USER_DEFINED_BARRIERS   SESSION_ID
301
 
USER_DEFINED_LOCKS      SESSION_ID
302
 
USER_DEFINED_VARIABLES  VARIABLE_VALUE
303
287
SELECT MAX(table_name) FROM data_dictionary.tables;
304
288
MAX(table_name)
305
289
VIEW_TABLE_USAGE
313
297
create table t2 (f1 int, f2 int);
314
298
drop table t1,t2;
315
299
select 1 as f1 from data_dictionary.tables  where "CHARACTER_SETS"=
316
 
(select cast(table_name as char)  from data_dictionary.tables WHERE TABLE_SCHEMA=schema()
317
 
AND TABLE_NAME = "CHARACTER_SETS"
318
 
 order by table_name limit 1) AND TABLE_SCHEMA=schema() limit 1;
 
300
(select cast(table_name as char)  from data_dictionary.tables
 
301
order by table_name limit 1) limit 1;
319
302
f1
 
303
1
320
304
select t.table_name, group_concat(t.table_schema, '.', t.table_name),
321
305
count(*) as num1
322
306
from data_dictionary.tables t
357
341
f5      BIGINT  NO              NO      
358
342
f6      BIGINT  NO      10      NO      
359
343
f7      DATETIME        NO              NO      
360
 
f8      DATETIME        YES     2006-01-01 00:00:00.000000      NO      
 
344
f8      DATETIME        YES     2006-01-01 00:00:00     NO      
361
345
drop table t1;
362
346
SET max_heap_table_size = DEFAULT;
363
347
USE test;
365
349
SELECT SCHEMA_NAME FROM data_dictionary.schemas
366
350
WHERE SCHEMA_NAME ='data_dictionary';
367
351
SCHEMA_NAME
368
 
DATA_DICTIONARY
 
352
data_dictionary
369
353
SELECT TABLE_COLLATION FROM data_dictionary.tables
370
354
WHERE TABLE_SCHEMA='mysql' and TABLE_NAME= 'db';
371
355
TABLE_COLLATION