SQL Server 2008 (Express) and Oracle 10g also use the same values for column labels and names on the database metadata result sets.
On May 4, 5:35 am, Bear <[email protected]> wrote: > Postgresql, mysql, derby, hsqldb, sqlite. I'm in the process of > standing up oracle and sqlserver instances so I'll know about them in > a few days. > > Please note that my question is different than the FAQ. I know the > difference between column names and labels and in fact that's why my > tool uses labels for the report's column headers. E.g., maybe the > user wrote > > select foo.x as foo, bar.x as bar from foo, bar > > and column name would be ambiguous. > > I'm looking specifically at the results of DatabaseMetaData queries, > e.g., getting a list of schemas or table types available in the > database. The javadoc refers to 'columns' but doesn't appear to > explicitly state that column names and labels must be identical. > > BTW the tool is a class that dumps jdbc result sets into properly > formatted excel files. E.g., it uses the correct formatting for > number of significant digits, understands whether a column is a > datetime, date or time, etc. The database metadata often comes up > (e.g. what types are there?) so there's wrappers for all of the > database metadata queries. The unit tests for those are tripping > since the report uses the column label but the unit test uses the > column name. It's easy to change but having seen 5 other databases > use the same values for both name and label so I wanted to point out > the inconsistency to you. > > Bear > > On May 3, 12:46 pm, Thomas Mueller <[email protected]> > wrote: > > > Hi, > > > This is a surprisingly common question. > > Seehttp://www.h2database.com/html/faq.html#column_names_incorrect > > > > all of the other databases I've tested > > > Which ones did you test? > > > Regards, > > Thomas > > > -- > > 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 > > athttp://groups.google.com/group/h2-database?hl=en. > > -- > 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 > athttp://groups.google.com/group/h2-database?hl=en. -- 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.
