forum.vmspython.org Forum Index forum.vmspython.org
Forum system
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

show variables like 'version%' - broken

 
Post new topic   Reply to topic    forum.vmspython.org Forum Index -> MySQL for OpenVMS
View previous topic :: View next topic  
Author Message
karcher



Joined: 11 Jan 2011
Posts: 7
Location: Madison, WI USA

PostPosted: Thu Mar 29, 2012 12:12 am    Post subject: show variables like 'version%' - broken Reply with quote

With MySQL V5.1.46 on IA64 the following works:

Code:

mysql> show variables like 'v%';
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| version                 | 5.1.46-log          |
| version_comment         | Source distribution |
| version_compile_machine | IA64                |
| version_compile_os      | OpenVMS             |
+-------------------------+---------------------+
4 rows in set (0.00 sec)


However, this fails:

Code:

mysql> show variables like 'version%';
Empty set (0.00 sec)

mysql>


This same query is used in installation scripts for various open source packages such as Request Tracker (bestpractical.com), horde webmail and atmail, making hosting a mysql db on VMS difficult.
Back to top
View user's profile Send private message Send e-mail
jescab



Joined: 28 Jan 2008
Posts: 252

PostPosted: Thu Mar 29, 2012 11:10 pm    Post subject: Reply with quote

Just as a reference (AlphaServer DS25 running OpenVMS V8.4)...
Code:

mysql> show variables like 'v%';
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| version                 | 5.1.46-log          |
| version_comment         | Source distribution |
| version_compile_machine | Alpha               |
| version_compile_os      | OpenVMS             |
+-------------------------+---------------------+
4 rows in set (0.01 sec)

mysql> show variables like 'version%';
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| version                 | 5.1.46-log          |
| version_comment         | Source distribution |
| version_compile_machine | Alpha               |
| version_compile_os      | OpenVMS             |
+-------------------------+---------------------+
4 rows in set (0.00 sec)

mysql> show variables like 'version_%';
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| version_comment         | Source distribution |
| version_compile_machine | Alpha               |
| version_compile_os      | OpenVMS             |
+-------------------------+---------------------+
3 rows in set (0.01 sec)

mysql>
Back to top
View user's profile Send private message
jfp



Joined: 12 Jul 2004
Posts: 618

PostPosted: Fri Apr 06, 2012 2:59 pm    Post subject: Reply with quote

I was nuable to reproduce, on my IA64 system:
Code:
mysql> show variables like 'v%';
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| version                 | 5.1.46-log          |
| version_comment         | Source distribution |
| version_compile_machine | IA64                |
| version_compile_os      | OpenVMS             |
+-------------------------+---------------------+
4 rows in set (0.00 sec)

mysql> show variables like 'version%';
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| version                 | 5.1.46-log          |
| version_comment         | Source distribution |
| version_compile_machine | IA64                |
| version_compile_os      | OpenVMS             |
+-------------------------+---------------------+
4 rows in set (0.00 sec)


JF
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    forum.vmspython.org Forum Index -> MySQL for OpenVMS All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group