- Notifications
You must be signed in to change notification settings - Fork5
Commitc508385
committed
Fix AT TIME ZONE (in all three variants) so that we first try to interpret
the timezone argument as a timezone abbreviation, and only try it as a fulltimezone name if that fails. The zic database has four zones (CET, EET, MET,WET) that are full daylight-savings zones and yet have names that are thesame as their abbreviations for standard time, resulting in ambiguity.In the timestamp input functions we resolve the ambiguity by preferring theabbreviation, and AT TIME ZONE should work the same way. (No functionalityis lost because the zic database also has other names for these zones, egEurope/Zurich.) Per gripe from Jaromir Talir.Backpatch to 8.1. Older releases did not have the issue because AT TIME ZONEonly accepted abbreviations not zone names. (Thus, this patch also arguablyfixes a compatibility botch introduced at 8.1: in ambiguous cases we nowbehave the same as 8.0 did.)1 parent76c3c59 commitc508385
2 files changed
+100
-89
lines changedLines changed: 26 additions & 23 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
8 | 8 |
| |
9 | 9 |
| |
10 | 10 |
| |
11 |
| - | |
| 11 | + | |
12 | 12 |
| |
13 | 13 |
| |
14 | 14 |
| |
| |||
2441 | 2441 |
| |
2442 | 2442 |
| |
2443 | 2443 |
| |
| 2444 | + | |
| 2445 | + | |
| 2446 | + | |
2444 | 2447 |
| |
2445 | 2448 |
| |
2446 | 2449 |
| |
2447 |
| - | |
2448 |
| - | |
2449 |
| - | |
| 2450 | + | |
| 2451 | + | |
| 2452 | + | |
| 2453 | + | |
| 2454 | + | |
| 2455 | + | |
2450 | 2456 |
| |
2451 | 2457 |
| |
2452 |
| - | |
2453 |
| - | |
2454 |
| - | |
2455 |
| - | |
2456 |
| - | |
2457 |
| - | |
| 2458 | + | |
| 2459 | + | |
| 2460 | + | |
2458 | 2461 |
| |
2459 |
| - | |
2460 |
| - | |
2461 |
| - | |
| 2462 | + | |
| 2463 | + | |
| 2464 | + | |
| 2465 | + | |
2462 | 2466 |
| |
2463 | 2467 |
| |
2464 |
| - | |
2465 |
| - | |
2466 |
| - | |
2467 |
| - | |
2468 |
| - | |
2469 |
| - | |
2470 |
| - | |
2471 |
| - | |
| 2468 | + | |
| 2469 | + | |
| 2470 | + | |
| 2471 | + | |
| 2472 | + | |
| 2473 | + | |
2472 | 2474 |
| |
2473 |
| - | |
2474 |
| - | |
| 2475 | + | |
| 2476 | + | |
| 2477 | + | |
2475 | 2478 |
| |
2476 | 2479 |
| |
2477 | 2480 |
| |
|
Lines changed: 74 additions & 66 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
8 | 8 |
| |
9 | 9 |
| |
10 | 10 |
| |
11 |
| - | |
| 11 | + | |
12 | 12 |
| |
13 | 13 |
| |
14 | 14 |
| |
| |||
4410 | 4410 |
| |
4411 | 4411 |
| |
4412 | 4412 |
| |
4413 |
| - | |
4414 | 4413 |
| |
| 4414 | + | |
| 4415 | + | |
| 4416 | + | |
| 4417 | + | |
4415 | 4418 |
| |
4416 | 4419 |
| |
4417 | 4420 |
| |
4418 | 4421 |
| |
4419 | 4422 |
| |
4420 |
| - | |
4421 |
| - | |
4422 |
| - | |
| 4423 | + | |
| 4424 | + | |
| 4425 | + | |
| 4426 | + | |
| 4427 | + | |
| 4428 | + | |
4423 | 4429 |
| |
4424 | 4430 |
| |
4425 |
| - | |
4426 |
| - | |
4427 |
| - | |
4428 |
| - | |
4429 |
| - | |
4430 |
| - | |
| 4431 | + | |
| 4432 | + | |
| 4433 | + | |
4431 | 4434 |
| |
4432 |
| - | |
4433 |
| - | |
4434 |
| - | |
4435 |
| - | |
4436 |
| - | |
4437 |
| - | |
4438 |
| - | |
4439 |
| - | |
4440 |
| - | |
4441 |
| - | |
| 4435 | + | |
| 4436 | + | |
| 4437 | + | |
| 4438 | + | |
| 4439 | + | |
| 4440 | + | |
4442 | 4441 |
| |
4443 | 4442 |
| |
4444 | 4443 |
| |
4445 |
| - | |
4446 |
| - | |
4447 |
| - | |
4448 |
| - | |
4449 |
| - | |
4450 |
| - | |
4451 |
| - | |
4452 |
| - | |
| 4444 | + | |
| 4445 | + | |
| 4446 | + | |
| 4447 | + | |
| 4448 | + | |
| 4449 | + | |
4453 | 4450 |
| |
4454 |
| - | |
4455 |
| - | |
| 4451 | + | |
| 4452 | + | |
| 4453 | + | |
| 4454 | + | |
| 4455 | + | |
| 4456 | + | |
| 4457 | + | |
| 4458 | + | |
| 4459 | + | |
| 4460 | + | |
| 4461 | + | |
4456 | 4462 |
| |
4457 | 4463 |
| |
4458 | 4464 |
| |
4459 | 4465 |
| |
4460 | 4466 |
| |
4461 |
| - | |
| 4467 | + | |
4462 | 4468 |
| |
4463 |
| - | |
4464 |
| - | |
4465 | 4469 |
| |
4466 | 4470 |
| |
4467 | 4471 |
| |
| |||
4580 | 4584 |
| |
4581 | 4585 |
| |
4582 | 4586 |
| |
4583 |
| - | |
4584 | 4587 |
| |
| 4588 | + | |
| 4589 | + | |
| 4590 | + | |
| 4591 | + | |
4585 | 4592 |
| |
4586 | 4593 |
| |
4587 | 4594 |
| |
4588 | 4595 |
| |
4589 | 4596 |
| |
4590 |
| - | |
4591 |
| - | |
4592 |
| - | |
| 4597 | + | |
| 4598 | + | |
| 4599 | + | |
| 4600 | + | |
| 4601 | + | |
| 4602 | + | |
4593 | 4603 |
| |
4594 | 4604 |
| |
4595 |
| - | |
4596 |
| - | |
4597 |
| - | |
4598 |
| - | |
4599 |
| - | |
4600 |
| - | |
| 4605 | + | |
| 4606 | + | |
| 4607 | + | |
4601 | 4608 |
| |
4602 |
| - | |
4603 |
| - | |
4604 |
| - | |
4605 |
| - | |
4606 |
| - | |
4607 |
| - | |
4608 |
| - | |
4609 |
| - | |
4610 |
| - | |
| 4609 | + | |
| 4610 | + | |
| 4611 | + | |
| 4612 | + | |
| 4613 | + | |
| 4614 | + | |
4611 | 4615 |
| |
4612 | 4616 |
| |
4613 | 4617 |
| |
4614 |
| - | |
4615 |
| - | |
4616 |
| - | |
4617 |
| - | |
4618 |
| - | |
4619 |
| - | |
4620 |
| - | |
4621 |
| - | |
| 4618 | + | |
| 4619 | + | |
| 4620 | + | |
| 4621 | + | |
| 4622 | + | |
| 4623 | + | |
4622 | 4624 |
| |
4623 |
| - | |
4624 |
| - | |
| 4625 | + | |
| 4626 | + | |
| 4627 | + | |
| 4628 | + | |
| 4629 | + | |
| 4630 | + | |
| 4631 | + | |
| 4632 | + | |
| 4633 | + | |
| 4634 | + | |
4625 | 4635 |
| |
4626 | 4636 |
| |
4627 | 4637 |
| |
4628 | 4638 |
| |
4629 | 4639 |
| |
4630 |
| - | |
| 4640 | + | |
4631 | 4641 |
| |
4632 |
| - | |
4633 |
| - | |
4634 | 4642 |
| |
4635 | 4643 |
| |
4636 | 4644 |
| |
|
0 commit comments
Comments
(0)