Hi,
there seems to be a problem at importing multiple boolean columns.
Example table:
create table testtab (
id integer,
field1 boolean,
field2 boolean
)
Import command (using loadercli, 7.6):
import table testtab
update duplicates
data instream file 'test.dat'
id 1
field1 2 null if pos 1 = 'NULL'
field2 3 null if pos 2 = 'NULL'
Content of test.dat:
1,NULL,NULL
2,NULL,FALSE
3,NULL,TRUE
4,FALSE,NULL
5,FALSE,FALSE
6,FALSE,TRUE
7,TRUE,NULL
8,TRUE,FALSE
9,TRUE,TRUE
With this file I get the error:
Error during execution
-->-25309
Invalid input for BOOLEAN column: NULL
...
If I remove the line with the id 4 (FALSE,NULL) all works fine! There
seems to be a bug with multiple boolean columns containing NULL values
follwing one boolean column with the value FALSE.
Using other representations for the NULL value show, that the IF
conditions don't work anymore after one FALSE value.
How can I solve this without changing the content of the imported columns?
I want to migrate various Adabas D table data to MaxDB 7.6 by
automatically generating the Adabas export and MaxDB import scripts and
this seems to be the only showstopper at the moment.
Thanks,
Thomas
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
