You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@netbeans.apache.org by GitBox <gi...@apache.org> on 2021/01/20 20:22:48 UTC

[GitHub] [netbeans] ses1112 opened a new pull request #2695: [NETBEANS-5269] Tooltip of columns in result-table

ses1112 opened a new pull request #2695:
URL: https://github.com/apache/netbeans/pull/2695


   If you execute a query on the db, a result-table appears. There you can hover about the column-name und you can see some additional information about the structure of the column. If the column is of the type string, it also shows the attribute "length" with the precision of the column. This doesn't make sense, because by string there is no precision.
   It occured with MariaDB and with a column of the type char(36).


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@netbeans.apache.org
For additional commands, e-mail: notifications-help@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

[GitHub] [netbeans] ses1112 closed pull request #2695: [NETBEANS-5269] Tooltip of columns in result-table

Posted by GitBox <gi...@apache.org>.
ses1112 closed pull request #2695:
URL: https://github.com/apache/netbeans/pull/2695


   


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@netbeans.apache.org
For additional commands, e-mail: notifications-help@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

[GitHub] [netbeans] matthiasblaesing commented on pull request #2695: [NETBEANS-5269] Tooltip of columns in result-table

Posted by GitBox <gi...@apache.org>.
matthiasblaesing commented on pull request #2695:
URL: https://github.com/apache/netbeans/pull/2695#issuecomment-763962917


   I reread the spec and no, NetBeans behaves correctly. See here (https://docs.oracle.com/javase/8/docs/api/java/sql/ResultSetMetaData.html#getPrecision-int-):
   
   > Get the designated column's specified column size. For numeric data, this is the maximum precision. **For character data, this is the length in characters**. For datetime datatypes, this is the length in characters of the String representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, this is the length in bytes. 0 is returned for data types where the column size is not applicable.
   
   So netbeans does the right thing - sorry, that I did not find that on the first pass, but on second read this is an issue in the DB driver.


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@netbeans.apache.org
For additional commands, e-mail: notifications-help@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

[GitHub] [netbeans] matthiasblaesing commented on pull request #2695: [NETBEANS-5269] Tooltip of columns in result-table

Posted by GitBox <gi...@apache.org>.
matthiasblaesing commented on pull request #2695:
URL: https://github.com/apache/netbeans/pull/2695#issuecomment-785294889


   Thank you for pursuing this and getting it fixed :thumbsup:


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@netbeans.apache.org
For additional commands, e-mail: notifications-help@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

[GitHub] [netbeans] ses1112 closed pull request #2695: [NETBEANS-5269] Tooltip of columns in result-table

Posted by GitBox <gi...@apache.org>.
ses1112 closed pull request #2695:
URL: https://github.com/apache/netbeans/pull/2695


   


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@netbeans.apache.org
For additional commands, e-mail: notifications-help@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

[GitHub] [netbeans] ses1112 closed pull request #2695: [NETBEANS-5269] Tooltip of columns in result-table

Posted by GitBox <gi...@apache.org>.
ses1112 closed pull request #2695:
URL: https://github.com/apache/netbeans/pull/2695


   


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@netbeans.apache.org
For additional commands, e-mail: notifications-help@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

[GitHub] [netbeans] matthiasblaesing commented on pull request #2695: [NETBEANS-5269] Tooltip of columns in result-table

Posted by GitBox <gi...@apache.org>.
matthiasblaesing commented on pull request #2695:
URL: https://github.com/apache/netbeans/pull/2695#issuecomment-763962917


   I reread the spec and no, NetBeans behaves correctly. See here (https://docs.oracle.com/javase/8/docs/api/java/sql/ResultSetMetaData.html#getPrecision-int-):
   
   > Get the designated column's specified column size. For numeric data, this is the maximum precision. **For character data, this is the length in characters**. For datetime datatypes, this is the length in characters of the String representation (assuming the maximum allowed precision of the fractional seconds component). For binary data, this is the length in bytes. For the ROWID datatype, this is the length in bytes. 0 is returned for data types where the column size is not applicable.
   
   So netbeans does the right thing - sorry, that I did not find that on the first pass, but on second read this is an issue in the DB driver.


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@netbeans.apache.org
For additional commands, e-mail: notifications-help@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

[GitHub] [netbeans] ses1112 commented on pull request #2695: [NETBEANS-5269] Tooltip of columns in result-table

Posted by GitBox <gi...@apache.org>.
ses1112 commented on pull request #2695:
URL: https://github.com/apache/netbeans/pull/2695#issuecomment-785059569


   It was an error in the MariaDB-Driver:
   https://jira.mariadb.org/browse/CONJ-850


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

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@netbeans.apache.org
For additional commands, e-mail: notifications-help@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists