Hi *!
This query runs ~16 ms with 5.0.4.1776 but I had to kill afer 30+ minutes run with 1784.
SubQueryConversion and OuterJoinConversion has no effect on this.
I can send the database on request.
SELECT DISTINCT 'ALTER TABLE ' || tabla.nev || ' DROP CONSTRAINT ' || o.nev
FROM gl_obj o
INNER JOIN gl_obj tabla ON tabla.id = o.obj_id
WHERE o.tipus = 'U' AND
EXISTS(SELECT
1
FROM gl_col c
INNER JOIN gl_col c2 ON c2.id = c.mezo_id
INNER JOIN gl_obj o2 ON o2.id = c2.obj_id
INNER JOIN gl_domain d ON d.id = c2.mezo_id
INNER JOIN rdb$relation_fields rf ON rf.rdb$relation_name = o2.nev AND
rdb$field_name = c2.nev
WHERE c.obj_id = o.id AND
(NOT rf.rdb$field_source STARTING WITH 'XCHAR') AND
d.nev STARTING WITH 'XCHAR') AND
EXISTS(SELECT
1
FROM rdb$relation_constraints rc
WHERE rc.rdb$constraint_name = o.nev)
Thank You!
Hi *!
This query runs ~16 ms with 5.0.4.1776 but I had to kill afer 30+ minutes run with 1784.
SubQueryConversion and OuterJoinConversion has no effect on this.
I can send the database on request.
Thank You!