René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Incorrect type generated for `SMALLINT`","articleBody":"### Version\r\n\r\n1.24.0\r\n\r\n### What happened?\r\n\r\nWhen creating a table that includes a column of type `SMALLINT`, the generated model that represents the column's field as int32 instead of int16. This can lead to unexpected errors from the database.\r\n\r\n#### Got\r\n```go\r\ntype Account struct {\r\n        ID        string\r\n        Userid    string\r\n        Balance   float64\r\n        Pin       int32\r\n        Currency  AccountsCurrency\r\n        Createdat time.Time\r\n        Upatedat  time.Time\r\n}\r\n\r\n```\r\n\r\n#### Expected\r\n```go\r\ntype Account struct {\r\n        ID        string\r\n        Userid    string\r\n        Balance   float64\r\n        Pin       int16\r\n        Currency  AccountsCurrency\r\n        Createdat time.Time\r\n        Upatedat  time.Time\r\n}\r\n```\r\n\r\n### Relevant log output\r\n\r\n_No response_\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TABLE IF NOT EXISTS accounts (\r\n        id VARCHAR(80) NOT NULL,\r\n        userId VARCHAR(80) NOT NULL,\r\n        balance FLOAT DEFAULT 0.0 NOT NULL,\r\n        pin SMALLINT NOT NULL,\r\n        currency ENUM('LRD', 'USD') NOT NULL,\r\n        createdAt DATETIME NOT NULL,\r\n        upatedAt DATETIME NOT NULL,\r\n        PRIMARY KEY(id),\r\n        FOREIGN KEY(userId) REFERENCES users(id)\r\n);\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n_No response_\r\n\r\n### Configuration\r\n\r\n```yaml\r\nversion: \"2\"\r\nsql:\r\n  - engine: \"mysql\"\r\n    queries: \"sql/queries\"\r\n    schema: \"sql/schema\"\r\n    gen:\r\n      go:\r\n        out: \"model\"\r\n```\r\n\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/486276076a4aae590e56c6a81de718232c89d551c51dfbcea042246b56f430a5\r\n\r\n### What operating system are you using?\r\n\r\nLinux\r\n\r\n### What database engines are you using?\r\n\r\nMySQL\r\n\r\n### What type of code are you generating?\r\n\r\nGo","author":{"url":"https://github.com/maxwelldorliea","@type":"Person","name":"maxwelldorliea"},"datePublished":"2023-12-30T14:57:28.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/3088/sqlc/issues/3088"}