[DRILL-2433] Implicit cast between date and timestamp is missing in joins

<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=Edge"/> <meta name="application-name" content="JIRA" data-name="jira" data-version="8.20.10"><meta name="ajs-server-scheme" content="https"> <meta name="ajs-server-port" content="443"> <meta name="ajs-server-name" content="issues.apache.org"> <meta name="ajs-behind-proxy" content="null"> <meta name="ajs-base-url" content="https://issues.apache.org/jira"> <meta name="ajs-viewissue-use-history-api" content="false"> <meta name="ajs-jira-base-url" content="https://issues.apache.org/jira"> <meta name="ajs-serverRenderedViewIssue" content="true"> <meta name="ajs-dev-mode" content="false"> <meta name="ajs-context-path" content="/jira"> <meta name="ajs-version-number" content="8.20.10"> <meta name="ajs-build-number" content="820010"> <meta name="ajs-is-beta" content="false"> <meta name="ajs-is-rc" content="false"> <meta name="ajs-is-snapshot" content="false"> <meta name="ajs-is-milestone" content="false"> <meta name="ajs-remote-user" content=""> <meta name="ajs-remote-user-fullname" content=""> <meta name="ajs-user-locale" content="en_UK"> <meta name="ajs-user-locale-group-separator" content=","> <meta name="ajs-app-title" content="ASF JIRA"> <meta name="ajs-keyboard-shortcuts-enabled" content="true"> <meta name="ajs-keyboard-accesskey-modifier" content="Alt"> <meta name="ajs-enabled-dark-features" content="["com.atlassian.jira.agile.darkfeature.editable.detailsview","nps.survey.inline.dialog","com.atlassian.jira.agile.darkfeature.edit.closed.sprint.enabled","jira.plugin.devstatus.phasetwo","jira.frother.reporter.field","atlassian.rest.xsrf.legacy.enabled","jira.issue.status.lozenge","com.atlassian.jira.config.BIG_PIPE","com.atlassian.jira.projects.issuenavigator","com.atlassian.jira.config.PDL","jira.plugin.devstatus.phasetwo.enabled","atlassian.aui.raphael.disabled","app-switcher.new","frother.assignee.field","com.atlassian.jira.projects.ProjectCentricNavigation.Switch","sd.internal.base.off.thread.on.completion.events.enabled","jira.onboarding.cyoa","com.atlassian.jira.agile.darkfeature.kanplan.enabled","sd.slavalue.record.updated.date.enabled","com.atlassian.jira.config.ProjectConfig.MENU","com.atlassian.jira.projects.sidebar.DEFER_RESOURCES","com.atlassian.jira.agile.darkfeature.kanplan.epics.and.versions.enabled","com.atlassian.jira.agile.darkfeature.sprint.goal.enabled","jira.zdu.admin-updates-ui","jira.zdu.jmx-monitoring","sd.sla.improved.rendering.enabled","com.atlassian.jira.migration.features.assess-l1-cloud-tooling","sd.canned.responses.enabled","sd.new.settings.sidebar.location.disabled","jira.zdu.cluster-upgrade-state","com.atlassian.jira.email.templates.readFromJiraHome","com.atlassian.jira.agile.darkfeature.splitissue","com.atlassian.jira.config.CoreFeatures.LICENSE_ROLES_ENABLED","jira.export.csv.enabled"]"> <meta name="ajs-in-admin-mode" content="false"> <meta name="ajs-is-sysadmin" content="false"> <meta name="ajs-is-admin" content="false"> <meta name="ajs-outgoing-mail-enabled" content="true"> <meta name="ajs-archiving-enabled" content="true"> <meta name="ajs-date-relativize" content="true"> <meta name="ajs-date-time" content="HH:mm"> <meta name="ajs-date-day" content="EEEE HH:mm"> <meta name="ajs-date-dmy" content="dd/MMM/yy"> <meta name="ajs-date-complete" content="dd/MMM/yy HH:mm"> <script type="text/javascript">var AJS=AJS||{};AJS.debug=true;</script> <meta id="atlassian-token" name="atlassian-token" content="A5KQ-2QAV-T4JA-FDED_1fa3913c417148bb2fff18f5c143370c5315523e_lout"> <link rel="shortcut icon" href="/jira/s/-lmkfjk/820010/13pdxe5/_/images/fav-jsw.png">  <script type="text/javascript"> (function() { var contextPath = '/jira'; function printDeprecatedMsg() { if (console && console.warn) { console.warn('DEPRECATED JS - contextPath global variable has been deprecated since 7.4.0. Use `wrm/context-path` module instead.'); } } Object.defineProperty(window, 'contextPath', { get: function() { printDeprecatedMsg(); return contextPath; }, set: function(value) { printDeprecatedMsg(); contextPath = value; } }); })(); </script> <script> window.WRM=window.WRM||{};window.WRM._unparsedData=window.WRM._unparsedData||{};window.WRM._unparsedErrors=window.WRM._unparsedErrors||{}; WRM._unparsedData["com.atlassian.plugins.atlassian-plugins-webresource-plugin:context-path.context-path"]="\"/jira\""; WRM._unparsedData["jira.core:feature-flags-data.feature-flag-data"]="{\"enabled-feature-keys\":[\"com.atlassian.jira.agile.darkfeature.editable.detailsview\",\"nps.survey.inline.dialog\",\"com.atlassian.jira.agile.darkfeature.edit.closed.sprint.enabled\",\"jira.plugin.devstatus.phasetwo\",\"jira.frother.reporter.field\",\"atlassian.rest.xsrf.legacy.enabled\",\"jira.issue.status.lozenge\",\"com.atlassian.jira.config.BIG_PIPE\",\"com.atlassian.jira.projects.issuenavigator\",\"com.atlassian.jira.config.PDL\",\"jira.plugin.devstatus.phasetwo.enabled\",\"atlassian.aui.raphael.disabled\",\"app-switcher.new\",\"frother.assignee.field\",\"com.atlassian.jira.projects.ProjectCentricNavigation.Switch\",\"sd.internal.base.off.thread.on.completion.events.enabled\",\"jira.onboarding.cyoa\",\"com.atlassian.jira.agile.darkfeature.kanplan.enabled\",\"sd.slavalue.record.updated.date.enabled\",\"com.atlassian.jira.config.ProjectConfig.MENU\",\"com.atlassian.jira.projects.sidebar.DEFER_RESOURCES\",\"com.atlassian.jira.agile.darkfeature.kanplan.epics.and.versions.enabled\",\"com.atlassian.jira.agile.darkfeature.sprint.goal.enabled\",\"jira.zdu.admin-updates-ui\",\"jira.zdu.jmx-monitoring\",\"sd.sla.improved.rendering.enabled\",\"com.atlassian.jira.migration.features.assess-l1-cloud-tooling\",\"sd.canned.responses.enabled\",\"sd.new.settings.sidebar.location.disabled\",\"jira.zdu.cluster-upgrade-state\",\"com.atlassian.jira.email.templates.readFromJiraHome\",\"com.atlassian.jira.agile.darkfeature.splitissue\",\"com.atlassian.jira.config.CoreFeatures.LICENSE_ROLES_ENABLED\",\"jira.export.csv.enabled\"],\"feature-flag-states\":{\"com.atlassian.jira.use.same.site.none.for.xsrf.token.cookie\":true,\"com.atlassian.jira.agile.darkfeature.handle.ug.usernames\":true,\"com.atlassian.jira.security.endpoint.non.admin.access.screens\":false,\"com.atlassian.jira.mailHandlerImapMessageQueryLegacy\":false,\"com.atlassian.jira.webhookEventsAsyncProcessing\":false,\"com.atlassian.jira.serAllowShareWithNonMember\":true,\"com.atlassian.troubleshooting.healthcheck.jira.license.limit\":false,\"com.atlassian.jira.diagnostics.perflog\":true,\"com.atlassian.jira.dbr\":true,\"com.atlassian.jira.agile.darkfeature.legacy.epic.picker\":false,\"com.atlassian.jira.issuetable.move.links.hidden\":true,\"com.atlassian.jira.agile.darkfeature.unlink.sprints.on.issue.move\":true,\"jira.renderer.consider.variable.format\":true,\"com.atlassian.jira.user.dbIdBasedKeyGenerationStrategy\":true,\"com.atlassian.jira.plugin.issuenavigator.jql.autocomplete.eagerlyLoaded\":false,\"com.atlassian.portfolio.dcBundling\":true,\"com.atlassian.jira.sharedEntityEditRights\":true,\"com.atlassian.jira.security.endpoint.anonymous.access.resolution\":false,\"com.atlassian.jira.agile.darkfeature.sprint.goal\":false,\"com.atlassian.jira.thumbnailsDeferredGeneration\":true,\"jira.cluster.monitoring.show.offline.nodes\":true,\"com.atlassian.jira.commentReactions\":true,\"data.pipeline.feature.jira.issue.links.export\":true,\"com.atlassian.jira.custom.csv.escaper\":true,\"com.atlassian.jira.fixedCommentDeletionNotifications\":true,\"com.atlassian.jira.allThumbnailsDeferred\":false,\"com.atlassian.jira.plugin.issuenavigator.filtersUxImprovment\":true,\"com.atlassian.jira.agile.darkfeature.kanplan.epics.and.versions\":false,\"com.atlassian.jira.jsd.mobile\":true,\"jira.customfields.cleanup.identification\":true,\"data.pipeline.feature.jira.all.exportable.custom.fields\":true,\"com.atlassian.jira.defaultValuesForSystemFields\":true,\"jira.dc.cleanup.cluser.tasks\":true,\"jira.customfields.bulk.delete\":true,\"com.atlassian.jira.issues.archiving.filters\":false,\"mail.batching.override.core\":true,\"jira.users.and.roles.page.in.react\":true,\"jira.security.csp.sandbox\":true,\"com.atlassian.jira.agile.darkfeature.velocity.chart.ui\":true,\"com.atlassian.jira.returnDefaultAvatarsForBrokenAvatars\":true,\"com.atlassian.jira.agile.darkfeature.sprint.auto.management\":false,\"jira.jql.suggestrecentfields\":false,\"com.atlassian.jira.gdpr.rtbf\":true,\"com.atlassian.jira.security.xsrf.session.token\":true,\"com.atlassian.jira.agile.darkfeature.optimistic.transitions\":true,\"com.atlassian.jira.security.project.admin.revoke.with.application.access\":true,\"com.atlassian.jiranomenclature\":true,\"com.atlassian.jira.security.endpoint.non.admin.access.avatar.system\":false,\"com.atlassian.jira.agile.darkfeature.kanplan\":false,\"com.atlassian.jira.agile.darkfeature.future.sprint.dates\":true,\"com.atlassian.jira.filtersAndDashboardsShareableWithAllGroupsAndRoles\":true,\"jira.customfields.paginated.ui\":true,\"com.atlassian.jira.agile.darkfeature.edit.closed.sprint\":false,\"jira.create.linked.issue\":true,\"com.atlassian.jira.advanced.audit.log\":true,\"jira.sal.host.connect.accessor.existing.transaction.will.create.transactions\":true,\"external.links.new.window\":true,\"jira.quick.search\":true,\"jira.jql.smartautoselectfirst\":false,\"jira.jql.membersof.ignoreGlobalPermissionsForAnonymous\":false,\"data.pipeline.feature.jira.issue.history.export\":true,\"com.atlassian.jira.security.endpoint.non.browse.projects.access.fields\":false,\"atlassian.cdn.static.assets\":true,\"jira.richeditor.bidi.warning\":true,\"mail.batching\":false,\"com.atlassian.jira.privateEntitiesEditable\":true,\"com.atlassian.jira.security.endpoint.anonymous.access.priority\":false,\"jira.priorities.per.project.edit.default\":false,\"com.atlassian.jira.agile.darkfeature.issues.in.epic.details.view\":true,\"jira.priorities.per.project.jsd\":true,\"com.atlassian.jira.plugin.issuenavigator.anonymousPreventCfData\":false,\"com.atlassian.jira.agile.darkfeature.rapid.boards.bands\":true,\"com.atlassian.jira.agile.darkfeature.flexible.boards\":true,\"com.atlassian.jira.agile.darkfeature.sprint.picker.allsprints.suggestion\":true,\"com.atlassian.jira.agile.darkfeature.epic.validate.visibility\":true,\"jira.dc.lock.leasing\":true,\"com.atlassian.jira.accessibility.personal.settings\":true,\"mail.batching.create.section.cf\":true,\"com.atlassian.jira.send.email.notifications.to.user.without.application.access\":false,\"com.atlassian.jira.security.endpoint.non.browse.projects.access.autocompletedata\":false,\"com.atlassian.mail.server.managers.hostname.verification\":true,\"com.atlassian.advancedroadmaps.rebrand\":true,\"com.atlassian.jira.upgrade.startup.fix.index\":true,\"com.atlassian.jira.security.endpoint.anonymous.access.projectCategory\":false,\"jira.redirect.anonymous.404.errors\":true,\"com.atlassian.jira.issuetable.draggable\":true,\"com.atlassian.jira.attachments.generate.unique.suffix\":true,\"com.atlassian.jira.agile.darkfeature.kanban.hide.old.done.issues\":true,\"jira.version.based.node.reindex.service\":true,\"com.atlassian.jira.agile.darkfeature.backlog.showmore\":true,\"com.atlassian.jira.agile.darkfeature.sprint.plan\":false,\"com.atlassian.jira.security.endpoint.anonymous.access.issueLinkType\":false,\"com.atlassian.jira.security.LegacyJiraTypeResolver.WARN_ONLY\":false,\"data.pipeline.feature.jira.schema.version.2\":true,\"com.atlassian.jira.agile.darkfeature.burnupchart\":true,\"com.atlassian.jira.agile.darkfeature.velocity.sprint.picker\":false,\"com.atlassian.jira.issues.archiving.browse\":true,\"jira.instrumentation.laas\":false,\"com.atlassian.jira.security.ChartUtils.browse.projects.permission.check\":false,\"mail.batching.user.notification\":true,\"com.atlassian.portfolio.permission.check.for.permissions\":true,\"com.atlassian.jira.agile.darkfeature.dataonpageload\":true,\"data.pipeline.feature.jira.archived.issue.export\":false,\"com.atlassian.jira.projects.per.project.permission.query\":true,\"com.atlassian.jira.issues.archiving\":true,\"index.use.snappy\":true,\"jira.priorities.per.project\":true}}"; WRM._unparsedData["jira.core:default-comment-security-level-data.DefaultCommentSecurityLevelHelpLink"]="{\"extraClasses\":\"default-comment-level-help\",\"title\":\"Commenting on an Issue\",\"url\":\"https://docs.atlassian.com/jira/jcore-docs-0820/Editing+and+collaborating+on+issues#Editingandcollaboratingonissues-restrictacomment\",\"isLocal\":false}"; WRM._unparsedData["jira.core:dateFormatProvider.allFormats"]="{\"dateFormats\":{\"meridiem\":[\"AM\",\"PM\"],\"eras\":[\"BC\",\"AD\"],\"months\":[\"January\",\"February\",\"March\",\"April\",\"May\",\"June\",\"July\",\"August\",\"September\",\"October\",\"November\",\"December\"],\"monthsShort\":[\"Jan\",\"Feb\",\"Mar\",\"Apr\",\"May\",\"Jun\",\"Jul\",\"Aug\",\"Sep\",\"Oct\",\"Nov\",\"Dec\"],\"weekdaysShort\":[\"Sun\",\"Mon\",\"Tue\",\"Wed\",\"Thu\",\"Fri\",\"Sat\"],\"weekdays\":[\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\"]},\"lookAndFeelFormats\":{\"relativize\":\"true\",\"time\":\"HH:mm\",\"day\":\"EEEE HH:mm\",\"dmy\":\"dd/MMM/yy\",\"complete\":\"dd/MMM/yy HH:mm\"}}"; WRM._unparsedData["com.atlassian.jira.jira-issue-nav-components:issueviewer.features"]="{\"rteEnabled\":true}"; WRM._unparsedData["com.atlassian.jira.jira-quick-edit-plugin:create-issue-data.data"]="{\"configurableSystemFieldIds\":[\"description\"]}"; WRM._unparsedData["com.onresolve.jira.groovy.groovyrunner:behaviours-translations.behaviours-translations-data-provider"]="{\"field.title.missing.value\":\"You must enter a value for this field\"}"; WRM._unparsedData["com.atlassian.jira.plugins.jira-dnd-attachment-plugin:dnd-issue-drop-zone.thumbnail-mime-types"]="\"image/png,image/vnd.wap.wbmp,image/x-png,image/jpeg,image/bmp,image/gif\""; WRM._unparsedData["com.atlassian.jira.plugins.jira-dnd-attachment-plugin:dnd-issue-drop-zone.upload-limit"]="\"62914560\""; WRM._unparsedData["com.atlassian.plugins.helptips.jira-help-tips:help-tip-manager.JiraHelpTipData"]="{\"anonymous\":true}"; WRM._unparsedData["com.atlassian.jira.jira-view-issue-plugin:controller-subtasks.controller.subtasks.parameters"]="{\"url\":\"/rest/api/2/issue/{issueId}/subtask/move\"}"; WRM._unparsedData["com.atlassian.jira.plugins.jira-wiki-editor:wiki-editor-thumbnails.thumbnails-allowed"]="false"; WRM._unparsedData["com.atlassian.jira.plugins.jira-wiki-editor:wiki-editor-resources.help-data"]="{\"showHelp\":true,\"editorDocumentationUrl\":[\"https://docs.atlassian.com/jira/jcore-docs-0820/Visual+editing\"],\"editorDocumentationTitle\":[\"Show me documentation for the visual editor\"]}"; WRM._unparsedData["jira.core:terminology-data.terminology"]="{\"terminologyEntries\":[{\"originalName\":\"sprint\",\"originalNamePlural\":\"sprints\",\"newName\":\"sprint\",\"newNamePlural\":\"sprints\",\"isDefault\":true},{\"originalName\":\"epic\",\"originalNamePlural\":\"epics\",\"newName\":\"epic\",\"newNamePlural\":\"epics\",\"isDefault\":true}],\"isTerminologyActive\":false}"; WRM._unparsedData["com.atlassian.analytics.analytics-client:policy-update-init.policy-update-data-provider"]="false"; WRM._unparsedData["com.atlassian.analytics.analytics-client:programmatic-analytics-init.programmatic-analytics-data-provider"]="false"; WRM._unparsedData["com.onresolve.jira.groovy.groovyrunner:web-item-response-renderer.web-item-actions-data-provider"]="[]"; WRM._unparsedData["com.atlassian.jira.plugins.jira-slack-server-integration-plugin:slack-link-error-resources.slack-link-error"]="{}"; WRM._unparsedData["jira.core:avatar-picker-data.data"]="{}"; WRM._unparsedData["com.atlassian.jira.jira-header-plugin:dismissedFlags.flags"]="{\"dismissed\":[]}"; WRM._unparsedData["com.atlassian.jira.jira-header-plugin:newsletter-signup-tip-init.newsletterSignup"]="{\"signupDescription\":\"Get updates, inspiration and best practices from the team behind Jira.\",\"formUrl\":\"https://www.atlassian.com/apis/exact-target/{0}/subscribe?mailingListId=1401671\",\"signupTitle\":\"Sign up!\",\"signupId\":\"newsletter-signup-tip\",\"showNewsletterTip\":false}"; WRM._unparsedData["com.atlassian.jira.project-templates-plugin:project-templates-plugin-resources.ptAnalyticsData"]="{\"instanceCreatedDate\":\"2011-01-31\"}"; WRM._unparsedData["jira.core:user-message-flags-data.adminLockout"]="{}"; WRM._unparsedData["jira.request.correlation-id"]="\"71cd532b7c5834\""; WRM._unparsedData["project-id"]="12313820"; WRM._unparsedData["project-key"]="\"DRILL\""; WRM._unparsedData["project-name"]="\"Apache Drill\""; WRM._unparsedData["project-type"]="\"software\""; WRM._unparsedData["com.atlassian.jira.jira-projects-issue-navigator:generic-filters"]="[{\"id\":\"allissues\",\"jql\":\"project = \\\"{0}\\\" ORDER BY {1}\",\"defaultOrderby\":\"created DESC\",\"label\":\"All issues\",\"requiresUser\":false,\"supportsInlineIssueCreate\":true,\"fields\":[]},{\"id\":\"allopenissues\",\"jql\":\"project = \\\"{0}\\\" AND resolution = Unresolved ORDER BY {1}\",\"defaultOrderby\":\"priority DESC, updated DESC\",\"label\":\"Open issues\",\"requiresUser\":false,\"supportsInlineIssueCreate\":true,\"fields\":[\"resolution\"]},{\"id\":\"doneissues\",\"jql\":\"project = \\\"{0}\\\" AND statusCategory = Done ORDER BY {1}\",\"defaultOrderby\":\"updated DESC\",\"label\":\"Done issues\",\"requiresUser\":false,\"supportsInlineIssueCreate\":false,\"fields\":[\"status\"]},{\"id\":\"recentlyviewed\",\"jql\":\"project = \\\"{0}\\\" AND issuekey in issueHistory() ORDER BY {1}\",\"defaultOrderby\":\"lastViewed DESC\",\"label\":\"Viewed recently\",\"requiresUser\":false,\"supportsInlineIssueCreate\":true,\"fields\":[\"issuekey\"]},{\"id\":\"addedrecently\",\"jql\":\"project = \\\"{0}\\\" AND created \u003e= -1w ORDER BY {1}\",\"defaultOrderby\":\"created DESC\",\"label\":\"Created recently\",\"requiresUser\":false,\"supportsInlineIssueCreate\":true,\"fields\":[\"created\"]},{\"id\":\"resolvedrecently\",\"jql\":\"project = \\\"{0}\\\" AND resolutiondate \u003e= -1w ORDER BY {1}\",\"defaultOrderby\":\"updated DESC\",\"label\":\"Resolved recently\",\"requiresUser\":false,\"supportsInlineIssueCreate\":false,\"fields\":[\"resolutiondate\"]},{\"id\":\"updatedrecently\",\"jql\":\"project = \\\"{0}\\\" AND updated \u003e= -1w ORDER BY {1}\",\"defaultOrderby\":\"updated DESC\",\"label\":\"Updated recently\",\"requiresUser\":false,\"supportsInlineIssueCreate\":true,\"fields\":[\"updated\"]}]"; WRM._unparsedData["com.atlassian.jira.jira-projects-issue-navigator:default-filter-priority"]="[\"allopenissues\",\"allissues\"]"; WRM._unparsedData["com.atlassian.jira.jira-projects-issue-navigator:can-manage-filters"]="false"; WRM._unparsedData["com.atlassian.jira.jira-projects-issue-navigator:project-filters"]="[]"; WRM._unparsedData["com.atlassian.jira.jira-projects-issue-navigator:can-create-issues"]="false"; WRM._unparsedData["projectId"]="12313820"; WRM._unparsedData["projectKey"]="\"DRILL\""; WRM._unparsedData["projectType"]="\"software\""; WRM._unparsedData["com.atlassian.jira.jira-projects-issue-navigator:server-rendered"]="true"; WRM._unparsedData["archivingProjectHelpUrl"]="\"https://docs.atlassian.com/jira/jadm-docs-0820/Archiving+a+project\""; WRM._unparsedData["archivingIssueHelpUrl"]="\"https://docs.atlassian.com/jira/jadm-docs-0820/Archiving+an+issue\""; if(window.WRM._dataArrived)window.WRM._dataArrived();</script> <link type="text/css" rel="stylesheet" href="/jira/s/b62489a2eaac59d9b8a093c1a51d034f-CDN/-lmkfjk/820010/13pdxe5/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css" data-wrm-key="_super" data-wrm-batch-type="context" media="all"> <link type="text/css" rel="stylesheet" href="/jira/s/56490edcf9d54e35149505f78cca6a47-CDN/-lmkfjk/820010/13pdxe5/6cbddbc35e560711d24cc3abdeb0b2dd/_/download/contextbatch/css/jira.browse.project,jira.view.issue,project.issue.navigator,atl.general,atl.global,jira.global,jira.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true&slack-enabled=true" data-wrm-key="jira.browse.project,jira.view.issue,project.issue.navigator,atl.general,atl.global,jira.global,jira.general,-_super" data-wrm-batch-type="context" media="all"> <script type="text/javascript" src="/jira/s/376e46e0779ab163ee1e4a22ec634b03-CDN/-lmkfjk/820010/13pdxe5/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/js/_super/batch.js?locale=en-UK" data-wrm-key="_super" data-wrm-batch-type="context" data-initially-rendered></script> <script type="text/javascript" src="/jira/s/6b40dcb2aa50c5e4045ef6e58ab3f0ef-CDN/-lmkfjk/820010/13pdxe5/6cbddbc35e560711d24cc3abdeb0b2dd/_/download/contextbatch/js/jira.browse.project,jira.view.issue,project.issue.navigator,atl.general,atl.global,jira.global,jira.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-UK&richediton=true&slack-enabled=true" data-wrm-key="jira.browse.project,jira.view.issue,project.issue.navigator,atl.general,atl.global,jira.global,jira.general,-_super" data-wrm-batch-type="context" data-initially-rendered></script> <script type="text/javascript" src="/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-lmkfjk/820010/13pdxe5/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js" data-wrm-key="jira.webresources:calendar-en" data-wrm-batch-type="resource" data-initially-rendered></script> <script type="text/javascript" src="/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-lmkfjk/820010/13pdxe5/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js" data-wrm-key="jira.webresources:calendar-localisation-moment" data-wrm-batch-type="resource" data-initially-rendered></script> <link type="text/css" rel="stylesheet" href="/jira/s/981f587853769311cda7c3b845131a06-CDN/-lmkfjk/820010/13pdxe5/cb5a5495a038c0744457f25821ba9ee8/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css" data-wrm-key="jira.global.look-and-feel,-_super" data-wrm-batch-type="context" media="all"> <script type="text/javascript" src="/jira/rest/api/1.0/shortcuts/820010/13d0e3ba62194e16a034b080ac028ecf/shortcuts.js?context=issuenavigation&context=issueaction"></script> <script> window.WRM=window.WRM||{};window.WRM._unparsedData=window.WRM._unparsedData||{};window.WRM._unparsedErrors=window.WRM._unparsedErrors||{}; WRM._unparsedData["com.atlassian.jira.jira-issue-nav-components:inline-edit-enabled"]="true"; WRM._unparsedData["should-display-chaperone"]="false"; if(window.WRM._dataArrived)window.WRM._dataArrived();</script> <link type="text/css" rel="stylesheet" href="/jira/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/-lmkfjk/820010/13pdxe5/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true" data-wrm-key="com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator" data-wrm-batch-type="context" media="all"> <script type="text/javascript" src="/jira/s/7d73e82dc911998b80de6f4ba150e07e-CDN/-lmkfjk/820010/13pdxe5/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-UK&richediton=true" data-wrm-key="com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator" data-wrm-batch-type="context" data-initially-rendered></script> <meta charset="utf-8"><meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="ajs-can-search-users" content="false"> <meta name="ajs-can-edit-watchers" content="false"> <meta name="ajs-default-avatar-url" content="https://issues.apache.org/jira/secure/useravatar?size=xsmall&avatarId=10453"> <meta name="ajs-issue-project-type" content="software"> <meta name="ajs-issue-key" content="DRILL-2433"> <meta name="ajs-server-view-issue-is-editable" content="false"> <title>[DRILL-2433] Implicit cast between date and timestamp is missing in joins - ASF JIRA</title> <link rel="search" type="application/opensearchdescription+xml" href="/jira/osd.jsp" title="[DRILL-2433] Implicit cast between date and timestamp is missing in joins - ASF JIRA"/> </head> <body id="jira" class="aui-layout aui-theme-default " data-version="8.20.10"> <div id="page"> <header id="header" role="banner"> <script> require(["jquery", "jira/license-banner"], function ($, licenseBanner) { $(function () { // eslint-disable-line @atlassian/onready-checks/no-jquery-onready licenseBanner.showLicenseBanner(""); licenseBanner.showLicenseFlag(""); }); }); </script> <div id="browser-warning" class="aui-message aui-message-error closeable"> <p> You are using an unsupported browser or your browser might be in the Compatibility View mode. See <a href='https://docs.atlassian.com/jira/jadm-docs-0820/Supported+Platforms'> Supported Platforms </a> for more information. </p> </div> <a class="aui-skip-link" href="/jira/login.jsp?os_destination=%2Fbrowse%2FDRILL-2433">Log in</a><a class="aui-skip-link" href="#main">Skip to main content</a><a class="aui-skip-link" href="#sidebar">Skip to sidebar</a><nav class="aui-header aui-dropdown2-trigger-group" aria-label="Site"><div class="aui-header-inner"><div class="aui-header-before"><button class=" aui-dropdown2-trigger app-switcher-trigger aui-dropdown2-trigger-arrowless" aria-controls="app-switcher" aria-haspopup="true" role="button" data-aui-trigger href="#app-switcher"><span class="aui-icon aui-icon-small aui-iconfont-appswitcher">Linked Applications</span></button><div id="app-switcher" class="aui-dropdown2 aui-style-default" role="menu" hidden data-is-switcher="true" data-environment="{"isUserAdmin":false,"isAppSuggestionAvailable":false,"isSiteAdminUser":false}"><div class="app-switcher-loading">Loading…</div></div></div><div class="aui-header-primary"><span id="logo" class="aui-header-logo aui-header-logo-custom"><a href="https://issues.apache.org/jira/secure/MyJiraHome.jspa" aria-label="Go to home page"><img src="/jira/s/-lmkfjk/820010/13pdxe5/_/jira-logo-scaled.png" alt="ASF JIRA" /></a></span><ul class='aui-nav'><li><a href="/jira/secure/Dashboard.jspa" class=" aui-nav-link aui-dropdown2-trigger aui-dropdown2-ajax" id="home_link" aria-haspopup="true" aria-controls="home_link-content" title="View and manage your dashboards" accesskey="d" elementtiming="app-header">Dashboards</a><div class="aui-dropdown2 aui-style-default" id="home_link-content" data-aui-dropdown2-ajax-key="home_link"></div></li><li><a href="/jira/browse/DRILL" class=" aui-nav-link aui-dropdown2-trigger aui-dropdown2-ajax" id="browse_link" aria-haspopup="true" aria-controls="browse_link-content" title="View recent projects and browse a list of projects" accesskey="p">Projects</a><div class="aui-dropdown2 aui-style-default" id="browse_link-content" data-aui-dropdown2-ajax-key="browse_link"></div></li><li><a href="/jira/issues/" class=" aui-nav-link aui-dropdown2-trigger aui-dropdown2-ajax" id="find_link" aria-haspopup="true" aria-controls="find_link-content" title="Search for issues and view recent issues" accesskey="i">Issues</a><div class="aui-dropdown2 aui-style-default" id="find_link-content" data-aui-dropdown2-ajax-key="find_link"></div></li> </ul></div><div class="aui-header-secondary"><ul class='aui-nav'> <li id="quicksearch-menu"> <form action="/jira/secure/QuickSearch.jspa" method="get" id="quicksearch" class="aui-quicksearch dont-default-focus ajs-dirty-warning-exempt"> <input id="quickSearchInput" autocomplete="off" class="search" type="text" title="Search" placeholder="Search" name="searchString" accessKey="q" /> <input type="submit" class="hidden" value="Search"> </form> </li> <li id="system-help-menu"> <a class="aui-nav-link aui-dropdown2-trigger aui-dropdown2-trigger-arrowless" id="help_menu" aria-haspopup="true" aria-owns="system-help-menu-content" href="https://docs.atlassian.com/jira/jcore-docs-0820/" target="_blank" rel="noopener noreferrer" title="Help"><span class="aui-icon aui-icon-small aui-iconfont-question-filled">Help</span></a> <div id="system-help-menu-content" class="aui-dropdown2 aui-style-default"> <div class="aui-dropdown2-section"> <ul id="jira-help" class="aui-list-truncate"> <li> <a id="view_core_help" class="aui-nav-link " title="Go to the online documentation for Jira Core" href="https://docs.atlassian.com/jira/jcore-docs-0820/" target="_blank" >Jira Core help</a> </li> <li> <a id="keyshortscuthelp" class="aui-nav-link " title="Get more information about Jira's Keyboard Shortcuts" href="/jira/secure/ViewKeyboardShortcuts!default.jspa" target="_blank" >Keyboard Shortcuts</a> </li> <li> <a id="view_about" class="aui-nav-link " title="Get more information about Jira" href="/jira/secure/AboutPage.jspa" >About Jira</a> </li> <li> <a id="view_credits" class="aui-nav-link " title="See who did what" href="/jira/secure/credits/AroundTheWorld!default.jspa" target="_blank" >Jira Credits</a> </li> </ul> </div> </div> </li> <li id="user-options"> <a class="aui-nav-link login-link" href="/jira/login.jsp?os_destination=%2Fbrowse%2FDRILL-2433">Log In</a> <div id="user-options-content" class="aui-dropdown2 aui-style-default"> <div class="aui-dropdown2-section"> </div> </div> </li> </ul></div></div><aui-header-end></aui-header-end></nav> </header> <div id="announcement-banner" class="alertHeader"> <div id="announcement-banner" class="alertHeader"> <div style="border: solid red; border-width: 0 1em 0; font-size:1.2em; text-align:center;background-color:#EEE"><p>Public signup for this instance is <strong>disabled</strong>. Go to our <a href="https://selfserve.apache.org/jira-account.html">Self serve sign up page</a> to request an account. Report potential security issues <a href="https://apache.org/security/#reporting-a-vulnerability">privately</a></p></div> </div> </div> <div id="content"> <big-pipe data-id="sidebar-id" unresolved></big-pipe><section class="aui-sidebar sidebar-placeholder" ><div class="aui-sidebar-wrapper"><div class="aui-sidebar-body"></div><div class="aui-sidebar-footer"><button class="aui-button aui-button-subtle aui-sidebar-toggle aui-sidebar-footer-tipsy" title="Expand sidebar ( [ )" data-tooltip="Expand sidebar ( [ )"><span class="aui-icon aui-icon-small aui-iconfont-chevron-double-left"></span></button></div></div></section><script id="projects-sidebar-events-attach"> (function () { var scriptTag = document.getElementById('projects-sidebar-events-attach'); var sidebarElement = document.querySelector('big-pipe[data-id=sidebar-id]'); sidebarElement.addEventListener('error', function (e) { require(['jira/projects/sidebar/sidebar-placeholder-initializer'], function (sidebarPlaceholderInitializer) { sidebarPlaceholderInitializer.onError(e); }); }); sidebarElement.addEventListener('success', function (e) { require(['jira/projects/sidebar/sidebar-placeholder-initializer'], function (sidebarPlaceholderInitializer) { sidebarPlaceholderInitializer.onSuccess(e); }); }); scriptTag.parentElement.removeChild(scriptTag); }()) </script><script id="projects-sidebar-init"> require(['jira/projects/sidebar/expansion-manager'], function(expansionManager) { var scriptTag = document.getElementById('projects-sidebar-init'); var sidebar = AJS.sidebar('.aui-sidebar'); expansionManager(sidebar); scriptTag.parentElement.removeChild(scriptTag); }); </script><div class="aui-page-panel" ><div class="aui-page-panel-inner"><div class="issue-navigator"><main id="main" class="content" role="main"><div class="issue-view"><div class="navigation-tools"><div class="pager-container"></div><div class="collapse-container"></div></div><div class="issue-container"><div id="issue-content" class="issue-edit-form"><header id="stalker" class="issue-header js-stalker"><div class="issue-header-content"><div class="aui-page-header" ><div class="aui-page-header-inner"><div class="aui-page-header-image" ><span id="12313820" class="aui-avatar aui-avatar-large aui-avatar-project"><span class="aui-avatar-inner"><img id="project-avatar" alt="Uploaded image for project: 'Apache Drill'" src="https://issues.apache.org/jira/secure/projectavatar?pid=12313820&avatarId=34732" /></span></span></div><div class="aui-page-header-main" ><ol class="aui-nav aui-nav-breadcrumbs"><li><a id="project-name-val" href="/jira/browse/DRILL">Apache Drill</a></li><li><a class="issue-link" data-issue-key="DRILL-2433" href="/jira/browse/DRILL-2433" id="key-val" rel="12781295">DRILL-2433</a></li></ol><h1 id="summary-val">Implicit cast between date and timestamp is missing in joins</h1></div><div class="aui-page-header-actions" ><div id="issue-header-pager"></div></div></div></div><div class="command-bar"><div class="ops-cont"><div class="ops-menus aui-toolbar2"><div class="aui-toolbar2-inner"><div class="aui-toolbar2-primary"><div id="opsbar-ops-login-lnk_container" class="aui-buttons pluggable-ops"><a id="ops-login-lnk"title="Log In"class="aui-button toolbar-trigger" href="/jira/login.jsp?os_destination=%2Fbrowse%2FDRILL-2433"><span class="trigger-label">Log In</span></a></div><div id="opsbar-opsbar-operations" class="aui-buttons pluggable-ops"></div><div id="opsbar-opsbar-transitions" class="aui-buttons pluggable-ops"></div><div id="opsbar-opsbar-admin" class="aui-buttons pluggable-ops"></div><div id="opsbar-opsbar-restore" class="aui-buttons pluggable-ops"></div></div><div class="aui-toolbar2-secondary"><div id="opsbar-jira.issue.tools" class="aui-buttons pluggable-ops"><a href="#"id="viewissue-export"aria-owns="viewissue-export_drop"aria-haspopup="true"title="Export this issue in another format"class="aui-button aui-dropdown2-trigger" data-aui-alignment-container=".command-bar"><span class="icon icon-default aui-icon aui-icon-small aui-iconfont-export"></span> <span class="dropdown-text">Export</span></a></div></div></div></div><aui-dropdown-menu id="viewissue-export_drop"><ul><aui-item-link href="/jira/si/jira.issueviews:issue-xml/DRILL-2433/DRILL-2433.xml"id="jira.issueviews:issue-xml"><span class="trigger-label">XML</span></aui-item-link><aui-item-link href="/jira/si/jira.issueviews:issue-word/DRILL-2433/DRILL-2433.doc"id="jira.issueviews:issue-word"><span class="trigger-label">Word</span></aui-item-link><aui-item-link href="/jira/si/jira.issueviews:issue-html/DRILL-2433/DRILL-2433.html"id="jira.issueviews:issue-html"><span class="trigger-label">Printable</span></aui-item-link><aui-item-link href="/jira/si/com.atlassian.jira.plugins.jira-importers-plugin:issue-json/DRILL-2433/DRILL-2433.json"id="com.atlassian.jira.plugins.jira-importers-plugin:issue-json"><span class="trigger-label">JSON</span></aui-item-link></ul></aui-dropdown-menu></div></div></div></header><div class="issue-body-content"><div class="aui-group issue-body"><div class="aui-item issue-main-column"><div id=details-module class="module toggle-wrap"><div id="details-module_heading" class="mod-header"><button class="aui-button toggle-title" aria-label="Details" aria-controls="details-module" aria-expanded="true"><svg xmlns="http://www.w3.org/2000/svg" width="14" height="14"><g fill="none" fill-rule="evenodd"><path d="M3.29175 4.793c-.389.392-.389 1.027 0 1.419l2.939 2.965c.218.215.5.322.779.322s.556-.107.769-.322l2.93-2.955c.388-.392.388-1.027 0-1.419-.389-.392-1.018-.392-1.406 0l-2.298 2.317-2.307-2.327c-.194-.195-.449-.293-.703-.293-.255 0-.51.098-.703.293z" fill="#344563"/></g></svg></button><h4 class="toggle-title" id="details-module-label">Details</h4><ul class="ops"></ul></div><div class="mod-content"> <ul id="issuedetails" class="property-list two-cols"> <li class="item"> <div class="wrap"> <strong class="name" title="Type"> <label for="issuetype">Type:</label> </strong> <span id="type-val" class="value"> <img alt="" height="16" src="/jira/secure/viewavatar?size=xsmall&avatarId=21140&avatarType=issuetype" title="Improvement - An improvement or enhancement to an existing feature or task." width="16" /> Improvement </span> </div> </li> <li class="item item-right"> <div class="wrap"> <strong class="name" title="Status">Status:</strong> <span id="status-val" class="value"> <span class=" jira-issue-status-lozenge aui-lozenge jira-issue-status-lozenge-green jira-issue-status-lozenge-done jira-issue-status-lozenge-max-width-medium" data-tooltip="<span class="jira-issue-status-tooltip-title">Closed</span><br><span class="jira-issue-status-tooltip-desc">The issue is considered finished, the resolution is correct. Issues which are not closed can be reopened.</span>">Closed</span> </span> </div> </li> <li class="item new"> <div class="wrap"> <strong class="name" title="Priority"> <label for="priority-field">Priority:</label> </strong> <span id="priority-val" class="value"> <img alt="" height="16" src="/jira/images/icons/priorities/major.svg" title="Major - Major loss of function." width="16" /> Major </span> </div> </li> <li class="item item-right"> <div class="wrap"> <strong class="name" title="Resolution">Resolution:</strong> <span id="resolution-val" class="value resolved" > Fixed </span> </div> </li> <li class="item"> <div class="wrap"> <strong class="name" title="Affects Version/s"> <label for="versions-textarea">Affects Version/s:</label> </strong> <span id="versions-val" class="value"> None </span> </div> </li> <li class="item item-right"> <div class="wrap"> <strong class="name" title="Fix Version/s"> <label for="fixVersions"> Fix Version/s: </label> </strong> <span id="fixfor-val" class="value"> <span class="shorten" id="fixVersions-field"> <a href="/jira/issues/?jql=project+%3D+DRILL+AND+fixVersion+%3D+1.0.0" title="1.0.0 GA">1.0.0</a> </span> </span> </div> </li> <li class="item"> <div class="wrap"> <strong class="name" title="Component/s"> <label for="components">Component/s:</label> </strong> <span id="components-val" class="value"> <span class="shorten" id="components-field"> <a href="/jira/issues/?jql=project+%3D+DRILL+AND+component+%3D+%22Execution+-+Data+Types%22" title="Execution - Data Types ">Execution - Data Types</a> </span> </span> </div> </li> <li class="item full-width"> <div class="wrap" id="wrap-labels"> <strong class="name" title="Labels"> <label for="labels-textarea">Labels:</label> </strong> <div class="labels-wrap value"> <span class="labels" id="labels-12781295-value">None</span> </div> </div> </li> </ul> </div></div><div id=descriptionmodule class="module toggle-wrap"><div id="descriptionmodule_heading" class="mod-header"><button class="aui-button toggle-title" aria-label="Description" aria-controls="descriptionmodule" aria-expanded="true"><svg xmlns="http://www.w3.org/2000/svg" width="14" height="14"><g fill="none" fill-rule="evenodd"><path d="M3.29175 4.793c-.389.392-.389 1.027 0 1.419l2.939 2.965c.218.215.5.322.779.322s.556-.107.769-.322l2.93-2.955c.388-.392.388-1.027 0-1.419-.389-.392-1.018-.392-1.406 0l-2.298 2.317-2.307-2.327c-.194-.195-.449-.293-.703-.293-.255 0-.51.098-.703.293z" fill="#344563"/></g></svg></button><h4 class="toggle-title" id="descriptionmodule-label">Description</h4><ul class="ops"></ul></div><div class="mod-content"><div id="description-val" class="field-ignore-highlight"> <div class="user-content-block"> <div class="code panel" style="border-width: 1px;"><div class="codeContent panelContent"> <pre class="code-java">0: jdbc:drill:schema=dfs> select count(*) from cast_tbl_1 a, cast_tbl_2 b where a.c_timestamp = b.c_date; Query failed: RemoteRpcException: Failure <span class="code-keyword">while</span> running fragment., Failure finding function that runtime code generation expected. Signature: compare_to_nulls_high( DATE:OPTIONAL, TIMESTAMP:OPTIONAL ) returns INT:REQUIRED [ e17b546e-81ec-49f0-ac91-f5714f570971 on atsqa4-134.qa.lab:31010 ] [ e17b546e-81ec-49f0-ac91-f5714f570971 on atsqa4-134.qa.lab:31010 ] Error: exception <span class="code-keyword">while</span> executing query: Failure <span class="code-keyword">while</span> executing query. (state=,code=0) </pre> </div></div> <p>This is inconsistent with our UNION ALL implementation.</p> <div class="code panel" style="border-width: 1px;"><div class="codeContent panelContent"> <pre class="code-java">0: jdbc:drill:schema=dfs> select c_date from cast_tbl_1 union all select c_timestamp from cast_tbl_2 order by c_date limit 5; +------------+ | c_date | +------------+ | 1960-01-03 00:00:00.0 | | 1960-01-03 00:00:00.0 | | 1960-01-05 00:00:00.0 | | 1960-01-05 00:00:00.0 | | 1960-01-08 00:00:00.0 | +------------+ 5 rows selected (0.276 seconds) </pre> </div></div> </div> </div> </div></div><div id=dnd-metadata class="module toggle-wrap"><div id="dnd-metadata_heading" class="mod-header"><button class="aui-button toggle-title" aria-label="Attachments" aria-controls="dnd-metadata" aria-expanded="true"><svg xmlns="http://www.w3.org/2000/svg" width="14" height="14"><g fill="none" fill-rule="evenodd"><path d="M3.29175 4.793c-.389.392-.389 1.027 0 1.419l2.939 2.965c.218.215.5.322.779.322s.556-.107.769-.322l2.93-2.955c.388-.392.388-1.027 0-1.419-.389-.392-1.018-.392-1.406 0l-2.298 2.317-2.307-2.327c-.194-.195-.449-.293-.703-.293-.255 0-.51.098-.703.293z" fill="#344563"/></g></svg></button><h4 class="toggle-title" id="dnd-metadata-label">Attachments</h4><ul class="ops"></ul></div><div class="mod-content"><div id="dnd-metadata-webpanel" data-can-attach="false" data-project-type="software" data-upload-limit="62914560" data-thumbnails-allowed="false"></div></div></div><div id=attachmentmodule class="module toggle-wrap"><div id="attachmentmodule_heading" class="mod-header"><button class="aui-button toggle-title" aria-label="Attachments" aria-controls="attachmentmodule" aria-expanded="true"><svg xmlns="http://www.w3.org/2000/svg" width="14" height="14"><g fill="none" fill-rule="evenodd"><path d="M3.29175 4.793c-.389.392-.389 1.027 0 1.419l2.939 2.965c.218.215.5.322.779.322s.556-.107.769-.322l2.93-2.955c.388-.392.388-1.027 0-1.419-.389-.392-1.018-.392-1.406 0l-2.298 2.317-2.307-2.327c-.194-.195-.449-.293-.703-.293-.255 0-.51.098-.703.293z" fill="#344563"/></g></svg></button><h4 class="toggle-title" id="attachmentmodule-label">Attachments</h4><ul class="ops"><li class="drop"><div class="aui-dd-parent"><button class="aui-button aui-button-compact aui-button-subtle js-default-dropdown" title="Options" aria-label="Attachments panel options"><span class="aui-icon aui-icon-small aui-iconfont-more">Options</span></button><div class="aui-dropdown-content aui-list"><ul id="attachment-sorting-options"class="aui-list-section aui-first"><li class="aui-list-item"><a id="attachment-sort-key-name"href="/jira/browse/DRILL-2433?attachmentSortBy=fileName#attachmentmodule"class="aui-list-checked aui-checked aui-list-item-link"title="viewissue.subtasks.tab.show.all.name"><span>Sort By Name</span></a></li><li class="aui-list-item"><a id="attachment-sort-key-date"href="/jira/browse/DRILL-2433?attachmentSortBy=dateTime#attachmentmodule"class="aui-list-checked aui-list-item-link"title="Sort By Date"><span>Sort By Date</span></a></li></ul><ul id="attachment-sorting-order-options"class="aui-list-section aui-last"><li class="aui-list-item"><a id="attachment-sort-direction-asc"href="/jira/browse/DRILL-2433?attachmentOrder=asc#attachmentmodule"class="aui-list-checked aui-checked aui-list-item-link"title="Ascending"><span>Ascending</span></a></li><li class="aui-list-item"><a id="attachment-sort-direction-desc"href="/jira/browse/DRILL-2433?attachmentOrder=desc#attachmentmodule"class="aui-list-checked aui-list-item-link"title="Descending"><span>Descending</span></a></li></ul></div></div></li></ul></div><div class="mod-content"><ol id="file_attachments" class="item-attachments" data-sort-key="fileName" data-sort-order="asc"><li class="attachment-content js-file-attachment" data-attachment-id="12729334"data-issue-id="12781295"data-attachment-type="file"><div class="attachment-thumb"><a href="/jira/secure/attachment/12729334/DRILL-2433.patch" draggable="true" data-downloadurl="text/plain:DRILL-2433.patch:https://issues.apache.org/jira/secure/attachment/12729334/DRILL-2433.patch"><span class="aui-icon aui-icon-small attachment-icon aui-iconfont-file-txt" title="Text File"></span></a></div><dl><dt class="attachment-title"><a href="/jira/secure/attachment/12729334/DRILL-2433.patch" title="Latest 29/Apr/15 22:52 - Mehant Baid" draggable="true" data-downloadurl="text/plain:DRILL-2433.patch:https://issues.apache.org/jira/secure/attachment/12729334/DRILL-2433.patch">DRILL-2433.patch</a></dt><dd class="attachment-delete"><span class="icon"></span></dd><dd class="attachment-date"><time class="livestamp" datetime="2015-04-29T22:52:46.419Z">29/Apr/15 22:52</time></dd><dd class="attachment-size">4 kB</dd><dd class="attachment-author">Mehant Baid</dd></dl></li></ol></div></div><div id=activitymodule class="module toggle-wrap"><div id="activitymodule_heading" class="mod-header"><button class="aui-button toggle-title" aria-label="Activity" aria-controls="activitymodule" aria-expanded="true"><svg xmlns="http://www.w3.org/2000/svg" width="14" height="14"><g fill="none" fill-rule="evenodd"><path d="M3.29175 4.793c-.389.392-.389 1.027 0 1.419l2.939 2.965c.218.215.5.322.779.322s.556-.107.769-.322l2.93-2.955c.388-.392.388-1.027 0-1.419-.389-.392-1.018-.392-1.406 0l-2.298 2.317-2.307-2.327c-.194-.195-.449-.293-.703-.293-.255 0-.51.098-.703.293z" fill="#344563"/></g></svg></button><h4 class="toggle-title" id="activitymodule-label">Activity</h4><ul class="ops"></ul></div><div class="mod-content"> <big-pipe data-id="activity-panel-pipe-id" style="height: 70px"> <div></div> </big-pipe> </div></div></div><div id="viewissuesidebar" class="aui-item issue-side-column"><div id=peoplemodule class="module toggle-wrap"><div id="peoplemodule_heading" class="mod-header"><button class="aui-button toggle-title" aria-label="People" aria-controls="peoplemodule" aria-expanded="true"><svg xmlns="http://www.w3.org/2000/svg" width="14" height="14"><g fill="none" fill-rule="evenodd"><path d="M3.29175 4.793c-.389.392-.389 1.027 0 1.419l2.939 2.965c.218.215.5.322.779.322s.556-.107.769-.322l2.93-2.955c.388-.392.388-1.027 0-1.419-.389-.392-1.018-.392-1.406 0l-2.298 2.317-2.307-2.327c-.194-.195-.449-.293-.703-.293-.255 0-.51.098-.703.293z" fill="#344563"/></g></svg></button><h4 class="toggle-title" id="peoplemodule-label">People</h4><ul class="ops"></ul></div><div class="mod-content"> <div class="item-details people-details" id="peopledetails"> <dl> <dt title="Assignee"> <label for="assignee-field">Assignee:</label> </dt> <dd> <span id="assignee-val" class="view-issue-field"> <span class="user-hover" id="issue_summary_assignee_mehant" rel="mehant"> <span class="aui-avatar aui-avatar-small"><span class="aui-avatar-inner"><img src="https://issues.apache.org/jira/secure/useravatar?size=small&avatarId=10432" alt="mehant" /></span></span> Mehant Baid </span> </span> </dd> </dl> <dl> <dt title="Reporter"> <label for="reporter-field">Reporter:</label> </dt> <dd> <span id="reporter-val" class="view-issue-field"> <span class="user-hover" id="issue_summary_reporter_vicky" rel="vicky"> <span class="aui-avatar aui-avatar-small"><span class="aui-avatar-inner"><img src="https://issues.apache.org/jira/secure/useravatar?size=small&avatarId=10452" alt="vicky" /></span></span> Victoria Markman </span> </span> </dd> </dl> </div> <div class="item-details"> <dl> <dt title="Votes">Votes:</dt> <dd> <aui-badge id="vote-data" class="">0</aui-badge> <span id="vote-label" title="You have to be logged in to vote for an issue.">Vote for this issue</span> </dd> </dl> <dl> <dt title="Watchers">Watchers:</dt> <dd> <aui-badge id="watcher-data" class="">3</aui-badge> <span id="watch-label" title="You have to be logged in to watch an issue.">Start watching this issue</span> </dd> </dl> </div> </div></div><div id=datesmodule class="module toggle-wrap"><div id="datesmodule_heading" class="mod-header"><button class="aui-button toggle-title" aria-label="Dates" aria-controls="datesmodule" aria-expanded="true"><svg xmlns="http://www.w3.org/2000/svg" width="14" height="14"><g fill="none" fill-rule="evenodd"><path d="M3.29175 4.793c-.389.392-.389 1.027 0 1.419l2.939 2.965c.218.215.5.322.779.322s.556-.107.769-.322l2.93-2.955c.388-.392.388-1.027 0-1.419-.389-.392-1.018-.392-1.406 0l-2.298 2.317-2.307-2.327c-.194-.195-.449-.293-.703-.293-.255 0-.51.098-.703.293z" fill="#344563"/></g></svg></button><h4 class="toggle-title" id="datesmodule-label">Dates</h4><ul class="ops"></ul></div><div class="mod-content"> <div class="item-details"> <dl class="dates"> <dt> Created: </dt> <dd class="date user-tz" title="11/Mar/15 18:56" > <span data-name="Created" id="created-val" data-fieldtype="datetime" > <time class="livestamp" datetime="2015-03-11T18:56:28+0000">11/Mar/15 18:56</time> </span> </dd> </dl> <dl class="dates"> <dt> Updated: </dt> <dd class="date user-tz" title="12/May/15 23:20" > <span data-name="Updated" id="updated-val" data-fieldtype="datetime" > <time class="livestamp" datetime="2015-05-12T23:20:52+0000">12/May/15 23:20</time> </span> </dd> </dl> <dl class="dates"> <dt> Resolved: </dt> <dd class="date user-tz" title="06/May/15 21:38" > <span data-name="Resolved" id="resolutiondate-val" data-fieldtype="datetime" > <time class="livestamp" datetime="2015-05-06T21:38:17+0000">06/May/15 21:38</time> </span> </dd> </dl> </div> </div></div></div></div></div></div></div></div></main></div></div></div><div class="issue-navigator-init"></div> </div> <footer id="footer" role="contentinfo"> <section class="footer-body"> <ul class="atlassian-footer"> <li> Atlassian Jira <a class="seo-link" rel="nofollow" href="https://www.atlassian.com/software/jira">Project Management Software</a> </li> <li> <a id="about-link" rel="nofollow" href="/jira/secure/AboutPage.jspa/secure/AboutPage.jspa">About Jira</a> </li> <li> <a id="footer-report-problem-link" rel="nofollow" href="/jira/secure/CreateIssue!default.jspa">Report a problem</a> </li> </ul> <p class="atlassian-footer"> <span class="licensemessage"> Powered by a free Atlassian <a rel='nofollow' href='http://www.atlassian.com/software/jira'>Jira</a> open source license for Apache Software Foundation. Try Jira - <a rel='nofollow' href='http://www.atlassian.com/software/jira'>bug tracking software</a> for <i>your</i> team. </span> </p> <div id="footer-logo"><a rel="nofollow" href="http://www.atlassian.com/">Atlassian</a></div> </section> <fieldset class="hidden parameters"> <input type="hidden" title="loggedInUser" value=""> <input type="hidden" title="ajaxTimeout" value="The call to the Jira server did not complete within the timeout period. We are unsure of the result of this operation."> <input type="hidden" title="JiraVersion" value="8.20.10" /> <input type="hidden" title="ajaxUnauthorised" value="You are not authorised to perform this operation. Please log in."> <input type="hidden" title="baseURL" value="https://issues.apache.org/jira" /> <input type="hidden" title="ajaxCommsError" value="The Jira server could not be contacted. This may be a temporary glitch or the server may be down. "> <input type="hidden" title="ajaxServerError" value="The Jira server was contacted but has returned an error response. We are unsure of the result of this operation."> <input type="hidden" title="ajaxErrorCloseDialog" value="Close this dialog and press refresh in your browser"> <input type="hidden" title="ajaxErrorDialogHeading" value="Communications Breakdown"> <input type="hidden" title="dirtyMessage" value="You have entered new data on this page. If you navigate away from this page without first saving your data, the changes will be lost."> <input type="hidden" title="dirtyDialogMessage" value="You have entered new data in this dialog. If you navigate away from this dialog without first saving your data, the changes will be lost. Click cancel to return to the dialog."> <input type="hidden" title="keyType" value="Type"> <input type="hidden" title="keyThen" value="then"> <input type="hidden" title="dblClickToExpand" value="Double click to expand"> <input type="hidden" title="actions" value="Actions"> <input type="hidden" title="removeItem" value="Remove"> <input type="hidden" title="workflow" value="Workflow"> <input type="hidden" title="labelNew" value="New Label"> <input type="hidden" title="issueActionsHint" value="Begin typing for available operations or press down to see all"> <input type="hidden" title="closelink" value="Close"> <input type="hidden" title="dotOperations" value="Operations"> <input type="hidden" title="dotLoading" value="Loading..."> <input type="hidden" title="frotherSuggestions" value="Suggestions"> <input type="hidden" title="frotherNomatches" value="No Matches"> <input type="hidden" title="multiselectVersionsError" value="{0} is not a valid version."> <input type="hidden" title="multiselectComponentsError" value="{0} is not a valid component."> <input type="hidden" title="multiselectGenericError" value="The value {0} is invalid."> </fieldset> </footer> </div> <script type="text/javascript" src="/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-lmkfjk/820010/13pdxe5/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js" data-wrm-key="jira.webresources:bigpipe-js" data-wrm-batch-type="resource" data-initially-rendered></script> <script> window.WRM=window.WRM||{};window.WRM._unparsedData=window.WRM._unparsedData||{};window.WRM._unparsedErrors=window.WRM._unparsedErrors||{}; WRM._unparsedData["activity-panel-pipe-id"]="\"\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n\\n \u003cdiv class=\\\"tabwrap aui-tabs horizontal-tabs aui-tabs-disabled\\\"\u003e\\n\\n \u003cul id=\\\"issue-tabs\\\" class=\\\"tabs-menu\\\"\u003e\\n \\n \u003cli class=\\\"menu-item \\\"\\n id=\\\"all-tabpanel\\\"\\n data-id=\\\"all-tabpanel\\\"\\n data-key=\\\"com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel\\\"\\n data-label=\\\"All\\\"\\n data-href=\\\"\\/jira\\/browse\\/DRILL-2433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel\\\"\\n \u003e\\n \u003ca id=\\\"all-tabpanel\\\" href=\\\"\\/jira\\/browse\\/DRILL-2433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel\\\" class=\\\"ajax-activity-content\\\"\u003eAll\u003c\\/a\u003e\\n \u003c\\/li\u003e\\n \\n \u003cli class=\\\"menu-item active-tab active \\\"\\n id=\\\"comment-tabpanel\\\"\\n data-id=\\\"comment-tabpanel\\\"\\n data-key=\\\"com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel\\\"\\n data-label=\\\"Comments\\\"\\n data-href=\\\"\\/jira\\/browse\\/DRILL-2433?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel\\\"\\n \u003e\\n \u003ca tabindex=\\\"0\\\"\u003eComments\u003c\\/a\u003e\\n \u003c\\/li\u003e\\n \\n \u003cli class=\\\"menu-item \\\"\\n id=\\\"worklog-tabpanel\\\"\\n data-id=\\\"worklog-tabpanel\\\"\\n data-key=\\\"com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel\\\"\\n data-label=\\\"Work Log\\\"\\n data-href=\\\"\\/jira\\/browse\\/DRILL-2433?page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel\\\"\\n \u003e\\n \u003ca id=\\\"worklog-tabpanel\\\" href=\\\"\\/jira\\/browse\\/DRILL-2433?page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel\\\" class=\\\"ajax-activity-content\\\"\u003eWork Log\u003c\\/a\u003e\\n \u003c\\/li\u003e\\n \\n \u003cli class=\\\"menu-item \\\"\\n id=\\\"changehistory-tabpanel\\\"\\n data-id=\\\"changehistory-tabpanel\\\"\\n data-key=\\\"com.atlassian.jira.plugin.system.issuetabpanels:changehistory-tabpanel\\\"\\n data-label=\\\"History\\\"\\n data-href=\\\"\\/jira\\/browse\\/DRILL-2433?page=com.atlassian.jira.plugin.system.issuetabpanels:changehistory-tabpanel\\\"\\n \u003e\\n \u003ca id=\\\"changehistory-tabpanel\\\" href=\\\"\\/jira\\/browse\\/DRILL-2433?page=com.atlassian.jira.plugin.system.issuetabpanels:changehistory-tabpanel\\\" class=\\\"ajax-activity-content\\\"\u003eHistory\u003c\\/a\u003e\\n \u003c\\/li\u003e\\n \\n \u003cli class=\\\"menu-item \\\"\\n id=\\\"activity-stream-issue-tab\\\"\\n data-id=\\\"activity-stream-issue-tab\\\"\\n data-key=\\\"com.atlassian.streams.streams-jira-plugin:activity-stream-issue-tab\\\"\\n data-label=\\\"Activity\\\"\\n data-href=\\\"\\/jira\\/browse\\/DRILL-2433?page=com.atlassian.streams.streams-jira-plugin:activity-stream-issue-tab\\\"\\n \u003e\\n \u003ca id=\\\"activity-stream-issue-tab\\\" href=\\\"\\/jira\\/browse\\/DRILL-2433?page=com.atlassian.streams.streams-jira-plugin:activity-stream-issue-tab\\\" class=\\\"ajax-activity-content\\\"\u003eActivity\u003c\\/a\u003e\\n \u003c\\/li\u003e\\n \\n \u003cli class=\\\"menu-item \\\"\\n id=\\\"transitions-summary-tabpanel\\\"\\n data-id=\\\"transitions-summary-tabpanel\\\"\\n data-key=\\\"com.googlecode.jira-suite-utilities:transitions-summary-tabpanel\\\"\\n data-label=\\\"Transitions\\\"\\n data-href=\\\"\\/jira\\/browse\\/DRILL-2433?page=com.googlecode.jira-suite-utilities:transitions-summary-tabpanel\\\"\\n \u003e\\n \u003ca id=\\\"transitions-summary-tabpanel\\\" href=\\\"\\/jira\\/browse\\/DRILL-2433?page=com.googlecode.jira-suite-utilities:transitions-summary-tabpanel\\\" class=\\\"ajax-activity-content\\\"\u003eTransitions\u003c\\/a\u003e\\n \u003c\\/li\u003e\\n \u003c\\/ul\u003e\\n\\n \u003cdiv class=\\\"sortwrap\\\"\u003e\\n \u003ca class=\\\"issue-activity-sort-link ajax-activity-content\\\" rel=\\\"nofollow\\\" data-tab-sort data-order=\\\"desc\\\" href=\\\"\\/jira\\/browse\\/DRILL-2433?actionOrder=desc\\\" title=\\\"Ascending order - Click to sort in descending order\\\"\u003e\\n \u003cspan class=\\\"aui-icon aui-icon-small aui-iconfont-up\\\"\u003eAscending order - Click to sort in descending order\u003c\\/span\u003e\\n \u003c\\/a\u003e\\n \u003c\\/div\u003e\\n \u003cdiv class=\\\"tabs-pane active-pane\\\"\u003e\u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003cdiv class=\\\"issuePanelWrapper\\\"\u003e\\n \u003cdiv class=\\\"issuePanelProgress\\\"\u003e\u003c\\/div\u003e\\n \u003cdiv class=\\\"issuePanelContainer\\\" id=\\\"issue_actions_container\\\"\u003e\\n \\n\\n\\n\u003cdiv id=\\\"comment-14520173\\\" class=\\\"issue-data-block activity-comment twixi-block expanded\\\"\u003e\\n \u003cdiv class=\\\"twixi-wrap verbose actionContainer\\\"\u003e\\n \u003cdiv class=\\\"action-head\\\"\u003e\\n \u003cbutton aria-label=\\\"Collapse comment\\\" title=\\\"Collapse comment\\\" class=\\\"twixi icon-default aui-icon aui-icon-small aui-iconfont-expanded\\\"\u003e\u003c\\/button\u003e\\n \u003cdiv class=\\\"action-details\\\"\u003e \\n \\n \\n \\n \\n\\n \u003ca class=\\\"user-hover user-avatar\\\" rel=\\\"mehant\\\" id=\\\"commentauthor_14520173_verbose\\\" href=\\\"\\/jira\\/secure\\/ViewProfile.jspa?name=mehant\\\"\u003e\u003cspan class=\\\"aui-avatar aui-avatar-xsmall\\\"\u003e\u003cspan class=\\\"aui-avatar-inner\\\"\u003e\u003cimg src=\\\"https:\\/\\/issues.apache.org\\/jira\\/secure\\/useravatar?size=xsmall&avatarId=10432\\\" alt=\\\"mehant\\\" \\/\u003e\u003c\\/span\u003e\u003c\\/span\u003e Mehant Baid\u003c\\/a\u003e\\n added a comment - \u003ca href=\'\\/jira\\/browse\\/DRILL-2433?focusedCommentId=14520173&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14520173\' class=\'commentdate_14520173_verbose subText comment-created-date-link\'\u003e\u003cspan class=\'date user-tz\' title=\'29\\/Apr\\/15 20:35\'\u003e\u003ctime class=\'livestamp\' datetime=\'2015-04-29T20:35:11+0000\'\u003e29\\/Apr\\/15 20:35\u003c\\/time\u003e\u003c\\/span\u003e\u003c\\/a\u003e \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003cdiv class=\\\"action-body flooded\\\"\u003e\u003cp\u003eMinor change to allow implicit cast between date and timestamp in a join condition. Since both Date and Timestamp are internally stored as \'long\' no changes need to be made to the distribution function itself (hash64).\u003c\\/p\u003e\\n\\n\u003cp\u003e\u003ca href=\\\"https:\\/\\/issues.apache.org\\/jira\\/secure\\/ViewProfile.jspa?name=amansinha100\\\" class=\\\"user-hover\\\" rel=\\\"amansinha100\\\"\u003eamansinha100\u003c\\/a\u003e can you please review. \u003c\\/p\u003e \u003c\\/div\u003e\\n \u003cdiv class=\\\"action-links action-comment-actions\\\"\u003e\\n \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003cdiv class=\\\"twixi-wrap concise actionContainer\\\"\u003e\\n \u003cdiv class=\\\"action-head\\\"\u003e\\n \u003cbutton aria-label=\\\"Expand comment\\\" title=\\\"Expand comment\\\" class=\\\"twixi icon-default aui-icon aui-icon-small aui-iconfont-collapsed\\\"\u003e\u003c\\/button\u003e\\n \u003cdiv class=\\\"action-details flooded\\\"\u003e\\n \\n \\n \\n \\n \\n\\n \u003ca class=\\\"user-hover user-avatar\\\" rel=\\\"mehant\\\" id=\\\"commentauthor_14520173_concise\\\" href=\\\"\\/jira\\/secure\\/ViewProfile.jspa?name=mehant\\\"\u003e\u003cspan class=\\\"aui-avatar aui-avatar-xsmall\\\"\u003e\u003cspan class=\\\"aui-avatar-inner\\\"\u003e\u003cimg src=\\\"https:\\/\\/issues.apache.org\\/jira\\/secure\\/useravatar?size=xsmall&avatarId=10432\\\" alt=\\\"mehant\\\" \\/\u003e\u003c\\/span\u003e\u003c\\/span\u003e Mehant Baid\u003c\\/a\u003e\\n added a comment - \u003ca href=\'\\/jira\\/browse\\/DRILL-2433?focusedCommentId=14520173&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14520173\' class=\'commentdate_14520173_concise subText comment-created-date-link\'\u003e\u003cspan class=\'date user-tz\' title=\'29\\/Apr\\/15 20:35\'\u003e\u003ctime class=\'livestamp\' datetime=\'2015-04-29T20:35:11+0000\'\u003e29\\/Apr\\/15 20:35\u003c\\/time\u003e\u003c\\/span\u003e\u003c\\/a\u003e Minor change to allow implicit cast between date and timestamp in a join condition. Since both Date and Timestamp are internally stored as \'long\' no changes need to be made to the distribution function itself (hash64). \\n\\n amansinha100 can you please review. \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n\u003c\\/div\u003e\\n \\n\\n\\n\u003cdiv id=\\\"comment-14520397\\\" class=\\\"issue-data-block activity-comment twixi-block expanded\\\"\u003e\\n \u003cdiv class=\\\"twixi-wrap verbose actionContainer\\\"\u003e\\n \u003cdiv class=\\\"action-head\\\"\u003e\\n \u003cbutton aria-label=\\\"Collapse comment\\\" title=\\\"Collapse comment\\\" class=\\\"twixi icon-default aui-icon aui-icon-small aui-iconfont-expanded\\\"\u003e\u003c\\/button\u003e\\n \u003cdiv class=\\\"action-details\\\"\u003e \\n \\n \\n \\n \\n\\n \u003ca class=\\\"user-hover user-avatar\\\" rel=\\\"amansinha100\\\" id=\\\"commentauthor_14520397_verbose\\\" href=\\\"\\/jira\\/secure\\/ViewProfile.jspa?name=amansinha100\\\"\u003e\u003cspan class=\\\"aui-avatar aui-avatar-xsmall\\\"\u003e\u003cspan class=\\\"aui-avatar-inner\\\"\u003e\u003cimg src=\\\"https:\\/\\/issues.apache.org\\/jira\\/secure\\/useravatar?size=xsmall&avatarId=10452\\\" alt=\\\"amansinha100\\\" \\/\u003e\u003c\\/span\u003e\u003c\\/span\u003e Aman Sinha\u003c\\/a\u003e\\n added a comment - \u003ca href=\'\\/jira\\/browse\\/DRILL-2433?focusedCommentId=14520397&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14520397\' class=\'commentdate_14520397_verbose subText comment-created-date-link\'\u003e\u003cspan class=\'date user-tz\' title=\'29\\/Apr\\/15 22:19\'\u003e\u003ctime class=\'livestamp\' datetime=\'2015-04-29T22:19:13+0000\'\u003e29\\/Apr\\/15 22:19\u003c\\/time\u003e\u003c\\/span\u003e\u003c\\/a\u003e \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003cdiv class=\\\"action-body flooded\\\"\u003e\u003cp\u003eCan you change the EXPR$0 to a named column ? We should preferably not use internal names in the queries. \u003c\\/p\u003e \u003c\\/div\u003e\\n \u003cdiv class=\\\"action-links action-comment-actions\\\"\u003e\\n \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003cdiv class=\\\"twixi-wrap concise actionContainer\\\"\u003e\\n \u003cdiv class=\\\"action-head\\\"\u003e\\n \u003cbutton aria-label=\\\"Expand comment\\\" title=\\\"Expand comment\\\" class=\\\"twixi icon-default aui-icon aui-icon-small aui-iconfont-collapsed\\\"\u003e\u003c\\/button\u003e\\n \u003cdiv class=\\\"action-details flooded\\\"\u003e\\n \\n \\n \\n \\n \\n\\n \u003ca class=\\\"user-hover user-avatar\\\" rel=\\\"amansinha100\\\" id=\\\"commentauthor_14520397_concise\\\" href=\\\"\\/jira\\/secure\\/ViewProfile.jspa?name=amansinha100\\\"\u003e\u003cspan class=\\\"aui-avatar aui-avatar-xsmall\\\"\u003e\u003cspan class=\\\"aui-avatar-inner\\\"\u003e\u003cimg src=\\\"https:\\/\\/issues.apache.org\\/jira\\/secure\\/useravatar?size=xsmall&avatarId=10452\\\" alt=\\\"amansinha100\\\" \\/\u003e\u003c\\/span\u003e\u003c\\/span\u003e Aman Sinha\u003c\\/a\u003e\\n added a comment - \u003ca href=\'\\/jira\\/browse\\/DRILL-2433?focusedCommentId=14520397&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14520397\' class=\'commentdate_14520397_concise subText comment-created-date-link\'\u003e\u003cspan class=\'date user-tz\' title=\'29\\/Apr\\/15 22:19\'\u003e\u003ctime class=\'livestamp\' datetime=\'2015-04-29T22:19:13+0000\'\u003e29\\/Apr\\/15 22:19\u003c\\/time\u003e\u003c\\/span\u003e\u003c\\/a\u003e Can you change the EXPR$0 to a named column ? We should preferably not use internal names in the queries. \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n\u003c\\/div\u003e\\n \\n\\n\\n\u003cdiv id=\\\"comment-14520454\\\" class=\\\"issue-data-block activity-comment twixi-block expanded\\\"\u003e\\n \u003cdiv class=\\\"twixi-wrap verbose actionContainer\\\"\u003e\\n \u003cdiv class=\\\"action-head\\\"\u003e\\n \u003cbutton aria-label=\\\"Collapse comment\\\" title=\\\"Collapse comment\\\" class=\\\"twixi icon-default aui-icon aui-icon-small aui-iconfont-expanded\\\"\u003e\u003c\\/button\u003e\\n \u003cdiv class=\\\"action-details\\\"\u003e \\n \\n \\n \\n \\n\\n \u003ca class=\\\"user-hover user-avatar\\\" rel=\\\"mehant\\\" id=\\\"commentauthor_14520454_verbose\\\" href=\\\"\\/jira\\/secure\\/ViewProfile.jspa?name=mehant\\\"\u003e\u003cspan class=\\\"aui-avatar aui-avatar-xsmall\\\"\u003e\u003cspan class=\\\"aui-avatar-inner\\\"\u003e\u003cimg src=\\\"https:\\/\\/issues.apache.org\\/jira\\/secure\\/useravatar?size=xsmall&avatarId=10432\\\" alt=\\\"mehant\\\" \\/\u003e\u003c\\/span\u003e\u003c\\/span\u003e Mehant Baid\u003c\\/a\u003e\\n added a comment - \u003ca href=\'\\/jira\\/browse\\/DRILL-2433?focusedCommentId=14520454&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14520454\' class=\'commentdate_14520454_verbose subText comment-created-date-link\'\u003e\u003cspan class=\'date user-tz\' title=\'29\\/Apr\\/15 22:52\'\u003e\u003ctime class=\'livestamp\' datetime=\'2015-04-29T22:52:46+0000\'\u003e29\\/Apr\\/15 22:52\u003c\\/time\u003e\u003c\\/span\u003e\u003c\\/a\u003e \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003cdiv class=\\\"action-body flooded\\\"\u003e\u003cp\u003eUpdated patch with review comment\u003c\\/p\u003e \u003c\\/div\u003e\\n \u003cdiv class=\\\"action-links action-comment-actions\\\"\u003e\\n \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003cdiv class=\\\"twixi-wrap concise actionContainer\\\"\u003e\\n \u003cdiv class=\\\"action-head\\\"\u003e\\n \u003cbutton aria-label=\\\"Expand comment\\\" title=\\\"Expand comment\\\" class=\\\"twixi icon-default aui-icon aui-icon-small aui-iconfont-collapsed\\\"\u003e\u003c\\/button\u003e\\n \u003cdiv class=\\\"action-details flooded\\\"\u003e\\n \\n \\n \\n \\n \\n\\n \u003ca class=\\\"user-hover user-avatar\\\" rel=\\\"mehant\\\" id=\\\"commentauthor_14520454_concise\\\" href=\\\"\\/jira\\/secure\\/ViewProfile.jspa?name=mehant\\\"\u003e\u003cspan class=\\\"aui-avatar aui-avatar-xsmall\\\"\u003e\u003cspan class=\\\"aui-avatar-inner\\\"\u003e\u003cimg src=\\\"https:\\/\\/issues.apache.org\\/jira\\/secure\\/useravatar?size=xsmall&avatarId=10432\\\" alt=\\\"mehant\\\" \\/\u003e\u003c\\/span\u003e\u003c\\/span\u003e Mehant Baid\u003c\\/a\u003e\\n added a comment - \u003ca href=\'\\/jira\\/browse\\/DRILL-2433?focusedCommentId=14520454&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14520454\' class=\'commentdate_14520454_concise subText comment-created-date-link\'\u003e\u003cspan class=\'date user-tz\' title=\'29\\/Apr\\/15 22:52\'\u003e\u003ctime class=\'livestamp\' datetime=\'2015-04-29T22:52:46+0000\'\u003e29\\/Apr\\/15 22:52\u003c\\/time\u003e\u003c\\/span\u003e\u003c\\/a\u003e Updated patch with review comment \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n\u003c\\/div\u003e\\n \\n\\n\\n\u003cdiv id=\\\"comment-14520492\\\" class=\\\"issue-data-block activity-comment twixi-block expanded\\\"\u003e\\n \u003cdiv class=\\\"twixi-wrap verbose actionContainer\\\"\u003e\\n \u003cdiv class=\\\"action-head\\\"\u003e\\n \u003cbutton aria-label=\\\"Collapse comment\\\" title=\\\"Collapse comment\\\" class=\\\"twixi icon-default aui-icon aui-icon-small aui-iconfont-expanded\\\"\u003e\u003c\\/button\u003e\\n \u003cdiv class=\\\"action-details\\\"\u003e \\n \\n \\n \\n \\n\\n \u003ca class=\\\"user-hover user-avatar\\\" rel=\\\"amansinha100\\\" id=\\\"commentauthor_14520492_verbose\\\" href=\\\"\\/jira\\/secure\\/ViewProfile.jspa?name=amansinha100\\\"\u003e\u003cspan class=\\\"aui-avatar aui-avatar-xsmall\\\"\u003e\u003cspan class=\\\"aui-avatar-inner\\\"\u003e\u003cimg src=\\\"https:\\/\\/issues.apache.org\\/jira\\/secure\\/useravatar?size=xsmall&avatarId=10452\\\" alt=\\\"amansinha100\\\" \\/\u003e\u003c\\/span\u003e\u003c\\/span\u003e Aman Sinha\u003c\\/a\u003e\\n added a comment - \u003ca href=\'\\/jira\\/browse\\/DRILL-2433?focusedCommentId=14520492&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14520492\' class=\'commentdate_14520492_verbose subText comment-created-date-link\'\u003e\u003cspan class=\'date user-tz\' title=\'29\\/Apr\\/15 23:16\'\u003e\u003ctime class=\'livestamp\' datetime=\'2015-04-29T23:16:39+0000\'\u003e29\\/Apr\\/15 23:16\u003c\\/time\u003e\u003c\\/span\u003e\u003c\\/a\u003e \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003cdiv class=\\\"action-body flooded\\\"\u003e\u003cp\u003e+1 . \u003c\\/p\u003e \u003c\\/div\u003e\\n \u003cdiv class=\\\"action-links action-comment-actions\\\"\u003e\\n \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003cdiv class=\\\"twixi-wrap concise actionContainer\\\"\u003e\\n \u003cdiv class=\\\"action-head\\\"\u003e\\n \u003cbutton aria-label=\\\"Expand comment\\\" title=\\\"Expand comment\\\" class=\\\"twixi icon-default aui-icon aui-icon-small aui-iconfont-collapsed\\\"\u003e\u003c\\/button\u003e\\n \u003cdiv class=\\\"action-details flooded\\\"\u003e\\n \\n \\n \\n \\n \\n\\n \u003ca class=\\\"user-hover user-avatar\\\" rel=\\\"amansinha100\\\" id=\\\"commentauthor_14520492_concise\\\" href=\\\"\\/jira\\/secure\\/ViewProfile.jspa?name=amansinha100\\\"\u003e\u003cspan class=\\\"aui-avatar aui-avatar-xsmall\\\"\u003e\u003cspan class=\\\"aui-avatar-inner\\\"\u003e\u003cimg src=\\\"https:\\/\\/issues.apache.org\\/jira\\/secure\\/useravatar?size=xsmall&avatarId=10452\\\" alt=\\\"amansinha100\\\" \\/\u003e\u003c\\/span\u003e\u003c\\/span\u003e Aman Sinha\u003c\\/a\u003e\\n added a comment - \u003ca href=\'\\/jira\\/browse\\/DRILL-2433?focusedCommentId=14520492&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14520492\' class=\'commentdate_14520492_concise subText comment-created-date-link\'\u003e\u003cspan class=\'date user-tz\' title=\'29\\/Apr\\/15 23:16\'\u003e\u003ctime class=\'livestamp\' datetime=\'2015-04-29T23:16:39+0000\'\u003e29\\/Apr\\/15 23:16\u003c\\/time\u003e\u003c\\/span\u003e\u003c\\/a\u003e +1 . \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n\u003c\\/div\u003e\\n \\n\\n\\n\u003cdiv id=\\\"comment-14531480\\\" class=\\\"issue-data-block activity-comment twixi-block expanded\\\"\u003e\\n \u003cdiv class=\\\"twixi-wrap verbose actionContainer\\\"\u003e\\n \u003cdiv class=\\\"action-head\\\"\u003e\\n \u003cbutton aria-label=\\\"Collapse comment\\\" title=\\\"Collapse comment\\\" class=\\\"twixi icon-default aui-icon aui-icon-small aui-iconfont-expanded\\\"\u003e\u003c\\/button\u003e\\n \u003cdiv class=\\\"action-details\\\"\u003e \\n \\n \\n \\n \\n\\n \u003ca class=\\\"user-hover user-avatar\\\" rel=\\\"mehant\\\" id=\\\"commentauthor_14531480_verbose\\\" href=\\\"\\/jira\\/secure\\/ViewProfile.jspa?name=mehant\\\"\u003e\u003cspan class=\\\"aui-avatar aui-avatar-xsmall\\\"\u003e\u003cspan class=\\\"aui-avatar-inner\\\"\u003e\u003cimg src=\\\"https:\\/\\/issues.apache.org\\/jira\\/secure\\/useravatar?size=xsmall&avatarId=10432\\\" alt=\\\"mehant\\\" \\/\u003e\u003c\\/span\u003e\u003c\\/span\u003e Mehant Baid\u003c\\/a\u003e\\n added a comment - \u003ca href=\'\\/jira\\/browse\\/DRILL-2433?focusedCommentId=14531480&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14531480\' class=\'commentdate_14531480_verbose subText comment-created-date-link\'\u003e\u003cspan class=\'date user-tz\' title=\'06\\/May\\/15 21:38\'\u003e\u003ctime class=\'livestamp\' datetime=\'2015-05-06T21:38:18+0000\'\u003e06\\/May\\/15 21:38\u003c\\/time\u003e\u003c\\/span\u003e\u003c\\/a\u003e \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003cdiv class=\\\"action-body flooded\\\"\u003e\u003cp\u003eFixed in 31e51832db216ca16525af83abd445b812c569c4\u003c\\/p\u003e \u003c\\/div\u003e\\n \u003cdiv class=\\\"action-links action-comment-actions\\\"\u003e\\n \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003cdiv class=\\\"twixi-wrap concise actionContainer\\\"\u003e\\n \u003cdiv class=\\\"action-head\\\"\u003e\\n \u003cbutton aria-label=\\\"Expand comment\\\" title=\\\"Expand comment\\\" class=\\\"twixi icon-default aui-icon aui-icon-small aui-iconfont-collapsed\\\"\u003e\u003c\\/button\u003e\\n \u003cdiv class=\\\"action-details flooded\\\"\u003e\\n \\n \\n \\n \\n \\n\\n \u003ca class=\\\"user-hover user-avatar\\\" rel=\\\"mehant\\\" id=\\\"commentauthor_14531480_concise\\\" href=\\\"\\/jira\\/secure\\/ViewProfile.jspa?name=mehant\\\"\u003e\u003cspan class=\\\"aui-avatar aui-avatar-xsmall\\\"\u003e\u003cspan class=\\\"aui-avatar-inner\\\"\u003e\u003cimg src=\\\"https:\\/\\/issues.apache.org\\/jira\\/secure\\/useravatar?size=xsmall&avatarId=10432\\\" alt=\\\"mehant\\\" \\/\u003e\u003c\\/span\u003e\u003c\\/span\u003e Mehant Baid\u003c\\/a\u003e\\n added a comment - \u003ca href=\'\\/jira\\/browse\\/DRILL-2433?focusedCommentId=14531480&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14531480\' class=\'commentdate_14531480_concise subText comment-created-date-link\'\u003e\u003cspan class=\'date user-tz\' title=\'06\\/May\\/15 21:38\'\u003e\u003ctime class=\'livestamp\' datetime=\'2015-05-06T21:38:18+0000\'\u003e06\\/May\\/15 21:38\u003c\\/time\u003e\u003c\\/span\u003e\u003c\\/a\u003e Fixed in 31e51832db216ca16525af83abd445b812c569c4 \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n\u003c\\/div\u003e\\n \\n\\n\\n\u003cdiv id=\\\"comment-14540990\\\" class=\\\"issue-data-block activity-comment twixi-block expanded\\\"\u003e\\n \u003cdiv class=\\\"twixi-wrap verbose actionContainer\\\"\u003e\\n \u003cdiv class=\\\"action-head\\\"\u003e\\n \u003cbutton aria-label=\\\"Collapse comment\\\" title=\\\"Collapse comment\\\" class=\\\"twixi icon-default aui-icon aui-icon-small aui-iconfont-expanded\\\"\u003e\u003c\\/button\u003e\\n \u003cdiv class=\\\"action-details\\\"\u003e \\n \\n \\n \\n \\n\\n \u003ca class=\\\"user-hover user-avatar\\\" rel=\\\"vicky\\\" id=\\\"commentauthor_14540990_verbose\\\" href=\\\"\\/jira\\/secure\\/ViewProfile.jspa?name=vicky\\\"\u003e\u003cspan class=\\\"aui-avatar aui-avatar-xsmall\\\"\u003e\u003cspan class=\\\"aui-avatar-inner\\\"\u003e\u003cimg src=\\\"https:\\/\\/issues.apache.org\\/jira\\/secure\\/useravatar?size=xsmall&avatarId=10452\\\" alt=\\\"vicky\\\" \\/\u003e\u003c\\/span\u003e\u003c\\/span\u003e Victoria Markman\u003c\\/a\u003e\\n added a comment - \u003ca href=\'\\/jira\\/browse\\/DRILL-2433?focusedCommentId=14540990&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14540990\' class=\'commentdate_14540990_verbose subText comment-created-date-link\'\u003e\u003cspan class=\'date user-tz\' title=\'12\\/May\\/15 23:20\'\u003e\u003ctime class=\'livestamp\' datetime=\'2015-05-12T23:20:45+0000\'\u003e12\\/May\\/15 23:20\u003c\\/time\u003e\u003c\\/span\u003e\u003c\\/a\u003e \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003cdiv class=\\\"action-body flooded\\\"\u003e\u003cp\u003eVerified fixed in 1.0.0\u003c\\/p\u003e\\n\\n\u003cp\u003e#Tue May 12 12:29:50 EDT 2015\u003cbr\\/\u003e\\ngit.commit.id.abbrev=d10769f\u003c\\/p\u003e\\n\\n\u003cp\u003eTests are checked in under: Functional\\/Passing\\/joins\\/implicit_cast\u003c\\/p\u003e \u003c\\/div\u003e\\n \u003cdiv class=\\\"action-links action-comment-actions\\\"\u003e\\n \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003cdiv class=\\\"twixi-wrap concise actionContainer\\\"\u003e\\n \u003cdiv class=\\\"action-head\\\"\u003e\\n \u003cbutton aria-label=\\\"Expand comment\\\" title=\\\"Expand comment\\\" class=\\\"twixi icon-default aui-icon aui-icon-small aui-iconfont-collapsed\\\"\u003e\u003c\\/button\u003e\\n \u003cdiv class=\\\"action-details flooded\\\"\u003e\\n \\n \\n \\n \\n \\n\\n \u003ca class=\\\"user-hover user-avatar\\\" rel=\\\"vicky\\\" id=\\\"commentauthor_14540990_concise\\\" href=\\\"\\/jira\\/secure\\/ViewProfile.jspa?name=vicky\\\"\u003e\u003cspan class=\\\"aui-avatar aui-avatar-xsmall\\\"\u003e\u003cspan class=\\\"aui-avatar-inner\\\"\u003e\u003cimg src=\\\"https:\\/\\/issues.apache.org\\/jira\\/secure\\/useravatar?size=xsmall&avatarId=10452\\\" alt=\\\"vicky\\\" \\/\u003e\u003c\\/span\u003e\u003c\\/span\u003e Victoria Markman\u003c\\/a\u003e\\n added a comment - \u003ca href=\'\\/jira\\/browse\\/DRILL-2433?focusedCommentId=14540990&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-14540990\' class=\'commentdate_14540990_concise subText comment-created-date-link\'\u003e\u003cspan class=\'date user-tz\' title=\'12\\/May\\/15 23:20\'\u003e\u003ctime class=\'livestamp\' datetime=\'2015-05-12T23:20:45+0000\'\u003e12\\/May\\/15 23:20\u003c\\/time\u003e\u003c\\/span\u003e\u003c\\/a\u003e Verified fixed in 1.0.0 \\n\\n #Tue May 12 12:29:50 EDT 2015 \\ngit.commit.id.abbrev=d10769f \\n\\n Tests are checked in under: Functional\\/Passing\\/joins\\/implicit_cast \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n\u003c\\/div\u003e\\n \u003c\\/div\u003e\\n \u003c\\/div\u003e\\n\""; if(window.WRM._dataArrived)window.WRM._dataArrived();</script> <script> window.WRM=window.WRM||{};window.WRM._unparsedData=window.WRM._unparsedData||{};window.WRM._unparsedErrors=window.WRM._unparsedErrors||{}; WRM._unparsedData["scope-filter-data"]="{\"createScopeActions\":[],\"scopes\":[]}"; WRM._unparsedData["sidebar-collapsed-by-default"]="true"; WRM._unparsedData["com.atlassian.jira.projects.shortcuts:can-manage"]="false"; WRM._unparsedData["com.atlassian.jira.projects.shortcuts:with-icons"]="false"; WRM._unparsedData["com.atlassian.jira.projects.shortcuts:shortcuts"]="[]"; WRM._unparsedData["com.atlassian.jira.projects.shortcuts:project-id"]="12313820"; WRM._unparsedData["sidebar-id"]="\"\u003csection class=\\\"aui-sidebar projects-sidebar sidebar-pending\\\" \u003e\u003cdiv class=\\\"aui-sidebar-wrapper\\\"\u003e\u003cdiv class=\\\"aui-sidebar-body\\\"\u003e\u003cdiv class=\\\"aui-page-header\\\" \u003e\u003cdiv class=\\\"aui-page-header-inner\\\"\u003e\u003cdiv class=\\\"aui-page-header-image\\\" \u003e\u003ca href=\\\"\\/jira\\/projects\\/DRILL\\/summary\\\" title=\\\"Apache Drill\\\" class=\\\"jira-project-avatar\\\"\u003e\u003cspan class=\\\"aui-avatar aui-avatar-large aui-avatar-project\\\"\u003e\u003cspan class=\\\"aui-avatar-inner\\\"\u003e\u003cimg src=\\\"\\/jira\\/secure\\/projectavatar?pid=12313820&avatarId=34732\\\" alt=\\\"Apache Drill\\\" \\/\u003e\u003c\\/span\u003e\u003c\\/span\u003e\u003cimg src=\\\"data:image\\/svg+xml;base64,PHN2ZyB3aWR0aD0iNzIiIGhlaWdodD0iNzIiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+PGcgZmlsbD0ibm9uZSIgZmlsbC1ydWxlPSJldmVub2RkIj48Y2lyY2xlIGZpbGw9IiNFRDZGMDAiIGN4PSIzNiIgY3k9IjM2IiByPSIzNiIvPjxwYXRoIGQ9Ik0yOS42OCA0OS42MTdhMy4xOTQgMy4xOTQgMCAwMS0yLjI2My0uOTM3TDE3LjExMyAzOC4zNzVhMy44MyAzLjgzIDAgMDEwLTUuNGwxMC4wNC0xMC4wNGEzLjIwOSAzLjIwOSAwIDAxNC41MjggMCAzLjIwNiAzLjIwNiAwIDAxMCA0LjUyOGwtOC4yMTUgOC4yMTMgOC40NzkgOC40OGEzLjIwMSAzLjIwMSAwIDAxLTIuMjY0IDUuNDZNNTAuNjYzIDM3LjQ5NmwuMDE2LjAxNi0uMDE2LS4wMTZ6bS04LjAzNSAxMi4xMmEzLjE5OCAzLjE5OCAwIDAxLTIuMjYyLTUuNDYxbDguNDc3LTguNDgtOC4yMS04LjIxNGEzLjIgMy4yIDAgMDEwLTQuNTI2IDMuMiAzLjIgMCAwMTQuNTIyLjAwMmwxMC4wNCAxMC4wNGEzLjc3NCAzLjc3NCAwIDAxMS4xMiAyLjY5IDMuNzg2IDMuNzg2IDAgMDEtMS4xMiAyLjcwOEw0NC44OSA0OC42OGEzLjE4NiAzLjE4NiAwIDAxLTIuMjYyLjkzN3oiIGZpbGw9IiNGRkYiLz48L2c+PC9zdmc+\\\" alt=\\\"Project Type: software\\\" class=\\\"jira-project-avatar-icon\\\" \\/\u003e\u003c\\/a\u003e\u003c\\/div\u003e\u003cdiv class=\\\"aui-page-header-main\\\" \u003e\u003ch1\u003e\u003cdiv class=\\\"aui-group aui-group-split\\\"\u003e\u003cdiv class=\\\"aui-item project-title\\\"\u003e\u003ca href=\\\"\\/jira\\/projects\\/DRILL\\/summary\\\" title=\\\"Apache Drill\\\"\u003eApache Drill\u003c\\/a\u003e\u003c\\/div\u003e\u003c\\/div\u003e\u003c\\/h1\u003e\u003c\\/div\u003e\u003cdiv class=\\\"aui-page-header-main scopeFilterContainer\\\" \u003e\u003c\\/div\u003e\u003c\\/div\u003e\u003c\\/div\u003e\u003cnav class=\\\"aui-navgroup aui-navgroup-vertical\\\"\u003e\u003cdiv class=\\\"aui-navgroup-inner sidebar-content-container jira-navigation\\\"\u003e\u003cdiv class=\\\"aui-sidebar-group aui-sidebar-group-tier-one\\\" data-id=\\\"sidebar-navigation-panel\\\"\u003e\u003cul class=\\\"aui-nav\\\"\u003e\u003cli class=\\\"aui-nav-selected\\\" \u003e\u003ca class=\\\"aui-nav-item \\\" href=\\\"\\/jira\\/projects\\/DRILL\\/issues\\\" data-link-id=\\\"com.atlassian.jira.jira-projects-issue-navigator:sidebar-issue-navigator\\\" \u003e\u003cspan class=\\\"aui-icon aui-icon-large icon-sidebar-issues aui-iconfont-issues\\\"\u003e\u003c\\/span\u003e\u003cspan class=\\\"aui-nav-item-label\\\" title=\\\"Issues\\\"\u003eIssues\u003c\\/span\u003e\u003c\\/a\u003e\u003c\\/li\u003e\u003cli \u003e\u003ca class=\\\"aui-nav-item \\\" href=\\\"\\/jira\\/projects\\/DRILL?selectedItem=com.atlassian.jira.jira-projects-plugin:report-page\\\" data-link-id=\\\"com.atlassian.jira.jira-projects-plugin:report-page\\\" \u003e\u003cspan class=\\\"aui-icon aui-icon-large agile-icon-report aui-iconfont-graph-line\\\"\u003e\u003c\\/span\u003e\u003cspan class=\\\"aui-nav-item-label\\\" title=\\\"Reports\\\"\u003eReports\u003c\\/span\u003e\u003c\\/a\u003e\u003c\\/li\u003e\u003cli \u003e\u003ca class=\\\"aui-nav-item \\\" href=\\\"\\/jira\\/projects\\/DRILL?selectedItem=com.atlassian.jira.jira-projects-plugin:components-page\\\" data-link-id=\\\"com.atlassian.jira.jira-projects-plugin:components-page\\\" \u003e\u003cspan class=\\\"aui-icon aui-icon-large icon-sidebar-components\\\"\u003e\u003c\\/span\u003e\u003cspan class=\\\"aui-nav-item-label\\\" title=\\\"Components\\\"\u003eComponents\u003c\\/span\u003e\u003c\\/a\u003e\u003c\\/li\u003e\u003cli \u003e\u003ca class=\\\"aui-nav-item \\\" href=\\\"\\/jira\\/projects\\/DRILL?selectedItem=biz.everit.jira.epic-roadmap:erfj-sidebar-roadmap\\\" data-link-id=\\\"biz.everit.jira.epic-roadmap:erfj-sidebar-roadmap\\\" \u003e\u003cspan class=\\\"aui-icon aui-icon-large erfj-icon\\\"\u003e\u003c\\/span\u003e\u003cspan class=\\\"aui-nav-item-label\\\" title=\\\"Roadmap\\\"\u003eRoadmap\u003c\\/span\u003e\u003c\\/a\u003e\u003c\\/li\u003e\u003c\\/ul\u003e\u003c\\/div\u003e\u003c\\/div\u003e\u003c\\/nav\u003e\u003c\\/div\u003e\u003cdiv class=\\\"aui-sidebar-footer\\\"\u003e\u003cbutton class=\\\"aui-button aui-button-subtle aui-sidebar-toggle aui-sidebar-footer-tipsy\\\" title=\\\"Expand sidebar ( [ )\\\" data-tooltip=\\\"Expand sidebar ( [ )\\\"\u003e\u003cspan class=\\\"aui-icon aui-icon-small aui-iconfont-chevron-double-left\\\"\u003e\u003c\\/span\u003e\u003c\\/button\u003e\u003c\\/div\u003e\u003c\\/div\u003e\u003c\\/section\u003e\""; if(window.WRM._dataArrived)window.WRM._dataArrived();</script> <script type="text/javascript" src="/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-lmkfjk/820010/13pdxe5/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js" data-wrm-key="jira.webresources:bigpipe-init" data-wrm-batch-type="resource" data-initially-rendered></script> <form id="jira_request_timing_info" class="dont-default-focus" > <fieldset class="parameters hidden"> <input type="hidden" title="jira.request.start.millis" value="1741015852974" /> <input type="hidden" title="jira.request.server.time" value="53" /> <input type="hidden" title="jira.request.id" value="930x5252253x1" /> <input type="hidden" title="jira.session.expiry.time" value="-" /> <input type="hidden" title="jira.session.expiry.in.mins" value="-" /> <input id="jiraConcurrentRequests" type="hidden" name="jira.request.concurrent.requests" value="1" /> <input type="hidden" title="db.reads.time.in.ms" value="4" /> <input type="hidden" title="db.conns.time.in.ms" value="7" /> </fieldset> </form>  </body> </html>

CINXE.COM

[DRILL-2433] Implicit cast between date and timestamp is missing in joins - ASF JIRA