Saurabh Kejriwal created DERBY-5818:
---------------------------------------
Summary: values
syscs_util.syscs_get_database_property('DataDictionaryVersion' ) does not
return full version information
Key: DERBY-5818
URL: https://issues.apache.org/jira/browse/DERBY-5818
Project: Derby
Issue Type: Bug
Reporter: Saurabh Kejriwal
Details
------------
$ ./sysinfo
------------------ Java Information ------------------
Java Version: 1.6.0
Java Vendor: Sun Microsystems Inc.
Java home: /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre
Java classpath:
/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derby.jar:/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derbynet.jar:/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derbytools.jar:/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derbyclient.jar
OS name: Linux
OS architecture: i386
OS version: 2.6.18-164.0.0.0.1.el5xen
Java user name: ansverma
Java user home: /home/ansverma
Java user dir: /scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/bin
java.specification.name: Java Platform API Specification
java.specification.version: 1.6
java.runtime.version: 1.6.0-b09
--------- Derby Information --------
JRE - JDBC: Java SE 6 - JDBC 4.0
[/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derby.jar] 10.8.2.2 -
(1181258)
[/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derbytools.jar] 10.8.2.2
- (1181258)
[/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derbynet.jar] 10.8.2.2 -
(1181258)
[/scratch/ansverma/JavaDBnew/db-derby-10.8.2.2-bin/lib/derbyclient.jar]
10.8.2.2 - (1181258)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale : [English/United States [en_US]]
Found support for locale: [cs]
version: 10.8.2.2 - (1181258)
Found support for locale: [de_DE]
version: 10.8.2.2 - (1181258)
Found support for locale: [es]
version: 10.8.2.2 - (1181258)
Found support for locale: [fr]
version: 10.8.2.2 - (1181258)
Found support for locale: [hu]
version: 10.8.2.2 - (1181258)
Found support for locale: [it]
version: 10.8.2.2 - (1181258)
Found support for locale: [ja_JP]
version: 10.8.2.2 - (1181258)
Found support for locale: [ko_KR]
version: 10.8.2.2 - (1181258)
Found support for locale: [pl]
version: 10.8.2.2 - (1181258)
Found support for locale: [pt_BR]
version: 10.8.2.2 - (1181258)
Found support for locale: [ru]
version: 10.8.2.2 - (1181258)
Found support for locale: [zh_CN]
version: 10.8.2.2 - (1181258)
Found support for locale: [zh_TW]
version: 10.8.2.2 - (1181258)
------------------------------------------------------
Description
-----------------
I am using Derby 10.8.2.2. I want to get derby version details through SQL. I
ran following query to retrieve version information.
$ java -jar /scratch/ansverma/JavaDBnew//db-derby-10.8.2.2-bin/lib/derbyrun.jar
ij
ij version 10.8
ij> CONNECT 'jdbc:derby:test2;user=test2;password=test2';
ij> values syscs_util.syscs_get_database_property('DataDictionaryVersion');
1
--------------------------------------------------------------------------------------------------------------------------------
10.8
1 row selected
It did not return full version information (10.8.2.2) for Derby.
Expected result = 10.8.2.2
Actual result = 10.8
I want the version details through SQL query.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
