From: Milan B. <mil...@gm...> - 2011-01-25 17:26:51
|
Hi, Tracker is unreachable right now, so I'm writing here to see if someone knows about such bug already. I have a query like this: SELECT coalesce(table3.c1||' ','') || table1.c1 FROM table1 JOIN view1 on view1.c1 = 'SYSDBA' LEFT JOIN table3 on table1.c2 = table3.c2 order by 1 which fails with: ------------------------------------- Message: isc_dsql_fetch failed. SQL Message : -508 The cursor identified in the UPDATE or DELETE statement is not positioned on a row. Engine Code : 335544348 Engine Message : no current record for fetch operation ------------------------------------- It does not fail and does return some records, if I do any of the following: - remove LEFT JOIN - convert LEFT JOIN to JOIN - change coalesce to become COALESCE(table3.c1, '') - remove ORDER BY clause - change from view1 to table4 or table5. View1 looks like this: create view view1 (c1, c2) as select c1, c2 from table4 union all select c1, c2 from table5; All this using 32bit Classic LI-V2.5.0.26074 Firebird 2.5. -- Milan Babuskov http://www.flamerobin.org |