Bug #7993 Multi-line sql input is truncated

• Submitted: 18 Jan 2005 20:10
• Modified: 18 Jan 2005 23:23
• Reporter: [ name withheld ]
• Status: Not a Bug
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 4.1.7
• OS: Windows (windows)
• CPU Architecture: Any

[18 Jan 2005 20:10] [ name withheld ]

Description:
I am using mysql client to input a large query. One of the lines is long and it got truncated. Is there anyway I can increase the line size?

In the following query I submit, the last WHERE clause condition is a long AND'ed constraint in parenthesis. It was truncated in mysql client.

SELECT
  PLANORDER.CUTLOC,
  PLANORDER.SEWLOC,
  PLANORDER.CLINE,
  PLANORDER.CPPPRODMETHOD,
  ITEM.ITEM,
  SKU.SKUTYPE,
  to_date(to_char(PLANORDER.ISSUEDATE,'MM/DD/RRRR'),'MM/DD/RRRR'),
  trunc(PLANORDER.SCHEDDATE),
  trunc(PLANORDER.STARTDATE),
  trunc(PLANORDER.START_FINDATE),
  trunc(PLANORDER.START_SEWDATE),
  SKU.FABRIC,
  PLANORDER.FINLOC,
  PLANORDER.LOC,
  PLANORDER.FIRMPLANSW,
  SKU.SUPPLYGROUP,
  nvl(DAMILL.MILL, 'No Mills') ,
  nvl(DAMILL.MILLREF, 'No Mill Ref'),
  DAMILL.MILL_ALIAS,
  DAMILL.BOM_ITEM_CODE,
  SKU.CLEVEL0,
  to_date(to_char( IssueCalDay.WK_END_D,'MM/DD/RRRR'),'MM/DD/RRRR'),
  to_date(to_char( IssueFiscMnth.BEG_FIS_MNTH_D,'MM/DD/RRRR'),'MM/DD/RRRR'),
  ( IssueCalDay.FIS_YEAR_I ) || ( IssueCalDay.FIS_MNTH_I ),
  IssueCalDay.FIS_WEEK_I,
  SKU.PRODUCT,
   to_date(to_char( IssueFiscWk.FISC_WK_BEG_DT,'MM/DD/RRRR'),'MM/DD/RRRR')
FROM
  PLANORDER,
  ITEM,
  SKU,
  DAMILL,
  FISCAL_DATE  IssueCalDay,
  FISCAL_MONTH  IssueFiscMnth,
  FISCAL_WK  IssueFiscWk,
  PLANORDER  PLANORDERFan
WHERE
  ( PLANORDER.ITEM=SKU.ITEM and PLANORDER.LOC=SKU.LOC and PLANORDER.SCEN=SKU.SCEN and PLANORDER.SCEN = 0  )
  AND  ( PLANORDER.CLINE=DAMILL.CLEVEL0CD(+) and PLANORDER.CUTLOC=DAMILL.MILL_ALIAS(+) and  PLANORDER.ITEM=DAMILL.PRODUCT(+)  )
  AND  ( trunc(IssueCalDay.DATE_D)=trunc(PLANORDER.ISSUEDATE)  )
  AND  ( IssueCalDay.FIS_MNTH_I=IssueFiscMnth.FIS_MNTH_I and IssueCalDay.FIS_YEAR_I=IssueFiscMnth.FIS_YEAR_I  )
  AND  ( PLANORDERFan.CPPPRODMETHOD=PLANORDER.CPPPRODMETHOD and PLANORDERFan.FIRMPLANSW=PLANORDER.FIRMPLANSW and PLANORDERFan.ITEM=PLANORDER.ITEM and PLANORDERFan.LOC=PLANORDER.LOC and PLANORDERFan.NEEDDATE=PLANORDER.NEEDDATE and PLANORDERFan.SCEN=PLANORDER.SCEN and PLANORDERFan.SCHEDDATE=PLANORDER.SCHEDDATE  )

How to repeat:
>mysql -u -p
>(copy & paste the query)

[18 Jan 2005 23:23] MySQL Verification Team

Please configure your DOS prompt command using the properties
option for to modify the layout of the screen buffer and screen
size.

[18 Jan 2005 23:43] [ name withheld ]

Modify Dos screen size did not help. I tried it before. The screen looked like below, the last line was truncated:

mysql> FROM
    ->   PLANORDER,
    ->   ITEM,
    ->   SKU,
    ->   DAMILL,
    ->   FISCAL_DATE  IssueCalDay,
    ->   FISCAL_MONTH  IssueFiscMnth,
    ->   FISCAL_WK  IssueFiscWk,
    ->   PLANORDER  PLANORDERFan
    -> WHERE
    ->   ( PLANORDER.ITEM=SKU.ITEM and PLANORDER.LOC=SKU.LOC and PLANORDER.SCEN=SKU.SCEN and PLANORD
ER.SCEN = 0  )
    ->   AND  ( PLANORDER.CLINE=DAMILL.CLEVEL0CD(+) and PLANORDER.CUTLOC=DAMILL.MILL_ALIAS(+) and  P
LANORDER.ITEM=DAMILL.PRODUCT(+)  )
    ->   AND  ( trunc(IssueCalDay.DATE_D)=trunc(PLANORDER.ISSUEDATE)  )
    ->   AND  ( IssueCalDay.FIS_MNTH_I=IssueFiscMnth.FIS_MNTH_I and IssueCalDay.FIS_YEAR_I=IssueFisc
Mnth.FIS_YEAR_I  )
    ->   AND  ( PLANORDERFan.CPPPRODMETHOD=PLANORDER.CPPPRODMETHOD and PLANORDERFan.FIRMPLANSW=PLANO
RDER.FIRMPLANSW and PLANORDERFan.ITEM=PLANORDER.ITEM and PLANORDERFan.LOC=PLANORDER.LOC and PLANORDE
RFan.NEEDDATE=PLANORDER.NEEDDATE and PLANORDERFan.SCEN=PLANOR