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;