Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

BYTE support #9

Open
clach04 opened this issue Jan 24, 2023 · 2 comments
Open

BYTE support #9

clach04 opened this issue Jan 24, 2023 · 2 comments

Comments

@clach04
Copy link
Member

clach04 commented Jan 24, 2023

(BYTE) Came up in conversation. Status of binary types:

  • VARBYTE

  • LONG BYTE (alias BLOB)

    • create table bin (b byte, vb varbyte(30), lb long byte, bl blob);\p\g
      create table bin (b byte, vb varbyte(30), lb long byte, bl blob);
      Executing . . .

    continue

    • help bin \p\g
      help bin
      Executing . . .

    Name: bin
    Owner: clach04
    Created: 24-jan-2023 09:47:28
    Type: user table
    Version: II10.0

    Column Information:
    Key
    Column Name Type Length Nulls Defaults Seq
    b byte 1 yes null
    vb byte varying 30 yes null
    lb long byte yes null
    bl long byte yes null

my thoughts.

Test:

  1. Python 2.x
  2. Python 3.x
@clach04
Copy link
Member Author

clach04 commented Jan 28, 2023

Code indicates there is some form of support:

https://github.com/ActianCorp/ingres_sa_dialect/blob/a6acefa5b4024c5d709c3078dba13c0eaf0f6a7b/lib/ingres_sa_dialect/base.py#L46

Need to check test suite.

@clach04
Copy link
Member Author

clach04 commented Jan 31, 2023

KeithB mentioned he saw something in the V2 docs about BINARY type support being dropped? Needs to be checked.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant