How can we help you today?
mysql: select column as abc ... ignores new columnname
4 CommentsSorted by Oldest First
Roger Bjärevall
said
about 16 years ago
[This reply is migrated from our old forums.]
Re: mysql: select column as abc ... ignores new columnname
Re: mysql: select column as abc ... ignores new columnname
Tanja,
Seem to be a bug in the JDBC driver. It works fine with (for example):
mysql-connector-java-3.1.13
mysql-connector-java-3.1.14
mysql-connector-java-5.0.5
mysql-connector-java-5.0.6
mysql-connector-java-5.0.7
mysql-connector-java-5.0.8
It doesn't work with:
mysql-connector-java-5.0.3
mysql-connector-java-5.1.5
mysql-connector-java-5.1.6
The conclusion is to try another version.
Best Regards
Roger
[This reply is migrated from our old forums. The original author name has been removed]
Re: mysql: select column as abc ... ignores new columnname
Re: mysql: select column as abc ... ignores new columnname
Hello!
Thank you for the answer. I opened a bug report at mysql and the answer was, that with DBVisualizer 6.0.2 there is no problem anymore and for older versions the
useOldAliasMetadataBehavior Parameter has to be set to "true":
jdbc:mysql://localhost/&useOldAliasMetadataBehavior=true
best regards
Tanja
Roger Bjärevall
said
about 16 years ago
[This reply is migrated from our old forums.]
Re: mysql: select column as abc ... ignores new columnname
Re: mysql: select column as abc ... ignores new columnname
Tanja,
Thanks for the clarification!
(However, this is not related to DbVisualizer at all but rather what version of the MySQL JDBC driver that is used).
Best Regards
Roger
Roger Bjärevall
said
almost 13 years ago
[This reply is migrated from our old forums.]
Re: mysql: select column as abc ... ignores new columnname
Re: mysql: select column as abc ... ignores new columnname
Tanja,
This is now fixed in the 8.0.6 version.
http://www.dbvis.com/products/dbvis/doc/relnotes/index.jsp?product=DbVisualizer&version=8.0.6
http://www.dbvis.com/products/dbvis/download/
Regards
Roger
anonymous