View Issue Details

IDProjectCategoryView StatusLast Update
0005949SymmetricDSImprovementpublic2023-08-09 17:58
Reporteredudebom Assigned To 
Status newResolutionopen 
Product Version3.14.8 
Summary0005949: Sybase2Postres - BIT VARYING Error
DescriptionError onCreate Table
Steps To Reproduce--Sybase
create table teste.replicacao_postgresql

<?xml version="1.0"?>
<!DOCTYPE database SYSTEM "">
<database name="dataextractor" schema="teste">
    <table name="replicacao_postgresql">
        <column name="ID" type="INTEGER" size="10">
            <platform-column name="sqlanywhere" type="int" size="10"/>
        <column name="I_BIT_VARYING" type="BINARY" size="500">
            <platform-column name="sqlanywhere" type="varbit" size="500"/>

--Postgres Result:

[JdbcSqlTemplate] ERROR: column "i_bit_varying" is of type bytea but expression is of type bit varying
CREATE TABLE "teste"."replicacao_postgresql"(
    "id" INTEGER,
    "i_bit_varying" BYTEA
Additional InformationI believe could be the same BIT VARYING(500):

CREATE TABLE "teste"."replicacao_postgresql"(
    "id" INTEGER,
    "i_bit_varying" BIT VARYING(500)
TagsNo tags attached.



2023-08-09 17:58

developer   ~0002371

Possibly add support for VARBIT as an extension of the JDBC types

Issue History

Date Modified Username Field Change
2023-08-08 22:48 edudebom New Issue
2023-08-09 17:58 pmarzullo Note Added: 0002371