🐛 BUG: D1 Result inconsistency with docs, live, and wrangler dev

[demosjarco]

Which Cloudflare product(s) does this pertain to?

D1, Wrangler

What version of Wrangler are you using?

2.6.2

What operating system are you using?

Windows 11 21H1

Describe the Bug

The return object (https://developers.cloudflare.com/d1/platform/client-api/#return-object) docs say there is supposed to be a meta object with the stats in it.
Running locally (wrangler dev --local --persist with v2.6.2):

[
  {
    results: [ [Object], [Object], [Object] ],
    duration: 0.32249999791383743,
    lastRowId: null,
    changes: null,
    success: true,
    served_by: 'x-miniflare.db3'
  }
]

Running live (pushed to cf):

[
  {
    results: [ [Object], [Object], [Object], [Object] ],
    success: true,
    meta: {
      duration: 0.08682096004486084,
      last_row_id: null,
      changes: null,
      served_by: 'primary-<redacted>.db3',
      internal_stats: null
    }
  }
]

[demosjarco]

For now I made this filler inline if statement. But I assume the docs' way is the way it should be?

const internalTiming = 'meta' in batchList[0] ? batchList[0].meta.duration : batchList[0].duration

[JoshVazq]

Besides this In D1 "live" after a successful insert not getting back "changes" flag or "last_row_id" value.
@rozenmd is this expected?

success: true,
  meta: {
    duration: 32.86404299736023,
    last_row_id: null,
    changes: null,
    served_by: 'primary-<redacted>.db3',
    internal_stats: null
  }

[rozenmd]

There's some inconsistency between miniflare's local emulation of D1 and live D1 @demosjarco - you can assume the D1 docs are the expected way it should work.

[mrbbot]

Hey! 👋 This should be resolved by #2717, which will be released shortly! 🙂