× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Ivan Gron
ivangron reported 2015-10-28T22:54:15Z  · nishtha(*) last modified 2015-12-04T13:34:43Z

Auto Completion -> ill formed extraction when <auto on all schemas> is not selected


Dev
Jenny Nishimura
JennyNishimura
QA
Sachin Prakash
SachinPrakash
Priority Low
Complexity Unknown
Component DB - BigQuery
Version 17.0
Open a query analyzer and attempt to do an [auto completion] without passing the objects scheam;  Example: "SELECT * FROM <ctrl+space>"
Code was added to SQLStdCompletionQuery at line 432 that sets the currentSchema = "<DEFAULT>" if the currentSchema is null or empty and [Auto On All Schemas] is set to false.  This modifies previous behavior of extraction on databases that allow for null/blank schemas.  Revision states this is a fix for mongoDB, perhaps we should only do this for mongodb?
 Currently I only see this affecting BigQuery as it attempts to extract objects from the <DEFAULT> schema, but this could be due to there been no schema context?  But in the future, apache phoenix allows for null and blank schemas, which will make this an issue, since null is the default schema in phoenix.
1 attachment
  •  
  •  
  • 4 shares
  •  
All Comments (4) Change History
Sort 

Issue #13806
Closed
Fixed
Resolved 2015-11-01T18:12:35Z
 
 
Completion
No due date
Fixed Build ADS 17.0.0-rc-28
No time estimate

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