The Heap™ – Consultancy ©®

@hot2use Not really, I guess. On average, about one extra holiday each month in addition to Saturdays and Sundays. In practice it's no extra holidays in some months and one or two in the others.

hot2use

8:49 AM

@AndriyM Nice. In Switzerland it depends which canton you are working in (and in some cases for which company).

bj.admin.ch/dam/data/bj/publiservice/service/zivilprozessrecht/… (@gbn might want to have a look)

Tom V

9:16 AM

why is this closed?

0

Q: Filter Schema In Index Optmize Script

Is is possible to do index optimization with Ola's scripts, and have it filter out a specific schema?

@hot2use ^^

Andriy M

Could it be because of the comment by Erik?

Tom V

I would need to test during lunch, but I can see why the documentation is hard to interpert and if my test case works I'll ask for it to be reopened then

ypercubeᵀᴹ

Why did we close this 5 years old question?

0

Q: Fulltext indexes and issuers with server startup

I have a windows server for host about 4500 data bases for same application. And this application have 34 fulltext catalogs on it, and the CHANGE_TRACKING for this fulltext index are AUTO. And the point is, same times I need to shut down the server or move between clusters nodes, and when it’s s...

sql-server-2008-r2 full-text-search

Since it had been migrated from SO, it is now shown as "migration rejected", question locked in our site and deleted at SO.

Was it so bad?

And I'm not sure when these happened, the timestamps look weird: stackoverflow.com/posts/14777473/revisions

hot2use

9:34 AM

@TomV Too basic: Didn't read the documentation, ladida, ...

@ypercubeᵀᴹ Very old, no answers, and possibly only answerable by a Microsoft specialist.

However in both cases: If the close vote triggered your attention, and you believe the questions can be answered, then they are all yours.

;-)

Tom V

I'll test if my hypothesis works, but to be fair I don't think the documentation is all that clear about "excluding" a schema. That's why I'd rather test my theory rather than assume

hot2use

Ok. Let me know and I'll cast a reopen vote in your favour.

@TomV and thanks for the ping

Andriy M

@ypercubeᵀᴹ They look fine to me. As for why, my guess is because the question was abandoned. No feedback on the comments, the OP never even registered here.

ypercubeᵀᴹ

@hot2use I don't think I can answer that. But I saw some comments that speculated a possible reason for the issue. Problem is, no one can answer now as the questions is locked.

@AndriyM Right, the timestamps look ok. I was confused ecause it showed "deleted" on March 2013, then unlocked a few minutes ago. I suppose the closing here triggered the rejection of the old migration so the question was "resurrected" (unlocked but staying deleted) at SO.

hot2use

@AndriyM How long should questions be allowed to ferment before we VtC?

ypercubeᵀᴹ

9:49 AM

Oh, I see the sql-server-2008-r2 tag. It's @MaxVernon's crusade to have every q on that tag answered! ;)

Andriy M

@hot2use For migrated questions it seems fair to give the OP some time to follow through to the target site and start responding to comments. In this case the OP never did that, but by the time one could reasonably conclude it unlikely that he would, everyone who might have followed the question had probably moved on.

@ypercubeᵀᴹ Is there an EAGL for that?

ypercubeᵀᴹ

Apr 20 at 15:39, by Max Vernon

I've been slowly making my way through sql-server-2008-r2 unanswered questions. Man, there are a lot of unanswered questions on the site.

Andriy M

@ypercubeᵀᴹ Aha, thanks!

hot2use

10:09 AM

0

Q: Should Very Old Questions Remain Open on DBA.SE Even Though They Don't Have Answers

I think the title sums it up quite nicely: Should Very Old Questions Remain Open on DBA.SE Even Though They Don't Have Answers? A recent VtC on the following question raised some concern that the votes were not correctly cast and would hinder people answering the question: Fulltext indexes an...

discussion

Have a bash guys.

Paul White

@TomV It's not now. Seems like a useful question to have if we can get a decent answer.

Max Vernon

11:20 AM

Some people. Dude, I'm trying to help.

In your previous comment, you complained that I hadn't given you the code, which was there. Now you're indignantly asking for the output from FILELISTONLY, which you hadn't asked for before. Would you please stop moving the goalposts? — Green Grasso Holm 2 mins ago

hot2use

@MaxVernon Difficult question. Agree.

Andriy M

@MaxVernon Tell me about it

sp_BlitzErik

@MaxVernon vtc as too localized

Max Vernon

When I get to work, I'll give him an mcve to prove he's wrong.

sp_BlitzErik

i've seen full text catalogs get created as secondary data files

so they show up as another D in file list only

Max Vernon

11:28 AM

@AndriyM ouch!

@sp_BlitzErik I've seen that too. In SQL Server 2005.

Tom V

Guys, remember to be welcoming and inclusive :D

4

sp_BlitzErik

@MaxVernon but if databases were created on 2005 or created using scripts written in 2005 they would have the same problem

i'm only aware of this because there's an isv we work with with this problem

Marian

@TomV I read that initially as "intrusive"

Max Vernon

@sp_BlitzErik oh, I agree completely with you. That's the mcve I'm hoping to put together. I just need to find 2005 bits first. But the point is really just "some people!"

The "scripts written in 2005" bit implies you can specify a filename in 2008+, that's not my experience...

I could easily be wrong. It would not be the first time, or the last, i assure you!

sp_BlitzErik

oh yeah i don't recall that much about it

Tom V

11:44 AM

@PaulWhite Thanks, answered

Paul White

@TomV Oh thanks very much.

sp_BlitzErik

i'll delete my comment there!

you're WELCOME

Paul White

@sp_BlitzErik ta

3

A: Filter Schema In Index Optmize Script

Yes if you look at the documentation you see that you can use the @indexes parameter to specify which indexes to defragment. You can use % wildcards in your object names and you can use the - to exclude indexes. Using this information the syntax you want to use is @indexes = 'ALL_INDEXES, -datab...

@MaxVernon It's easy to get frustrated when two people are trying to communicate a complex problem with text only. I have done my best to bring the question up to date with the results of comments so far.

If you think it would help, I can invite the OP here.

But remember the room is public anyway and does not require login to view, so they might be reading everyone's commentary here already.

hot2use

@TomV Good answer

Paul White

Andriy will still find some errors :)

Max Vernon

11:56 AM

@PaulWhite cheers for the edits, and cleanup. I'm ok with not chatting with that guy right now.

Of course, if you all want to, be my guests!

Paul White

@MaxVernon Ok just try to bear in mind that, for the OP, the question is always abundantly clear :). I guess the trick is in helping them to understand that it might not be to readers seeing only their description of problem.

Andy K

afternoon and evening

Max Vernon

12:12 PM

@PaulWhite loud and clear!

Paul White

@MaxVernon Cheers. I know it's not always easy eh

sp_BlitzErik

1:01 PM

maybe what we need to humanize OP is live video feeds of them while they ask questions and respond to comments and answers

3

A_V

1:14 PM

Hello !

I've spent some time testing the new mysql 8 versus sqlserver on linux

The goal is to sync data from our sqlserver to a new mysql

so I'm trying to insert a bunch of rows as fast as possible from a SP

Unsurprisingly it's 3 times faster in SqlServer

0

Q: c# Fastest way to insert rows in mysql vs sqlserver (large dataset)

I'm looking for any possible improvements that could be made to run the mysql piece of code faster. I created a simple test winform application that creates two docker databases : -Sqlserver on linux latest -Mysql 8.0.11 Once the instances are created, it creates a similar table on both. I th...

c# mysql sql sql-server docker

Is there a tool that does that ?

sync from mysql to sqlserver ?

I tried with SSIS

sp_BlitzErik

what didn't ssis do?

A_V

there's so much nitpicky business logic

and also it has to go both ways

and a human has to decide what to send where

sp_BlitzErik

oh boy

A_V

I'm thinking this has to be done by hand with code

sp_BlitzErik

afaik, no software comes with a human to make decisions

;)

A_V

1:17 PM

Yeah... Pipedream softwares are the most expensive

sp_BlitzErik

i have toto stuck in my head

it's a real problem

A_V

Now there's an app for that

Paul White

@sp_BlitzErik It's gonna take a lot to take that away from you

sp_BlitzErik

LOOK YOU

Paul White

:)

@sp_BlitzErik that's a terrifying prospect

sp_BlitzErik

1:24 PM

@PaulWhite maybe just desktop screen share then?

Paul White

hm the question was just self-deleted.

sp_BlitzErik

which?

Paul White

@sp_BlitzErik or a dress code at least

@sp_BlitzErik link added (10k)

thanks @TomV sorry to ninja-edit you

sp_BlitzErik

danke

Paul White

but if we're being serious about the interaction problem idk what the answer is beyond being epicly patient and full of goodwill, or having a willingness to move on unsatisified

Max Vernon

1:31 PM

@PaulWhite dammit, he deleted his post. Oh well, I'll create a canonical one.

Andriy M

UNSUBSCRIBE works well as a cool-off method at least

Paul White

@MaxVernon yep a self-q&a is always an option

I wonder if he found a bug :)

Max Vernon

@PaulWhite I'd wouldn't bother, but I've written a full on answer practically.

@PaulWhite I couldn't say for sure. But I'd put money on it.

Paul White

@MaxVernon tell me about it. guess how long it took me to clean that question up

but hey ho that's the gig

Max Vernon

I'm thinking it was a while!

Paul White

1:33 PM

@AndriyM yep

Max Vernon

plus, I'm "mad" typing. Everyone around me must wonder why I'm so annoyed.

Paul White

listen to a Toto song, I hear they're very relaxing

Max Vernon

@PaulWhite I'm not sure even Enya could help me now. ;-)

Paul White

I guess it's gonna take some time to do the things we never had

ypercubeᵀᴹ

@PaulWhite more than Rick Astley?

Paul White

1:36 PM

@ypercubeᵀᴹ Well Erik told me, and he's very reliable so I'd have to say 'yes'

sp_BlitzErik

@PaulWhite i thought i wasn't reliable until i hit 20k rep?

Paul White

@sp_BlitzErik trusted

you've always been 'reliable'

Max Vernon

@PaulWhite FYI, my answer on that deleted post is only half the story. I've got SQL Server 2005 bits, and will install them soon so that I can create that setup in 2005 to see what happens when it's subsequently restored onto 2012.

ypercubeᵀᴹ

@PaulWhite reliably untrusted

Paul White

@MaxVernon yep understood that much

oh ha ha who pinned that message lol

Max Vernon

1:41 PM

that was me

just wanted to make sure it got some visibility - it was a really great comment!

real genius material, if you ask me.

Paul White

yes it was

oh I wonder if the full text OP was falling prey to no rows resetting/not resetting a variable

SELECT @logicalFtiFile = logicalName
    FROM @BackupFileInfo
    WHERE type = 'F';

sp_BlitzErik

setting variables is hard

Paul White

it actually is! I always have to check e.g. dba.stackexchange.com/a/136212 but yeah defensive coding is key

Taryn

@PaulWhite Africa. Always listen to Africa

Max Vernon

Toto - Africa (Video)

►

ypercubeᵀᴹ

1:46 PM

~~Two~~ Three reliable sources. Must be true.

Paul White

@Taryn I was hoping to find some long forgotten words or ancient melodies

Taryn

@MaxVernon That's the song I play when I start most of my runs

Paul White

I have to say that's long been a favourite of mine

Max Vernon

@Taryn nice! it's a great song!

Paul White

I'm going to respond with quotes from Africa lyrics as often as possible until I forget I'm doing it

Taryn

1:48 PM

@PaulWhite people think I'm nuts that I like it when I run

Paul White

Well tbf it doesn't mean you're not nuts either

sp_BlitzErik

you're all wrong

Taryn

@PaulWhite true

sp_BlitzErik

always listen to the dune soundtrack by toto

Paul White

> not trustworthy

sp_BlitzErik

1:49 PM

what kind of crappy nerds are you

Taryn

@sp_BlitzErik Rosanna?

Zane

lol

Paul White

anyone listening to the sub-20k guy?

meanwhile tonight is a good night because there are back-to-back Knight Rider reruns on tv

3

Max Vernon

@PaulWhite Kit!

Tom V

@PaulWhite Frightened of this thing you have become

3

Paul White

1:51 PM

Super Pursuit Mode!

Taryn

@PaulWhite do you have a time machine or are you living in the 80s?

Paul White

@TomV well done, sir

Max Vernon

I actually bought a 1984 Firebird Trans Am because of that

Paul White

@Taryn I live in New Zealand :)

Taryn

lol

Paul White

1:51 PM

@MaxVernon I hate you

Max Vernon

@PaulWhite it was, wait for it, "sweet as" lol

Paul White

@Taryn Nah seriously we have a couple of retro tv channels

@MaxVernon Did you fit a red LED whoosh-whoosh thing on the front?

Zane

I remember when HDTV first came out there was a channel called HD net that used to run Reruns of Knight Rider. This would have been early 2000's when I was in high school.

I watched that all the time.

Max Vernon

@PaulWhite oh god I wish.

Paul White

Also there is absolutely nothing wrong with living in the 80s

Max Vernon

1:53 PM

back when Hasselhoff was cool.

Taryn

@PaulWhite nice

sp_BlitzErik

@PaulWhite that's where my heart is

Paul White

well it's good background stuff

@sp_BlitzErik yeah me too wistful look

man I was so happy not having a girlfriend and writing machine code for my vic-20

good times

Zane

@MaxVernon is he not?

Max Vernon

@PaulWhite so you traded in your Vic-20 for a wife. Sounds reasonable to me.

sp_BlitzErik

1:56 PM

@PaulWhite hormones ruin everything

Max Vernon

@Zane lol. I guess.

Zane

Are you telling my all of my Hasselhoff Cassette tapes won't appreciate in value?!

Paul White

I did not marry my cbm-64

Max Vernon

@Zane oh no, you keep 'em!

Paul White

@sp_BlitzErik that is profound

Tom V

2:02 PM

0

Q: Match phone numbers efficent

For a mobile application we are considering validating a user based on their mobile phone number. In the app we will restrict so that the user input will be stored in the following format. +46700112233. That would mean in this case Swedish phonenumber (+46) remove initial 0 and then 9 digits (mo...

mysql sql

ouch

Paul White

There's nothing that a hundred men or more could ever do

3

sp_BlitzErik

@TomV sounds like a mysql problem

Taryn

@PaulWhite You really are going there

Paul White

you doubted me? ;)

Taryn

I'm impressed

Paul White

2:08 PM

I know that I must do what's right

Taryn

Have you seen this though?

Dax and Kristen do Africa (music video)

►

It's pretty darn funny

Paul White

watching

Taryn

they filmed it on their vacation

Paul White

impressive!

thanks for that

sp_BlitzErik

youtube.com/user/strindberghelium?app=desktop

Max Vernon

2:21 PM

can someone add in parameters to have begin birth date and end birth date range? — AppleBook89 8 mins ago

I feel like their personal coder.

sp_BlitzErik

@MaxVernon i'd point them here: sqlservercentral.com/articles/Test+Data/88964

that user asks some real breastfeedy questions

Max Vernon

@sp_BlitzErik lol.

I was going to give them a bitcoin address. But that's probably against the rules.

plus, do I really want to go there? no.

there's something nice about providing questions for free. You never have to support them 10 years later.

sp_BlitzErik

dba.stackexchange.com/questions/205468/…

heh

chat isn't a 10k user apparently

Max Vernon

2:38 PM

dba.stackexchange.com/questions/205468/…

^^^ 10k only, since it's deleted. Suffice to say, someone doesn't like downvotes.

sp_BlitzErik

if they didn't like downvotes they would have brought a better answer

Max Vernon

@sp_BlitzErik agreed

sp_BlitzErik

i'm gonna do another self q&a today

i think i have a good idea

Max Vernon

@sp_BlitzErik there better not be any references to my mom ;-)

sp_BlitzErik

@MaxVernon not your mom per se

Max Vernon

2:51 PM

phew

Lamak

3:03 PM

@sp_BlitzErik are you sure about that?

sp_BlitzErik

@Lamak the voters will have their say

wBob

KITT ssshurely

Airwolf would **** KITT up.

Lamak

@sp_BlitzErik I meant about you having a good idea

Max Vernon

@wBob ooops, that's what I meant ;-)

@wBob A-Team vs Airwolf vs KITT

wBob

3:18 PM

Stringfellow Hawk makes Murdoch look like a [insert funny comment here].

jcolebrand

3:57 PM

@ypercubeᵀᴹ

FIX THIS MESS YOURSELF

0

A: postgres index on text column

Ok, my text column contains "...@sometext...", can i make index on this? For example, rows, where different sometext exists?

:p

ypercubeᵀᴹ

@jcolebrand I already voted to delete.

jcolebrand

The edit bro

Make the edit to the Q

Or do you want it to be a comment on the other answer?

Then you should be more clear on the flag

But you wrote: "You can comment on other answers or edit your question. Please delete this." which makes me think you want it to be an edit

You lot are killing me

2

ypercubeᵀᴹ

@jcolebrand Not sure what he is trying to say really.

Just reject the flag, man. No hard feelings ;)

OK, I edited the q. He had a similar comment under there.

jcolebrand

4:21 PM

And this is why modrators is just assholes with guns in their hands :p

Thanks for the flag. And for taking ownership ;-)

ypercubeᵀᴹ

@jcolebrand First to get the Marshal badge ;) dba.stackexchange.com/help/badges/78/marshal

That use has started to annoy me

Instead of folllowing the suggestion in the answer and the comments, he is thinking about zombodb ...

Whatever that is.

I think about zombodb, but for this i have to change some queries. — Ivan Alex 9 mins ago

jcolebrand

@ypercubeᵀᴹ Well done sir :D

Paul White

@jcolebrand Speak for yourself

@wBob oh wow I remember those endless debates :)

Tom V

@ypercubeᵀᴹ postgres +elasticsearch aparrently

zombodb.com

Paul White

might be headed for zombiedb

Tom V

4:36 PM

These names are just getting sillier and sillier

MDCCL

The [standard-edition] tag seems a bit strange.

It's mostly used for questions about SQL Server, though there are a few Oracle ones grouped by it.

Maybe there should be two tags, for example: [sql-server-standard-edition] and [oracle-standard-edition]...

Max Vernon

@PaulWhite - is this edit ok, or too brutal?

MDCCL

There's a [sql-server-express] one, talking about editions.

Paul White

@MaxVernon brutal?

Max Vernon

@PaulWhite ok, perhaps mean? I'm talking about the edit comment

I'm fine with removing the "I SOLVED IT" type messaging at the start of the post.

you?

presumably I wasn't too rude?

Paul White

4:44 PM

@MaxVernon oh I thought you meant the edit itself. Yes the edit comment was a little OTT, I edited it for you.

Max Vernon

@PaulWhite thanks

Paul White

The edit itself was perfectly good of course thank you

Max Vernon

thanks

I hate those "*** SOLVED ***" banners you see in Google results for questions. It raises my ire like you wouldn't believe. Especially when I see that on social.microsoft.com

why people feel the need to advertise that they got a resolution is beyond me.

Paul White

idk maybe SEO for older platforms

Max Vernon

although, I suppose [StackExchange] makes it easier to see answers than other platforms do.

perhaps, SEO, as you say. If I was google I'd be sinking those results :-)

putting them in the "phishing" barrel.

Paul White

4:47 PM

honestly I have no idea but around here it is just unwelcome noise

Max Vernon

perfect

Evan Carroll

Bounty for MySQL/MariaDB: dba.stackexchange.com/q/204747/2639

Master Database

5:17 PM

0

Q: Tag rename [ansi-sql-standard] to [sql-standard]

The standard, though originally ANSI isn't really ANSI anymore. In fact, I imagine far more people develop it from the ISO/IEC outside of ANSI. ANSI is kind of a private cabal of American corporate and government interests that that sit united at ISO/IEC. Regardless, ansi isn't really relevant.

discussion support tagging

Tom V

5:43 PM

@PaulWhite it was supposed to help people looking for a solution but it never worked because it wasn't used consistently

Accepting answers just works better

The idea was to not waste people's time reading through a thread looking for a solution if there wasn't any

Cc @MaxVernon

Paul White

They should have just added a Like button and some Reactions

Tom V

Those were the bulletinboard and php forum days

To be fair ExpertSexChange did a good job in changing a lot of those problems

2

Unfortunately they broke it with the paid subscription and hiding everything behind a paywall

Evan Carroll

Let's review. Trump ran promising to improve relations w/ Russia...voters agreed. But permanent DC hated the idea. They’ve been pushing war w/ Iran for yrs. Closer ties w/ Russia would make an Iran war more complicated. Russia needed to be our enemy, no matter what voters wanted.

Tweeted by TuckerCarlson on May 2, 2018 at 12:49 AM

theatlantic.com/international/archive/2012/02/…

> "I do think, I'm sure I'm the lone voice in saying this, that Iran deserves to be annihilated. I think they're lunatics. I think they're evil."

USA is so awesome, "who can start a pointless war and blame it on the other guy"

Max Vernon

Cheers, @PaulW

Paul White

@EvanCarroll whoa

Max Vernon

5:57 PM

American hegemony doesn't work wothout a big bad enemy and a war machine to feed it.

2

But, that's political :-]

Evan Carroll

I hope Iran ~~gets~~ develops the nuke this year. Trump in office and Netanyahu up for election with allegations of corruption and felony, and a tanking Iran.

Why let the Iranians depose their own regime when no one wants to fight for it and you walk in and hold your victory parade!

Especially if Trump tears up the Iran agreement.

Paul White

6:41 PM

@EvanCarroll Er hang on what does "Iran gets the nuke this year" mean?

That they develop nuclear weapons? Or that the country is hit by them?

jadarnel27

@PaulWhite I imagine he means develop, and is referring to this agreement.

Paul White

@jadarnel27 That was my initial reading, but given the rather important difference, I want it to be clear.

jadarnel27

Ah, I see. We certainly shouldn't be wishing nuclear strikes on anyone.

Evan Carroll

7:04 PM

@PaulWhite develop them.

Paul White

@EvanCarroll phew thanks :)

Evan Carroll

0

Q: Can MariaDB or MySQL cast as bigint?

If I want to take a string and create a table, CREATE TABLE g AS SELECT CAST('2147483699' AS int); How do I tell it that I want a bigint type? I'll also get an int(10) type. SELECTing from it is humorous too, +---------------------------+ | CAST('2147483699' AS int) | +---------------------...

mysql mariadb datatypes cast mariadb-10.1

Andriy M

7:25 PM

@EvanCarroll The MySQL manual is (and has been for a long time) pretty clear about what you can specify as the target type for CAST/CONVERT. For integers, your only options are SIGNED and UNSIGNED. You only needed to look into the docs. Is there something I'm missing?

Evan Carroll

7:50 PM

@AndriyM that's an answer, I find it to be especially poor but if no one else has a workaround or idea I'll accept that "docs don't explicitly say it is possible so it's not and there is nothing you can do".

Shy of that, who knows we got lots of MySQL experts maybe they'll have a workaround (or there is one -- MySQL doesn't put food on my plate, and I try to avoid it)

Andriy M

"Nothing you can do" doesn't seem to me a valid conclusion. What's wrong with using either SIGNED or UNSIGNED?

Evan Carroll

ah, as a workaround that works so long as the single extra bit solves your problem. Which isn't exactly my problem. My problem is I actually wanted to get a bigint with a small number. Specifically to run some tests with bit strings.

Lamak

@EvanCarroll > MySQL supports arithmetic with both signed and unsigned 64-bit values. For numeric operators (such as + or -) where one of the operands is an unsigned integer, the result is unsigned by default (see Section 12.6.1, “Arithmetic Operators”). To override this, use the SIGNED or UNSIGNED cast operator to cast a value to a signed or unsigned 64-bit integer, respectively.

Andriy M

@EvanCarroll Oh, I see. Perhaps you could clarified that in the question. But in that case the problem does seem unlikely to have a solution. I'm not an expert either, though, so it may still be worth asking.

Lamak

apparently, converting to UNSIGNED converts to bigint

Evan Carroll

7:57 PM

oh shit!

That I did not see.

Lamak

using SIGNED too, sorry...

I meant that using those gives you a bigint

Evan Carroll

but that doesn't seem to work.

MariaDB [test]> CREATE TABLE f AS SELECT CAST('1' AS SIGNED INT);
Query OK, 1 row affected (0.03 sec)
Records: 1  Duplicates: 0  Warnings: 0

MariaDB [test]> SHOW CREATE TABLE f;
+-------+--------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                           |
+-------+--------------------------------------------------------------------------------------------------------+

Lamak

ah well, it's still MySQL

2

;)

Evan Carroll

bwahahha true dat.

Lamak

and using just SIGNED?, not SIGNED INT

Evan Carroll

8:00 PM

MariaDB [test]> SHOW CREATE TABLE f;
+-------+----------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                       |
+-------+----------------------------------------------------------------------------------------------------+
| f     | CREATE TABLE `f` (
  `CAST('1' AS SIGNED)` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |
+-------+----------------------------------------------------------------------------------------------------+

is AS SIGNED different from AS SIGNED INT

gawd I hope not.

The docs on MySQL are actually total pooop

Andriy M

SELECT CAST('9876543210' AS SIGNED) AS v; works but CREATE TABLE f AS SELECT CAST('9876543210' AS SIGNED) AS v; breaks in MySQL 8.0. There's still room for improvement.

You can do CREATE TABLE f AS SELECT 9876543210 AS v, though, in which case you do get a bigint: dbfiddle.uk/…

ypercubeᵀᴹ

@AndriyM CREATE TABLE f (v BIGINT) AS SELECT CAST('9876543210' AS SIGNED) AS v;

dbfiddle.uk/…

Andriy M

8:15 PM

@ypercubeᵀᴹ Good to know!

Evan Carroll

So if I do CAST('9876543210' AS SIGNED) outside of a CTAS that's enough to get the internal representation as a BIGINT?

Is there a way to test that, or do we just take the docs at it?

I was wanting to test it. I don't actually care about the CTAS.

Though it's interesting and probably useful to have that somewhere if it's really a bug.

I wish mysql had a pg_typeof dba.stackexchange.com/a/203927/2639

Transcript for

The Heap™ – Consultancy ©®