Issue with Auto-Generated SQL for Tables Containing BIT Columns

[Harry Zhang]

HI,

I would like to report an issue related to how SQL statements are auto-generated when working with tables that contain multiple BIT(1) columns.

Steps to Reproduce:

Create a table that includes more than one BIT(1) column, followed by columns of other data types.

1. Execute a query:
SELECT * FROM the_table_with_bit;

2. Edit the result by inserting new rows or updating existing ones.

3. Click on the Apply button to generate the corresponding SQL statements.

Observed Behavior:

The auto-generated SQL may omit the leading b for BIT values.

In some cases, the generated SQL applies the leading b prefix to all values, including those not of BIT type.

This behavior leads to incorrect queries or unexpected results.

Please let me know if any additional details are needed.

Regards,
Wang