This query:
SELECT IS_IPV6(_ucs2 0x0031);
|
crashes with the following stack:
#3 0x00007ffff5e3b2d2 in __GI___assert_fail (assertion=0x15783c4 "cs->mbminlen == 1",
|
file=0x1578368 "/home/bar/maria-git/server.10.4/sql/item_inetfunc.cc", line=473,
|
function=0x1578b20 <Inet6::str_to_ipv6(char const*, unsigned long, charset_info_st const*)::__PRETTY_FUNCTION__> "bool Inet6::str_to_ipv6(const char*, size_t, CHARSET_INFO*)") at assert.c:101
|
#4 0x0000000000cec24c in Inet6::str_to_ipv6 (this=0x7ffff0bd2f30, str=0x7ffe6c016880 "", str_length=2,
|
cs=0x1f49500 <my_charset_ucs2_general_ci>) at /home/bar/maria-git/server.10.4/sql/item_inetfunc.cc:473
|
#5 0x0000000000cedeba in Inet6_null::Inet6_null (this=0x7ffff0bd2f30, str=0x7ffe6c016880 "", length=2,
|
cs=0x1f49500 <my_charset_ucs2_general_ci>) at /home/bar/maria-git/server.10.4/sql/item_inetfunc.cc:267
|
#6 0x0000000000cedf2b in Inet6_null::Inet6_null (this=0x7ffff0bd2f30, str=...) at /home/bar/maria-git/server.10.4/sql/item_inetfunc.cc:270
|
#7 0x0000000000ced2a3 in Item_func_is_ipv6::val_int (this=0x7ffe6c016948) at /home/bar/maria-git/server.10.4/sql/item_inetfunc.cc:911
|
#8 0x00000000009e4c47 in Type_handler::Item_send_long (this=0x1e1fda0 <type_handler_bool>, item=0x7ffe6c016948, protocol=0x7ffe6c0010c8,
|
buf=0x7ffff0bd3020) at /home/bar/maria-git/server.10.4/sql/sql_type.cc:6675
|
#9 0x00000000009f0538 in Type_handler_long::Item_send (this=0x1e1fda0 <type_handler_bool>, item=0x7ffe6c016948, protocol=0x7ffe6c0010c8,
|
buf=0x7ffff0bd3020) at /home/bar/maria-git/server.10.4/sql/sql_type.h:4829
|
#10 0x00000000006d5baa in Item::send (this=0x7ffe6c016948, protocol=0x7ffe6c0010c8, buffer=0x7ffff0bd3020)
|
at /home/bar/maria-git/server.10.4/sql/item.h:1033
|
So does this query:
SELECT IS_IPV4(_ucs2 0x0031);
|
- blocks
-
MDEV-274
The data type for IPv6/IPv4 addresses in MariaDB
-
-
Closed
{"report":{"fcp":885.2000000476837,"ttfb":207.30000019073486,"pageVisibility":"visible","entityId":74267,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"ed3ac51e-744b-4cd3-855a-bc0e58aa53de","navigationType":0,"readyForUser":975.9000000953674,"redirectCount":0,"resourceLoadedEnd":933.5,"resourceLoadedStart":213.60000014305115,"resourceTiming":[{"duration":88.79999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":213.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":213.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":302.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":88.79999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":213.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":213.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":302.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":163.20000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":214.10000014305115,"connectEnd":214.10000014305115,"connectStart":214.10000014305115,"domainLookupEnd":214.10000014305115,"domainLookupStart":214.10000014305115,"fetchStart":214.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":214.10000014305115,"responseEnd":377.30000019073486,"responseStart":377.30000019073486,"secureConnectionStart":214.10000014305115},{"duration":251.29999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":214.30000019073486,"connectEnd":214.30000019073486,"connectStart":214.30000019073486,"domainLookupEnd":214.30000019073486,"domainLookupStart":214.30000019073486,"fetchStart":214.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":214.30000019073486,"responseEnd":465.60000014305115,"responseStart":465.60000014305115,"secureConnectionStart":214.30000019073486},{"duration":255,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":214.40000009536743,"connectEnd":214.40000009536743,"connectStart":214.40000009536743,"domainLookupEnd":214.40000009536743,"domainLookupStart":214.40000009536743,"fetchStart":214.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":214.40000009536743,"responseEnd":469.40000009536743,"responseStart":469.40000009536743,"secureConnectionStart":214.40000009536743},{"duration":255.39999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":214.60000014305115,"connectEnd":214.60000014305115,"connectStart":214.60000014305115,"domainLookupEnd":214.60000014305115,"domainLookupStart":214.60000014305115,"fetchStart":214.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":214.60000014305115,"responseEnd":470,"responseStart":470,"secureConnectionStart":214.60000014305115},{"duration":255.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":214.80000019073486,"connectEnd":214.80000019073486,"connectStart":214.80000019073486,"domainLookupEnd":214.80000019073486,"domainLookupStart":214.80000019073486,"fetchStart":214.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":214.80000019073486,"responseEnd":470.30000019073486,"responseStart":470.30000019073486,"secureConnectionStart":214.80000019073486},{"duration":331.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":215,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":215,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":546.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":255.60000014305115,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":215.20000004768372,"connectEnd":215.20000004768372,"connectStart":215.20000004768372,"domainLookupEnd":215.20000004768372,"domainLookupStart":215.20000004768372,"fetchStart":215.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":215.20000004768372,"responseEnd":470.80000019073486,"responseStart":470.80000019073486,"secureConnectionStart":215.20000004768372},{"duration":331.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":215.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":215.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":547,"responseStart":0,"secureConnectionStart":0},{"duration":255.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":215.5,"connectEnd":215.5,"connectStart":215.5,"domainLookupEnd":215.5,"domainLookupStart":215.5,"fetchStart":215.5,"redirectEnd":0,"redirectStart":0,"requestStart":215.5,"responseEnd":471.40000009536743,"responseStart":471.40000009536743,"secureConnectionStart":215.5},{"duration":678,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":216.30000019073486,"connectEnd":216.30000019073486,"connectStart":216.30000019073486,"domainLookupEnd":216.30000019073486,"domainLookupStart":216.30000019073486,"fetchStart":216.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":216.30000019073486,"responseEnd":894.3000001907349,"responseStart":894.3000001907349,"secureConnectionStart":216.30000019073486},{"duration":717.0999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":216.40000009536743,"connectEnd":216.40000009536743,"connectStart":216.40000009536743,"domainLookupEnd":216.40000009536743,"domainLookupStart":216.40000009536743,"fetchStart":216.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":216.40000009536743,"responseEnd":933.5,"responseStart":933.5,"secureConnectionStart":216.40000009536743},{"duration":334.7999999523163,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":559.9000000953674,"connectEnd":559.9000000953674,"connectStart":559.9000000953674,"domainLookupEnd":559.9000000953674,"domainLookupStart":559.9000000953674,"fetchStart":559.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":559.9000000953674,"responseEnd":894.7000000476837,"responseStart":894.7000000476837,"secureConnectionStart":559.9000000953674},{"duration":244.59999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":876.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":876.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1120.9000000953674,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":62,"responseStart":207,"responseEnd":209,"domLoading":211,"domInteractive":1168,"domContentLoadedEventStart":1168,"domContentLoadedEventEnd":1213,"domComplete":2906,"loadEventStart":2906,"loadEventEnd":2908,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1135.3000001907349},{"name":"bigPipe.sidebar-id.end","time":1136.1000001430511},{"name":"bigPipe.activity-panel-pipe-id.start","time":1136.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":1139},{"name":"activityTabFullyLoaded","time":1219.6000001430511}],"measures":[],"correlationId":"47558dc2654ec2","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":85,"dbReadsTimeInMs":12,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}