~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/create.result

  • Committer: Brian Aker
  • Date: 2011-04-03 06:02:00 UTC
  • mto: (2263.2.2 drizzle-ga)
  • mto: This revision was merged to the branch mainline in revision 2268.
  • Revision ID: brian@tangent.org-20110403060200-g8v2x1k33rrpx1an
This adds the concept of a definer to a table definition.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1474
1474
  `STATE` VARCHAR(256) DEFAULT NULL,
1475
1475
  `INFO` VARCHAR(100) DEFAULT NULL,
1476
1476
  `HAS_GLOBAL_LOCK` BOOLEAN NOT NULL
1477
 
) ENGINE=InnoDB COLLATE = utf8_general_ci REPLICATE = FALSE
 
1477
) ENGINE=InnoDB COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
1478
1478
drop table t1;
1479
1479
create temporary table t1 like data_dictionary.processlist;
1480
1480
Got one of the listed errors
1491
1491
  `STATE` VARCHAR(256) DEFAULT NULL,
1492
1492
  `INFO` VARCHAR(100) DEFAULT NULL,
1493
1493
  `HAS_GLOBAL_LOCK` BOOLEAN NOT NULL
1494
 
) ENGINE=MyISAM COLLATE = utf8_general_ci REPLICATE = FALSE
 
1494
) ENGINE=MyISAM COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
1495
1495
drop table t1;
1496
1496
 
1497
1497
# --