MariaDB [regrtest]> desc vrfstaticroute; +------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------------------+------+-----+---------+-------+ | nid | int(11) | NO | PRI | NULL | | | vrfid | int(11) | NO | PRI | NULL | | | ifnr | int(11) | NO | PRI | NULL | | | destipaddress | binary(16) | NO | PRI | NULL | | | destipversion | tinyint(3) unsigned | NO | PRI | NULL | | | destmask | tinyint(3) unsigned | NO | PRI | NULL | | | nexthopipaddress | binary(16) | NO | PRI | NULL | | | nexthopipversion | tinyint(3) unsigned | NO | PRI | NULL | | | routedistance | smallint(6) | NO | | NULL | | | state | smallint(6) | NO | | NULL | | | action | smallint(6) | NO | | NULL | | | discoverystate | smallint(6) | NO | | NULL | | | bfd | smallint(6) | NO | | NULL | | | recursivenexthop | smallint(6) | NO | | NULL | | | destinationvrfid | int(11) | NO | | NULL | | | metric | int(11) | NO | | NULL | | | bfddepend | tinyint(3) unsigned | NO | | NULL | | | bfdlastresort | tinyint(3) unsigned | NO | | NULL | | +------------------+---------------------+------+-----+---------+-------+ 18 rows in set (0.02 sec) sql="SELECT vrfstaticroute.nid, vrfstaticroute.vrfid, vrfstaticroute.ifnr, vrfstaticroute.destipaddress, vrfstaticroute.destipversion, vrfstaticroute.destmask, vrfstaticroute.nexthopipaddress, vrfstaticroute.nexthopipversion, vrfstaticroute.routedistance, vrfstaticroute.state, vrfstaticroute.action, vrfstaticroute.discoverystate, vrfstaticroute.bfd, vrfstaticroute.recursivenexthop, vrfstaticroute.destinationvrfid, vrfstaticroute.metric, vrfstaticroute.bfddepend, vrfstaticroute.bfdlastresort FROM vrfstaticroute WHERE vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30308 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30308 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3030c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3030c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30310 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30310 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30314 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30314 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30318 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30318 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3031c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3031c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30320 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30320 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30324 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30324 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30328 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30328 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3032c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3032c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30330 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30330 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30334 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30334 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30338 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30338 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3033c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3033c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30340 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30340 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30344 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30344 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30348 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30348 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3034c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3034c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30350 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30350 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30354 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30354 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30358 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30358 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3035c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3035c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30360 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30360 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30364 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30364 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30368 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30368 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3036c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3036c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30370 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30370 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30374 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30374 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30378 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30378 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3037c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3037c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30380 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30380 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30384 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30384 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30388 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30388 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3038c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3038c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30390 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30390 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30394 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30394 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30398 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa30398 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3039c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa3039c AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303a0 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303a0 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303a4 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303a4 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303a8 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303a8 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303ac AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303ac AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303b0 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303b0 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303b4 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303b4 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303b8 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303b8 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303bc AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303bc AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303c0 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303c0 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303c4 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303c4 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303c8 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303c8 AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303cc AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 AND ( vrfstaticroute.ifnr = 0 OR vrfstaticroute.ifnr = -1 ) ) OR ( vrfstaticroute.nid = 1163 AND vrfstaticroute.vrfid = 1 AND vrfstaticroute.destipaddress = 0x0000000000000000000000000aa303cc AND vrfstaticroute.destmask = 30 AND vrfstaticroute.nexthopipaddress = 0x0000000000000000000000000a796606 ) FOR UPDATE"