Mailing-List: contact dev-help@hawq.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hawq.incubator.apache.org
From: entong <git@git.apache.org>
To: dev@hawq.incubator.apache.org
Reply-To: dev@hawq.incubator.apache.org
Message-ID: <git-pr-104-incubator-hawq@git.apache.org>
Subject: [GitHub] incubator-hawq pull request: HAWQ-130. Fix analyzedb utility
 faili...
Content-Type: text/plain
Date: Thu, 12 Nov 2015 22:23:56 +0000 (UTC)

GitHub user entong opened a pull request:

    https://github.com/apache/incubator-hawq/pull/104

    HAWQ-130. Fix analyzedb utility failing when a table was created usin…

    …g quotes having upper case letters
    
    In this commit we fix the quoting issue of analyzedb if tablename contains uppercase letters.
    
    Below is the repro of the issue:
    
    stevejobs=# create table "APPLE" (field1 int);
    stevejobs=# \dt
    List of relations
    Schema | Name | Type | Owner | Storage
    --------------------------------
    public | APPLE | table | gpadmin | heap
    public | mac | table | gpadmin | heap
    (2 rows)
    one uppercase,lowercase table 
    ========
    Now i am analysing with analyzedb utility for database stevejobs 
    =======
    [gpadmin@mdw ~]$ analyzedb -d stevejobs
    20151005:14:16:32:032553 analyzedb:mdw:gpadmin-[INFO]:-Starting analyzedb with args: -d stevejobs
    20151005:14:16:32:032553 analyzedb:mdw:gpadmin-[INFO]:-Getting and verifying input tables...
    20151005:14:16:32:032553 analyzedb:mdw:gpadmin-[INFO]:-Checking for tables with stale stats...
    20151005:14:16:32:032553 analyzedb:mdw:gpadmin-[ERROR]:-analyzedb error: error 'ERROR: relation "public.apple" does not exist
    LINE 4: ...eration'::regclass,'pg_catalog.pg_proc'::regclass,'public.AP...
    ^
    ' in '
    select n.nspname as schemaname, c.relname as tablename from pg_class c, pg_namespace n where

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/entong/incubator-hawq HAWQ-130

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-hawq/pull/104.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #104
    
----
commit ef424a7521e8b2ce09e3262f9b0e97640c9ddc53
Author: Entong Shen <shenentong@gmail.com>
Date:   2015-11-12T22:16:36Z

    HAWQ-130. Fix analyzedb utility failing when a table was created using quotes having upper case letters

----


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---