-
Bug
-
-
Major
-
Resolution:
Fixed
-
None
-
-
-
SELECT ST_LatFromGeoHash("ї");
|
SELECT ST_LongFromGeoHash("ї");
|
bb-11.7-mdev-34120-gis-functions branch
Version: '11.7.0-MariaDB-debug' socket: '/11.8/dt/my.sock' port: 3314 Source distribution
|
=================================================================
|
==353691==ERROR: AddressSanitizer: global-buffer-overflow on address 0x5563ae842117 at pc 0x5563ac9a69eb bp 0x7fa74860b010 sp 0x7fa74860b000
|
READ of size 1 at 0x5563ae842117 thread T12 (one_connection)
|
#0 0x5563ac9a69ea in Item_func_latlongfromgeohash::decode_geohash(String*, double*, double*) /11.8/src/sql/item_geofunc.cc:3048
|
#1 0x5563ac9a7273 in Item_func_latlongfromgeohash::val_real() /11.8/src/sql/item_geofunc.cc:3182
|
#2 0x5563ac5593bd in Type_handler::Item_send_double(Item*, Protocol*, st_value*) const /11.8/src/sql/sql_type.cc:7731
|
#3 0x5563ac577afb in Type_handler_double::Item_send(Item*, Protocol*, st_value*) const /11.8/src/sql/sql_type.h:6348
|
#4 0x5563aba1e8b9 in Item::send(Protocol*, st_value*) /11.8/src/sql/item.h:1255
|
#5 0x5563abaf6bc3 in Protocol::send_result_set_row(List<Item>*) /11.8/src/sql/protocol.cc:1359
|
#6 0x5563abcb0309 in select_send::send_data(List<Item>&) /11.8/src/sql/sql_class.cc:3279
|
#7 0x5563ac001a9c in select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long) /11.8/src/sql/sql_class.h:6179
|
#8 0x5563abf250a6 in JOIN::exec_inner() /11.8/src/sql/sql_select.cc:4900
|
#9 0x5563abf23ba5 in JOIN::exec() /11.8/src/sql/sql_select.cc:4812
|
#10 0x5563abf28463 in mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /11.8/src/sql/sql_select.cc:5345
|
#11 0x5563abef5e99 in handle_select(THD*, LEX*, select_result*, unsigned long long) /11.8/src/sql/sql_select.cc:628
|
#12 0x5563abe11e00 in execute_sqlcom_select /11.8/src/sql/sql_parse.cc:6154
|
#13 0x5563abe019aa in mysql_execute_command(THD*, bool) /11.8/src/sql/sql_parse.cc:3954
|
#14 0x5563abe1ce5f in mysql_parse(THD*, char*, unsigned int, Parser_state*) /11.8/src/sql/sql_parse.cc:7876
|
#15 0x5563abdf3474 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /11.8/src/sql/sql_parse.cc:1892
|
#16 0x5563abdf0117 in do_command(THD*, bool) /11.8/src/sql/sql_parse.cc:1405
|
#17 0x5563ac2f7c09 in do_handle_one_connection(CONNECT*, bool) /11.8/src/sql/sql_connect.cc:1448
|
#18 0x5563ac2f7594 in handle_one_connection /11.8/src/sql/sql_connect.cc:1350
|
#19 0x5563ad006195 in pfs_spawn_thread /11.8/src/storage/perfschema/pfs.cc:2198
|
#20 0x7fa776153608 in start_thread /build/glibc-FcRMwW/glibc-2.31/nptl/pthread_create.c:477
|
#21 0x7fa775c8e352 in __clone (/lib/x86_64-linux-gnu/libc.so.6+0x11f352) (BuildId: 0323ab4806bee6f846d9ad4bccfc29afdca49a58)
|
|
0x5563ae842117 is located 17 bytes after global variable '*.LC319' defined in '/11.8/src/sql/item_geofunc.cc' (0x5563ae8420c0) of size 70
|
'*.LC319' is ascii string 'void Item_func_geohash::encode_geohash(String*, double, double, uint)'
|
SUMMARY: AddressSanitizer: global-buffer-overflow /11.8/src/sql/item_geofunc.cc:3048 in Item_func_latlongfromgeohash::decode_geohash(String*, double*, double*)
|
Shadow bytes around the buggy address:
|
0x5563ae841e80: 00 00 00 00 00 00 00 00 00 00 00 02 f9 f9 f9 f9
|
0x5563ae841f00: 00 03 f9 f9 f9 f9 f9 f9 00 00 00 01 f9 f9 f9 f9
|
0x5563ae841f80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
0x5563ae842000: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
0x5563ae842080: 00 00 01 f9 f9 f9 f9 f9 00 00 00 00 00 00 00 00
|
=>0x5563ae842100: 06 f9[f9]f9 f9 f9 f9 f9 00 00 00 00 00 00 00 00
|
0x5563ae842180: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
0x5563ae842200: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
0x5563ae842280: f9 f9 f9 f9 00 00 00 00 00 00 00 00 00 00 02 f9
|
0x5563ae842300: f9 f9 f9 f9 00 00 02 f9 f9 f9 f9 f9 00 f9 f9 f9
|
0x5563ae842380: f9 f9 f9 f9 00 00 00 00 00 00 00 00 00 00 00 00
|
Shadow byte legend (one shadow byte represents 8 application bytes):
|
Addressable: 00
|
Partially addressable: 01 02 03 04 05 06 07
|
Heap left redzone: fa
|
Freed heap region: fd
|
Stack left redzone: f1
|
Stack mid redzone: f2
|
Stack right redzone: f3
|
Stack after return: f5
|
Stack use after scope: f8
|
Global redzone: f9
|
Global init order: f6
|
Poisoned by user: f7
|
Container overflow: fc
|
Array cookie: ac
|
Intra object redzone: bb
|
ASan internal: fe
|
Left alloca redzone: ca
|
Right alloca redzone: cb
|
Thread T12 (one_connection) created by T0 here:
|
#0 0x7fa77661d175 in __interceptor_pthread_create ../../../../src/libsanitizer/asan/asan_interceptors.cpp:208
|
#1 0x5563ad001db9 in my_thread_create /11.8/src/storage/perfschema/my_thread.h:38
|
#2 0x5563ad006588 in pfs_spawn_thread_v1 /11.8/src/storage/perfschema/pfs.cc:2249
|
#3 0x5563ab9f123e in inline_mysql_thread_create /11.8/src/include/mysql/psi/mysql_thread.h:1139
|
#4 0x5563aba0abb7 in create_thread_to_handle_connection(CONNECT*) /11.8/src/sql/mysqld.cc:6270
|
#5 0x5563aba0b222 in create_new_thread(CONNECT*) /11.8/src/sql/mysqld.cc:6332
|
#6 0x5563aba0b54f in handle_accepted_socket(st_mysql_socket, st_mysql_socket) /11.8/src/sql/mysqld.cc:6394
|
#7 0x5563aba0c24c in handle_connections_sockets() /11.8/src/sql/mysqld.cc:6507
|
#8 0x5563aba0a3af in mysqld_main(int, char**) /11.8/src/sql/mysqld.cc:6165
|
#9 0x5563ab9f033c in main /11.8/src/sql/main.cc:34
|
#10 0x7fa775b93082 in __libc_start_main ../csu/libc-start.c:308
|
|
==353691==ABORTING
|
Alice Sherepa
made changes -
Assignee
|
|
Dave Gosselin
[ JIRAUSER52216
]
|
Alice Sherepa
made changes -
Component/s
|
|
GIS
[ 10105
]
|
Dave Gosselin
made changes -
Status
|
Open
[ 1
]
|
In Progress
[ 3
]
|
Dave Gosselin
made changes -
Assignee
|
Dave Gosselin
[ JIRAUSER52216
]
|
Daniel Black
[ danblack
]
|
Status
|
In Progress
[ 3
]
|
In Review
[ 10002
]
|
Dave Gosselin
made changes -
Fix Version/s
|
|
12.0.0
[ 30115
]
|
Fix Version/s
|
12.0
[ 29945
]
|
|
Resolution
|
|
Fixed
[ 1
]
|
Status
|
In Review
[ 10002
]
|
Closed
[ 6
]
|
Daniel Black
made changes -
Assignee
|
Daniel Black
[ danblack
]
|
Dave Gosselin
[ JIRAUSER52216
]
|
{"report":{"fcp":885.8000001907349,"ttfb":298.80000019073486,"pageVisibility":"visible","entityId":133004,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"c69f0e8b-17dc-494a-9fc7-f57c4ad2419e","navigationType":0,"readyForUser":1018.8000001907349,"redirectCount":0,"resourceLoadedEnd":589.4000000953674,"resourceLoadedStart":304.19999980926514,"resourceTiming":[{"duration":12.600000381469727,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":304.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":304.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":316.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":12.599999904632568,"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":304.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":304.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":317.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":168.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":304.69999980926514,"connectEnd":304.69999980926514,"connectStart":304.69999980926514,"domainLookupEnd":304.69999980926514,"domainLookupStart":304.69999980926514,"fetchStart":304.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":318.69999980926514,"responseEnd":473.09999990463257,"responseStart":330.90000009536743,"secureConnectionStart":304.69999980926514},{"duration":284.5,"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":304.90000009536743,"connectEnd":304.90000009536743,"connectStart":304.90000009536743,"domainLookupEnd":304.90000009536743,"domainLookupStart":304.90000009536743,"fetchStart":304.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":320.59999990463257,"responseEnd":589.4000000953674,"responseStart":336.40000009536743,"secureConnectionStart":304.90000009536743},{"duration":13.599999904632568,"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":305.09999990463257,"connectEnd":305.09999990463257,"connectStart":305.09999990463257,"domainLookupEnd":305.09999990463257,"domainLookupStart":305.09999990463257,"fetchStart":305.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":305.09999990463257,"responseEnd":318.69999980926514,"responseStart":318.69999980926514,"secureConnectionStart":305.09999990463257},{"duration":43.39999961853027,"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":305.30000019073486,"connectEnd":305.30000019073486,"connectStart":305.30000019073486,"domainLookupEnd":305.30000019073486,"domainLookupStart":305.30000019073486,"fetchStart":305.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":323,"responseEnd":348.69999980926514,"responseStart":346.30000019073486,"secureConnectionStart":305.30000019073486},{"duration":35.80000019073486,"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":305.5,"connectEnd":305.5,"connectStart":305.5,"domainLookupEnd":305.5,"domainLookupStart":305.5,"fetchStart":305.5,"redirectEnd":0,"redirectStart":0,"requestStart":322.40000009536743,"responseEnd":341.30000019073486,"responseStart":339.69999980926514,"secureConnectionStart":305.5},{"duration":15.300000190734863,"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":305.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":305.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":321,"responseStart":0,"secureConnectionStart":0},{"duration":42.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":305.90000009536743,"connectEnd":305.90000009536743,"connectStart":305.90000009536743,"domainLookupEnd":305.90000009536743,"domainLookupStart":305.90000009536743,"fetchStart":305.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":323.90000009536743,"responseEnd":348.40000009536743,"responseStart":345.59999990463257,"secureConnectionStart":305.90000009536743},{"duration":16.800000190734863,"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":306,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":306,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":322.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":43.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":306.19999980926514,"connectEnd":306.19999980926514,"connectStart":306.19999980926514,"domainLookupEnd":306.19999980926514,"domainLookupStart":306.19999980926514,"fetchStart":306.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":327.40000009536743,"responseEnd":350.09999990463257,"responseStart":346.90000009536743,"secureConnectionStart":306.19999980926514},{"duration":18.300000190734863,"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":316.69999980926514,"connectEnd":316.69999980926514,"connectStart":316.69999980926514,"domainLookupEnd":316.69999980926514,"domainLookupStart":316.69999980926514,"fetchStart":316.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":316.69999980926514,"responseEnd":335,"responseStart":335,"secureConnectionStart":316.69999980926514},{"duration":13.299999713897705,"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":324.90000009536743,"connectEnd":324.90000009536743,"connectStart":324.90000009536743,"domainLookupEnd":324.90000009536743,"domainLookupStart":324.90000009536743,"fetchStart":324.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":324.90000009536743,"responseEnd":338.19999980926514,"responseStart":338.19999980926514,"secureConnectionStart":324.90000009536743},{"duration":141.80000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":630.0999999046326,"connectEnd":630.0999999046326,"connectStart":630.0999999046326,"domainLookupEnd":630.0999999046326,"domainLookupStart":630.0999999046326,"fetchStart":630.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":736.5,"responseEnd":771.9000000953674,"responseStart":771.1999998092651,"secureConnectionStart":630.0999999046326}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":86,"responseStart":298,"responseEnd":324,"domLoading":302,"domInteractive":1174,"domContentLoadedEventStart":1175,"domContentLoadedEventEnd":1221,"domComplete":1731,"loadEventStart":1731,"loadEventEnd":1731,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1133},{"name":"bigPipe.sidebar-id.end","time":1133.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.start","time":1134},{"name":"bigPipe.activity-panel-pipe-id.end","time":1136.8000001907349},{"name":"activityTabFullyLoaded","time":1239.0999999046326}],"measures":[],"correlationId":"3bb4dbd56c43bf","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":105,"dbReadsTimeInMs":18,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}