MariaDB Issue with Connect Date Columns.docx
[MDEV-9955] CONNECT - Wrong date retrieved from connect table connected to Oracle DB Created: 2016-04-20 Updated: 2017-10-20 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - Connect |
| Affects Version/s: | 10.1.10 |
| Fix Version/s: | 10.1 |
| Type: | Bug | Priority: | Major |
| Reporter: | Arnold Aristotle Tayag | Assignee: | Olivier Bertrand |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Environment: |
Red Hat Enterprise Linux Server release 6.6 (Santiago) |
||
| Attachments: |
MariaDB Issue with Connect Date Columns.docx
|
| Description |
|
The date retrieved from Connect Table is different from the date in source (Oracle DB) |
| Comments |
| Comment by Olivier Bertrand [ 2016-05-13 ] |
|
This may be a problem with the TIME ZONE setting of the server, system and/or database. If they don't match, there will be a correction leading to apparently false information. |
| Comment by Olivier Bertrand [ 2017-10-20 ] |
|
Looking into the attached document, it seems that sometimes the date is correctly retrieved and sometimes it is not recognized at all. However, I cannot investigate this any further not having the Oracle table available. |