René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"MySQL: integer types for int8 and int16 are missing and use int32","articleBody":"### Version\n\n1.15.0\n\n### What happened?\n\nFor MySQL, the usage of SMALLINT and TINYINT (except TINYINT(1)) result in int32 while int16 and int8 respectively would be the correct choice.\r\nThe PostgreSQL implementation does map correctly.\n\n### Relevant log output\n\n_No response_\n\n### Database schema\n\n```sql\nCREATE TABLE authors (\r\n  id   INT UNSIGNED PRIMARY KEY,\r\n  id_author SMALLINT NOT NULL,\r\n  id_name BIGINT NOT NULL\r\n);\n```\n\n\n### SQL queries\n\n_No response_\n\n### Configuration\n\n```yaml\n{\r\n  \"version\": \"1\",\r\n  \"packages\": [\r\n    {\r\n      \"path\": \"db\",\r\n      \"engine\": \"mysql\",\r\n      \"schema\": \"query.sql\",\r\n      \"queries\": \"query.sql\"\r\n    }\r\n  ]\r\n}\n```\n\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/62380b5c7ae894a511e870a044c334871d577b9fec10a9f11fdd4c114e7ba3b1\n\n### What operating system are you using?\n\nmacOS\n\n### What database engines are you using?\n\nMySQL\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/Funzinator","@type":"Person","name":"Funzinator"},"datePublished":"2022-09-21T15:04:50.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/1856/sqlc/issues/1856"}