Comment 25 for bug 1290717

Revision history for this message
In , Brendan (mailinglist-endosquid) wrote :

mysql> use akonadi
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+----------------------------------+
| Tables_in_akonadi |
+----------------------------------+
| collectionattributetable |
| collectionmimetyperelation |
| collectionpimitemrelation |
| collectiontable |
| flagtable |
| mimetypetable |
| parttable |
| parttypetable |
| pimitemflagrelation |
| pimitemtable |
| pimitemtagrelation |
| resourcetable |
| schemaversiontable |
| tagattributetable |
| tagremoteidresourcerelationtable |
| tagtable |
+----------------------------------+
16 rows in set (0.00 sec)

mysql> DELETE FROM parttable WHERE name = 'GID';
ERROR 1054 (42S22): Unknown column 'name' in 'where clause'
mysql> desc part
partTypeId parttable.data parttable.external parttable.partTypeId parttable.version parttypetable.id parttypetable.ns
parttable parttable.datasize parttable.id parttable.pimItemId parttypetable parttypetable.name
mysql> desc parttable;
+------------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| pimItemId | bigint(20) | NO | MUL | NULL | |
| partTypeId | bigint(20) | NO | MUL | NULL | |
| data | longblob | YES | | NULL | |
| datasize | bigint(20) | NO | | NULL | |
| version | int(11) | YES | | 0 | |
| external | tinyint(1) | YES | | 0 | |
+------------+------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

mysql> select * from partable;
ERROR 1146 (42S02): Table 'akonadi.partable' doesn't exist
mysql> Bye

Yeah, I'm at the limit on this one.