Cannot insert numbers into postgresql `incorrect binary data format`

[CMCDragonkai]

Describe the bug

See title.

I'm using:

    "dob_year": {
      "type": "number",
      "optional": true,
      "subtype": "u32",
      "range": {
        "high": 2022,
        "low": 1900,
        "step": 1
      }
    },
    "dob_month": {
      "type": "number",
      "optional": true,
      "subtype": "u32",
      "range": {
        "high": 12,
        "low": 1,
        "step": 1
      }
    },

To Reproduce Steps to reproduce the behavior:

1. Schema (if applicable)

   CREATE TABLE "customers" (
   "id" uuid DEFAULT gen_random_uuid(),
   "name" text NOT NULL,
   "email" text NOT NULL UNIQUE,
   "phone_number" text,
   "address_line_1" text,
   "address_line_2" text,
   "address_post_code" text,
   "address_state" text,
   "address_country" text,
   "dob_year" smallint CHECK (dob_year > 1900 AND dob_year <= 9999),
   "dob_month" smallint CHECK (dob_month > 0 AND dob_month <= 12),
   "notes" text NOT NULL DEFAULT '',
   "has_sms_allowed" boolean NOT NULL DEFAULT false,
   "has_email_allowed" boolean NOT NULL DEFAULT false,
   "created_on" TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
   "updated_on" TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (id)
   );

2. See error

   
   [2022-12-15T08:57:39Z WARN  synth::datasource::relational_datasource] Trying to put an unsigned u32 into a int2 typed column customers.dob_month
   Error: At namespace "fixtures"

Caused by: 0: Failed to insert data for collection customers 1: One or more database inserts failed: error returned from database: incorrect binary data format in bind parameter 7: incorrect binary data format in bind parameter 7

**Expected behavior**

It should just insert the numbers.

**Screenshots**
If applicable, add screenshots to help explain your problem.

**Environment (please complete the following information):**
 - OS: [e.g. Linux, MacOS, Windows]
 - Version: 0.6.5

**Additional context**
Add any other context about the problem here.

---

Would be nice to see what the SQL is being generated to understand the problem.

[iamwacko]

int2 hasn't been implemented yet. This was first reported with #271.

[CMCDragonkai]

Why can't it just insert the number? The SQL expression looks the same whether it is a smallint or something else.

[iamwacko]

If you read the error closely you see error returned from database. The SQL expression's might look the same, but they aren't to the server.

[iamwacko]

int2 is now implemented in the codebase, but until the next release you will have to compile from source to get it to work.