infinite loop on a sql query
----------------------------
Key: CORE-3888
URL: http://tracker.firebirdsql.org/browse/CORE-3888
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.1
Environment: xubuntu linux 3.0.23
firebird 2.5.1 super-classic
Reporter: Daniel
whit this query
"update full_combin_random c set c.utilise=1 where
c.ID in (select a.ID from full_combin_random a inner join full_combin b on
b.utilise=1 and
a.A=b.A and
a.B=b.B and
a.C=b.C and
a.D=b.D and
a.E=b.E and
a.F=b.F);"
or
"select c.* from full_combin_random c where
c.ID in (select a.ID from full_combin_random a inner join full_combin b on
b.utilise=1 and
a.A=b.A and
a.B=b.B and
a.C=b.C and
a.D=b.D and
a.E=b.E and
a.F=b.F);"
i have a infinity loop !
the table "full_combin_randon" contains + - 8000000 million rows,
the table "full_combin" same thing.
the two tables are indexed on fields (a, b, c, d, e, f) and (utilise).
the processor goes up to 99%.
I let the query run two days without results.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
