When I use BINLOG_GTID_POS(..) on a server where binary log is not enabled, I expect it to return ER_NO_BINARY_LOGGING. It does so lets say in MySQL client, but with some API variants it does not.
C API:
#include <my_global.h>
|
#include <mysql.h>
|
|
int main(int argc, char **argv)
|
{
|
MYSQL con;
|
mysql_init(&con);
|
|
if (mysql_real_connect(&con, "127.0.0.1", "root", "",
|
"test", 3306, NULL, 0) == NULL)
|
{
|
fprintf(stderr, "ERROR: %s\n", mysql_error(&con));
|
exit(1);
|
}
|
|
mysql_query(&con,"select binlog_gtid_pos('a',1)");
|
// If I call mysql_store_result(&con) here, everything works.
|
// If I call mysql_use_result(&con) or nothing at all, there is no error
|
fprintf(stderr,"Here should be an error: %s\n",mysql_error(&con));
|
|
mysql_close(&con);
|
}
|
Perl:
use DBD::mysql;
|
use strict;
|
|
my $dsn = "dbi:mysql:host=127.0.0.1:port=3306:user=root:database=test";
|
my $dbh = DBI->connect($dsn);
|
|
unless (defined $dbh) {
|
print STDERR "Could not connect to $dsn\n";
|
exit(1);
|
}
|
|
my $sth = $dbh->prepare("SELECT binlog_gtid_pos('a',1)");
|
# If I set mysql_store_result here, or nothing at all, everything works.
|
# If I set mysql_use_result, it does not
|
$sth->{'mysql_use_result'}=1;
|
unless (defined $sth) {
|
print STDERR $dbh->errstr(), "\n";
|
exit(1);
|
}
|
|
$sth->execute();
|
print "Here should be an error: ", $sth->errstr(), "\n";
|
$sth->finish();
|
$dbh->disconnect();
|
In both cases output is
Current tree:
revision-id: monty@askmonty.org-20140222011156-i1pa6zm2iltb4usv
|
revno: 4007
|
branch-nick: 10.0
|
{"report":{"fcp":942.2000000476837,"ttfb":252.70000004768372,"pageVisibility":"visible","entityId":31110,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"c7b9fb2b-102e-4973-bca6-367e92810661","navigationType":0,"readyForUser":1001.7000000476837,"redirectCount":0,"resourceLoadedEnd":1115.2000000476837,"resourceLoadedStart":267.60000002384186,"resourceTiming":[{"duration":210.10000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":267.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":267.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":477.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":209.90000009536743,"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":267.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":267.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":477.8000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":268.8000000715256,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":267.89999997615814,"connectEnd":267.89999997615814,"connectStart":267.89999997615814,"domainLookupEnd":267.89999997615814,"domainLookupStart":267.89999997615814,"fetchStart":267.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":267.89999997615814,"responseEnd":536.7000000476837,"responseStart":536.7000000476837,"secureConnectionStart":267.89999997615814},{"duration":335.2999999523163,"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":268.10000002384186,"connectEnd":268.10000002384186,"connectStart":268.10000002384186,"domainLookupEnd":268.10000002384186,"domainLookupStart":268.10000002384186,"fetchStart":268.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":268.10000002384186,"responseEnd":603.3999999761581,"responseStart":603.3999999761581,"secureConnectionStart":268.10000002384186},{"duration":339,"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":268.2000000476837,"connectEnd":268.2000000476837,"connectStart":268.2000000476837,"domainLookupEnd":268.2000000476837,"domainLookupStart":268.2000000476837,"fetchStart":268.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":268.2000000476837,"responseEnd":607.2000000476837,"responseStart":607.2000000476837,"secureConnectionStart":268.2000000476837},{"duration":339.60000002384186,"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":268.2000000476837,"connectEnd":268.2000000476837,"connectStart":268.2000000476837,"domainLookupEnd":268.2000000476837,"domainLookupStart":268.2000000476837,"fetchStart":268.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":268.2000000476837,"responseEnd":607.8000000715256,"responseStart":607.8000000715256,"secureConnectionStart":268.2000000476837},{"duration":339.89999997615814,"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":268.3000000715256,"connectEnd":268.3000000715256,"connectStart":268.3000000715256,"domainLookupEnd":268.3000000715256,"domainLookupStart":268.3000000715256,"fetchStart":268.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":268.3000000715256,"responseEnd":608.2000000476837,"responseStart":608.2000000476837,"secureConnectionStart":268.3000000715256},{"duration":340.2000000476837,"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":268.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":268.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":608.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":340.10000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":268.60000002384186,"connectEnd":268.60000002384186,"connectStart":268.60000002384186,"domainLookupEnd":268.60000002384186,"domainLookupStart":268.60000002384186,"fetchStart":268.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":268.60000002384186,"responseEnd":608.7000000476837,"responseStart":608.7000000476837,"secureConnectionStart":268.60000002384186},{"duration":341.39999997615814,"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":268.8000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":268.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":610.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":341.5,"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":268.89999997615814,"connectEnd":268.89999997615814,"connectStart":268.89999997615814,"domainLookupEnd":268.89999997615814,"domainLookupStart":268.89999997615814,"fetchStart":268.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":268.89999997615814,"responseEnd":610.3999999761581,"responseStart":610.3999999761581,"secureConnectionStart":268.89999997615814},{"duration":732.6000000238419,"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":269.39999997615814,"connectEnd":269.39999997615814,"connectStart":269.39999997615814,"domainLookupEnd":269.39999997615814,"domainLookupStart":269.39999997615814,"fetchStart":269.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":269.39999997615814,"responseEnd":1002,"responseStart":1002,"secureConnectionStart":269.39999997615814},{"duration":845.7000000476837,"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":269.5,"connectEnd":269.5,"connectStart":269.5,"domainLookupEnd":269.5,"domainLookupStart":269.5,"fetchStart":269.5,"redirectEnd":0,"redirectStart":0,"requestStart":269.5,"responseEnd":1115.2000000476837,"responseStart":1115.2000000476837,"secureConnectionStart":269.5},{"duration":273.39999997615814,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":750.5,"connectEnd":750.5,"connectStart":750.5,"domainLookupEnd":750.5,"domainLookupStart":750.5,"fetchStart":750.5,"redirectEnd":0,"redirectStart":0,"requestStart":750.5,"responseEnd":1023.8999999761581,"responseStart":1023.8999999761581,"secureConnectionStart":750.5},{"duration":194.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":921.8000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":921.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1116.3000000715256,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":70,"responseStart":252,"responseEnd":264,"domLoading":264,"domInteractive":1148,"domContentLoadedEventStart":1148,"domContentLoadedEventEnd":1183,"domComplete":2135,"loadEventStart":2135,"loadEventEnd":2137,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1131.7000000476837},{"name":"bigPipe.sidebar-id.end","time":1132.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1132.7000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":1135.1000000238419},{"name":"activityTabFullyLoaded","time":1221.3000000715256}],"measures":[],"correlationId":"990e1fe13baa9a","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":110,"dbReadsTimeInMs":13,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}