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:54 UTC
[2/3] incubator-netbeans git commit: [NETBEANS-54] Module Review
db.sql.editor
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.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromQuoted.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromQuoted.test
index 7cc243a..b6d4e56 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromQuoted.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromQuoted.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 "accounting"."invoice", "accounting"."customer" "foo", "asummary" "a"
--
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/selectAllFromTableInSyntheticSchema.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromTableInSyntheticSchema.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromTableInSyntheticSchema.pass
index 750669a..85bcbb0 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromTableInSyntheticSchema.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromTableInSyntheticSchema.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 table_catalog in table columns
Column table_schema in table columns
Column table_name in table columns
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/selectAllFromTableInSyntheticSchema.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromTableInSyntheticSchema.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromTableInSyntheticSchema.test
index d057f84..708e2bf 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromTableInSyntheticSchema.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllFromTableInSyntheticSchema.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.
+#
# Ensures colums from the table in the default schema "customers" show up in the completion,
# not from the one in the "accounting" 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/selectAllWhenFromClauseEmpty.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenFromClauseEmpty.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenFromClauseEmpty.pass
index bda9918..b0c09a4 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenFromClauseEmpty.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenFromClauseEmpty.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/selectAllWhenFromClauseEmpty.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenFromClauseEmpty.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenFromClauseEmpty.test
index 6a8c562..ccbee31 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenFromClauseEmpty.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenFromClauseEmpty.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/selectAllWhenSyntheticSchema.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenSyntheticSchema.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenSyntheticSchema.pass
index 77fcdd5..1454096 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenSyntheticSchema.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenSyntheticSchema.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
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/selectAllWhenSyntheticSchema.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenSyntheticSchema.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenSyntheticSchema.test
index 4a7d26a..89d912b 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenSyntheticSchema.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectAllWhenSyntheticSchema.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.
+#
# Ensures tables from a model with no schemas show up.
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/selectDoubleQualColumn.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumn.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumn.pass
index ae82b40..f70cffd 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumn.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumn.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 accounting.invoice
Column customer_id in table accounting.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/selectDoubleQualColumn.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumn.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumn.test
index 81b88f3..0b850b2 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumn.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumn.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 accounting.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/selectDoubleQualColumnFromQualTableInNonDefaultSchema.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumnFromQualTableInNonDefaultSchema.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumnFromQualTableInNonDefaultSchema.pass
index ae82b40..f70cffd 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumnFromQualTableInNonDefaultSchema.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumnFromQualTableInNonDefaultSchema.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 accounting.invoice
Column customer_id in table accounting.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/selectDoubleQualColumnFromQualTableInNonDefaultSchema.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumnFromQualTableInNonDefaultSchema.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumnFromQualTableInNonDefaultSchema.test
index ed9f143..0bd3ca9 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumnFromQualTableInNonDefaultSchema.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectDoubleQualColumnFromQualTableInNonDefaultSchema.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 accounting.invoice.| from accounting.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/selectQualColumn.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumn.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumn.pass
index 5714d1f..447ea82 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumn.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumn.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
Column customer_rating 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/selectQualColumn.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumn.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumn.test
index 1dbda90..d3c134c 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumn.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumn.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 customer.cus|
--
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/selectQualColumnFromQualTableInDefaultSchema.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromQualTableInDefaultSchema.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromQualTableInDefaultSchema.pass
index 9ed310a..2860b57 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromQualTableInDefaultSchema.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromQualTableInDefaultSchema.pass
@@ -1 +1,18 @@
+# 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
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/selectQualColumnFromQualTableInDefaultSchema.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromQualTableInDefaultSchema.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromQualTableInDefaultSchema.test
index f6c1412..4ef2957 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromQualTableInDefaultSchema.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromQualTableInDefaultSchema.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.
+#
# Ensures columns from the "customer" table show up, even if the table
# is qualified with the (default) schema name in the SELECT clause.
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/selectQualColumnFromTableInNonDefaultSchema.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableInNonDefaultSchema.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableInNonDefaultSchema.pass
index e69de29..b4646d1 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableInNonDefaultSchema.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableInNonDefaultSchema.pass
@@ -0,0 +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.
+#
\ 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/selectQualColumnFromTableInNonDefaultSchema.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableInNonDefaultSchema.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableInNonDefaultSchema.test
index 6aee86d..4a52ffc 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableInNonDefaultSchema.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableInNonDefaultSchema.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.
+#
# Ensures nothing shows up in the completion, because the "customer"
# table is 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/selectQualColumnFromTableNotInFromClause.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableNotInFromClause.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableNotInFromClause.pass
index e69de29..b4646d1 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableNotInFromClause.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableNotInFromClause.pass
@@ -0,0 +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.
+#
\ 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/selectQualColumnFromTableNotInFromClause.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableNotInFromClause.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableNotInFromClause.test
index 915bff4..68e1cc0 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableNotInFromClause.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromTableNotInFromClause.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 accounting.invoice.| from accounting.customer foo
--
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/selectQualColumnFromUnqualTableInDefaultSchema.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromUnqualTableInDefaultSchema.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromUnqualTableInDefaultSchema.pass
index 410892a..22def15 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromUnqualTableInDefaultSchema.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromUnqualTableInDefaultSchema.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
Column address_line 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/selectQualColumnFromUnqualTableInDefaultSchema.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromUnqualTableInDefaultSchema.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromUnqualTableInDefaultSchema.test
index c3d3442..1a19c93 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromUnqualTableInDefaultSchema.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnFromUnqualTableInDefaultSchema.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.
+#
# Ensures columns from the "customer" table show up, although the table
# is not qualified with the (default) schema name in the SELECT clause.
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/selectQualColumnWhenTableInDefaultSchema.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInDefaultSchema.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInDefaultSchema.pass
index 410892a..22def15 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInDefaultSchema.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInDefaultSchema.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
Column address_line 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/selectQualColumnWhenTableInDefaultSchema.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInDefaultSchema.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInDefaultSchema.test
index c269f5b..2cf0919 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInDefaultSchema.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInDefaultSchema.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.
+#
# Ensures colums from the table in the default schema "customers" show up in the completion,
# not from the one in the "accounting" 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/selectQualColumnWhenTableInNonDefaultSchema.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInNonDefaultSchema.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInNonDefaultSchema.pass
index e69de29..b4646d1 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInNonDefaultSchema.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInNonDefaultSchema.pass
@@ -0,0 +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.
+#
\ 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/selectQualColumnWhenTableInNonDefaultSchema.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInNonDefaultSchema.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInNonDefaultSchema.test
index 166b561..6f12268 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInNonDefaultSchema.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInNonDefaultSchema.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.
+#
# Ensures nothing shows up in the completion, because the "customer"
# table is 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/selectQualColumnWhenTableInSyntheticSchema.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInSyntheticSchema.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInSyntheticSchema.pass
index 4ebd177..fa4f380 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInSyntheticSchema.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInSyntheticSchema.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 table_catalog in table columns
Column table_schema in table columns
Column table_name in table columns
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/selectQualColumnWhenTableInSyntheticSchema.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInSyntheticSchema.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInSyntheticSchema.test
index 9be8f86..cf57846 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInSyntheticSchema.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualColumnWhenTableInSyntheticSchema.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.
+#
# Ensures colums from the table in the default schema "customers" show up in the completion,
# not from the one in the "accounting" 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/selectQualTable.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTable.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTable.pass
index 82bae1e..e73275d 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTable.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTable.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/selectQualTable.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTable.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTable.test
index 0097b5f..6638782 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTable.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTable.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 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/selectQualTableFromNonDefaultSchema.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromNonDefaultSchema.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromNonDefaultSchema.pass
index 11a40d2..73fca66 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromNonDefaultSchema.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromNonDefaultSchema.pass
@@ -1 +1,18 @@
+# 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 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/selectQualTableFromNonDefaultSchema.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromNonDefaultSchema.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromNonDefaultSchema.test
index a4385d7..5387019 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromNonDefaultSchema.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromNonDefaultSchema.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 accounting.| from accounting.invoice, accounting.customer foo
--
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/selectQualTableFromTableInSyntheticSchema.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromTableInSyntheticSchema.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromTableInSyntheticSchema.pass
index b1706df..4d3f7f7 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromTableInSyntheticSchema.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromTableInSyntheticSchema.pass
@@ -1 +1,18 @@
+# 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 columns
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/selectQualTableFromTableInSyntheticSchema.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromTableInSyntheticSchema.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromTableInSyntheticSchema.test
index d786c04..7a1cb39 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromTableInSyntheticSchema.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualTableFromTableInSyntheticSchema.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.
+#
# Ensures colums from the table in the default schema "customers" show up in the completion,
# not from the one in the "accounting" 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/selectQualifiedIdentifierFrom.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualifiedIdentifierFrom.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualifiedIdentifierFrom.pass
index a1982cd..38d88d6 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualifiedIdentifierFrom.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualifiedIdentifierFrom.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
Table invoice
\ 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/selectQualifiedIdentifierFrom.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualifiedIdentifierFrom.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualifiedIdentifierFrom.test
index 42c54a7..abfc2f6 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualifiedIdentifierFrom.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQualifiedIdentifierFrom.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 acatalog.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/selectQuote.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuote.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuote.pass
index 7256591..c63bdb4 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuote.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuote.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 customer_rating in table customer
Column address_line 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/selectQuote.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuote.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuote.test
index a89130c..94e5947 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuote.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuote.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 "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/selectQuotedQualColumn.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualColumn.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualColumn.pass
index 5714d1f..447ea82 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualColumn.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualColumn.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
Column customer_rating 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/selectQuotedQualColumn.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualColumn.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualColumn.test
index ee497cd..6e30c99 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualColumn.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualColumn.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 "customer"."cus|
--
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/selectQuotedQualTable.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualTable.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualTable.pass
index 82bae1e..e73275d 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualTable.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualTable.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/selectQuotedQualTable.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualTable.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualTable.test
index b48420f..a0ed760 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualTable.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectQuotedQualTable.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 "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/selectSimple.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimple.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimple.pass
index d940de5..bfaeb5d 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimple.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimple.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 cus_summary_id in view cus_summary
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/selectSimple.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimple.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimple.test
index d30f093..5d03536 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimple.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimple.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.
+#
# Everything starting with "cus" should show up,
# except for the "customization" table (not in the default schema).
# No columns other than those in the default schema should show up.
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/selectSimpleFrom.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimpleFrom.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimpleFrom.pass
index 429efab..533f636 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimpleFrom.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimpleFrom.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 customer_id in table customizations.customization
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/selectSimpleFrom.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimpleFrom.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimpleFrom.test
index 6f0ab7b..f102401 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimpleFrom.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSimpleFrom.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/selectSubquery.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSubquery.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSubquery.pass
index 663754e..7041e26 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSubquery.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSubquery.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 cust to customer
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/selectSubquery.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSubquery.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSubquery.test
index 6264c6a..0911638 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSubquery.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectSubquery.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 customer cust where cust.customer_id in (select distinct | from 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/selectTripleQualColumn.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectTripleQualColumn.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectTripleQualColumn.pass
index 8265857..5487e7e 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectTripleQualColumn.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectTripleQualColumn.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 acatalog.accounting.invoice
Column customer_id in table acatalog.accounting.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/selectTripleQualColumn.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectTripleQualColumn.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectTripleQualColumn.test
index f89052d..a262b7e 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectTripleQualColumn.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectTripleQualColumn.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 acatalog.accounting.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/selectViews.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectViews.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectViews.pass
index 87a6c46..2f33639 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectViews.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectViews.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.
+#
View overview
View summary
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/selectViews.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectViews.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectViews.test
index e84fc31..a6f1af2 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectViews.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/selectViews.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/updateAll.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateAll.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateAll.pass
index 692ad52..5c2179e 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateAll.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateAll.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/updateAll.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateAll.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateAll.test
index e92b1d2..75f3ba9 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateAll.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateAll.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.
+#
update |
--
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/updateSet.pass
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateSet.pass b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateSet.pass
index d11ac97..ca72c8c 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateSet.pass
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateSet.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/updateSet.test
----------------------------------------------------------------------
diff --git a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateSet.test b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateSet.test
index 0afc5f8..927c2ec 100644
--- a/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateSet.test
+++ b/db.sql.editor/test/unit/src/org/netbeans/modules/db/sql/editor/completion/updateSet.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.
+#
UPDATE customer_tab c1 SET |
--