Title: MySQL: Proper type for YEAR and TINYINT · Issue #3201 · sqlc-dev/sqlc · GitHub
Open Graph Title: MySQL: Proper type for YEAR and TINYINT · Issue #3201 · sqlc-dev/sqlc
X Title: MySQL: Proper type for YEAR and TINYINT · Issue #3201 · sqlc-dev/sqlc
Description: Version 1.25.0 What happened? In issue #3088, SMALLINT was (correctly) changed from int32 to int16. Surprisingly, TINYINT, which should have int8, has not been touched, resulting in the situation that TINYINT is now larger than SMALLINT....
Open Graph Description: Version 1.25.0 What happened? In issue #3088, SMALLINT was (correctly) changed from int32 to int16. Surprisingly, TINYINT, which should have int8, has not been touched, resulting in the situation t...
X Description: Version 1.25.0 What happened? In issue #3088, SMALLINT was (correctly) changed from int32 to int16. Surprisingly, TINYINT, which should have int8, has not been touched, resulting in the situation t...
Opengraph URL: https://github.com/sqlc-dev/sqlc/issues/3201
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"MySQL: Proper type for YEAR and TINYINT","articleBody":"### Version\n\n1.25.0\n\n### What happened?\n\nIn issue #3088, `SMALLINT` was (correctly) changed from `int32` to `int16`. \r\nSurprisingly, `TINYINT`, which should have `int8`, has not been touched, resulting in the situation that `TINYINT` is now larger than `SMALLINT`.\r\n\r\nAdditionally, `YEAR` is checked for signed vs unsigned, even though this flag is not possible for MySQL: it should always result in an `uint16`.\r\n\r\nFWIW: Closing this issue will also close #1856\n\n### Relevant log output\n\n_No response_\n\n### Database schema\n\n_No response_\n\n### SQL queries\n\n_No response_\n\n### Configuration\n\n_No response_\n\n### Playground URL\n\n_No response_\n\n### What operating system are you using?\n\nLinux\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/Necoro","@type":"Person","name":"Necoro"},"datePublished":"2024-02-14T22:23:35.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/3201/sqlc/issues/3201"}
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:8f2859e8-e4f0-36ae-996c-24bd7db73907 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | C534:20B327:13C01A2:1A1E86A:6A51B554 |
| html-safe-nonce | a767cea3764f34a6a8d9be7acb2546646f766ee0fb2faae8cded8dcefd0a6951 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDNTM0OjIwQjMyNzoxM0MwMUEyOjFBMUU4NkE6NkE1MUI1NTQiLCJ2aXNpdG9yX2lkIjoiMzQ1NTQ2ODY5MDg0NTMxNjQzNiIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | beeb0f5baf967fe7d1311565c2bdf83d5bbb00b19162916a84b8f81b7c6a99df |
| hovercard-subject-tag | issue:2135300914 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlc-dev/sqlc/3201/issue_layout |
| twitter:image | https://opengraph.githubassets.com/a7a38db73418c249d0f908a568bf7ddde511400aeca0a848a9cc1b70f83818e8/sqlc-dev/sqlc/issues/3201 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/a7a38db73418c249d0f908a568bf7ddde511400aeca0a848a9cc1b70f83818e8/sqlc-dev/sqlc/issues/3201 |
| og:image:alt | Version 1.25.0 What happened? In issue #3088, SMALLINT was (correctly) changed from int32 to int16. Surprisingly, TINYINT, which should have int8, has not been touched, resulting in the situation t... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | Necoro |
| hostname | github.com |
| expected-hostname | github.com |
| None | b9a586c06a05a7a86fc7e3f4dbd03e42f6869085879aa184aa6369456dbd50fb |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlc-dev/sqlc git https://github.com/sqlc-dev/sqlc.git |
| octolytics-dimension-user_id | 136738596 |
| octolytics-dimension-user_login | sqlc-dev |
| octolytics-dimension-repository_id | 193160679 |
| octolytics-dimension-repository_nwo | sqlc-dev/sqlc |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 193160679 |
| octolytics-dimension-repository_network_root_nwo | sqlc-dev/sqlc |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 7aed05249554b889eb33d002851a973eebcc7e91 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width