× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
chandradipjain(*) reported 2014-06-06T06:50:57Z  · tomconrad last modified 2018-03-12T01:03:09Z

Execute Edit on Views gives connection error for Vertica db.


PM
Priority Major
Complexity Unknown
Component DB - Vertica
Version Future
Aqua Data Studio 15.0.0-dev-311
Build #: 38320
Built on: 2014-Jun-05 05:09:09 PM
OS Environment: Windows 8(x64 bit)
 
DB : Vertica 7.x
 
Steps to Reproduce:
1. Connect to vertica server
2. Create table
 
   CREATE TABLE "public"."employee"  ( 
    "emp_id"       int,
    "emp_name"     varchar(80),
    "dept_id"     int,
    "location"     varchar(80),
    "salary"       int,
    "joining_date" date 
    )
   GO
 
3. Create view on above table
   
   CREATE VIEW "public"."emp_view" AS SELECT * FROM public.employee
   GO
 
4. Open Query analyzer and write select query on above created view
   
   SELECT "emp_id", "emp_name", "dept_id", "location", "salary", "joining_date" 
    FROM "public"."emp_view"
   GO
 
5. Now click on Execute Edit button on query analyzer window it gives connection error message "Fialed to Locate table".
 
Please see attached screenshot.
    
1 attachment

Issue #12263

New
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017