You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@netbeans.apache.org by ma...@apache.org on 2017/09/30 11:35:55 UTC
[3/3] incubator-netbeans git commit: [NETBEANS-54] Module Review
db.sql.editor
[NETBEANS-54] Module Review db.sql.editor
- no external library
- checked Rat report; unrecognized license headers manually changed,
missing headers added, ignored *.form (see central problems) and
SQLExample. The latter file is used in the GUI as a sample and
in addition does not reach a level of creativity.
- skimmed through the module, did not notice additional problems
- Modified tests to allow comments in *.test and *.pass files
Project: http://git-wip-us.apache.org/repos/asf/incubator-netbeans/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-netbeans/commit/ac84c02c
Tree: http://git-wip-us.apache.org/repos/asf/incubator-netbeans/tree/ac84c02c
Diff: http://git-wip-us.apache.org/repos/asf/incubator-netbeans/diff/ac84c02c
Branch: refs/heads/master
Commit: ac84c02c9c5f4db50e7b1adb353ba64be1ab73b1
Parents: 753eb18
Author: Matthias Bläsing <mb...@doppel-helix.eu>
Authored: Fri Sep 29 22:19:13 2017 +0200
Committer: Matthias Bläsing <mb...@doppel-helix.eu>
Committed: Sat Sep 30 13:06:24 2017 +0200
----------------------------------------------------------------------
.../resources/CityLights-SQL-fontsColors.xml | 58 ++++++--------------
.../resources/NetBeans-SQL-fontsColors.xml | 58 ++++++--------------
.../org.netbeans.spi.lexer.LanguageProvider | 16 ++++++
.../completion/SelectCompletionQueryTest.java | 40 +++++++-------
.../db/sql/editor/completion/deleteAll.pass | 17 ++++++
.../db/sql/editor/completion/deleteAll.test | 17 ++++++
.../db/sql/editor/completion/deleteSimple.pass | 17 ++++++
.../db/sql/editor/completion/deleteSimple.test | 17 ++++++
.../sql/editor/completion/deleteSubquery.pass | 17 ++++++
.../sql/editor/completion/deleteSubquery.test | 17 ++++++
.../db/sql/editor/completion/deleteView.pass | 17 ++++++
.../db/sql/editor/completion/deleteView.test | 17 ++++++
.../db/sql/editor/completion/deleteWhere.pass | 17 ++++++
.../db/sql/editor/completion/deleteWhere.test | 17 ++++++
.../db/sql/editor/completion/dropTableAll.pass | 17 ++++++
.../db/sql/editor/completion/dropTableAll.test | 17 ++++++
.../sql/editor/completion/dropTableSimple.pass | 17 ++++++
.../sql/editor/completion/dropTableSimple.test | 17 ++++++
.../db/sql/editor/completion/fromAll.pass | 17 ++++++
.../db/sql/editor/completion/fromAll.test | 17 ++++++
.../editor/completion/fromJoinCondition.pass | 17 ++++++
.../editor/completion/fromJoinCondition.test | 17 ++++++
.../completion/fromJoinConditionAlias.pass | 17 ++++++
.../completion/fromJoinConditionAlias.test | 17 ++++++
.../db/sql/editor/completion/fromQualTable.pass | 17 ++++++
.../db/sql/editor/completion/fromQualTable.test | 17 ++++++
.../db/sql/editor/completion/fromSimple.pass | 17 ++++++
.../db/sql/editor/completion/fromSimple.test | 17 ++++++
.../db/sql/editor/completion/groupBySimple.pass | 17 ++++++
.../db/sql/editor/completion/groupBySimple.test | 17 ++++++
.../db/sql/editor/completion/insertSet.pass | 17 ++++++
.../db/sql/editor/completion/insertSet.test | 17 ++++++
.../editor/completion/insertSetSubselect.pass | 17 ++++++
.../editor/completion/insertSetSubselect.test | 17 ++++++
.../db/sql/editor/completion/orderBySimple.pass | 17 ++++++
.../db/sql/editor/completion/orderBySimple.test | 17 ++++++
.../db/sql/editor/completion/script.pass | 17 ++++++
.../db/sql/editor/completion/script.test | 17 ++++++
.../editor/completion/selectAfterDeclare.pass | 17 ++++++
.../editor/completion/selectAfterDeclare.test | 17 ++++++
.../sql/editor/completion/selectAfterSet.pass | 17 ++++++
.../sql/editor/completion/selectAfterSet.test | 17 ++++++
.../db/sql/editor/completion/selectAll.pass | 17 ++++++
.../db/sql/editor/completion/selectAll.test | 17 ++++++
.../db/sql/editor/completion/selectAllFrom.pass | 17 ++++++
.../db/sql/editor/completion/selectAllFrom.test | 17 ++++++
.../editor/completion/selectAllFromQuoted.pass | 17 ++++++
.../editor/completion/selectAllFromQuoted.test | 17 ++++++
.../selectAllFromTableInSyntheticSchema.pass | 17 ++++++
.../selectAllFromTableInSyntheticSchema.test | 17 ++++++
.../selectAllWhenFromClauseEmpty.pass | 17 ++++++
.../selectAllWhenFromClauseEmpty.test | 17 ++++++
.../selectAllWhenSyntheticSchema.pass | 17 ++++++
.../selectAllWhenSyntheticSchema.test | 17 ++++++
.../completion/selectDoubleQualColumn.pass | 17 ++++++
.../completion/selectDoubleQualColumn.test | 17 ++++++
...alColumnFromQualTableInNonDefaultSchema.pass | 17 ++++++
...alColumnFromQualTableInNonDefaultSchema.test | 17 ++++++
.../sql/editor/completion/selectQualColumn.pass | 17 ++++++
.../sql/editor/completion/selectQualColumn.test | 17 ++++++
...tQualColumnFromQualTableInDefaultSchema.pass | 17 ++++++
...tQualColumnFromQualTableInDefaultSchema.test | 17 ++++++
...ctQualColumnFromTableInNonDefaultSchema.pass | 17 ++++++
...ctQualColumnFromTableInNonDefaultSchema.test | 17 ++++++
...electQualColumnFromTableNotInFromClause.pass | 17 ++++++
...electQualColumnFromTableNotInFromClause.test | 17 ++++++
...ualColumnFromUnqualTableInDefaultSchema.pass | 17 ++++++
...ualColumnFromUnqualTableInDefaultSchema.test | 17 ++++++
...electQualColumnWhenTableInDefaultSchema.pass | 17 ++++++
...electQualColumnWhenTableInDefaultSchema.test | 17 ++++++
...ctQualColumnWhenTableInNonDefaultSchema.pass | 17 ++++++
...ctQualColumnWhenTableInNonDefaultSchema.test | 17 ++++++
...ectQualColumnWhenTableInSyntheticSchema.pass | 17 ++++++
...ectQualColumnWhenTableInSyntheticSchema.test | 17 ++++++
.../sql/editor/completion/selectQualTable.pass | 17 ++++++
.../sql/editor/completion/selectQualTable.test | 17 ++++++
.../selectQualTableFromNonDefaultSchema.pass | 17 ++++++
.../selectQualTableFromNonDefaultSchema.test | 17 ++++++
...lectQualTableFromTableInSyntheticSchema.pass | 17 ++++++
...lectQualTableFromTableInSyntheticSchema.test | 17 ++++++
.../selectQualifiedIdentifierFrom.pass | 17 ++++++
.../selectQualifiedIdentifierFrom.test | 17 ++++++
.../db/sql/editor/completion/selectQuote.pass | 17 ++++++
.../db/sql/editor/completion/selectQuote.test | 17 ++++++
.../completion/selectQuotedQualColumn.pass | 17 ++++++
.../completion/selectQuotedQualColumn.test | 17 ++++++
.../completion/selectQuotedQualTable.pass | 17 ++++++
.../completion/selectQuotedQualTable.test | 17 ++++++
.../db/sql/editor/completion/selectSimple.pass | 17 ++++++
.../db/sql/editor/completion/selectSimple.test | 17 ++++++
.../sql/editor/completion/selectSimpleFrom.pass | 17 ++++++
.../sql/editor/completion/selectSimpleFrom.test | 17 ++++++
.../sql/editor/completion/selectSubquery.pass | 17 ++++++
.../sql/editor/completion/selectSubquery.test | 17 ++++++
.../completion/selectTripleQualColumn.pass | 17 ++++++
.../completion/selectTripleQualColumn.test | 17 ++++++
.../db/sql/editor/completion/selectViews.pass | 17 ++++++
.../db/sql/editor/completion/selectViews.test | 17 ++++++
.../db/sql/editor/completion/updateAll.pass | 17 ++++++
.../db/sql/editor/completion/updateAll.test | 17 ++++++
.../db/sql/editor/completion/updateSet.pass | 17 ++++++
.../db/sql/editor/completion/updateSet.test | 17 ++++++
.../sql/editor/completion/updateSetValue.pass | 17 ++++++
.../sql/editor/completion/updateSetValue.test | 17 ++++++
.../db/sql/editor/completion/updateSimple.pass | 17 ++++++
.../db/sql/editor/completion/updateSimple.test | 17 ++++++
.../sql/editor/completion/updateSubquery.pass | 17 ++++++
.../sql/editor/completion/updateSubquery.test | 17 ++++++
.../db/sql/editor/completion/updateView.pass | 17 ++++++
.../db/sql/editor/completion/updateView.test | 17 ++++++
.../db/sql/editor/completion/updateWhere.pass | 17 ++++++
.../db/sql/editor/completion/updateWhere.test | 17 ++++++
.../db/sql/editor/completion/whereAll.pass | 17 ++++++
.../db/sql/editor/completion/whereAll.test | 17 ++++++
.../sql/editor/completion/whereQualTable.pass | 17 ++++++
.../sql/editor/completion/whereQualTable.test | 17 ++++++
.../db/sql/editor/completion/whereSimple.pass | 17 ++++++
.../db/sql/editor/completion/whereSimple.test | 17 ++++++
118 files changed, 2005 insertions(+), 105 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/src/org/netbeans/modules/db/sql/editor/resources/CityLights-SQL-fontsColors.xml
----------------------------------------------------------------------
diff --git a/db.sql.editor/src/org/netbeans/modules/db/sql/editor/resources/CityLights-SQL-fontsColors.xml b/db.sql.editor/src/org/netbeans/modules/db/sql/editor/resources/CityLights-SQL-fontsColors.xml
index 8ec1c4e..2fd1fdf 100644
--- a/db.sql.editor/src/org/netbeans/modules/db/sql/editor/resources/CityLights-SQL-fontsColors.xml
+++ b/db.sql.editor/src/org/netbeans/modules/db/sql/editor/resources/CityLights-SQL-fontsColors.xml
@@ -1,48 +1,22 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE fontscolors PUBLIC "-//NetBeans//DTD Editor Fonts and Colors settings 1.1//EN" "http://www.netbeans.org/dtds/EditorFontsColors-1_1.dtd">
<!--
-DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
-
-Copyright 1997-2010 Oracle and/or its affiliates. All rights reserved.
-
-Oracle and Java are registered trademarks of Oracle and/or its affiliates.
-Other names may be trademarks of their respective owners.
-
-
-The contents of this file are subject to the terms of either the GNU
-General Public License Version 2 only ("GPL") or the Common
-Development and Distribution License("CDDL") (collectively, the
-"License"). You may not use this file except in compliance with the
-License. You can obtain a copy of the License at
-http://www.netbeans.org/cddl-gplv2.html
-or nbbuild/licenses/CDDL-GPL-2-CP. See the License for the
-specific language governing permissions and limitations under the
-License. When distributing the software, include this License Header
-Notice in each file and include the License file at
-nbbuild/licenses/CDDL-GPL-2-CP. Oracle designates this
-particular file as subject to the "Classpath" exception as provided
-by Oracle in the GPL Version 2 section of the License file that
-accompanied this code. If applicable, add the following below the
-License Header, with the fields enclosed by brackets [] replaced by
-your own identifying information:
-"Portions Copyrighted [year] [name of copyright owner]"
-
-Contributor(s):
-
-The Original Software is NetBeans. The Initial Developer of the Original
-Software is Sun Microsystems, Inc. Portions Copyright 1997-2006 Sun
-Microsystems, Inc. All Rights Reserved.
-
-If you wish your version of this file to be governed by only the CDDL
-or only the GPL Version 2, indicate your decision by adding
-"[Contributor] elects to include this software in this distribution
-under the [CDDL or GPL Version 2] license." If you do not indicate a
-single choice of license, a recipient has the option to distribute
-your version of this file under either the CDDL, the GPL Version 2 or
-to extend the choice of license to its licensees as provided above.
-However, if you add GPL Version 2 code and therefore, elected the GPL
-Version 2 license, then the option applies only if the new code is
-made subject to such option by the copyright holder.
+ Licensed to the Apache Software Foundation (ASF) under one
+ or more contributor license agreements. See the NOTICE file
+ distributed with this work for additional information
+ regarding copyright ownership. The ASF licenses this file
+ to you under the Apache License, Version 2.0 (the
+ "License"); you may not use this file except in compliance
+ with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing,
+ software distributed under the License is distributed on an
+ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ KIND, either express or implied. See the License for the
+ specific language governing permissions and limitations
+ under the License.
-->
<fontscolors>
<fontcolor name="default" default="default"/>
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/src/org/netbeans/modules/db/sql/editor/resources/NetBeans-SQL-fontsColors.xml
----------------------------------------------------------------------
diff --git a/db.sql.editor/src/org/netbeans/modules/db/sql/editor/resources/NetBeans-SQL-fontsColors.xml b/db.sql.editor/src/org/netbeans/modules/db/sql/editor/resources/NetBeans-SQL-fontsColors.xml
index dd9e68b..65b753d 100644
--- a/db.sql.editor/src/org/netbeans/modules/db/sql/editor/resources/NetBeans-SQL-fontsColors.xml
+++ b/db.sql.editor/src/org/netbeans/modules/db/sql/editor/resources/NetBeans-SQL-fontsColors.xml
@@ -1,48 +1,22 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE fontscolors PUBLIC "-//NetBeans//DTD Editor Fonts and Colors settings 1.1//EN" "http://www.netbeans.org/dtds/EditorFontsColors-1_1.dtd">
<!--
-DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
-
-Copyright 1997-2010 Oracle and/or its affiliates. All rights reserved.
-
-Oracle and Java are registered trademarks of Oracle and/or its affiliates.
-Other names may be trademarks of their respective owners.
-
-
-The contents of this file are subject to the terms of either the GNU
-General Public License Version 2 only ("GPL") or the Common
-Development and Distribution License("CDDL") (collectively, the
-"License"). You may not use this file except in compliance with the
-License. You can obtain a copy of the License at
-http://www.netbeans.org/cddl-gplv2.html
-or nbbuild/licenses/CDDL-GPL-2-CP. See the License for the
-specific language governing permissions and limitations under the
-License. When distributing the software, include this License Header
-Notice in each file and include the License file at
-nbbuild/licenses/CDDL-GPL-2-CP. Oracle designates this
-particular file as subject to the "Classpath" exception as provided
-by Oracle in the GPL Version 2 section of the License file that
-accompanied this code. If applicable, add the following below the
-License Header, with the fields enclosed by brackets [] replaced by
-your own identifying information:
-"Portions Copyrighted [year] [name of copyright owner]"
-
-Contributor(s):
-
-The Original Software is NetBeans. The Initial Developer of the Original
-Software is Sun Microsystems, Inc. Portions Copyright 1997-2006 Sun
-Microsystems, Inc. All Rights Reserved.
-
-If you wish your version of this file to be governed by only the CDDL
-or only the GPL Version 2, indicate your decision by adding
-"[Contributor] elects to include this software in this distribution
-under the [CDDL or GPL Version 2] license." If you do not indicate a
-single choice of license, a recipient has the option to distribute
-your version of this file under either the CDDL, the GPL Version 2 or
-to extend the choice of license to its licensees as provided above.
-However, if you add GPL Version 2 code and therefore, elected the GPL
-Version 2 license, then the option applies only if the new code is
-made subject to such option by the copyright holder.
+ Licensed to the Apache Software Foundation (ASF) under one
+ or more contributor license agreements. See the NOTICE file
+ distributed with this work for additional information
+ regarding copyright ownership. The ASF licenses this file
+ to you under the Apache License, Version 2.0 (the
+ "License"); you may not use this file except in compliance
+ with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing,
+ software distributed under the License is distributed on an
+ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ KIND, either express or implied. See the License for the
+ specific language governing permissions and limitations
+ under the License.
-->
<fontscolors>
<fontcolor name="default" default="default"/>
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/META-INF/services/org.netbeans.spi.lexer.LanguageProvider
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/META-INF/services/org.netbeans.spi.lexer.LanguageProvider b/db.sql.editor/test/unit/src/META-INF/services/org.netbeans.spi.lexer.LanguageProvider
index 7b3f656..3b2cf3c 100644
--- a/db.sql.editor/test/unit/src/META-INF/services/org.netbeans.spi.lexer.LanguageProvider
+++ b/db.sql.editor/test/unit/src/META-INF/services/org.netbeans.spi.lexer.LanguageProvider
@@ -1 +1,17 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
org.netbeans.lib.lexer.test.TestLanguageProvider
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/SelectCompletionQueryTest.java
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/SelectCompletionQueryTest.java b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/SelectCompletionQueryTest.java
index f4861df..357aed3 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/SelectCompletionQueryTest.java
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/SelectCompletionQueryTest.java
@@ -35,7 +35,6 @@ import junit.framework.TestSuite;
import org.netbeans.junit.NbTestCase;
import org.netbeans.modules.db.explorer.test.api.SQLIdentifiersTestUtilities;
import org.netbeans.modules.db.metadata.model.api.Metadata;
-import org.openide.filesystems.FileUtil;
/**
*
@@ -125,9 +124,9 @@ public class SelectCompletionQueryTest extends NbTestCase {
public void testCompletion() throws Exception {
StringBuilder sqlData = new StringBuilder();
- List<String> modelData = new ArrayList<String>();
- BufferedReader reader = new BufferedReader(new InputStreamReader(SelectCompletionQueryTest.class.getResource(getName() + ".test").openStream(), "utf-8"));
- try {
+ List<String> modelData = new ArrayList<>();
+ try (InputStream is = SelectCompletionQueryTest.class.getResourceAsStream(getName() + ".test");
+ BufferedReader reader = new BufferedReader(new InputStreamReader(is, "utf-8"))) {
boolean separatorRead = false;
for (String line; (line = reader.readLine()) != null;) {
if (line.startsWith("#") || line.trim().length() == 0) {
@@ -143,8 +142,6 @@ public class SelectCompletionQueryTest extends NbTestCase {
}
}
}
- } finally {
- reader.close();
}
String sql = sqlData.toString();
Metadata metadata = TestMetadata.create(modelData);
@@ -152,18 +149,12 @@ public class SelectCompletionQueryTest extends NbTestCase {
performTest(sql, metadata, System.out);
} else {
File result = new File(getWorkDir(), getName() + ".result");
- Writer writer = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(result), "utf-8"));
- try {
+ try (Writer writer = new BufferedWriter(new OutputStreamWriter(new FileOutputStream(result), "utf-8"))) {
performTest(sql, metadata, writer);
- } finally {
- writer.close();
}
File pass = new File(getWorkDir(), getName() + ".pass");
- InputStream input = SelectCompletionQueryTest.class.getResource(getName() + ".pass").openStream();
- try {
- copyStream(input, pass);
- } finally {
- input.close();
+ try (InputStream input = SelectCompletionQueryTest.class.getResourceAsStream(getName() + ".pass")) {
+ createReferenceFile(input, pass);
}
assertFile(getName(), result, pass, null);
}
@@ -184,12 +175,19 @@ public class SelectCompletionQueryTest extends NbTestCase {
}
}
- private static void copyStream(InputStream input, File dest) throws IOException {
- OutputStream output = new FileOutputStream(dest);
- try {
- FileUtil.copy(input, output);
- } finally {
- output.close();
+ private static void createReferenceFile(InputStream is, File dest) throws IOException {
+ try ( InputStreamReader isr = new InputStreamReader(is, "utf-8");
+ BufferedReader reader = new BufferedReader(isr);
+ OutputStream os = new FileOutputStream(dest);
+ OutputStreamWriter osr = new OutputStreamWriter(os, "utf-8");
+ BufferedWriter writer = new BufferedWriter(osr)) {
+ for (String line; (line = reader.readLine()) != null;) {
+ if (line.startsWith("#") || line.trim().length() == 0) {
+ continue;
+ }
+ writer.write(line);
+ writer.write("\n");
+ }
}
}
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteAll.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteAll.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteAll.pass
index 692ad52..5c2179e 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteAll.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteAll.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Table tab_customer
Schema sch_accounting
Schema sch_customers
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteAll.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteAll.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteAll.test
index 1fbf750..1b8fe6d 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteAll.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteAll.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
delete from |
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSimple.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSimple.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSimple.pass
index 3b0019a..fef8929 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSimple.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSimple.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Table customer_tab
Schema customers_sch
Catalog catalog_1
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSimple.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSimple.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSimple.test
index c6139b4..287c686 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSimple.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSimple.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
DELETE FROM c|
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSubquery.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSubquery.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSubquery.pass
index d678eac..cb06794 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSubquery.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSubquery.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Alias c1 to customer_tab
Column invoice_id in table invoice_tab
Column order_id in table purchase_order_tab
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSubquery.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSubquery.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSubquery.test
index 7846dd3..7cb0ed5 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSubquery.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteSubquery.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
DELETE FROM customer_tab c1 WHERE customer_id = (SELECT invoice_id FROM invoice_tab WHERE invoice_id = (select |order_id from purchase_order_tab))
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteView.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteView.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteView.pass
index d847fec..d5b8585 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteView.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteView.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Schema sch_accounting
Schema sch_customers
Catalog catalog_1
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteView.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteView.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteView.test
index ffc5488..6bb61b5 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteView.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteView.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
delete from |
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteWhere.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteWhere.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteWhere.pass
index d11ac97..ca72c8c 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteWhere.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteWhere.pass
@@ -1,2 +1,19 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Alias c1 to customer_tab
Column customer_id in table customer_tab
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteWhere.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteWhere.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteWhere.test
index 45b5888..ca5ff01 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteWhere.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/deleteWhere.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
DELETE FROM customer_tab c1 WHERE |
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableAll.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableAll.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableAll.pass
index 692ad52..5c2179e 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableAll.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableAll.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Table tab_customer
Schema sch_accounting
Schema sch_customers
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableAll.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableAll.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableAll.test
index 415010e..2d001b9 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableAll.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableAll.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
drop table |
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableSimple.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableSimple.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableSimple.pass
index 3b0019a..fef8929 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableSimple.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableSimple.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Table customer_tab
Schema customers_sch
Catalog catalog_1
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableSimple.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableSimple.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableSimple.test
index 203ef83..ecb7b92 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableSimple.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/dropTableSimple.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
drop table c|
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromAll.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromAll.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromAll.pass
index e050089..b1b2548 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromAll.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromAll.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Table customer
View asummary
Schema accounting
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromAll.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromAll.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromAll.test
index 07e2c71..afecb30 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromAll.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromAll.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
select from |
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinCondition.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinCondition.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinCondition.pass
index e2a0b86..b32c047 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinCondition.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinCondition.pass
@@ -1,2 +1,19 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Column invoice_id in table invoice
Column customer_id in table invoice
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinCondition.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinCondition.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinCondition.test
index 7c3f12a..a42baa4 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinCondition.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinCondition.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
select * from invoice inner join customer on invoice.|
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinConditionAlias.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinConditionAlias.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinConditionAlias.pass
index e2a0b86..b32c047 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinConditionAlias.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinConditionAlias.pass
@@ -1,2 +1,19 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Column invoice_id in table invoice
Column customer_id in table invoice
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinConditionAlias.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinConditionAlias.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinConditionAlias.test
index 93a69a8..3c68cfb 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinConditionAlias.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromJoinConditionAlias.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
select * from invoice inv inner join customer on inv.|
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromQualTable.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromQualTable.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromQualTable.pass
index 82bae1e..e73275d 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromQualTable.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromQualTable.pass
@@ -1,2 +1,19 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Table customer
View asummary
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromQualTable.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromQualTable.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromQualTable.test
index 3dc891f..dbcb68e 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromQualTable.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromQualTable.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
select from customers.|
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromSimple.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromSimple.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromSimple.pass
index 33dda86..e573738 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromSimple.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromSimple.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Table customer
View casummary
Schema customers
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromSimple.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromSimple.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromSimple.test
index 20fde40..efde101 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromSimple.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/fromSimple.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
select from c|
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/groupBySimple.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/groupBySimple.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/groupBySimple.pass
index 3123d39..6697669 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/groupBySimple.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/groupBySimple.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Alias cus to discount_code
Column customer_id in table customer
Column customer_id in table customizations.customization
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/groupBySimple.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/groupBySimple.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/groupBySimple.test
index adef78f..3ac96fd 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/groupBySimple.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/groupBySimple.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
# The "customers" schema should not show up (not needed). The "customer" table should. The "customization" table should not,
# because it's not in the default schema.
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSet.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSet.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSet.pass
index d27d859..f6f2151 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSet.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSet.pass
@@ -1,2 +1,19 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Column customer_id in table customer_tab
Table customer_tab
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSet.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSet.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSet.test
index 76dedaf..2e6918f 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSet.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSet.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
INSERT INTO customer_tab SET |
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSetSubselect.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSetSubselect.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSetSubselect.pass
index 131fb21..8de7ea0 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSetSubselect.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSetSubselect.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Table customer_tab
Table invoice_tab
Table purchase_order_tab
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSetSubselect.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSetSubselect.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSetSubselect.test
index 167a462..e0ee595 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSetSubselect.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/insertSetSubselect.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
INSERT INTO customer_tab c1 SET customer_id = (SELECT invoice_id FROM invoice_tab WHERE invoice_id = (select order_id from |purchase_order_tab)) WHERE
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/orderBySimple.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/orderBySimple.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/orderBySimple.pass
index 3123d39..6697669 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/orderBySimple.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/orderBySimple.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Alias cus to discount_code
Column customer_id in table customer
Column customer_id in table customizations.customization
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/orderBySimple.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/orderBySimple.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/orderBySimple.test
index adef78f..3ac96fd 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/orderBySimple.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/orderBySimple.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
# The "customers" schema should not show up (not needed). The "customer" table should. The "customization" table should not,
# because it's not in the default schema.
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/script.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/script.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/script.pass
index e201486..5f1cda2 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/script.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/script.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Column customer_id in table customer
Column csummary_id in view csummary
Table customer
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/script.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/script.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/script.test
index 7aa339d..2274b45 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/script.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/script.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
insert into customer values (1);
insert into customer values (2);
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterDeclare.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterDeclare.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterDeclare.pass
index eddff67..bbb8451 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterDeclare.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterDeclare.pass
@@ -1,2 +1,19 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Table customer
Schema customers
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterDeclare.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterDeclare.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterDeclare.test
index da184bf..e22cbfa 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterDeclare.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterDeclare.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
DECLARE @StartDate datetime, @EndDate datetime
SET @StartDate = '2010-01-01'
SET @EndDate = '2012-01-01'
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterSet.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterSet.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterSet.pass
index eddff67..bbb8451 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterSet.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterSet.pass
@@ -1,2 +1,19 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Table customer
Schema customers
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterSet.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterSet.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterSet.test
index 2b53f25..374e6f3 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterSet.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAfterSet.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
SET @PreviousDay = dateAdd(d, -1, @StartDate)
# comment
select |
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAll.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAll.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAll.pass
index d75312f..2f61a23 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAll.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAll.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Table customer
View overview
Schema accounting
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAll.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAll.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAll.test
index 0273520..dee3185 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAll.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAll.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
select |
--
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFrom.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFrom.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFrom.pass
index e56113a..3406704 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFrom.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFrom.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Alias cus to customer
Column invoice_id in table accounting.invoice
Column customer_id in table customer
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFrom.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFrom.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFrom.test
index 42337a3..f4ebbc3 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFrom.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFrom.test
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
# Columns are not sorted (they are in table order), columns from customer are
# only listed once (although the table is there twice), the "cus" alias is there,
# the "unused" schema is not there.
http://git-wip-us.apache.org/repos/asf/incubator-netbeans/blob/ac84c02c/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromQuoted.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromQuoted.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromQuoted.pass
index 6c9a63c..31c8ae8 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromQuoted.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromQuoted.pass
@@ -1,3 +1,20 @@
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+#
Alias a to asummary
Alias foo to accounting.customer
Column invoice_id in table accounting.invoice