You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "AleBonini (via GitHub)" <gi...@apache.org> on 2023/02/09 14:27:59 UTC
[GitHub] [hop] AleBonini opened a new issue, #2295: [Bug]: table input automatically insert square bracket and this leads to error
AleBonini opened a new issue, #2295:
URL: https://github.com/apache/hop/issues/2295
### Apache Hop version?
2.3
### Java version?
11
### Operating system
Windows
### What happened?
When I use _table input_ transform and I select a table from a db in the query the program automatically adds square brackets and this lead to an error because the query results wrong. If I manually delete the extra square brackets it works but in this way I can't automatically select all the fields on the table if not with _select *_. This problem is present with all type of db connection, but I noticed that if the schema is beetween _" "_ the problem is not present.
![image](https://user-images.githubusercontent.com/57216494/217839612-c12cc147-3b20-4fc9-bba4-d142f7c5161d.png)
### Issue Priority
Priority: 3
### Issue Component
Component: Actions
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [hop] gertwieland commented on issue #2295: [Bug]: Table input automatically insert square bracket around schema and this leads to error
Posted by "gertwieland (via GitHub)" <gi...@apache.org>.
gertwieland commented on issue #2295:
URL: https://github.com/apache/hop/issues/2295#issuecomment-1445221453
I have exactly the same issue.
Win 11, Hop 2.3, Java 11
SQL Database is an Azure SQL db.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [hop] hansva commented on issue #2295: [Bug]: table input automatically insert square bracket and this leads to error
Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #2295:
URL: https://github.com/apache/hop/issues/2295#issuecomment-1424287483
Database type and version?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [hop] AleBonini commented on issue #2295: [Bug]: table input automatically insert square bracket and this leads to error
Posted by "AleBonini (via GitHub)" <gi...@apache.org>.
AleBonini commented on issue #2295:
URL: https://github.com/apache/hop/issues/2295#issuecomment-1424318967
Ok sorry I checked better and with oracle and mysql I don't have the problem since there the schema is always between _" "_. The problem is with mssql (native) version: Microsoft SQL Server 2012 (SP3) (KB3072779) - 11.0.6020.0 (X64)
Oct 20 2015 15:36:27
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
and postregsql version: PostgreSQL 11.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org