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