Patrick Jolliffe

@jolliffe.bluesky.social

[Patrick Jolliffe @jolliffe]

https://t.co/FZkwIQvuGR
I'm doing a webinar next Tuesday. It's decent, but hey I'm biased. It's free to join. There will be pictures of dogs. You will likely learn something you didn't know before. There's even a tiny bit in there about the Oracle Database. #odtug @odtug

[Patrick Jolliffe @jolliffe]

Wrong Results with nchar & flash cache
https://t.co/q9jovtNTMx

[litquidity @litcapital]

“But guys, we don’t even trade with your country”

“Shut the fuck up penguin. Did you even say thank you? We’re tired of you taking advantage of hard working American patriots”

[ORA-600 @POUG_ORG]

Join us to celebrate the 10th #POUG conference anniversary! 📷
We started in (let's be honest) the basement of a small hotel near Warsaw Airport, and now we're here, with our amazing community.
Book now: https://t.co/JnMFIVFEpt
#POUG2025

[Erik van Roon @evrocs_nl]

Having dinner and drinks with lovely friends pre #ukougdiscover24

[Patrick Jolliffe @jolliffe]

Depends on your definition of open i suppose. Total chaos at Berlin T2 this morning, long queue at security only 2 scanners working, I've never seen so many stressed people.

[Patrick Jolliffe @jolliffe]

@OyvindIsene @pioro Cool photobombing by @MDWidlake

[Patrick Jolliffe @jolliffe]

@oracleace @alexnuijten @MrOffstone @dani_schnider @evrocs_nl @FSimonDBA @frankyweber @G_Ceresa @ilmarkerm @jasminfluri @JulianFreyCH @POUG_ORG I do prefer ACE Ass. to ACE associate. Why do the pros get to abbreviate but we don't? (Yes it's rhetorical i do know the answer).

[Patrick Jolliffe @jolliffe]

A light meal i asked for. Sure we have spratzle, it's like German pasta he said. Very very stodgy, but with the sauce and a couple of pilsners i managed to finish it. Don't think I'd rush to have it again though.

[Patrick Jolliffe @jolliffe]

@RogerMacNicol Kind of similar i did buy a bottle of it at a portuguese supermarket and threw the wine away. I wanted a screw top half bottle for keeping the wine leftovers in the fridge and this was the only option. Pt doesn't really do screw tops or half bottles.

[Patrick Jolliffe @jolliffe]

Impulse purchase at the airport on the way to #poug2024. It's basically Portuguese Carlo Rossi.

[Patrick Jolliffe @jolliffe]

Silly Germans building two willhelm -something strasses in totally different parts of the city. If i wasn't a global travel expert that might have caught me out

[Patrick Jolliffe @jolliffe]

@DBoriented @connor_mc_d @thatjeffsmith Just one more thing I learned while putting the session together (thanks @DBoriented). Do you think you know everything there is to know about NULL in the Oracle database? Let's find out at my session, "The Great Unknown" at #poug2024 @poug_org next Sunday, a few tickets left

[Patrick Jolliffe @jolliffe]

Bug or not? I think yes, I don't see any reason why this should fail, at least if it does fail it shouldn't make up a story about multiple primary keys. "Self-evident" my a$$. cc @connor_mc_d @thatjeffsmith

[Patrick Jolliffe @jolliffe]

@DBoriented @connor_mc_d @thatjeffsmith OK, wow, so it's then parsing as (NOT NULL ENABLE) (PRIMARY KEY), and thus assuming I am defining a new primary key. Makes sense, thanks!

[Patrick Jolliffe @jolliffe]

@JBeresniewicz @DBoriented @connor_mc_d @thatjeffsmith To my mind the more worrying is the fact that this is the default behavior if nullability attribute is not specified on pk column (the fact that the pk enforces the nullability means most won't notice)

[Patrick Jolliffe @jolliffe]

@JBeresniewicz @DBoriented @connor_mc_d @thatjeffsmith Ok, took me a little while to parse the triple negative there, but maybe there would be some edge use case for having the pk, but if it is dropped or disabled, to allow nulls then. ETL process loads nulls, fixes them, then reenable pk?

[Patrick Jolliffe @jolliffe]

@ilmarkerm @thatjeffsmith @connor_mc_d Not strictly needed, if you were to disable (or delete) the PK for some reason and hadn't define the cols as "not null" you might suddenly hit data integrity issues.

[Patrick Jolliffe @jolliffe]

@thatjeffsmith @connor_mc_d Same behavior if you don't specify NULL...

[Patrick Jolliffe @jolliffe]

@thatjeffsmith @connor_mc_d Nope, just trying to demo the relationship between nullability & pks and ran this command which failed unexpectedly. I have slipped no NULLs into anything (per testcase it's an empty table).

[Patrick Jolliffe @jolliffe]

@thatjeffsmith @connor_mc_d I haven't tested, but I imagine it's always been this way. I only hit it because I'm doing weird sh*t for a presentation, nothing real-world :)