You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "Akira74 (via GitHub)" <gi...@apache.org> on 2026/01/29 11:27:30 UTC

[I] [Bug]: Wrong datatypes in SQLiteDB when specified with size in DB (hop)

Akira74 opened a new issue, #6472:
URL: https://github.com/apache/hop/issues/6472

   ### Apache Hop version?
   
   2.15.0
   
   ### Java version?
   
   OpenJDK Runtime Environment Temurin-17.0.17+10 (build 17.0.17+10)
   
   ### Operating system
   
   Windows
   
   ### What happened?
   
   1. Create a SQLiteDB with
   CREATE TABLE str_test (
       TEXT      TEXT,
       TEXT_50   TEXT (50),
       INTEGER   INTEGER,
       INTEGER20 INTEGER (20),
       NUMERIC   NUMERIC,
       NUMERIC20 NUMERIC (20),
       REAL      REAL,
       REAL10    REAL (10),
       BLOB      BLOB
   );
   
   
   open database in database explorer:
   The datatypes without a length are correct.
   The datatypes with a specified length, the length is correct but the datatype is always BigNumber
   
   
   
   
   ### Issue Priority
   
   Priority: 2
   
   ### Issue Component
   
   Component: Database


-- 
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

Re: [I] [Bug]: Wrong datatypes in SQLiteDB when specified with size in DB (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #6472:
URL: https://github.com/apache/hop/issues/6472#issuecomment-3818010027

   I just noticed the TEXT one, that clearly is incorrect... some more investigation might be needed


-- 
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

Re: [I] [Bug]: Wrong datatypes in SQLiteDB when specified with size in DB (hop)

Posted by "Akira74 (via GitHub)" <gi...@apache.org>.
Akira74 commented on issue #6472:
URL: https://github.com/apache/hop/issues/6472#issuecomment-3819258554

   Ok, many thanks to the corrections on the other Data types.
   I just had trouble with the  TEXT (50) field. 
   I will create a Test DB with some more data Types (with correct length) and will try it again.
   


-- 
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

Re: [I] [Bug]: Wrong datatypes in SQLiteDB when specified with size in DB (hop)

Posted by "Akira74 (via GitHub)" <gi...@apache.org>.
Akira74 commented on issue #6472:
URL: https://github.com/apache/hop/issues/6472#issuecomment-3817869069

   <img width="714" height="205" alt="Image" src="https://github.com/user-attachments/assets/2b458342-5fa1-4a2c-b5e8-2066573005f2" />


-- 
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

Re: [I] [Bug]: Wrong datatypes in SQLiteDB when specified with size in DB (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva commented on issue #6472:
URL: https://github.com/apache/hop/issues/6472#issuecomment-3817935549

   An integer with 20 positions is a correctly a BigNumber, a default integer only has 10 positions.
   For the number, internally we use a Double, which technically can be larger, but by default we convert to BigNumber when it is longer than 15 characters or precision is larger than 15 characters
   


-- 
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

Re: [I] [Bug]: Wrong datatypes in SQLiteDB when specified with size in DB (hop)

Posted by "hansva (via GitHub)" <gi...@apache.org>.
hansva closed issue #6472: [Bug]: Wrong datatypes in SQLiteDB when specified with size in DB
URL: https://github.com/apache/hop/issues/6472


-- 
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