createQueryReader() is not returning data before saveChanges() is called

[JulijaRamoskiene]

Description

createQueryReader() is not returning inserted data before saveChanges is called.

Reproduce steps

To reproduce, execute code similar to this:

  async function logCounts(iModelDb: IModelDb) {
      const ecsql = "SELECT Count(*) as C FROM bis.Subject where CodeValue='S1'";

      const result = iModelDb.withPreparedStatement(ecsql, stmt => {
          if (DbResult.BE_SQLITE_ROW === stmt.step()) {
              return stmt.getValue(0).getInteger();
          }
          return 0;
      });
      console.log(`withPreparedStatement returned: ${result}`);

      for await (const row of iModelDb.createQueryReader(ecsql )) {
          console.log(`createQueryReader returned:  ${row.C}`);
      }
  }

  // Use your preffered way to create empty iModel e.g. SnapshotDb.createEmpty()

  Subject.insert(iModelDb, IModel.rootSubjectId, "S1");
  console.log("before saving changes");
  await logCounts(iModelDb);
  iModelDb.saveChanges();
  console.log("after saving changes");
  await logCounts(iModelDb);

Results

It prints:

before saving changes
withPreparedStatement returned: 1
createQueryReader returned: 0
after saving changes
withPreparedStatement returned: 1
createQueryReader returned: 1

Expected results

createQueryReader() should query inserted data. Same as withPreparedStatement(), which returns data even if saveChanges() was not called yet.

Package version

• iTwin.js Version 4.10.2

[grigasp]

Did you try passing usePrimaryConn flag to createQueryReader 3rd arg?

Also adding @khanaffan

[JulijaRamoskiene]

Adding that flag worked. Thanks @grigasp

[JulijaRamoskiene]

Wondering if documentation could be improved to state this more clearly? For example here: https://www.itwinjs.org/learning/ecsqlcodeexamples/

[grigasp]

Wondering if documentation could be improved to state this more clearly? For example here: https://www.itwinjs.org/learning/ecsqlcodeexamples/

@ColinKerr