dbdiff2 - patches

Posted in 1994

Jack Parker — 14 May 1994 19:03:04 -0400 — source: Informix-list mailing list archive (1991-1998)

Rather than post the whole thing again... The enclosed is a diff between the posted dbdiff2 and the corrected version. This patch resolves: A syntax error in the CREATE INDEX statement. (Thank you Robert Minter) A problem wherein dbdiff2 attempts to (incorrectly) resolve constraints. (Thank you Martin Andrews) < = posted dbdiff2 > = current version ===================================== < DEFINE sel_stmt CHAR(400), --- > DEFINE sel_stmt CHAR(450), 589c589 < IF ONLINE_SW THEN # current length of sel_stmt = 395 --- > IF ONLINE_SW THEN # current length of sel_stmt = 424 597c597,598 < 'AND "informix".systables.tabid = "informix".sysindexes.tabid' --- > 'AND "informix".systables.tabid = "informix".sysindexes.tabid ', > 'AND idxname NOT MATCHES " *"' 605c606,607 < 'AND "informix".systables.tabid = "informix".sysindexes.tabid' --- > 'AND "informix".systables.tabid = "informix".sysindexes.tabid ', > 'AND idxname NOT MATCHES " *"' 775c777 < " ON TABLE ", idxrec.tabname clipped, " (" --- > " ON ", idxrec.tabname clipped, " (" ==================================== cheers j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| Domini, Domini, Domini jparker@hpbs3645.boi.hp.com | you're all Catholic now. (208) 396-5388 (W) (208) 384-1623 (H) | - FT _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________