#89 Bad table sorting change in 3.6.1

closed
Heiko Hilbert
None
5
2011-10-07
2011-10-04
cardonbj
No

I have been using SQL Explorer for two years now, and this latest update is barely usable for me anymore. What this boils down to for me is the way that the tables are sorted in the Database Structure view that has changed drastically in this last update. It used to look like this:

Namespace.TableName

Now it looks like this:

SchemaName.Namespace.TableName

Why even show the Schema name at all? I already saw that when I clicked to open it. Also, it is now sorted like this, which is REALLY frustrating:

SchemaName.test.aaa
SchemaName.zed.aaa
SchemaName.test.alpha
SchemaName.apple.beta
SchemaName.fred.charlie

Therefore, you cannot rely on grouping by namespace name, which makes looking for tables cumbersome and annoying. I noticed in the options that there is now a way to disable "Show table name with schema", however SQL Explorer has decided that the table namespace is part of the schema and removes it when this option is disabled.

This sorting really messes up the Database Structure view. If nothing else, an option should be put in to restore the old sorting.

Discussion

  • Heiko Hilbert
    Heiko Hilbert
    2011-10-04

    In the last release there was no change in Table sorting. The option you found was added with 3.5.0.RC7 (25.02.2009). It applies on information provided by the squirrel library we are using here.
    Which Databae do you use? So I can check which information is available from this database to resolve this.

     
  • cardonbj
    cardonbj
    2011-10-04

    o_O I have been using other versions of SQL Explorer since that date and nothing changed until I updated to 3.6.1. I am using Microsoft SQL Server 2008 with the jTDS 1.2.5 driver.

     
  • Heiko Hilbert
    Heiko Hilbert
    2011-10-06

    How do you create such tables. In the documentation I found this:

    CREATE TABLE
    [ database_name . [ schema_name ] . | schema_name . ] table_name ....

    Does this mean SchemaName = database, test = schema_name, aaa = table_name ?

     
  • Heiko Hilbert
    Heiko Hilbert
    2011-10-06

    • assigned_to: nobody --> hhilbert
     
  • cardonbj
    cardonbj
    2011-10-06

    I guess I should have checked the documentation before looking.

    Yes, it is showing DatabaseName.SchemaName.TableName

    Before upgrading to 3.6.1 I was only seeing

    SchemaName.TableName

    I don't really think seeing the DatabaseName there adds any value at all.

    You can create a table using:

    USE TestDatabase
    GO
    CREATE TABLE [test].[alpha]... etc

     
  • Heiko Hilbert
    Heiko Hilbert
    2011-10-06

    I have found it.
    A fix made for DB2 with last release causes the change that the cataloge name is now displayed for mssql tables when 'Show table with schema' is on. I have to check what the problem with DB2 was for that change to found a solution which works for 'all' database systems.

     
  • cardonbj
    cardonbj
    2011-10-06

    Great. Thanks for looking into this so quickly. SQL Explorer is a great tool.

     
  • Heiko Hilbert
    Heiko Hilbert
    2011-10-07

    • status: open --> closed
     
  • Heiko Hilbert
    Heiko Hilbert
    2011-10-07

    The problem is solved. I have deployed a patch on the update site. So after updating your SQL Expolrer installation all should be fine.