←2023-03-01 2023-03-02 2023-03-03→ ↑2023 ↑all
02:20:00 -!- Lord_of_Life has quit (Ping timeout: 255 seconds).
02:20:29 -!- Lord_of_Life has joined.
02:35:04 -!- razetime has joined.
03:45:35 -!- razetime has quit (Ping timeout: 248 seconds).
04:24:00 <esolangs> [[User:Vandlen't]] https://esolangs.org/w/index.php?diff=107207&oldid=107189 * Vandlen't * (+81) Changed page source.
04:25:17 <esolangs> [[Vandalang]] https://esolangs.org/w/index.php?diff=107208&oldid=107190 * SpaceByte * (+7)
04:26:20 <esolangs> [[Vandalang]] https://esolangs.org/w/index.php?diff=107209&oldid=107208 * SpaceByte * (-7)
04:28:39 <esolangs> [[User:Vandlen't]] https://esolangs.org/w/index.php?diff=107210&oldid=107207 * Vandlen't * (+81) Changed page source.
04:28:45 <esolangs> [[Vandalang]] https://esolangs.org/w/index.php?diff=107211&oldid=107209 * SpaceByte * (+7)
04:29:54 <esolangs> [[Vandalang]] https://esolangs.org/w/index.php?diff=107212&oldid=107211 * SpaceByte * (-7)
04:41:52 -!- razetime has joined.
05:07:05 -!- ais523 has quit (Quit: quit).
05:25:48 -!- razetime has quit (Ping timeout: 268 seconds).
05:28:59 -!- fungot has quit (Ping timeout: 264 seconds).
05:41:18 -!- razetime has joined.
05:43:47 -!- slavfox has quit (Quit: ZNC 1.8.2 - https://znc.in).
05:44:17 -!- chiselfuse has quit (Ping timeout: 255 seconds).
05:46:32 -!- chiselfuse has joined.
05:49:21 -!- slavfox has joined.
06:37:38 -!- bgs has joined.
07:00:06 -!- tromp has joined.
08:01:41 -!- tromp has quit (Quit: My iMac has gone to sleep. ZZZzzz…).
08:05:23 -!- razetime has quit (Ping timeout: 260 seconds).
08:08:11 -!- Sgeo has quit (Read error: Connection reset by peer).
08:09:34 -!- tromp has joined.
08:31:30 -!- razetime has joined.
09:22:30 -!- razetime1 has joined.
09:23:20 -!- razetime has quit (Ping timeout: 255 seconds).
09:23:21 -!- razetime1 has changed nick to razetime.
09:41:52 -!- razetime1 has joined.
09:42:57 -!- razetime has quit (Ping timeout: 268 seconds).
09:42:58 -!- razetime1 has changed nick to razetime.
10:35:30 -!- razetime has quit (Remote host closed the connection).
10:49:49 -!- __monty__ has joined.
12:28:13 -!- tromp has quit (Quit: My iMac has gone to sleep. ZZZzzz…).
13:45:05 -!- tromp has joined.
15:03:48 <esolangs> [[LaserFuck]] https://esolangs.org/w/index.php?diff=107213&oldid=98292 * Joaozin003 * (-8)
15:09:39 -!- wib_jonas has joined.
15:12:45 <wib_jonas> TIL in SQL syntax that "LIMIT 50", to restrict a select statement to return only the first 50 rows in the order give by its ORDER BY, is spelled in MS SQL as "OFFSET 0 ROW FETCH NEXT 50 ROW ONLY". It seems like none of the words or parts of that spelling is optional, so I'm not just cheating by adding extra nop words.
15:14:41 <wib_jonas> There's also an alternate MS SQL syntax "TOP 50", but you put that after "SELECT and before the list of columns to be selected, with no separator, so you have two expressions adjacent to each other with no separator, which is error-prone and will make it even harder than usual in MS SQL to find out what the syntax error in your query is, so I don't
15:14:41 <wib_jonas> think I'll use it. And no, you can't just write "TOP 50 ROWS" to have a separator.
15:15:20 <wib_jonas> Also while DO is a keyword in some SQLs, PLEASE apparently isn't yet.
15:20:25 <wib_jonas> they should have required "OFFSET 0 ROW BUT PLEASE FETCH NEXT 50 ROW ONLY SO USERS PAGE THROUGH UNNECESSARILY SHORT WINDOWS OF DATA ON MY WEBPAGE TO SERVE MORE ADS" as the syntax so that SQL is readable
15:20:39 <fizzie> That sounds a little like one of those window definitions.
15:20:53 <fizzie> ROWS BETWEEN UNBOUNDED PRECEDING AND 5 FOLLOWING EXCLUDE CURRENT ROW and so on.
15:24:17 <wib_jonas> in a saner version of SQL, most of those words would be optional, like [OFFSET 0 [ROW|ROWS]] FETCH [NEXT|FIRST] 50 [ROW|ROWS] [ONLY]. MS SQL allows the alternate keywords, but not omitting any of them.
15:26:05 <wib_jonas> (they should have added more synonyms, so SEEK 0 ROWS ACQUIRE FIRST 50 ROWS MERELY works too)\
15:26:27 -!- Sgeo has joined.
15:35:33 <wib_jonas> SQL should gain some Intercal features, they're a good combination in syntax and arcanness of rules. REINSTATE UPDATING for example, but more importantly randomization percentages so you can make constraints that are enforced only 90% of the time, or triggers that trigger only 10% of the time.
15:39:34 <wib_jonas> also new conflict handling strategies: INSERT OR FORGET and INSERT OR RESUME
15:47:23 <wib_jonas> by the way, where's fungot?
15:51:51 <int-e> Well I hope they're having fun.
15:55:02 -!- tromp has quit (Quit: My iMac has gone to sleep. ZZZzzz…).
15:56:41 <FireFly> wib_jonas: "select top x ..." is what I've heard of/seen done before, at least
15:56:58 <FireFly> for MSSQL limits
15:57:12 <FireFly> SQL is possibly the one spec that is even less standardised than IRC lol
15:57:31 <FireFly> in that there is a standard and everyone promptly ignores it and reality doesn't match it very well
16:06:10 -!- tromp has joined.
16:09:54 <wib_jonas> FireFly: as far as I understand there's a standard and implementations mostly follow it, but the standard specifies so few features that everyone needs to use lots of extensions. Imagine if you wish the C standard with its standard library, plus a thousand vendor libraries.
16:11:36 <FireFly> I guess something like that, though I think there's also spec things that some implementations just diverged on early and now that ecosystem is set in its ways
16:11:47 <wib_jonas> sure
16:12:02 <FireFly> I guess there's less of like, "library code useful between implementations" compared to conventional programming languages
16:12:50 <wib_jonas> and then https://xkcd.com/927/ I guess
16:13:39 <FireFly> yeah
16:16:28 <esolangs> [[User:CappyIsCrappy]] https://esolangs.org/w/index.php?diff=107214&oldid=97395 * Joaozin003 * (+34)
16:17:29 <esolangs> [[User:Joaozin003]] https://esolangs.org/w/index.php?diff=107215&oldid=107041 * Joaozin003 * (+40) /* Links */
16:31:11 -!- razetime has joined.
16:43:56 -!- wib_jonas has quit (Quit: Client closed).
17:00:09 <esolangs> [[Trainfck]] https://esolangs.org/w/index.php?diff=107216&oldid=107003 * Mujk * (+64) /* language */
17:02:38 <esolangs> [[Multidodecagony]] https://esolangs.org/w/index.php?diff=107217&oldid=106061 * Joaozin003 * (+0) /* I/O commands */
17:03:05 <esolangs> [[Multidodecagony]] https://esolangs.org/w/index.php?diff=107218&oldid=107217 * Joaozin003 * (+27)
17:20:25 <esolangs> [[Talk:Snowflake]] https://esolangs.org/w/index.php?diff=107219&oldid=76041 * Joaozin003 * (+96) /* Is there a version of this without interpreter-self-modification? */ new section
17:42:14 -!- razetime has quit (Remote host closed the connection).
18:06:11 -!- perlbot has quit (Ping timeout: 264 seconds).
18:06:21 -!- simcop2387 has quit (Ping timeout: 255 seconds).
18:15:10 -!- simcop2387 has joined.
18:17:42 -!- perlbot has joined.
18:30:38 -!- tromp has quit (Quit: My iMac has gone to sleep. ZZZzzz…).
19:09:43 -!- tromp has joined.
19:58:15 <esolangs> [[XY problem]] M https://esolangs.org/w/index.php?diff=107220&oldid=107203 * Hakerh400 * (-948)
20:01:40 <zzo38> I think that they should allow to abbreviate "ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING" as "ALL ROWS", but they don't.
20:27:47 <esolangs> [[SideStacks]] M https://esolangs.org/w/index.php?diff=107221&oldid=105175 * Myoitzi * (+0)
21:05:27 <esolangs> [[Shader state]] https://esolangs.org/w/index.php?diff=107222&oldid=101103 * Joaozin003 * (+8) Added WIP template
21:54:20 <zzo38> You can make triggers that only trigger 10% of the time in SQL if you use WHEN RANDOM(). However, being able to ABSTAIN and REINSTATE might sometimes be useful, including to prevent all triggers from firing; being able to specify this as a part of the statement causing the triggers to fire (so that it doesn't fire) might be the way to be done.
22:07:23 -!- m5zs7k has quit (Ping timeout: 264 seconds).
22:07:47 -!- m5zs7k has joined.
22:10:08 -!- tromp has quit (Quit: My iMac has gone to sleep. ZZZzzz…).
22:26:53 -!- chiselfuse has quit (Ping timeout: 255 seconds).
22:28:49 -!- chiselfuse has joined.
22:32:10 -!- __monty__ has quit (Quit: leaving).
22:32:44 -!- tromp has joined.
23:54:11 -!- chiselfuse has quit (Ping timeout: 255 seconds).
23:56:00 -!- chiselfuse has joined.
23:56:05 -!- tromp has quit (Quit: My iMac has gone to sleep. ZZZzzz…).
←2023-03-01 2023-03-02 2023-03-03→ ↑2023 ↑all