Sure thing, on it now. Thanks.
Btw, since I don't know how long will the wait last until bug gets to be
fixed - can I help fixing it, somehow? My employer most probably won't
mind since we need this functionality.
John
Yep
drizzle> describe ipaddress_table;
+-------+------+------+---------+-----------------+-----------+
| Field | Type | Null | Default | Default_is_NULL | On_Update |
+-------+------+------+---------+-----------------+-----------+
| addr | IPV6 | YES | | YES | |
+-------+------+------+---------+-----------------+-----------+
1 row in set (0.001061 sec)
drizzle> insert into ipaddress_table values ('10.28.4.10');
Query OK, 1 row affected (0.009366 sec)
drizzle> select * from ipaddress_table;
+-----------------------------------------+
| addr |
+-----------------------------------------+
| 000:000:000:000:000:000:010.028.004.010 |
+-----------------------------------------+
1 row in set (0.000795 sec)
drizzle> select * from ipaddress_table where addr='10.28.4.10';
Empty set (0.000814 sec)
Please file a bug. Any value that will be accepted for insert, should
certainly be accepted for where clause too.
henrik
On Thu, Mar 15, 2012 at 9:35 PM, John Z.<[email protected]> wrote:
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
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
