AW: remote synonym for table with boolean column (bug?) [2371]

Some additional information on that: 1. You can't even do a remote select on that column; 2. You still can do remote select on other non-boolean columns of that table ------------------------------------------ Alexey Sonkin Senior Database Administrator > > I've just found a very strange problem that reproduces in 9.21uc4 and > 9.40uc2: > > 1. Create table containing boolean: > create table test_tab (aaa boolean)> 2. In another database (on the same server), create remote synonym for > that > table: > create synonym test for test:test_tab;> 3. Get a very strange error "999: Not implemented yet" > > Is it a known problem? Any workaroud? > sending to informix-list

Alexey Sonkin wrote: > Some additional information on that: > 1. You can't even do a remote select on that column; > 2. You still can do remote select on other non-boolean columns > of that table > > ------------------------------------------ > Alexey Sonkin > Senior Database Administrator > > > >>I've just found a very strange problem that reproduces in 9.21uc4 and >>9.40uc2: >> >>1. Create table containing boolean: >> create table test_tab (aaa boolean)>>2. In another database (on the same server), create remote synonym for >>that >>table: >> create synonym test for test:test_tab;>>3. Get a very strange error "999: Not implemented yet" >> >>Is it a known problem? Any workaroud? Yes, it is a known problem. The bug reproduces in IDS 9.x for all values of x from 00 through 40. The workarounds may or may not be palatable. The simplest is to change the column type to: colname CHAR(1) NOT NULL CHECK(colname IN ('f', 't')) The fix for this is not scheduled to appear until 9.50. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/