[jira] [Commented] (HAWQ-130) Analyzedb utility failing when a table was created using quotes having upper case letters

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HAWQ-130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15003070#comment-15003070 ] 

ASF GitHub Bot commented on HAWQ-130:
-------------------------------------

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 <sh...@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

----


> Analyzedb utility failing when a table was created using quotes having upper case letters
> -----------------------------------------------------------------------------------------
>
>                 Key: HAWQ-130
>                 URL: https://issues.apache.org/jira/browse/HAWQ-130
>             Project: Apache HAWQ
>          Issue Type: Bug
>            Reporter: Entong Shen
>            Assignee: Entong Shen
>
> The analyzedb utility returned an error if the utility encountered a table or schema name that contained uppercase characters (the name was enclosed in quotes and contained upper case characters).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)