title: flutter sqflite transaction does not insert record after successfull commit
body: <p>Using sqflite database at Flutter project and I need some help.</p>
  <p>Below you can see my transaction code</p>
  <pre><code>  await db!.transaction((txn) async {
      var batch = txn.batch();
      for (DespatchTransaction despatch in transactions) {
        if (isSynced) {
          despatch.isSynced = 1;
          despatch.syncDate = DateTime.now();
        }
        final List&lt;Map&lt;String, dynamic&gt;&gt; exist = await txn.query(tableName, where: &quot;id =?&quot;, whereArgs: [despatch.id]);
        if (exist.length == 0)
          _insert(despatch, txn, batch);
        else
          _update(despatch, txn, batch);
      }
      await batch.commit(continueOnError: false).then((value) {
        if (value.length &gt; 0) dbSaveResult = value.length;
      });
    });
  </code></pre>
  <p>And insert code block as below</p>
  <pre><code>  batch.insert(tableName, item.toMap(),conflictAlgorithm: ConflictAlgorithm.replace);
  </code></pre>
  <p>I have turned on the debug mode at sqflite database and can see the transaction insert statement and commit command</p>
  <pre><code>D/Sqflite (14181): [2,Sqflite(850)] INSERT OR REPLACE INTO DespatchTransactions (id, isActive, createdUser, createdDate, updatedDate, updatedUser, isSynced, syncDate, sourceId, sourceName, applicationType, statusId, companyId, branchId, warehouseId, employeeId, accountId, currencyType, tradeType, documentType, subDocumentType, directionType, documentDate, transactionDate, projectId, costCenterId, despatchAddressId, invoiceAddressId, isReturned, serial, number, documentId, description, lineCount, lineExtensionAmount, taxInclusiveAmount, taxExclusiveAmount, allowanceTotalAmount, chargeTotalAmount, payableRoundingAmount, payableAmount, vatTotal, taxTotal, deductionTotal, cargoTransactionId, detailId, eDocumentId, integrationId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NULL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NULL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NULL, NULL, NULL, NULL) [da4d5b2a-3730-455f-9388-f1cdcc59c3c7, 1, c0e7b68a-90af-488d-97ce-08d83de6f8df, 2021-08-11T21:45:18.373228, 2021-08-11T21:45:18.373238, c0e7b68a-90af-488d-97ce-08d83de6f8df, 1, 2021-08-11T21:45:18.371369, 9995af04-c946-42c3-a6a7-fd6c9374ec21, Eqlem Mobil Uygulama, 9998, 5155eb76-8ff0-4068-59c5-08d83de65f2d, bd1b9d20-4ce2-4b23-0352-08d83de81a96, a4d26dcb-ab72-4c8b-9170-baefe4a0ea70, 645193c6-002e-4fe2-5ac5-08d83de82cd8, 88293574-97c7-452b-b629-0683c2bd8268, 1, 0, 102, 101, 1, 2021-08-11T12:17:51.204862, 2021-08-11T12:17:51.204869, acaf97d2-00d0-49b2-ff24-08d87f29ef6c, 6325c200-a695-4e45-6c75-08d87f294e0b, 6b8e77a0-6aa1-44bf-8b5b-0eca7b2b5bac, c62f3f2f-d1da-4cea-8de9-82e1e3359e46, 0, MBL, 0, E61C6CD99D7, 1, 900.0, 1062.0, 900.0, 0.0, 0.0, 0.0, 1062.0, 162.0, 0.0, 0.0]
  D/Sqflite (14181): [2,Sqflite(850)] inserted 23
  
  D/Sqflite (14181): [2,Sqflite(850)] COMMIT
  </code></pre>
  <p>When I check the record on the table no record was inserted, and Flutter does not throw any exception at all.</p>
  <p>I need some advice/help please?</p>