Hi,
I have created a function aliases:
CREATE ALIAS DATE FOR "archon.exodus.h2.TimeFunctions.parseDate";
Inside TimeFunctions I have three versions of the method parseDate
1) public static Date parseDate(long ms)
2) public static Date parseDate(String dateLiteral, String formatPattern)
3) public static Date parseDate(String dateLiteral, String
formatPattern, String tzName)
When selecting "SELECT * FROM INFORMATION_SCHEMA.FUNCTION_ALIASES"
there exists 3 rows of the same alias DATE (different versions).
ALIAS_CATALOG
<https://db.tv7.fi:8084/query.do?jsessionid=6145746a49473d5761d8bca6152d1a55#>
ALIAS_SCHEMA
<https://db.tv7.fi:8084/query.do?jsessionid=6145746a49473d5761d8bca6152d1a55#>
ALIAS_NAME
<https://db.tv7.fi:8084/query.do?jsessionid=6145746a49473d5761d8bca6152d1a55#>
JAVA_CLASS
<https://db.tv7.fi:8084/query.do?jsessionid=6145746a49473d5761d8bca6152d1a55#>
JAVA_METHOD
<https://db.tv7.fi:8084/query.do?jsessionid=6145746a49473d5761d8bca6152d1a55#>
DATA_TYPE
<https://db.tv7.fi:8084/query.do?jsessionid=6145746a49473d5761d8bca6152d1a55#>
COLUMN_COUNT
<https://db.tv7.fi:8084/query.do?jsessionid=6145746a49473d5761d8bca6152d1a55#>
RETURNS_RESULT
<https://db.tv7.fi:8084/query.do?jsessionid=6145746a49473d5761d8bca6152d1a55#>
REMARKS
<https://db.tv7.fi:8084/query.do?jsessionid=6145746a49473d5761d8bca6152d1a55#>
ID
<https://db.tv7.fi:8084/query.do?jsessionid=6145746a49473d5761d8bca6152d1a55#>
SOURCE
<https://db.tv7.fi:8084/query.do?jsessionid=6145746a49473d5761d8bca6152d1a55#>
TV7 EXODUS DATE archon.exodus.h2.TimeFunctions parseDate 91
1 2 12 /null/
TV7 EXODUS DATE archon.exodus.h2.TimeFunctions parseDate 91
2 2 12 /null/
TV7 EXODUS DATE archon.exodus.h2.TimeFunctions parseDate 91
3 2 12 /null/
Now when I would like to comment those 3 different versions of the
function alias differently it turns out to be impossible.
COMMENT ON ALIAS DATE IS 'DATE(bigint:millis) -> DATE';
Puts the same comment for all the versions.
ALIAS_CATALOG
<https://192.168.42.128:8082/query.do?jsessionid=796407946da6f596d06eb618a1560a6f#>
ALIAS_SCHEMA
<https://192.168.42.128:8082/query.do?jsessionid=796407946da6f596d06eb618a1560a6f#>
ALIAS_NAME
<https://192.168.42.128:8082/query.do?jsessionid=796407946da6f596d06eb618a1560a6f#>
JAVA_CLASS
<https://192.168.42.128:8082/query.do?jsessionid=796407946da6f596d06eb618a1560a6f#>
JAVA_METHOD
<https://192.168.42.128:8082/query.do?jsessionid=796407946da6f596d06eb618a1560a6f#>
DATA_TYPE
<https://192.168.42.128:8082/query.do?jsessionid=796407946da6f596d06eb618a1560a6f#>
COLUMN_COUNT
<https://192.168.42.128:8082/query.do?jsessionid=796407946da6f596d06eb618a1560a6f#>
RETURNS_RESULT
<https://192.168.42.128:8082/query.do?jsessionid=796407946da6f596d06eb618a1560a6f#>
REMARKS
<https://192.168.42.128:8082/query.do?jsessionid=796407946da6f596d06eb618a1560a6f#>
ID
<https://192.168.42.128:8082/query.do?jsessionid=796407946da6f596d06eb618a1560a6f#>
SOURCE
<https://192.168.42.128:8082/query.do?jsessionid=796407946da6f596d06eb618a1560a6f#>
TV7 EXODUS DATE archon.exodus.h2.TimeFunctions parseDate 91 1 2
DATE(bigint:millis) -> DATE 14 /null/
TV7 EXODUS DATE archon.exodus.h2.TimeFunctions parseDate 91 2 2
DATE(bigint:millis) -> DATE 14 /null/
TV7 EXODUS DATE archon.exodus.h2.TimeFunctions parseDate 91 3 2
DATE(bigint:millis) -> DATE 14 /null/
The reason being of course that different objects in the database have
the same name
One way to solve this would be to enable a syntax like this
COMMENT ON ALIAS DATE(COLUMN_COUNT) IS 'blah blah blah';
Further it seems a tad bit peculiar that the same thing is called
somewhere COMMENT and in other places REMARK (but that is just an
aesthetic issue).
- rami
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
