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.
