Update: The original dev does not remember exactly. However they have said that clientId was originally a VARCHAR, so this may have been checking for both '0' or ''
So an over-engineered workaround to a bad datatype perhaps?
I forgot to mention this is in SQL Server, so SIN operates on radians. So I THINK this can only ever cast to a 0 when clientId is also 0
It certainly doesn't for any of the 100,000 existing rows
The client table has around 100,000 rows each with a unique clientId, none of which are returned from the CAST / ABS / SIN
I think you are right and this is a 'fix' for something lost to time. I am going to talk to the original dev tomorrow to see if they remember what it was for
I am one of the developers on a very small team and have just found the following query
I would love to hear your ideas for what you think was being attempted here!
SELECT ... FROM client WHERE CAST(ABS(SIN(clientId)) AS BIT) = 0
Thank you so much, I'll check it out!
Absolutely, it's a great read. Could you link the video you watched?
I hope some people here enjoy reading these as much as I have
If you know of anything similar, I would love to hear them
Two years ago, something very strange happened to me while working from my home network. I was exploiting a blind XXE vulnerability that required an external HTTP server to smuggle out files, so I spun up an AWS box and ran a simple Python webserver to receive the traffic from the vulnerable server.
- Soft Skills Engineering - Software engineering advice podcast
- If Books Could Kill - Criticising reviews of bestselling books
- CoRecursive - Stories about software
Found an interesting little glitch
- Close your game
- Turn your phone's GPS off
- Start the game and as soon as it loads open routes
- Turn GPS back on and after a few seconds close routes
Gyms and stops don't appear
Pokemon cannot be clicked on
What am I meant to be doing with "routes". There are none around me to follow and I cannot seem to create a new one
I am missing something? Do I need to complete something?
I work on top of pokestops, so add me and you'll get one today
0692 0102 3964
I am wondering if anyone can help me.
I have an issue with compiling some code in Eclipse but not with IntelliJ or javac.
I am using sneakyThrow to bubble a checked exception up through 2 streams.
Here is the smallest reproducible code I can make:
``` import java.io.IOException; import java.util.List; import java.util.function.Predicate; import java.util.stream.Collectors;
public class Example { public static void main(String[] args) throws IOException { List<List<Integer>> input = List.of(List.of(1, 2), List.of(2, 4));
// Should return any List whose elements are all even. List<List<Integer>> output = input.stream() .filter(bubblePredicate(o -> o.stream() .allMatch(bubblePredicate(i -> { if (i > 10) { throw new IOException("Number too large."); } return i % 2 == 0; })))) .collect(Collectors.toList());
System.out.println(output); }
private interface ThrowingPredicate<S, E extends Exception> { boolean test(S s) throws E; }
private static <S, E extends Exception> Predicate<S> bubblePredicate(ThrowingPredicate<S, E> callable) throws E { return s -> { try { return callable.test(s); } catch (Exception e) { sneakyThrow(e); return false; } }; }
private static <E extends Throwable> void sneakyThrow(Exception exception) throws E { throw (E)exception; } } ```
Compiles and runs completely fine with javac 11.0.12, but doesn't on Eclipse 4.21.0.I20210906-0500 nor Eclipse 4.27.0.20230309-1200.
Has anyone encountered this before, or have any idea what I am misunderstanding?
Can probably only send you 1 gift, as my friend list is quite full
0692 0102 3964
