Code: Select all
MariaDB [pmat]> CREATE TABLE vis (id INT, ts TIMESTAMP);
INSERT INTO vis VALUES(1,NOW());
DESCRIBE vis;
SELECT * FROM vis;
Query OK, 0 rows affected (0.03 sec)
Query OK, 1 row affected (0.01 sec)
+-------+-----------+------+-----+---------------------+-------------------------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-----------+------+-----+---------------------+-------------------------------+
| id | int(11) | YES | | NULL | |
| ts | timestamp | NO | | current_timestamp() | on update current_timestamp() |
+-------+-----------+------+-----+---------------------+-------------------------------+
2 rows in set (0.00 sec)
+------+---------------------+
| id | ts |
+------+---------------------+
| 1 | 2018-11-19 15:34:12 |
+------+---------------------+
1 row in set (0.00 sec)
But when I try to open the table in base the table returns no records. Notice no title in title bar: However if I run a SELECT from Tools>SQL.. I get the expected result: Queries also behave unexpectedly. This code, run directly, returns nothing.
Code: Select all
SELECT * FROM vis
Code: Select all
SELECT id FROM vis
I have also found that changing the file type from (TIMESTAMP or DATETIME) to either (DATE or TIME) types everything works as expected.
Base is connected and other tables behave normally, only a table with either TIMESTAMP or DATETIME type does this problem apppear.
Any ideas?