Films where two specific actors appeared together in the sakila (mysql) db. 19
mysql
anoldmaninthesea anoldmaninthesea
2 The second `film_actor` join is required because in each case it is being restricted to a single actor. The query is to get films where two actors appear together.
Jack Douglas
Firebird on DBFiddle - lack of error reporting and... lack of text (charsets) support. 21 3
Meta
dbfiddle
Arioch Arioch
What does it mean when pg_stat_activity.datname is NULL?
postgresql
PeterVandivier PeterVandivier
What's the purpose of using 'timestamp' data type, when it only goes up to year 2038-01-18? 6
mysql
anoldmaninthesea anoldmaninthesea
Adding/Importing an example database from mySQL to SQL server 2019 8
anoldmaninthesea anoldmaninthesea
6 SQL Server and MySQL are different platforms. Think of SQL Server as Microsoft Excel and MySQL as Apple Numbers. They're similar, but you shouldn't expect to be able to use them interchangeably.
PeterVandivier
UNION ALL + LIMIT - unintuitive behaviour with subselect
postgresql
PeterVandivier PeterVandivier
3 The docs are a bit vague about this. In the ["Combining Queries"](https://www.postgresql.org/docs/13/queries-union.html) section (which discusses `UNION`/`INTERSECT`/`EXCEPT`) they state:
Jack Douglas
3 Without explicit parentheses, the second `LIMIT` is scoped to the batch, not the statement. Consider the `EXPLAIN`
PeterVandivier
Using 'source' in mySQL cmd prompt to import data 27
mysql-8.0
anoldmaninthesea anoldmaninthesea
If a Parallelism Exchange Event deadlock is victim-less, is it a problem?
sql-server
mark sinkinson mark sinkinson
6 I wouldn't be surprised if this is the way the deadlock graph looks when an intra-query parallel deadlock is resolved by an exchange spill (so there is no victim, except performance).
Paul White
db<>fiddle inline highlights 4
Meta
dbfiddle
PeterVandivier PeterVandivier
db<>fiddle Feedback 479 5
Meta
dbfiddle
Jack Douglas Jack Douglas
5 `feature-request` **Concurrency Support**
PeterVandivier
5 I have several links to db&lt;&gt;fiddle for demos in the following post:
Solomon Rutzky
5 The "ff" ligature destroys the cursor position. See GIF below:
fiatjaf
4 `bug` `fixed` Brittle fiddle one-boxing in chat
PeterVandivier
4 `bug` `fixed` YYYY-MM-DD for SQL Server
PeterVandivier
4 `bug` `fixed` Embedded fiddles should respect `&hide=` args
PeterVandivier
4 `bug` clicking 'Back' should switch back not only the query, but also the database selection.
Ami
3 `feature-request` please add an (opt-in) cookie to remember the last platform a user was on?
PeterVandivier
2 `bug` `fixed` All-null rows collapsing in embedded fiddles
PeterVandivier
2 `feature-request` please add CockroachDB
PeterVandivier
2 `feature-request` `declined` add an 'Update this post' button on embedded db<>fiddles on TopAnswers
PeterVandivier
2 `bug` `fixed`: Firebird, datatypes, aligning
Arioch
0 `feature-request` sa/postgres/root - superuser fiddles
PeterVandivier
0 `feature-request` `retracted` Add support for SQL Server `GO [count]` syntax
John aka hot2use
0 `feature-request` [`declined`](https://topanswers.xyz/transcript?room=37&id=17302#c17302) Allow multiple statements per batch for Firebird again
Arioch
chat
transcript

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.