I am having an issue with oracle database.
SELECT COUNT(A.A) AS count
FROM A
LEFT JOIN B ON A.B = B.B
LEFT JOIN C ON A.C = C.C
LEFT JOIN D ON A.D = D.D
LEFT JOIN E ON A.E = E.E
-- Limit is here
LEFT JOIN F ON A.F = F.F
LEFT JOIN G ON A.G = G.G
LEFT JOIN H ON A.H = H.H
LEFT JOIN I ON A.I = I.I
LEFT JOIN J ON A.J = J.J
I try to execute a query similar to query above, but it always return ORA-00600 Exception. So i try to limit the table joining, and it works well when i stopped joining at table E, but when i hit more tables, it shows the exception again.
I've never encountered something like this when using SQLServer. I used to join more than 20 tables when using SQLServer. Is this a bug in oracle?