View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0005949SymmetricDSImprovementpublic2023-08-08 22:482024-10-01 23:11
Reporteredudebom Assigned To 
Prioritylow 
Status newResolutionopen 
Product Version3.14.8 
Summary0005949: Sybase2Postres - BIT VARYING Error
DescriptionError onCreate Table
Steps To Reproduce--Sybase
create table teste.replicacao_postgresql
(
 ID INTEGER,
 I_BIT_VARYING BIT VARYING(500)
);

<?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<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>
        <column name="I_BIT_VARYING" type="BINARY" size="500">
            <platform-column name="sqlanywhere" type="varbit" size="500"/>
        </column>
    </table>
</database>

--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.

Relationships

related to 0006605 new Support for cross platform BIT data type size > 1 (bit varying, varbit, bit string, bit array) 

Activities

pmarzullo

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
2024-10-01 23:11 elong Relationship added related to 0006605