[JBoss JIRA] (TEIIDDES-2382) No error message for query with aggregate function and no group by clause
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2382?page=com.atlassian.jira.plu... ]
Barry LaFond edited comment on TEIIDDES-2382 at 11/6/14 2:29 PM:
-----------------------------------------------------------------
Tested with latest code and appears the vague error was related to TEIIDDES-2344, which was fixed.
Defining the specified SQL in Description validated correctly. No error.
Removing the GROUP BY cust.id; results in: * ERROR: [cust.id] cannot be used outside of aggregate functions since they are not present in a GROUP BY clause.*
was (Author: blafond):
Tested with latest code and appears the vague error was related to TEIIDDES-2344, which was fixed.
Defining the specified SQL in Description validated correctly. No error.
> No error message for query with aggregate function and no group by clause
> -------------------------------------------------------------------------
>
> Key: TEIIDDES-2382
> URL: https://issues.jboss.org/browse/TEIIDDES-2382
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 8.6
> Reporter: Jan Stastny
> Assignee: Barry LaFond
>
> In designer when defining a table in view model with following transformation query, bad error message is returned to user.
> SELECT cust.id AS customer_id, SUM(ord.amount) AS total_amount
> FROM
> customers AS cust INNER JOIN orders AS ord
> ON cust.id = ord.customer_id
> GROUP BY cust.id;
> When user forgets to write the GROUP BY clause then error with following message occurs: "ERROR:ERROR".
> When I execute similar query via teeid driver then I get very useful message: "Error: Remote org.teiid.api.exception.query.QueryValidatorException: Non-constant, non-aggregate expression cust.id cannot be mixed with aggregate functions and implicit grouping."
> It would be very helpful if Teiid designer gave similar message instead of the "ERROR:ERROR" one.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIIDDES-2382) No error message for query with aggregate function and no group by clause
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2382?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2382.
------------------------------------
Assignee: Barry LaFond
Resolution: Duplicate Issue
Tested with latest code and appears the vague error was related to TEIIDDES-2344, which was fixed.
Defining the specified SQL in Description validated correctly. No error.
> No error message for query with aggregate function and no group by clause
> -------------------------------------------------------------------------
>
> Key: TEIIDDES-2382
> URL: https://issues.jboss.org/browse/TEIIDDES-2382
> Project: Teiid Designer
> Issue Type: Bug
> Components: Transformations
> Affects Versions: 8.6
> Reporter: Jan Stastny
> Assignee: Barry LaFond
>
> In designer when defining a table in view model with following transformation query, bad error message is returned to user.
> SELECT cust.id AS customer_id, SUM(ord.amount) AS total_amount
> FROM
> customers AS cust INNER JOIN orders AS ord
> ON cust.id = ord.customer_id
> GROUP BY cust.id;
> When user forgets to write the GROUP BY clause then error with following message occurs: "ERROR:ERROR".
> When I execute similar query via teeid driver then I get very useful message: "Error: Remote org.teiid.api.exception.query.QueryValidatorException: Non-constant, non-aggregate expression cust.id cannot be mixed with aggregate functions and implicit grouping."
> It would be very helpful if Teiid designer gave similar message instead of the "ERROR:ERROR" one.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIIDDES-2187) Teiid Connection importer- chosing a location isn't filled in unless you hit back button
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2187?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2187.
------------------------------------
Fix Version/s: (was: 9.0)
(was: 9.0.1)
Resolution: Out of Date
Support/patching for 8.3.x branch has ended. Upgrading support using Designer 8.6.x branch. Mark's testing with Windows 7 confirms that upgrading next JBDSIS 7.1 patch release and using Windows 7 or above fixes the issue.
> Teiid Connection importer- chosing a location isn't filled in unless you hit back button
> ----------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2187
> URL: https://issues.jboss.org/browse/TEIIDDES-2187
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.3.2
> Environment: Windows Vista or 2008 Only
> Reporter: Debbie Steigner
> Assignee: Mark Drilling
> Fix For: 8.6.1
>
>
> This only happens when installed on Windows Vista or 2008 not on Linux.
> Choose File -> Import -> Teiid Designer -> Teiid Connection >> Source model:
> Then, choose a particular data source (shouldn't matter which one)
> Click "Next", this screen will now ask you to choose a location
> Click on the dots behind the grayed out "Location:" field and choose a location
> After selecting a location and pressing the "Ok" button, the location is not taken from the "Select a folder" dialog box and therefore empty.
> If I now choose "Back", I arrive in the previous screen again. Pressing "Next" again now does fill in the previously chosen "Location" value.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIIDDES-2384) Visual corruption of dropdowns in import dialogs
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2384?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration commented on TEIIDDES-2384:
---------------------------------------------------
Barry LaFond <blafond(a)redhat.com> changed the Status of [bug 1161181|https://bugzilla.redhat.com/show_bug.cgi?id=1161181] from NEW to MODIFIED
> Visual corruption of dropdowns in import dialogs
> ------------------------------------------------
>
> Key: TEIIDDES-2384
> URL: https://issues.jboss.org/browse/TEIIDDES-2384
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs, Eclipse Integration, Usability
> Affects Versions: 9.0.1
> Environment: Teiid Designer 9.0.1.Beta1-v20141021-1225-B183
> JBDS 8.0.0.GA
> Fedora 20
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Attachments: dropdown-corruption-1.png, dropdown-corruption-2.png
>
>
> Dropdowns in some of the import dialogs (JDBC import dialog, Teiid Connection import dialog) seem to overlay several entries over each other, which makes selecting with mouse impossible. Selecting with arrow keys is possible, but the items are highlighted in seemingly random order.
> This issue does not appear anywhere else (at least I haven't been able to find any other examples).
> Only happens on Linux.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIIDDES-2384) Visual corruption of dropdowns in import dialogs
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2384?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2384.
------------------------------------
Assignee: Barry LaFond
Resolution: Duplicate Issue
This was already logged and fixed as: https://issues.jboss.org/browse/TEIIDDES-2375 and will be available in the next 9.0.x milestone
> Visual corruption of dropdowns in import dialogs
> ------------------------------------------------
>
> Key: TEIIDDES-2384
> URL: https://issues.jboss.org/browse/TEIIDDES-2384
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs, Eclipse Integration, Usability
> Affects Versions: 9.0.1
> Environment: Teiid Designer 9.0.1.Beta1-v20141021-1225-B183
> JBDS 8.0.0.GA
> Fedora 20
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Attachments: dropdown-corruption-1.png, dropdown-corruption-2.png
>
>
> Dropdowns in some of the import dialogs (JDBC import dialog, Teiid Connection import dialog) seem to overlay several entries over each other, which makes selecting with mouse impossible. Selecting with arrow keys is possible, but the items are highlighted in seemingly random order.
> This issue does not appear anywhere else (at least I haven't been able to find any other examples).
> Only happens on Linux.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIIDDES-2384) Visual corruption of dropdowns in import dialogs
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2384?page=com.atlassian.jira.plu... ]
RH Bugzilla Integration updated TEIIDDES-2384:
----------------------------------------------
Bugzilla Update: Perform
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1161181
> Visual corruption of dropdowns in import dialogs
> ------------------------------------------------
>
> Key: TEIIDDES-2384
> URL: https://issues.jboss.org/browse/TEIIDDES-2384
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs, Eclipse Integration, Usability
> Affects Versions: 9.0.1
> Environment: Teiid Designer 9.0.1.Beta1-v20141021-1225-B183
> JBDS 8.0.0.GA
> Fedora 20
> Reporter: Andrej Šmigala
> Attachments: dropdown-corruption-1.png, dropdown-corruption-2.png
>
>
> Dropdowns in some of the import dialogs (JDBC import dialog, Teiid Connection import dialog) seem to overlay several entries over each other, which makes selecting with mouse impossible. Selecting with arrow keys is possible, but the items are highlighted in seemingly random order.
> This issue does not appear anywhere else (at least I haven't been able to find any other examples).
> Only happens on Linux.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months
[JBoss JIRA] (TEIIDDES-2384) Visual corruption of dropdowns in import dialogs
by Andrej Šmigala (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2384?page=com.atlassian.jira.plu... ]
Andrej Šmigala updated TEIIDDES-2384:
-------------------------------------
Attachment: dropdown-corruption-1.png
dropdown-corruption-2.png
> Visual corruption of dropdowns in import dialogs
> ------------------------------------------------
>
> Key: TEIIDDES-2384
> URL: https://issues.jboss.org/browse/TEIIDDES-2384
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dialogs, Eclipse Integration, Usability
> Affects Versions: 9.0.1
> Environment: Teiid Designer 9.0.1.Beta1-v20141021-1225-B183
> JBDS 8.0.0.GA
> Fedora 20
> Reporter: Andrej Šmigala
> Attachments: dropdown-corruption-1.png, dropdown-corruption-2.png
>
>
> Dropdowns in some of the import dialogs (JDBC import dialog, Teiid Connection import dialog) seem to overlay several entries over each other, which makes selecting with mouse impossible. Selecting with arrow keys is possible, but the items are highlighted in seemingly random order.
> This issue does not appear anywhere else (at least I haven't been able to find any other examples).
> Only happens on Linux.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)
11 years, 5 months