Click here to Skip to main content
15,884,760 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: M5 Stack Fire - can recommend! Pin
dandy729-Jun-22 3:41
dandy729-Jun-22 3:41 
GeneralRe: M5 Stack Fire - can recommend! Pin
PIEBALDconsult8-Jun-22 14:10
mvePIEBALDconsult8-Jun-22 14:10 
GeneralRe: M5 Stack Fire - can recommend! Pin
honey the codewitch8-Jun-22 14:46
mvahoney the codewitch8-Jun-22 14:46 
GeneralRe: M5 Stack Fire - can recommend! Pin
John Wellbelove8-Jun-22 22:08
John Wellbelove8-Jun-22 22:08 
GeneralRe: M5 Stack Fire - can recommend! Pin
honey the codewitch8-Jun-22 22:48
mvahoney the codewitch8-Jun-22 22:48 
GeneralRe: M5 Stack Fire - can recommend! Pin
dandy729-Jun-22 3:26
dandy729-Jun-22 3:26 
RantMS Azure Storage Explorer Pin
TNCaver8-Jun-22 4:43
TNCaver8-Jun-22 4:43 
GeneralRe: MS Azure Storage Explorer Pin
jsc428-Jun-22 5:36
professionaljsc428-Jun-22 5:36 
This sounds like it is similar to a problem I encountered with Oracle some years ago (10+ years?).

In the previous version of Oracle (7 or 8?), a statement like
(my Oracle SQL syntax is rusty, so this may be incorrect)
SQL
SELECT TOP 1000 Surname
FROM Employees
ORDER BY Surname
gave an alphabetical list of 1000 surnames starting at A and going as far as (say) C; but the next version (10?) gave an alphabetical list of 1000 surnames not necessarily starting with A and not necessarily ending with C. I spotted it, because my name used to appear in the answer, but then stopped appearing.

The reason (I worked out) was that the old version did the ORDER BY first, then the TOP 1000 (so they were pre-sorted then truncated); and the new version did the TOP 1000 first, then did the ORDER BY (so they were sorted after truncation meaning that you got a random sample). Both are - as I understand it - valid results from the SQL statement, but the difference upset a lot of people (including myself) who thought that they had been eliminated and not told about it.

My solution, to get my preferred old-style list, was something like
(again, my Oracle SQL is rusty)
SQL
SELECT TOP 1000 Surname
FROM 
   (
      SELECT Surname
      FROM Employees
      ORDER BY Surname
   )
I don't think that your description fits that scenario; but could the caching have unsorted the data? Bad design if that is what had happened.
GeneralRe: MS Azure Storage Explorer Pin
Sander Rossel8-Jun-22 6:19
professionalSander Rossel8-Jun-22 6:19 
GeneralWindows 10 Update 20H2 rant Pin
richwfowler8-Jun-22 4:23
richwfowler8-Jun-22 4:23 
GeneralRe: Windows 10 Update 20H2 rant Pin
0x01AA8-Jun-22 6:56
mve0x01AA8-Jun-22 6:56 
GeneralRe: Windows 10 Update 20H2 rant Pin
richwfowler8-Jun-22 7:24
richwfowler8-Jun-22 7:24 
GeneralRe: Windows 10 Update 20H2 rant Pin
0x01AA8-Jun-22 10:42
mve0x01AA8-Jun-22 10:42 
GeneralRe: Windows 10 Update 20H2 rant Pin
dandy728-Jun-22 9:54
dandy728-Jun-22 9:54 
GeneralRe: Windows 10 Update 20H2 rant Pin
richwfowler8-Jun-22 10:00
richwfowler8-Jun-22 10:00 
GeneralRe: Windows 10 Update 20H2 rant Pin
Gary R. Wheeler8-Jun-22 15:41
Gary R. Wheeler8-Jun-22 15:41 
GeneralRe: Windows 10 Update 20H2 rant Pin
richwfowler9-Jun-22 4:49
richwfowler9-Jun-22 4:49 
GeneralApple has till 2024 to dump Lightning Pin
obermd8-Jun-22 3:57
obermd8-Jun-22 3:57 
GeneralRe: Apple has till 2024 to dump Lightning Pin
Richard MacCutchan8-Jun-22 4:18
mveRichard MacCutchan8-Jun-22 4:18 
GeneralRe: Apple has till 2024 to dump Lightning Pin
PIEBALDconsult8-Jun-22 4:19
mvePIEBALDconsult8-Jun-22 4:19 
GeneralRe: Apple has till 2024 to dump Lightning Pin
OriginalGriff8-Jun-22 6:26
mveOriginalGriff8-Jun-22 6:26 
GeneralRe: Apple has till 2024 to dump Lightning Pin
fgs19638-Jun-22 9:25
fgs19638-Jun-22 9:25 
GeneralRe: Apple has till 2024 to dump Lightning Pin
OriginalGriff8-Jun-22 10:06
mveOriginalGriff8-Jun-22 10:06 
GeneralRe: Apple has till 2024 to dump Lightning Pin
fgs19638-Jun-22 10:14
fgs19638-Jun-22 10:14 
GeneralRe: Apple has till 2024 to dump Lightning Pin
obermd9-Jun-22 3:42
obermd9-Jun-22 3:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.