Proof verification fails for document query using startAt without where/orderBy #3078

// demonstrate-startAt-issue.mjs
// Demonstrates the startAt bare query proof verification failure

import { EvoSDK } from '@dashevo/evo-sdk';

const DPNS_CONTRACT_ID = 'GWRSAVFMjXx8HpQFaNJMqBV7MBgMK4br5UESsB4S31Ec';
const KNOWN_DOCUMENT_ID = 'E8m6NCCnpschx4WRfk1uLMHqttqMJKPwYt8fWaVSJPrL';

async function main() {
  const sdk = EvoSDK.testnetTrusted();
  await sdk.connect();

  // -------------------------------------------------------
  // 1. FAILING QUERY — startAt with only limit (no where/orderBy)
  // -------------------------------------------------------
  console.log('--- Test 1: bare startAt query (expected to FAIL) ---');
  try {
    const result = await sdk.documents.query({
      dataContractId: DPNS_CONTRACT_ID,
      documentTypeName: 'domain',
      limit: 1,
      startAt: KNOWN_DOCUMENT_ID,
    });
    console.log('Unexpected success. Documents returned:', result.length);
  } catch (err) {
    console.error('FAILED as expected:', err.message);
    // Expected: "grovedb: invalid proof: Invalid proof verification
    //            parameters: invalid proof error Proof returns more
    //            data than limit Some(1)"
  }

  // -------------------------------------------------------
  // 2. PASSING QUERY — same startAt combined with where/orderBy
  // -------------------------------------------------------
  console.log('\n--- Test 2: startAt with where + orderBy (expected to PASS) ---');
  try {
    const result = await sdk.documents.query({
      dataContractId: DPNS_CONTRACT_ID,
      documentTypeName: 'domain',
      limit: 1,
      startAt: KNOWN_DOCUMENT_ID,
      where: [
        ['normalizedParentDomainName', '==', 'dash'],
        ['normalizedLabel', 'startsWith', 'tut0r1a1-test-'],
      ],
      orderBy: [['normalizedLabel', 'asc']],
    });
    console.log('SUCCESS. Documents returned:', result.size);
    if (result.size > 0) {
      const [id] = [...result.entries()][0];
      console.log('First document ID:', id.toString());
    }
  } catch (err) {
    console.error('Unexpected failure:', err.message);
  }
}

main().then(() => process.exit(0));