This is currently impossible.
MySQL doesn't have a real BOOLEAN type, (or a real array type.. or a real JSON type). It has an alias for TINYINT.
Any condition returns an interger. This is the fastest datatype for a CPU, and presumably this implementation detail is reflected here. For instance,...
That seems crudish
Oh BTW @ChrisTravers, I went mucking with pg-bignum.
the c-library that was a fun break. I'll play with the index functionality sometime
@EvanCarroll I think the sweet spot for MySQL is still in content management systems.
@EvanCarroll Nice :-). Put it on GitHub? ;-)
by the way did you see our base36 extension on pgxn/github?
it's great because at PGConf-EU, base36 encoding was mentioned by the guy from TheDailyWTF as something maybe that shouldn't be in the database because it is not a good abstraction for Canadian postal codes. But those problems seem rather separable.
First of all, sorry if this has been answered before. I couldn't find any relevant question, so I'll give it a shot.
In order to document our databases, I have a query that fetches all relevant information of every database. This script only works on the instance that I run it on:
SELECT d.NAME...
To explain at great length, persZoltan was a weak reference to hungarian notation, which has been an occasional running joke on this board. I'm here 'til Thursday is intended to sound like a stand-up comedian in a smaller venue, indicating that it was meant to be a joke.
@dezso That last name is not uncommon here, in Ukraine. I never thought much of it but it sounded more or less native (Slavic) to me. Although thinking more about it, there's probably something Turkic about it too. It never occurred to me that it could be Hungarian in origin
I mean, we still don't know yet, do we :) But it now looks possible to me
> Hungarian (Barabás), Polish (Barabasz or Barabas), Czech and Slovak (Barabáš), and Spanish (Bar(r)abás): from the New Testament personal name Barabas (Greek Barabbas) ‘son of Aba’. This was the name borne by the thief whose life was demanded by the crowd in Jerusalem in preference to that of Jesus (Matthew 27:15–21). In central Europe it was sometimes adopted as a personal name by a repentant sinner.
@dezso Interesting. Reading the Ukrainian Wiki on the Барабаш (Barabash) family name, and it does says that the name is Ukrainian and Polish, of Turkic origin. (I guess I may have read the article before, or otherwise heard that from somewhere else.)
Tl;Dr
I have a SQL Server instance (SQLSERVER01-i01) with a dedicated IP address and port (162.xxx.xxx.51:1433) on a multi-instance SQL Server (each SQL Server instance on the Windows Server has its own IP address) which are all running on one Windows server (SQLSERVER01 / 162.xxx.xxx.50).
I ...
> I have become aware of a situation in which the my findings do not work. Although the source SQL Server Reporting Server instance is configured to use a dedicated IP address to connect to a different SQL Server instance with a dedicated IP address on a different server, and even though only one rules exists, the Reporting Server instance (http.sys process) is trying to connect to the SQL Server instance via the Windows Server IP address.
> This is why I am opening up a special bounty again, because I would like to award Jens Ehrich (or any other future answerer) with a bonus award for pointing out: _ Yes, two rules is the only safe option. I fully agree that it's not implemented correctly, nor very well._ and also for his explanation of Therefore it stands to reason that the client will use IPADDR_ANY during the Bind() method when setting up the network connection. This leaves Windows to make the decision.
> I am looking forward to any other details that could be provided.
I have a schema that involves an array of timestamps. Due to an import problem all the timestamps are off by one hour (time zone issue). I'd like to update all the timestamps in all the records with one UPDATE statement.
@JamesL yup. After a couple of months running, the RepServer (on SRV A) has decided to use the Windows Server IP (SRV A) to connect to the SQL Server / Windows Server (SRV B) instance
First person to build an IRC client in ring -3 on Intel Minix wins!
Intel uses SOAP to do this. that's frightening
> One of the most interesting features that this technology supports is direct access to the network interface card (NIC) via SOAP services as the ME share access to a LAN interface.
This is the now compromised kernel running in the -3 ring which everyone is pushing to exploit, and Google is pushing to save the world by reverse engineering it and wiping it before the zombie apocalypse.
You know it's kind of funny, when I first got into Linux about 15 years ago as a sophomore I used to encounter people that told me how terrifying Intel was. The AIX users where always loud about it. I could never figure out what exactly was wrong with Intel. Then when Apple dropped Power, and AMD fell out everyone used Intel and that talk went away.
Anyway, I'm just shocked they had this stuff in there for decades and no one found it.
This is currently impossible.
MySQL doesn't have a real BOOLEAN type, (or a real array type.. or a real JSON type). It has an alias for TINYINT.
Any condition returns an interger. This is the fastest datatype for a CPU, and presumably this implementation detail is reflected here. For instance,...
First of all, sorry if this has been answered before. I couldn't find any relevant question, so I'll give it a shot.
In order to document our databases, I have a query that fetches all relevant information of every database. This script only works on the instance that I run it on:
SELECT d.NAME...
Tl;Dr
I have a SQL Server instance (SQLSERVER01-i01) with a dedicated IP address and port (162.xxx.xxx.51:1433) on a multi-instance SQL Server (each SQL Server instance on the Windows Server has its own IP address) which are all running on one Windows server (SQLSERVER01 / 162.xxx.xxx.50).
I ...
I have a schema that involves an array of timestamps. Due to an import problem all the timestamps are off by one hour (time zone issue). I'd like to update all the timestamps in all the records with one UPDATE statement.
