1 Reply Latest reply: Dec 18, 2013 10:19 PM by Vin Steele RSS

    Bug v4.0 - SQL History not saved

    Marwim

      Hello,

       

      1. Install version 4.0.0.13 on German XP (JDK1.7.0_40) without migrating settings from previous versions.
      2. Import connections saved from version 3.2.2.
      3. Press F8 -> I can see the SQL History generated by 3.2.2
      4. Open a connection and query SELECT 1 FROM dual;
      5. SQL History is updated
      6. Restart SQL Devloper
      7. Press F8 -> Same History as in step 3

       

      I had to delete the complete history, now v4.0 saves the executet SQL. Of course I had to delete it using v3.2.2, because 4.0 didn't save any changes.

       

      Additionally it would be great when each version would use the same timestamp format.

      • 3.2.2 writes dd.mm.yyyy hh24:mi (the format I would prefer)
      • 4.0 writes mm/dd/yy hh24:mi

       

      Regards

      Marcus

       

      BTW: Can someone explain the order logic in the timestamp column of the SQL History :-)

       

      sorting in v4.0 from my tests

      Sort descending

      12/18/12 10:14

      18.12.2013 10:17

      18.12.2013 10:10

      12/18/13 10:16

       

      Same history in 3.2.2

      Sort descending

      18.12.2013 10:17

      12/18/12 10:14

      18.12.2013 10:10

      12/18/13 10:16

       

      An example in v4.0 from my now deleted history

      Sort ascending

      13.08.2013 12:21

      07.08.2013 16:10

      06.06.2013 08:27

      04.06.2013 10:19

      31.01.2013 15:29

      14.01.2013 08:39

      7/20/11 11:04 AM

      25.10.2012 15:34

      25.10.2012 09:41

      6/20/12 1:21 PM

      12/29/11 9:43 AM

      20.10.2013 16:48

      26.09.2013 08:38

      31.07.2013 08:36

      22.10.2012 14:30

      4/10/12 3:08 PM

      23.04.2013 16:03

      12.12.2012 10:31

      ...