Hello,
I have a table with IPv6 column. Documentation says IPv6 supports
IPv4 values too, so I'm using same column to store both values if needed.
IPv6 insertion/selection works just fine, however I can't figure
out proper string format when trying to select by an IPv4 value - it
always returns an empty result set.
Describe table and some examples follow:
drizzle> describe cassandra_cluster;
+-------+---------+------+---------+-----------------+-----------+
| Field | Type | Null | Default | Default_is_NULL | On_Update |
+-------+---------+------+---------+-----------------+-----------+
| node | IPV6 | NO | | NO | |
| port | INTEGER | NO | | NO | |
+-------+---------+------+---------+-----------------+-----------+
drizzle> insert into cassandra_cluster values('::10.28.4.10', 9160);
Query OK, 1 row affected (0.100422 sec)
drizzle> select * from cassandra_cluster;
+-----------------------------------------+------+
| node | port |
+-----------------------------------------+------+
| 000:000:000:000:000:000:010.028.004.010 | 9160 |
+-----------------------------------------+------+
1 row in set (0.00042 sec)
drizzle> select * from cassandra_cluster where node='::10.28.4.10';
Empty set (0.000433 sec)
Here, I tried various formats for '::10.28.4.10', but all of them
failing, together with copy-paste of output from select *.
I tried on IRC, but we concluded that it could be a bug, and I was
suggested to try here first, before reporting it.
Please, help :-)
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
