a file named fOo.h2.db is created
Inside the database that db is referred to as catalog FOO
Why do you need the catalog? It is supported for compatibility (with
OpenOffice as far as I remember).
Why did you write function DATABASE()?
It returns the name of catalog (or should I say database?).
And it returns it in all uppercase.
Now why would it do that?
Because clearly the url to connect to it does not think that is the name of the
database (if the file has lowercase letters).
And why in the information_schema tables the catalog name is mentioned
everywhere? Clearly it can have only one value everywhere. The name of the
database. Of course it is for compatibility you say.
But trust me. If you make a definate decision (or should I say conceptual
clarification) that x is what catalog means and y is what database means then it
is so much simpler for users to use the software.
In addition of having clear meanings one needs also clear syntax rules.
So if DATABASE() returns the name of the database in all uppercase then
that value should work everywhere where a reference to that database is made.
Right? I think the reason here would be called consistency.
So since the catalog and database name are case insensitive (all uppercase)
I think the file name should be too.
No, I think that's not required.
Jolly Good!
It certainly is not required but it is desired :-)
Think about this use case.
Someone has 3 databases on linux and wants to move them on windows.
Oh but he can't.
What is the benefit of keeping database names case-sensitive?
- 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.
