When assigning a value with more decimals than a DECIMAL column was created for a
1265 | Data truncated for column 'val' at row 1
warning is raised.There has been a request whether an error could be raised instead.
We looked into solving this using triggers or a check constraint, but apparently rounding already happens before trigger or check condition code is executed, so this approach does not seem to work.
Hence this feature request for some sort of "NO_DECIMAL_TRUNCATION" sql_mode
The current behavior is what the standard requires us to do:
If an assignment of some number would result in a loss of its most significant digit, an exception condition is raised. If least significant digits are lost, implementation-defined rounding or truncating occurs, with no exception condition being raised.
Sergei Golubchik
added a comment - The current behavior is what the standard requires us to do:
If an assignment of some number would result in a loss of its most significant digit, an exception condition is raised. If least significant digits are lost, implementation-defined rounding or truncating occurs, with no exception condition being raised.
strict is basically "as strict as the standard", so it should be an error when truncating strings or truncating most significant digits from decimal. And no error when truncating least significant digits.
Sergei Golubchik
added a comment - strict is basically "as strict as the standard", so it should be an error when truncating strings or truncating most significant digits from decimal. And no error when truncating least significant digits.
People
Ralf Gebhardt
Hartmut Holzgraefe
Votes:
0Vote for this issue
Watchers:
7Start watching this issue
Dates
Created:
Updated:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":699,"ttfb":126.59999990463257,"pageVisibility":"visible","entityId":117910,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"739b0392-6eef-4efc-90f0-a3dc7b08cc75","navigationType":0,"readyForUser":756,"redirectCount":0,"resourceLoadedEnd":608.8999998569489,"resourceLoadedStart":131.29999995231628,"resourceTiming":[{"duration":94,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":131.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":131.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":225.29999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":93.70000004768372,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":131.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":131.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":225.29999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":109,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":131.69999980926514,"connectEnd":131.69999980926514,"connectStart":131.69999980926514,"domainLookupEnd":131.69999980926514,"domainLookupStart":131.69999980926514,"fetchStart":131.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":131.69999980926514,"responseEnd":240.69999980926514,"responseStart":240.69999980926514,"secureConnectionStart":131.69999980926514},{"duration":208.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":131.89999985694885,"connectEnd":131.89999985694885,"connectStart":131.89999985694885,"domainLookupEnd":131.89999985694885,"domainLookupStart":131.89999985694885,"fetchStart":131.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":131.89999985694885,"responseEnd":340.09999990463257,"responseStart":340.09999990463257,"secureConnectionStart":131.89999985694885},{"duration":212,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":132,"connectEnd":132,"connectStart":132,"domainLookupEnd":132,"domainLookupStart":132,"fetchStart":132,"redirectEnd":0,"redirectStart":0,"requestStart":132,"responseEnd":344,"responseStart":344,"secureConnectionStart":132},{"duration":212.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":132.09999990463257,"connectEnd":132.09999990463257,"connectStart":132.09999990463257,"domainLookupEnd":132.09999990463257,"domainLookupStart":132.09999990463257,"fetchStart":132.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":132.09999990463257,"responseEnd":344.2999999523163,"responseStart":344.2999999523163,"secureConnectionStart":132.09999990463257},{"duration":212.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":132.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":132.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":345.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":212.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":132.19999980926514,"connectEnd":132.19999980926514,"connectStart":132.19999980926514,"domainLookupEnd":132.19999980926514,"domainLookupStart":132.19999980926514,"fetchStart":132.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":132.19999980926514,"responseEnd":344.59999990463257,"responseStart":344.59999990463257,"secureConnectionStart":132.19999980926514},{"duration":213.10000014305115,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":132.39999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":132.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":345.5,"responseStart":0,"secureConnectionStart":0},{"duration":212.70000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":132.39999985694885,"connectEnd":132.39999985694885,"connectStart":132.39999985694885,"domainLookupEnd":132.39999985694885,"domainLookupStart":132.39999985694885,"fetchStart":132.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":132.39999985694885,"responseEnd":345.09999990463257,"responseStart":345.09999990463257,"secureConnectionStart":132.39999985694885},{"duration":213.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":132.59999990463257,"connectEnd":132.59999990463257,"connectStart":132.59999990463257,"domainLookupEnd":132.59999990463257,"domainLookupStart":132.59999990463257,"fetchStart":132.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":132.59999990463257,"responseEnd":345.69999980926514,"responseStart":345.69999980926514,"secureConnectionStart":132.59999990463257},{"duration":394.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":149.19999980926514,"connectEnd":149.19999980926514,"connectStart":149.19999980926514,"domainLookupEnd":149.19999980926514,"domainLookupStart":149.19999980926514,"fetchStart":149.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":149.19999980926514,"responseEnd":543.5999999046326,"responseStart":543.5999999046326,"secureConnectionStart":149.19999980926514},{"duration":443.10000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":162.69999980926514,"connectEnd":162.69999980926514,"connectStart":162.69999980926514,"domainLookupEnd":162.69999980926514,"domainLookupStart":162.69999980926514,"fetchStart":162.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":162.69999980926514,"responseEnd":605.7999999523163,"responseStart":605.7999999523163,"secureConnectionStart":162.69999980926514},{"duration":153.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":390.2999999523163,"connectEnd":390.2999999523163,"connectStart":390.2999999523163,"domainLookupEnd":390.2999999523163,"domainLookupStart":390.2999999523163,"fetchStart":390.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":390.2999999523163,"responseEnd":543.8999998569489,"responseStart":543.8999998569489,"secureConnectionStart":390.2999999523163},{"duration":3.0999999046325684,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":605.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":605.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":608.8999998569489,"responseStart":0,"secureConnectionStart":0},{"duration":241.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":606.5,"connectEnd":606.5,"connectStart":606.5,"domainLookupEnd":606.5,"domainLookupStart":606.5,"fetchStart":606.5,"redirectEnd":0,"redirectStart":0,"requestStart":606.5,"responseEnd":848.1999998092651,"responseStart":848.1999998092651,"secureConnectionStart":606.5},{"duration":249,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":606.7999999523163,"connectEnd":606.7999999523163,"connectStart":606.7999999523163,"domainLookupEnd":606.7999999523163,"domainLookupStart":606.7999999523163,"fetchStart":606.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":606.7999999523163,"responseEnd":855.7999999523163,"responseStart":855.7999999523163,"secureConnectionStart":606.7999999523163}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":11,"responseStart":127,"responseEnd":163,"domLoading":130,"domInteractive":807,"domContentLoadedEventStart":807,"domContentLoadedEventEnd":852,"domComplete":1075,"loadEventStart":1075,"loadEventEnd":1076,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":786.7999999523163},{"name":"bigPipe.sidebar-id.end","time":787.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":787.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":789.1999998092651},{"name":"activityTabFullyLoaded","time":869.3999998569489}],"measures":[],"correlationId":"3e5f0bbc8cad3f","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":69,"dbReadsTimeInMs":7,"dbConnsTimeInMs":13,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
I am interested on this feature request, any advice on which files I should look into?