The Heap™ – Consultancy ©®

7:55 AM

Morning

8:12 AM

I'm surprised the system let me add luatex to dba.stackexchange.com/q/242422/1319

Oh, one only needs 300 rep to create new tags. That seems quite low.

8:27 AM

Yeah that may be removed

The tags are fairly sacred here

@George.Palacios Oh

Nothing personal :) I just can't see that particular tag being reused in future

But I'm not the person that makes these decisions so I could be wrong too

@George.Palacios It's ok. It won't break my heart, or anything. It would be amusing if the luatex tag started a trend, though.

Stranger things have happened!

(They haven't)

@George.Palacios Some stuff that happens is fairly strange.

Peter Vandivier

8:44 AM

@George.Palacios [ominous synth music plays]

9:31 AM

Does sqlite3 have an editing mode like psql's \e?

That's very handy.

4 hours later…

1:40 PM

hello everyone, would someone like to help me troubleshoot this issue?

db_1  | 2019-07-09T13:39:30.795926Z 0 [Warning] InnoDB: Cannot open table mysql/plugin from the internal data dictionary of InnoDB though the .frm file for the table exists. Please refer to dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
db_1  | mysqld: Table 'mysql.plugin' doesn't exist
db_1  | 2019-07-09T13:39:30.795968Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
db_1  | 2019-07-09T13:39:30.830946Z 0 [Warning] InnoDB: Cannot open table mysql/gtid_executed from the internal data dictionary of InnoDB t…

that's mysql 5.7 inside a docker container starting up after probably erroneously removing ib* files from its data directory

1 hour later…

2:42 PM

@JoshDarnell - I wonder why string_split won't work for me.

Microsoft SQL Server 2016 (SP2-GDR) (KB4293802) - 13.0.5081.1 (X64)
Jul 20 2018 22:12:40
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor)

SELECT d.name
    , d.compatibility_level
FROM sys.databases d
WHERE d.database_id = DB_ID();
GO

╔════════╦═════════════════════╗
║  name  ║ compatibility_level ║
╠════════╬═════════════════════╣
║ tempdb ║                 130 ║
╚════════╩═════════════════════╝

select string_split('this, that, the other thing', ',')

Msg 195, Level 15, State 10, Line 110
'string_split' is not a recognized built-in function name.

strange

@MaxVernon have you tried using it as a table-valued function

no, but I'll give it a go

I'm dumb

well I didn't want to say anything

but we star stuff like that

I appreciate that.

> A table-valued function that splits a string into rows of substrings, based on a specified separator character.

2:45 PM

wow is there egg on my face

I must be new.

@JoshDarnell will be relieved

Josh Darnell

Finally it's not just me.

Max is away updating his avatar with a superimposed fried egg

ypercubeᵀᴹ

@slhck unlikely to find someone here to help with that

@ypercubeᵀᴹ why is that if I may ask? (got sent here from the SQL chat…)

mustaccio

3:01 PM

@slhck This place is for random banter mostly, as you can see. Try to formulate your question on the main site may be

but search first, it may already be answered

Database Administrators site

Thanks for the suggestion. Did that, came up with nothing useful. I was more hoping for a bit of interactive troubleshooting or quick suggestions. I'll just wipe the installation and restore from a backup.

Josh Darnell

@mustaccio I don't think that's entirely true. There are lots of technical discussions and troubleshooting conversations in here.

There's a pretty strong skew towards SQL Server experience in here, maybe that's what @ypercubeᵀᴹ meant.

mustaccio

Still random.

mustaccio

3:21 PM

@slhck Nothing useful? Not even this dba.stackexchange.com/questions/57120/… or any of the "linked" Q&As?