i've been getting "Run Failed" trying to create new fiddles from yesterday
Anonymous 13589
Tried to reproduce - but can't. Will keep an eye on it - sorry to have bothered you!
Anonymous 13589
There appears to be a problem with (at least) the PostgreSQL fiddles - I make changes but they appear to keep reverting back to previous versions - https://dbfiddle.uk/UkakOPQr - I tried labelling one of the snippets (Snippet 8) to demonstrate, but even that won't stay in the fiddle - try changing `LIKE` to `=` in the first SQL query - or try changing the LIMIT from 10 to 5 - doesn't persist either - my SQL has become all messed up with some changes apparently persisting and others not!
John K N
https://dbfiddle.uk/YuAX1REn
John K N
Msg 1101 Level 17 State 12 Line 1
Could not allocate a new page for database 'fiddle_18db0a5382d849b2a8cf9f9addf716f8' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
John K N
Hi Jack. Was trying to repro something on dbfiddle.uk and got an error message.
Andriy M
hi
Anonymous 7711
hi~
kus
Good morning, have you guys ever been so sure that there is a bug but then you try to create an scccccccce (can never remember the number of c's in there) and you cannot reproduce the bug that you were so sure of :D
Paul White
spatial never worked in db<>fiddle afaik
Paul White
@Jack Run failed message for any query on SQL Server 2019 (Windows) using the AdventureWorks sample db
PeterVandivier
nbd on either, thanks for the reply on both :smile:
yes, I wasn't sure anyone used that so I got rid of it — the idea was to add some documentation posts here with examples of how best to show stats for the different engines. I haven't got round to that though. It's on my list now!
@Jack am i misremembering or did there used to be a little "gear" icon for fiddle batches that would set stats io, time for sql server and enable explain for postgres or something along those lines?
PeterVandivier
am i misremembering or did db<>fiddle used to render spatial results for SQL server? https://dbfiddle.uk/?rdbms=sqlserver_2019&fiddle=89fbead71bffc811affd33786ae76084
trying the query from http://slavasql.blogspot.com/2015/09/draw-american-flag-in-ssms-using.html
yes, and I don't think there is any need to exclude them anywhere any more, it was just when we were getting a lot on meta - I've tweaked so they are now showing, thanks!
PeterVandivier
I remembered they were excluded for the meta channel. I figured the db<>fiddle channel was mainly for feature-requests though
Jack Douglas
The search is `@+ {}{code golf}{blog}[!bug][!feature-request]`
Jack Douglas
I will check :)
Jack Douglas
I can't remember what the driteria are for showing on the home page
this is what i see on the home page (logged in). Qs 2039 & 2045 are visible. Qs 2038 & 2040 are not, despite sorting higher by last modification date
Jack Douglas
If you wat to see them on dba.ta etc you can use cross-community feeds
