#89 Bad table sorting change in 3.6.1

closed
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.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks