Type:
Bug
Priority:
Major
Resolution:
Unresolved
Affects Version/s:
10.5 , 10.6 , 10.11 , 11.4 , 11.7(EOL) , 11.8
CREATE TABLE t (c BIT );
INSERT INTO t VALUES (1e+19); # Issue does not reproduce with <19
Leads to:
CS 10.5.28 a226f12675c6312ca7632b90261397e313e6a7ae (Optimized, UBASAN, Clang)
/test/10.5_opt_san/sql/field.cc:9926:38: runtime error: 1e+19 is outside the range of representable values of type 'long long'
SUMMARY: UndefinedBehaviorSanitizer: float-cast-overflow /test/10.5_opt_san/sql/field.cc:9926:38
#0 0x55cc6bc42b72 in Field_bit::store(double) /test/10.5_opt_san/sql/field.cc:9926:38
#1 0x55cc6bc42b72 in Field_bit_as_char::store(double) /test/10.5_opt_san/sql/field.h:5107:53
#2 0x55cc6aae4de8 in fill_record(THD*, TABLE*, Field**, List<Item>&, bool, bool, bool) /test/10.5_opt_san/sql/sql_base.cc:8836:18
#3 0x55cc6aae63b0 in fill_record_n_invoke_before_triggers(THD*, TABLE*, Field**, List<Item>&, bool, trg_event_type) /test/10.5_opt_san/sql/sql_base.cc:8891:11
#4 0x55cc6ac01bcd in mysql_insert(THD*, TABLE_LIST*, List<Item>&, List<List<Item>>&, List<Item>&, List<Item>&, enum_duplicates, bool, select_result*) /test/10.5_opt_san/sql/sql_insert.cc:1072:13
#5 0x55cc6adbf51b in mysql_execute_command(THD*) /test/10.5_opt_san/sql/sql_parse.cc:4664:10
#6 0x55cc6ad80e98 in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /test/10.5_opt_san/sql/sql_parse.cc:8251:18
#7 0x55cc6ad739d0 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /test/10.5_opt_san/sql/sql_parse.cc:1891:7
#8 0x55cc6ad838d9 in do_command(THD*) /test/10.5_opt_san/sql/sql_parse.cc:1375:17
#9 0x55cc6b48b5c2 in do_handle_one_connection(CONNECT*, bool) /test/10.5_opt_san/sql/sql_connect.cc:1386:11
#10 0x55cc6b48aa24 in handle_one_connection /test/10.5_opt_san/sql/sql_connect.cc:1298:5
#11 0x55cc6a7eb10c in asan_thread_start(void*) asan_interceptors.cpp.o
#12 0x14b32469ca93 in start_thread nptl/pthread_create.c:447:8
#13 0x14b324729c3b in clone3 misc/../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
SUMMARY: UndefinedBehaviorSanitizer: float-cast-overflow /test/10.5_opt_san/sql/field.cc:9926:38
Setup:
Compiled with a recent version of Clang (I used Clang 18.1.3) with LLVM 18:
# Note: llvm-17-linker-tools installs /usr/lib/llvm-17/lib/LLVMgold.so, which is needed for compilation, and LLVMgold.so is no longer included in LLVM 18
sudo apt install clang llvm-18 llvm-18-linker-tools llvm-18-runtime llvm-18-tools llvm-18-dev libstdc++-14-dev llvm-dev llvm-17-linker-tools
sudo ln -s /usr/lib/llvm-17/lib/LLVMgold.so /usr/lib/llvm-18/lib/LLVMgold.so
Compiled with: '-DCMAKE_C_COMPILER=/usr/bin/clang -DCMAKE_CXX_COMPILER=/usr/bin/clang++' and:
-DWITH_ASAN=ON -DWITH_ASAN_SCOPE=ON -DWITH_UBSAN=ON -DWSREP_LIB_WITH_ASAN=ON
Set before execution:
export UBSAN_OPTIONS=print_stacktrace=1:report_error_type=1 # And you may also want to supress UBSAN startup issues using 'suppressions=UBSAN.filter'. For an example of UBSAN.filter, which includes current startup issues see: https://github.com/mariadb-corporation/mariadb-qa/blob/master/UBSAN.filter
Bug confirmed present in:
MariaDB: 10.5.28 (dbg), 10.5.28 (opt), 10.6.21 (dbg), 10.6.21 (opt), 10.11.11 (dbg), 10.11.11 (opt), 11.4.5 (dbg), 11.4.5 (opt), 11.7.1 (dbg), 11.7.1 (opt), 11.8.0 (dbg), 11.8.0 (opt)
relates to
MDEV-36013
UBSAN: runtime error: X is outside the range of representable values of type 'long long' on INSERT to SET()
Confirmed
{"report":{"fcp":777.2999999523163,"ttfb":158.90000009536743,"pageVisibility":"visible","entityId":132170,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"e2514cef-837a-4cec-ab7d-ac86db8be1d7","navigationType":0,"readyForUser":857.2999999523163,"redirectCount":0,"resourceLoadedEnd":883,"resourceLoadedStart":168.09999990463257,"resourceTiming":[{"duration":140.80000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":168.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":168.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":308.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":140.5,"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":168.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":168.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":309,"responseStart":0,"secureConnectionStart":0},{"duration":151.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":168.5,"connectEnd":168.5,"connectStart":168.5,"domainLookupEnd":168.5,"domainLookupStart":168.5,"fetchStart":168.5,"redirectEnd":0,"redirectStart":0,"requestStart":168.5,"responseEnd":320,"responseStart":320,"secureConnectionStart":168.5},{"duration":241.60000014305115,"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":169.09999990463257,"connectEnd":169.09999990463257,"connectStart":169.09999990463257,"domainLookupEnd":169.09999990463257,"domainLookupStart":169.09999990463257,"fetchStart":169.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":169.09999990463257,"responseEnd":410.7000000476837,"responseStart":410.7000000476837,"secureConnectionStart":169.09999990463257},{"duration":237.60000014305115,"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":169.09999990463257,"connectEnd":169.09999990463257,"connectStart":169.09999990463257,"domainLookupEnd":169.09999990463257,"domainLookupStart":169.09999990463257,"fetchStart":169.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":169.09999990463257,"responseEnd":406.7000000476837,"responseStart":406.7000000476837,"secureConnectionStart":169.09999990463257},{"duration":242.60000014305115,"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":169.29999995231628,"connectEnd":169.29999995231628,"connectStart":169.29999995231628,"domainLookupEnd":169.29999995231628,"domainLookupStart":169.29999995231628,"fetchStart":169.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":169.29999995231628,"responseEnd":411.90000009536743,"responseStart":411.90000009536743,"secureConnectionStart":169.29999995231628},{"duration":243.39999985694885,"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":169.40000009536743,"connectEnd":169.40000009536743,"connectStart":169.40000009536743,"domainLookupEnd":169.40000009536743,"domainLookupStart":169.40000009536743,"fetchStart":169.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":169.40000009536743,"responseEnd":412.7999999523163,"responseStart":412.7999999523163,"secureConnectionStart":169.40000009536743},{"duration":244.40000009536743,"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":169.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":169.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":413.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":244.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":169.59999990463257,"connectEnd":169.59999990463257,"connectStart":169.59999990463257,"domainLookupEnd":169.59999990463257,"domainLookupStart":169.59999990463257,"fetchStart":169.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":169.59999990463257,"responseEnd":413.90000009536743,"responseStart":413.90000009536743,"secureConnectionStart":169.59999990463257},{"duration":245.20000004768372,"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":169.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":169.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":414.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":245.20000004768372,"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":169.79999995231628,"connectEnd":169.79999995231628,"connectStart":169.79999995231628,"domainLookupEnd":169.79999995231628,"domainLookupStart":169.79999995231628,"fetchStart":169.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":169.79999995231628,"responseEnd":415,"responseStart":415,"secureConnectionStart":169.79999995231628},{"duration":350.90000009536743,"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":174.59999990463257,"connectEnd":174.59999990463257,"connectStart":174.59999990463257,"domainLookupEnd":174.59999990463257,"domainLookupStart":174.59999990463257,"fetchStart":174.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":174.59999990463257,"responseEnd":525.5,"responseStart":525.5,"secureConnectionStart":174.59999990463257},{"duration":706.7999999523163,"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":176.20000004768372,"connectEnd":176.20000004768372,"connectStart":176.20000004768372,"domainLookupEnd":176.20000004768372,"domainLookupStart":176.20000004768372,"fetchStart":176.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":176.20000004768372,"responseEnd":883,"responseStart":883,"secureConnectionStart":176.20000004768372},{"duration":49.200000047683716,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":477.59999990463257,"connectEnd":477.59999990463257,"connectStart":477.59999990463257,"domainLookupEnd":477.59999990463257,"domainLookupStart":477.59999990463257,"fetchStart":477.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":477.59999990463257,"responseEnd":526.7999999523163,"responseStart":526.7999999523163,"secureConnectionStart":477.59999990463257},{"duration":237.20000004768372,"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":696.2999999523163,"connectEnd":696.2999999523163,"connectStart":696.2999999523163,"domainLookupEnd":696.2999999523163,"domainLookupStart":696.2999999523163,"fetchStart":696.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":696.2999999523163,"responseEnd":933.5,"responseStart":933.5,"secureConnectionStart":696.2999999523163}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":18,"responseStart":158,"responseEnd":175,"domLoading":162,"domInteractive":911,"domContentLoadedEventStart":911,"domContentLoadedEventEnd":959,"domComplete":1702,"loadEventStart":1702,"loadEventEnd":1704,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":891.9000000953674},{"name":"bigPipe.sidebar-id.end","time":892.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":892.7000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":895.5999999046326},{"name":"activityTabFullyLoaded","time":966.9000000953674}],"measures":[],"correlationId":"24634b399d9067","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":73,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}