The Heap™ – Consultancy ©®

2:15 AM

A one instruction set computer (OISC), sometimes called an ultimate reduced instruction set computer (URISC), is an abstract machine that uses only one instruction – obviating the need for a machine language opcode. With a judicious choice for the single instruction and given infinite resources, an OISC is capable of being a universal computer in the same manner as traditional computers that have multiple instructions. OISCs have been recommended as aids in teaching computer architecture and have been used as computational models in structural computing research. == Machine architecture == In a...

hot2use

2:27 AM

Well I must say I am slightly disappointed with Microsoft OneDrive. All my Christmas letters from the previous years have gone. Vanished. Nada.

Evan Carroll

2:55 AM

@hot2use And people trust those very same people to develop a RDBMS???

ZINGGGG

dezso

5:15 AM

morning

-1

Q: Your Highness of wakanda

what are you doing? There is war going on in mars for homw

mongodb-3.4

Evan Carroll

5:36 AM

postgresql.org/message-id/…

Weee

McNets

6:09 AM

Morning

Evan Carroll

6:19 AM

1

Q: MySQL 5.6 Problem with union with decimal type and null value

I have this scenario, it looks like MySQL is taking the largest decimal value and tries to cast the other values to that. The problem is that this query is generated by an external library, so I don't have control over this code, at this level at least. Do you have some idea how to fix this? ...

mysql-5.6 union decimal

bwahahahha

What a non-database.

Andriy M

6:54 AM

So the issue was permissions... — Sean Gallardy - Microsoft 6 hours ago

Morning

ypercubeᵀᴹ

7:12 AM

You must be reading something else or I don't understand. The quoted paragraph refers only to the behaviour of distinct (UNION vs UNION DISTINCT vs UNION ALL) and has nothing to do with data types or casting. — ypercubeᵀᴹ 37 secs ago

Andriy M

7:28 AM

Not a bug. Documented. — Evan Carroll 49 mins ago

@EvanCarroll ^^^ Perhaps this comment no longer stands

Evan Carroll

The one about it being not a bug and documented? Yeah, that's wrong I yanked that comment.

I find it confusing that they're referring to types of a union as being DISTINCT and ALL but whatever.

Seems likely that it's what they're referring to

I think it's a type promotion bug at this point

looking at the code now

ypercubeᵀᴹ

@EvanCarroll yeah, using "types" is confusing. They just say (in a very weird way) that in SELECT .. UNION ALL ... UNION ALL ...UNION (DISTINCT) SELECT ..;, all UNIONs are treated as UNION DISTINCT.

Andriy M

Even more confusing... SELECT 20 UNION SELECT null UNION SELECT 40 UNION SELECT 4.3; works fine — Evan Carroll 1 hour ago

Perhaps the number of occurrences of values of certain types is taken into account.

Somehow

Wait, that one doesn't seem to work in MySQL 8

Evan Carroll

A step in the wrong direction, I know I am on to them now.

Andriy M

It does work in MariaDB 10.2, though. Different teams, different results

ypercubeᵀᴹ

7:40 AM

More joy: SELECT 20 AS x UNION SELECT null UNION SELECT 40000000000 UNION SELECT 4.3;

Try to guess the result!

Andriy M

Three rows?

No

ypercubeᵀᴹ

No 4. But 20 comes out correct. The 40000000000 fails

Evan Carroll

C++ is a horrible language.

And MySQL is its shining accomplishment

Tom V

@ypercubeᵀᴹ In an unpredictable way :)

ypercubeᵀᴹ

MySQL: predictably unpredictable ;)

2

Andriy M

7:53 AM

It's predictable to a point. The point is not very predictable, though.

4

hot2use

8:16 AM

@AndriyM Was that the DBCC issue?

Andriy M

> hi guys, the problem was from the active directory, the IT guy put the DBA group from one to another, thank you all.

hot2use

Ah all that effort in vain.

Mikael Eriksson

I knew you'd show up! — sp_BlitzErik 34 mins ago

@sp_BlitzErik Of course, someone said XML on DBA :)

Andriy M

@hot2use Not all, perhaps. You suggested that they explain why theirs wasn't a permissions issue, which may have prompted them to investigate further.

McNets

8:36 AM

@ypercubeᵀᴹ CAST is required dbfiddle.uk/…

Andriy M

@McNets You don't even have to cast as decimal(18,10), decimal(2,0) is enough.

So far it looks like as soon as there are decimal values before the largest integer, the output is correct.

McNets

@AndriyM I mean, it seems that MySql is casting as float?? by default

Philᵀᴹ

This is an interesting one. DevOps vs DBAs: theregister.co.uk/2018/04/24/devops_dba_work

Andriy M

@McNets To me it looks like when you have a fairly large integer and a decimal following it, the resulting decimal(x,y) type is chosen in such a way that x is the length of the largest integer literal and y is the scale of the decimal literal that follows. But the type should actually be decimal(x+y,y).

Tom V

@AndriyM dbfiddle.uk/…

Andriy M

8:52 AM

@TomV dbfiddle.uk/… vs dbfiddle.uk/… (illustrating my last point)

Tom V

@AndriyM Ah ok I misread your point as the 2 values needing to be the "first two". An incorrect assumption

Andriy M

@TomV Yes, in your example there are decimals before the largest int. That's the scenario that I described as working correctly.

Tom V

9:08 AM

I would like to reopen this question — Tom V 1 min ago

Paul White

@TomV Can you say why?

Tom V

@PaulWhite Yep, I had the same issue. It's either a server audit or an unaknowledged bug. We decided to roll back the CU as we didn't have a server audit running

When I ran into it I found this feedback item

Paul White

@TomV I mean are you planning to answer the question.

Tom V

Unless you want me to post that as a comment/answer

3

ypercubeᵀᴹ

@TomV ha ;)

Andriy M

9:16 AM

Our mods are most understanding and cooperative.

2

Jack Douglas

9:52 AM

@Philᵀᴹ the first comment sums it up very well :)

hot2use

@JackDouglas ...and then they come crying when performance is sub-crap.

Jack Douglas

I'm 98% sure he is being sarcastic

hot2use

@JackDouglas I really do hope so.

Tom V

11:41 AM

I'm voting to close this question as off-topic because it should have been posted on serverfault.com: Server Fault is a question and answer site for managing information technology systems in a business environment. It's built and run by you as part of the Stack Exchange network of Q&A sites. With your help, we're working together to build a library of detailed answers to every question about server, networking, or related infrastructure administration. — hot2use yesterday

The question is already reposted on ServerFault a few days later:)

0

Q: Is RAID 170 a Proprietary RAID Config or a Combination of Traditional RAID Configs?

I acquired a Cisco c240 M4 with twenty-four (24) 800 GB SATA SSD. I requested the engineers configure the disks in two separate RAID 10 arrays (18 + 4), plus with a hot spare for each. The LSI MegaRAID Storage Manager was installed and I used it to review the settings, and came across the followi...

raid cisco lsi megaraid

gbn

12:03 PM

I had to google raid 7

ypercubeᵀᴹ

12:27 PM

Some questions smell "cross-posting"

I'm voting to close this question as off-topic because it has been cross-posted at DBA.SE (where it has an answer): dba.stackexchange.com/questions/204780/… Please, one question, in one site, is enough. — ypercubeᵀᴹ 5 mins ago

Transcript for

The Heap™ – Consultancy ©®