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

1 files changed, 33 insertions, 0 deletions

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;