Create table with bit field via Postgres produces wrong exception

Bug #889242 reported by Tim Blackman
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Akiban SQL Parser
Medium
Unassigned

Bug Description

Using the Postgres server to create a table with a field of type 'bit'
produces a parse exception rather than an unsupported data type
exception (error code 42000 vs. 50008).

SQL:

  CREATE TABLE t (bit_field bit)

Result:

  com.akiban.server.error.ParseException: PARSE_EXCEPTION: [] com.akiban.sql.parser.ParseException: Encountered " "bit" "bit "" at line 1, column 27.
  Was expecting one of:
      ")" ...
      "," ...
      : CREATE TABLE t (bit_field bit)
   at com.akiban.sql.pg.PostgresServerConnection.processParse(PostgresServerConnection.java:453)
   at com.akiban.sql.pg.PostgresServerConnection.topLevel(PostgresServerConnection.java:195)
   at com.akiban.sql.pg.PostgresServerConnection.run(PostgresServerConnection.java:145)
   at java.lang.Thread.run(Thread.java:680)

To reproduce:

  mvn test -Dtest=PostgresServerMiscYamlIT -Dcom.akiban.sql.pg.PostgresServerMiscYamlIT.CASE_NAME_REGEXP=bug-create-table-bit

Reproduced in trunk revision 1239

Mike McMahon (mmcm)
affects: akiban-server → akiban-sql-parser
Changed in akiban-sql-parser:
status: New → Confirmed
Changed in akiban-sql-parser:
milestone: none → future
importance: Undecided → Medium
tags: added: indiedb types
information type: Private → Public
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers