Nope I counteracted the false point you were most likely going to make that just because someone isnt perfect that it means they cant be accepted by the Most High. When the Most High had someone write down that a RIGHTEOUS man falls down 7 times but gets up 8.
Yes as a covenant, a covenant means a two way promise. You fulfill your part, I'll fulfill mine. If you don't fulfill yours, the whole thing is null and void.
God said He'd make a SECOND COVENANT with Israel and Judah though when He regathers them from the places He sent them. Hasnt happened yet, but whether you believe it or not, IT WILL. What the Most High said in Zec 8 wasnt conditional. It was a prophecy about the end times that we're soon approaching. Once everyone's getting hit with this or that, and yall see a group of people untouched, you'll get the idea....
As was stated before, this covenant, like many others has passed. What happened to the covenant with Adam? And the one with Noah? And the one with David? They progressively changed as humanity changed, and the new covenant is given in the blood of Jesus Christ and his teachings, sorry boss.
The Most High said this:
24 Considerest thou not what this people have spoken, saying, The two families which the Lord hath chosen, he hath even cast them off? thus they have despised my people, that they should be no more a nation before them.
25 Thus saith the Lord; If my covenant be not with day and night, and if I have not appointed the ordinances of heaven and earth;
26 Then will I cast away the seed of Jacob and David my servant, so that I will not take any of his seed to be rulers over the seed of Abraham, Isaac, and Jacob: for I will cause their captivity to return, and have mercy on them.
Even after we failed the first covenant, God said He'd have mercy on us, gather us back, and make a SECOND covenant with us. And with that second covenant, we wouldnt even be given the opportunity to fail because EACH of us (that He chooses) would have His law in our hearts.
So Im not sure why you're asking about covenants with Adam, Noah or David. They dont disappear just as the one the Most High WILL make with Israel/Judah (not everyone) will appear probably sooner than we think. And noneof those covenants changedd because of "humanity changing" because God said He doesnt change. So why would He change His agreements based on the flimsiness of man?