[hive] branch master updated: HIVE-26390: TxnHandler.getTxnDbsUpdated() SQL syntax error on Postgres. (#3437)

[ngangam]

This is an automated email from the ASF dual-hosted git repository.

ngangam pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hive.git


The following commit(s) were added to refs/heads/master by this push:
     new b51dcfe87b8 HIVE-26390: TxnHandler.getTxnDbsUpdated() SQL syntax error 
on Postgres. (#3437)
b51dcfe87b8 is described below

commit b51dcfe87b8ab85cc756622c672aeda61060fe90
Author: cmunkey <49877369+cmun...@users.noreply.github.com>
AuthorDate: Thu Jul 14 17:31:24 2022 -0700

    HIVE-26390: TxnHandler.getTxnDbsUpdated() SQL syntax error on Postgres. 
(#3437)
    
    The column name "T2W_DATABASE" needs to be quoted.
    
    Co-authored-by: Francis Pang <fp...@cloudera.com>
---
 .../src/main/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java  | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git 
a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java
 
b/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java
index dec309243d6..9e270fc731d 100644
--- 
a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java
+++ 
b/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java
@@ -1682,7 +1682,7 @@ abstract class TxnHandler implements TxnStore, 
TxnStore.MutexAPI {
     try {
       try (Statement stmt = dbConn.createStatement()) {
 
-        String query = "SELECT DISTINCT T2W_DATABASE " +
+        String query = "SELECT DISTINCT \"T2W_DATABASE\" " +
                 " FROM \"TXN_TO_WRITE_ID\" \"COMMITTED\"" +
                 "   WHERE \"T2W_TXNID\" = " + txnId;