Product: Aqua Data Studio
Version: 17.0.0-dev-74
Build #: 44661
Build Date: 2015-Jul-09 05:29:58 PM
Operating Environment: Linux (3.13.0-57-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.7.0_60-b19
Memory: Max=704,643,072; Total=429,391,872; Free=106,939,112; CPUs=8
Database - Apache Derby 10.11
Apache Derby 10.11 : Autocompletion is not working properly,for schema having same name in upper and lower case.
Steps to Reproduce :
1. Connect to Apache Derby database.
2. Create following two schemas :
CREATE SCHEMA "project"
GO
CREATE SCHEMA "PROJECT"
GO
3. Create following two tables in created schemas :
CREATE TABLE "project"."abc" (
"c1" VARCHAR(25)
)
GO
CREATE TABLE "PROJECT"."xyz" (
"col" VARCHAR(25)
)
GO
4. Now right click on "project" schema and select "Query analyzer" option.
5. In query analyzer, click on "Auto Complete" option.
Now write "select * from" and Hit space after "from" keyword.
-> Here it is observed that "xyz" table displayed in pop-up under "project" schema when we hit space after "from" keyword.
It should display "abc" table name under "project" schema.
