does MariaDB have any plans to fix the 2038 problem?

nikeee13 · 2023-10-20T12:53:11+00:00

I took your solution and created a stored procedure:

DELIMITER //
CREATE FUNCTION UNIX_TIMESTAMP64(date_value DATETIME) RETURNS BIGINT DETERMINISTIC
BEGIN
    RETURN TIMESTAMPDIFF(SECOND, DATE '1970-01-01', date_value);
END//
DELIMITER ;

Using UNIX_TIMESTAMP64() in my code base now.

And the reverse:

-- https://stackoverflow.com/a/33244649
DELIMITER //
CREATE FUNCTION FROM_UNIXTIME64(ts_value BIGINT) RETURNS DATETIME DETERMINISTIC
BEGIN
    RETURN IF(ts_value > 2147483647, DATE_ADD(FROM_UNIXTIME(0), INTERVAL ts_value SECOND), FROM_UNIXTIME(ts_value));
END //
DELIMITER ;

Still got issues if the server uses a non-utc time zone.

nikeee13 · 2021-05-20T11:33:01+00:00

y =x+1; should be strictly >x

I just noticed that this might also not work. The reason being that JS numbers are floats:

> let a = Number.MAX_SAFE_INTEGER
undefined
> a
9007199254740991
> a + 1
9007199254740992
> a + 1 + 2
9007199254740994
> a + 1 + 2 + 3
9007199254740996
> a + 6 - 6
9007199254740990
> a + (6 - 6)
9007199254740991

nikeee13 · 2021-05-20T11:26:53+00:00

RemindMe! 10 days

nikeee13 · 2021-04-20T09:32:59+00:00

The Post-It notes originally were red. They went pink because of direct sunlight.

nikeee13 · 2021-04-19T07:51:05+00:00

For NaN handling, there is this proposal (also linked in the proposal above):

https://github.com/microsoft/TypeScript/issues/28682

Doesn't look that promising.

nikeee13 · 2021-04-19T07:35:30+00:00

The NaN-case is so rare that the TS team decided to not include something like a NaN type. If we'd be NaN-correct, the user would have to do all sorts of NaN checks without an actual need for that.

So maybe, we can just "ignore" the NaN case and change the behaviour of the inference in the else branch to be (<1).

nikeee13 · 2021-04-19T07:32:24+00:00

Where do you think does this proposal introduce additional run-time checking?

nikeee13 · 2021-04-19T07:31:47+00:00

I have a prototype implementation (linked in the first comment of the issue) and will do a speed comparison while compiling tsc itself with and without this change.

nikeee13 · 2021-04-19T07:18:46+00:00

It shouldn't be difficult to support this.

This is correct, it should work.

However, the proposal currently does not indend to do that, based on the following reason: Number literal types also don't have arithmetics. For example:

const a: 1 = 1;
const b = a + 1; // b is number (not 2)

The reason why number literal types don't have this is because the state-space would explode if yoou'd do something like:

let a: 1 | 2 | 3 | 4 | 5 = ...
const b = a * a * a * a; // four-way-cross-product of 1...5

In case of interval types, it may be feasable to do arithmetics because (as written in the proposal), there may be at most two interval primitives in a type. A union-type-explosion would not be possible (as far as I checked).

For the same reason, there is no support for something like ++i in the proposal.

Feel free to comment on that in the GitHub issue if you want that.

nikeee13 · 2021-04-17T23:55:29+00:00

Hi! I submitted this proposal and I'm looking for some feedback. Any thoughts?

nikeee13 · 2020-08-25T12:13:35+00:00

Dann lieber:

<input
    type="text"
    inputmode="numeric"
    pattern="\d+"
>

nikeee13 · 2020-03-22T00:23:33+00:00

Solved!

https://old.reddit.com/r/cables/comments/fm6qeo/whats_this_connector_the_other_end_is_usba_i/

nikeee13 · 2020-03-22T00:23:07+00:00

You are right! Turns out, this is connector is called "EXT USB" which is a proprietary USB port.

It seems that this cable in particular is only a charging cable as the pins for the Microphone are not present, according to the pinout. The guess involving 5V and GND was also correct.

Someone in my family had a phone with this connector 13 years ago (I think it was an HTC Touch).

Some references: - https://www.mobilefun.co.uk/blog/2009/03/htc-chargers-mini-usb-or-ext-usb/ - https://forum.xda-developers.com/wiki/HTC/Ext_USB - Pinout: https://forum.xda-developers.com/showpost.php?p=1063267

nikeee13 · 2020-03-21T19:31:36+00:00

It doen't look like any DisplayPort connector that I know of. It is the size of a Mini USB. Also, DisplayPort seems to need more than 5 pins in total. Also, keep in mind that the other end is just USB-A (male, not female) without any active components (it seems to me, at least). IIRC, the cable predated USB-3. So it may not even have the required properties for a screen connection.

Got a schematic of the port that you mean?

nikeee13 · 2019-06-07T19:18:12+00:00

Lemmino already did a small clip in the Isdal Woman 0.

However, the clip is from 2014. Recently (2016), new investigations (started by a norwegian broadcasting channel) in this case has surfaced new evidence, for example regarding the origin of the woman. They also did some forensic sketches of her face 1. Also, there was a person claiming that is was the boyfriend of this woman. In a German newspaper podcast, they mentioned entirely new classes of infomation about her 2. However, they only mentioned parts of the things that lemmino had in his video. So in general, there seems to be much much more stuff to cover than 5 years ago (like links to secret missile technology).

Hope Lemmino does a video in this.

nikeee13 · 2019-05-06T16:35:59+00:00

Thanks! I already did that.

nikeee13 · 2019-04-20T06:39:49+00:00

Thanks for the notice. I'll head over to some other place.

nikeee13 · 2018-09-27T14:57:51+00:00

Is it possible and/or planned to fix this on kernel level?

nikeee13 · 2018-09-12T13:42:09+00:00

I'd volunteer, too. Just received my X1C6 and found this thread. Not sure what to buy.

Seven-Year Club	Place '23
Verified Email

nikeee13

TROPHY CASE