You're comparing systems that are not from the same car. What would you like me to say ? The CEL in the dash that clearly states you have a knock sensor failure is wrong since a manual from a 97Q45 obdII states knock sensor will not trigger MIL. Nissan manuals are never accurate 100%. For e.g. a 1992-94 cali-spec maxima has an injector leakdown circuit which detects and triggers code 53. Has any cali spec owner ever seen this , no. I personally own a cali-spec 92SE with clearly dribbling injectors that caused a hard start 2 years ago which I found by doing a fuel system pressure test over a week. Not even a stored code, not while driving with a snap-on handheld, not while doing a injector power balance test.
Knock sensor transmits voltage to the ECU that variates from the piezo electric element detecting vibration and converting it to voltage. You can cheat the knock sensor by putting a resistor that clones the normal operating ohms on the factory harness. This will let the car coast 24/7 fooling the ECCS into thinking the engine is always optimum and not to adjust fuel mixture, timing, with respect to knock sensor readings. However, this is not a long term solution..can be short term test bed. Look into the VQ history..they have known problems with knock sensors.. Look here to get an idea of a knock sensor replacement:
http://www.motorvate.ca/mvp.php/507 Just be glad you are not experiencing the known issue with airbag modules on that car... $600+ for each..and dealer won't even touch it nor will infiniti corporate, even with extended warranties.despite being a safety issue.