[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 <[email protected]> Authored: Fri Sep 29 22:19:13 2017 +0200 Committer: Matthias Bläsing <[email protected]> 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
