Subject | get overflow error when selecting from table with blob |
---|---|
Author | andycolson |
Post date | 2002-02-21T18:48:53Z |
I just changed a varchar to a blob, now this sql statement gives the
error: "Overflow occured during data type conversion. conversion
error from string "BLOB"
select customers.organization as cust, jobs.descr as jd, tasks.descr
as td,
sum(times.hours) as hours, customers.cid as cid, idate as pdate
from times
join jobs on (times.jobid=jobs.jobid)
join tasks on (times.taskid = tasks.taskid)
join customers on (times.custid = customers.custid)
where times.empid = 8
group by idate, customers.organization, customers.cid, jobs.descr,
tasks.descr, remarks
order by customers.organization, idate
Tables:
CREATE TABLE TIMES (
EMPID INTEGER NOT NULL,
IDATE DATE NOT NULL,
JOBID INTEGER NOT NULL,
TASKID INTEGER NOT NULL,
HOURS NUMERIC (9, 2),
CUSTID INTEGER NOT NULL,
REMARKS BLOB sub_type 1 segment size 80);
Remarks used to be a varchar 500, but I switched to blob. I'm
running Firebird 1 RC2 (Version is LI-T6.2.681 Firebird RC 2)
I backuped the database and restored it on an IB6.0 server and the
query seemed to work ok.
Is this a problem with my sql or perhaps a firebird bug?
error: "Overflow occured during data type conversion. conversion
error from string "BLOB"
select customers.organization as cust, jobs.descr as jd, tasks.descr
as td,
sum(times.hours) as hours, customers.cid as cid, idate as pdate
from times
join jobs on (times.jobid=jobs.jobid)
join tasks on (times.taskid = tasks.taskid)
join customers on (times.custid = customers.custid)
where times.empid = 8
group by idate, customers.organization, customers.cid, jobs.descr,
tasks.descr, remarks
order by customers.organization, idate
Tables:
CREATE TABLE TIMES (
EMPID INTEGER NOT NULL,
IDATE DATE NOT NULL,
JOBID INTEGER NOT NULL,
TASKID INTEGER NOT NULL,
HOURS NUMERIC (9, 2),
CUSTID INTEGER NOT NULL,
REMARKS BLOB sub_type 1 segment size 80);
Remarks used to be a varchar 500, but I switched to blob. I'm
running Firebird 1 RC2 (Version is LI-T6.2.681 Firebird RC 2)
I backuped the database and restored it on an IB6.0 server and the
query seemed to work ok.
Is this a problem with my sql or perhaps a firebird bug?