Drizzled Public API Documentation

no_primary_key.inc

00001 # 
00002 # Simple test of the transaction log and the errors
00003 # which should be produced when a table is inserted
00004 # into when the transaction log is enabled but the
00005 # table does not have primary keys.
00006 # 
00007 # We create a table without a primary key and insert 
00008 # a record into it.  An error should be produced.
00009 #
00010 
00011 --disable_warnings
00012 DROP TABLE IF EXISTS t1;
00013 --enable_warnings
00014 
00015 CREATE TABLE t1 (
00016   id INT NOT NULL
00017 , padding VARCHAR(200) NOT NULL
00018 );
00019 
00020 # The below should produce an error because the CREATE TABLE
00021 # above does not have a primary key.
00022 --error ER_NO_PRIMARY_KEY_ON_REPLICATED_TABLE
00023 INSERT INTO t1 VALUES (1, "I love testing.");
00024 
00025 DROP TABLE t1;