MySQL & .NET - Insert Identity & Boolean Values Incorrect

#1

Wappler Version : 1.9.9
Operating System : Windows 10

Expected behavior

Identity returned after insert should be something like 123, 13 etc.
Setting boolean type value in insert/updpate query action should treat value as numeric - 0, 1

Actual behavior

Identity returned after insert is 123.0, 13.0 etc.
Setting boolean type value in insert/updpate query action is treated as - '0', '1'

How to reproduce

Open a .NET/IIS project. Create a new insert query for a database in MySQL. Connect with Driver 8.0. Insert boolean value in a table and retrieve its last inserted ID using identity option in server action.

assigned patrick #2