From 6bb380a0ce11d55d6fbe6cf7e1b3f0404d77d17a Mon Sep 17 00:00:00 2001 From: unknown Date: Thu, 1 Mar 2001 11:49:06 -0700 Subject: text/blob fields in some cases were not handled properly mysql-test/t/bdb.test: added space mysql-test/t/fulltext.test: comment out the test for the last bug until Serg pushes the change sql/field.cc: fixed coredump in INSERT into BDB table --- mysql-test/t/bdb-crash.test | 33 +++++++++++++++++++++++++++++++++ 1 file changed, 33 insertions(+) create mode 100644 mysql-test/t/bdb-crash.test (limited to 'mysql-test/t/bdb-crash.test') diff --git a/mysql-test/t/bdb-crash.test b/mysql-test/t/bdb-crash.test new file mode 100644 index 00000000000..febcfcafde4 --- /dev/null +++ b/mysql-test/t/bdb-crash.test @@ -0,0 +1,33 @@ +# test for bug reported by Mark Steele + +drop table if exists tblChange; +CREATE TABLE tblCharge ( + ChargeID int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + ServiceID int(10) unsigned DEFAULT '0' NOT NULL, + ChargeDate date DEFAULT '0000-00-00' NOT NULL, + ChargeAmount decimal(20,2) DEFAULT '0.00' NOT NULL, + FedTaxes decimal(20,2) DEFAULT '0.00' NOT NULL, + ProvTaxes decimal(20,2) DEFAULT '0.00' NOT NULL, + ChargeStatus enum('New','Auth','Unauth','Sale','Denied','Refund') +DEFAULT 'New' NOT NULL, + ChargeAuthorizationMessage text, + ChargeComment text, + ChargeTimeStamp varchar(20), + PRIMARY KEY (ChargeID), + KEY ServiceID (ServiceID), + KEY ChargeDate (ChargeDate) +) type=BDB; + +BEGIN; +INSERT INTO tblCharge +VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW())); +COMMIT; + +BEGIN; +UPDATE tblCharge SET ChargeAuthorizationMessage = 'blablabla' WHERE +ChargeID = 1; +COMMIT; + +INSERT INTO tblCharge +VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW())); +drop table tblCharge; -- cgit v1.2.1