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

Posted in 2003

DL Redden — Thu, 18 Dec 2003 19:50:10 -0800 (PST) — source: Usenet: comp.databases.informix

--0-1885777015-1071805810=:41590 Content-Type: text/plain; charset=us-ascii This is a known "That's just how it works" problem. There is no work around according to tech support. I was lucky and didn't need the boolean column mapped in the synonym, so I created a view in the source database that selected all non-boolean columns from the source table. Then created my synonym on the view instead of the actual table. I cannot, however, get this method to work in 9.30 which is quite irritating. Alexey Sonkin <alexeis@grandvirtual.com> 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? > sending to informix-list --------------------------------- Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing --0-1885777015-1071805810=:41590 Content-Type: text/html; charset=us-ascii <DIV>This is a known "That's just how it works" problem. There is no work around according to tech support. I was lucky and didn't need the boolean column mapped in the synonym, so I created a view in the source database that selected all non-boolean columns from the source table. Then created my synonym on the view instead of the actual table. I cannot, however, get this method to work in 9.30 which is quite irritating.</DIV> <DIV> </DIV> <DIV> Alexey Sonkin <alexeis@grandvirtual.com> wrote:</DIV> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">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</BLOCKQUOTE><hr SIZE=1> Do you Yahoo!? <a href="http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=21260/*http://photos.yahoo.com">New Yahoo! Photos - easier uploading and sharing</a> --0-1885777015-1071805810=:41590-- sending to informix-list