llbe

This is my third or fourth Dell XPS, now a 9350 with touchscreen that I bought last year. I re-mapped Escape to Caps lock since the function keys no longer give any feedback and I use Escape a lot. But I've found it astonishing that after 60 years or so, or even more if you count typewriters, Dell has now invented a keyboard where the keys are invisible in daylight. Amazing progress.

To add to this, after 14 months with this laptop the "t" key and the shift key now randomly stops working. After a frustrated hard press they continue to work after a few seconds.

This will definitely be my last Dell laptop.

https://preview.redd.it/9jftpo158kgh1.jpg?width=1294&format=pjpg&auto=webp&s=6d39f209

I have a Dell XPS 13 (9370) that out of the blue (no physical hardship that I know of) fails to charge the battery.

• BIOS recognizes the AC adapter and states the battery as charging

• If the battery is charged, it provides power as expected

• It only discharges however

I've tried replacing the battery and it's the same thing. If I remove the battery entirely, the laptop runs with AC power only, as expected.

Is this likely a motherboard failure, or is there anything else I can try? Any idea on how this can happen?

I thought this was a nice combo of a virtual column and unique index wth null.

create temporary table `t1` (
  `id` int unsigned not null auto_increment,
  `foo` int unsigned not null,
  `state` enum('active','dead'),
  `state_unique` enum('active') generated always as (if(`state` in('active'), `state`, null)) virtual,
  primary key (`id`),
  unique key `foo-state_unique` (`foo`,`state_unique`)
);

insert into t1(`foo`, `state`) values (1, 'active'), (1, 'dead'), (1, 'dead');

insert into t1(`foo`, `state`) values (1, 'active');

-- ERROR 1062 (23000): Duplicate entry '1-active' for key 'foo-state_unique'