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

Tags: indiedb types
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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.