Bug: prepared statement execute() returns Result object for all queries

[kenjis]

Describe the bug In the CI4 spec, query() returns bool for write-type queries. But the current implementation of execute() returns Result object for all queries.

Isn't it a bug?

See https://github.com/codeigniter4/CodeIgniter4/pull/4176#issuecomment-784805837.

CodeIgniter 4 version develop branch.

Affected module(s) Database

Expected behavior, and steps to reproduce if appropriate The same as query() return value.

[michalsn]

Yes, for write-type queries we should have a boolean result.

[sclubricants]

Does https://github.com/codeigniter4/CodeIgniter4/pull/6750 close this?

[kenjis]

Yes.

[kenjis]

Closed by #6750