DROP TABLE IF EXISTS TestTable;

CREATE TABLE TestTable (
  SupaBlob BLOB (0,1)
);

INSERT INTO TestTable VALUES 
('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa');


SELECT CAST(SUBSTRING(SupaBlob  FROM 1) AS CHAR(250)) FROM TestTable;

SELECT SUBSTRING(SupaBlob  FROM 1) FROM TestTable;

also gives an AV.

---

 Comments

---

Workaround: the SELECT statement should look like this:

SELECT CAST(SUBSTRING(SupaBlob FROM 1 FOR 250) AS CHAR(250)) FROM TestTable;

---

 Resolution

---

Fixed Problem on 8/28/2002 in version 3.15 build 1